Practical Excel 2016 Intermediate Advanced | 6EC1219976D9754B44405BE1D0B13AD7F5FEC0BD

Practical Excel 2016 Intermediate Advanced

Name	Practical Excel 2016 – Intermediate & Advanced	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	1.1 GB
Total Files	80
Hash	6EC1219976D9754B44405BE1D0B13AD7F5FEC0BD

/13 Power BI/
003 Power Query.mp4	17.9 MB
004 Power Pivot.mp4	42.9 MB
001 Intro to Power BI.mp4	5.5 MB
002 Data Model.mp4	28.0 MB
005 Power View.mp4	13.3 MB
006 Power Map.mp4	17.6 MB
/04 Text Functions/
005 Parsing with Text to Columns.mp4	10.5 MB
006 Parsing with Text Functions.mp4	28.5 MB
007 Flash Fill.mp4	15.3 MB
004 Concatenating.mp4	5.8 MB
002 LOWER, UPPER, PROPER.mp4	3.6 MB
003 TRIM, VALUE.mp4	10.7 MB
001 Intro to Text Functions.mp4	3.6 MB
/03 Math Functions/
003 ABS, SQRT, SUMSQ.mp4	8.6 MB
002 INT, ROUND, CEILING, FLOOR.mp4	12.4 MB
001 Intro to Math Functions.mp4	2.6 MB
004 LN, EXP.mp4	11.8 MB
005 RAND, RANDBETWEEN.mp4	9.5 MB
/09 Logical Functions/
003 IF Functions.mp4	4.0 MB
001 Intro to Logical Functions.mp4	1.6 MB
002 IS Functions.mp4	19.4 MB
/12 Data Analysis Tools/
006 Slicers.mp4	15.7 MB
005 Pivot Tables 2.mp4	50.8 MB
007 Consolidating.mp4	21.4 MB
008 Subtotals.mp4	14.4 MB
001 Intro to Data Analysis Tools.mp4	2.3 MB
004 Pivot Tables 1.mp4	42.2 MB
003 Tables.mp4	46.1 MB
010 Forecasting.mp4	17.4 MB
009 Data Tables.mp4	26.5 MB
011 Goal Seek.mp4	9.5 MB
012 Solver.mp4	17.6 MB
002 Quick Analysis.mp4	6.9 MB
/08 Reference Functions/
005 INDIRECT.mp4	12.1 MB
003 MATCH.mp4	9.7 MB
004 OFFSET.mp4	12.8 MB
002 INDEX.mp4	5.8 MB
001 Intro to Reference Functions.mp4	2.2 MB
/07 Financial Functions/
002 PMT.mp4	4.5 MB
003 NPV, XNPV.mp4	8.5 MB
001 Intro to Financial Functions.mp4	2.0 MB
004 IRR, XIRR.mp4	7.2 MB
/15 Conclusion to Course/
001 Conclusion to Excel 2016 Intermediate and Advanced Course.mp4	2.4 MB
/06 Statistical Functions/
003 MEDIAN, QUARTILE, PERCENTILE.mp4	9.6 MB
002 MIN, MAX.mp4	3.6 MB
001 Intro to Statistical Functions.mp4	3.7 MB
004 STDEV, VAR.mp4	9.5 MB
006 RANK, LARGE, SMALL.mp4	15.9 MB
007 New Statistical Functions.mp4	5.9 MB
005 CORREL, COVAR.mp4	12.1 MB
/02 Summarizing Functions/
001 COUNTIF, SUMIF, AVERAGEIF.mp4	21.7 MB
002 COUNTIFS, SUMIFS, AVERAGEIFS.mp4	21.9 MB
/01 Introduction to Course/
001 Welcome to Intermediate Advance Course.mp4	2.7 MB
/10 Advanced Formula Tools/
002 R1C1 Notation.mp4	8.5 MB
001 Range Names 2.mp4	25.9 MB
003 Auditing Formulas.mp4	18.6 MB
004 Evaluating a Formula.mp4	22.2 MB
005 External Formula References.mp4	15.2 MB
006 Array Formulas.mp4	21.8 MB
/11 Importing External Data/
004 Importing Data from the Web.mp4	17.4 MB
005 Importing Data from Saved Connections.mp4	15.8 MB
001 Intro to Importing External Data.mp4	3.8 MB
002 Importing Data from a Database.mp4	29.6 MB
003 Importing Data from a Text File.mp4	24.0 MB
/05 Dates and Times Functions/
006 DATE, DATEVALUE.mp4	16.9 MB
001 Intro to Dates and Times in Excel.mp4	11.4 MB
005 DATEDIF.mp4	6.9 MB
002 Y2K.mp4	2.8 MB
004 YEAR, MONTH, DAY, WEEKDAY.mp4	11.4 MB
007 NETWORKDAYS, WORKDAY.mp4	6.3 MB
003 TODAY, NOW.mp4	2.9 MB
/14 Adding Professional Touches/
007 Developer Ribbon.mp4	2.4 MB
008 Using Form Controls.mp4	30.3 MB
009 Recording a Macro.mp4	5.9 MB
006 Outlining.mp4	9.5 MB
004 Custom Views.mp4	7.9 MB
001 Intro to Adding Professional Touches.mp4	1.6 MB
002 Data Validation.mp4	14.9 MB
003 Protecting Worksheets and Workbooks.mp4	18.6 MB
005 Scenarios.mp4	13.2 MB
Total files 80