Learn Excel 2016 Intermediate Level Beyond the Basics | 524C62A90EB98C3E122F233E2BEE2C19CEBA386D

Learn Excel 2016 Intermediate Level Beyond the Basics

Name	Learn Excel 2016 Intermediate Level - Beyond the Basics	DOWNLOAD Copy Link
Total Size	1.8 GB
Total Files	83
Hash	524C62A90EB98C3E122F233E2BEE2C19CEBA386D

/.../004 Course Support Files/Support files/1-6-special-commands/
1-6-special-commands-workbook.xlsx	11.7 KB
Workbook A.xlsx	7.7 KB
Workbook B.xlsx	8.1 KB
/.../003 Course Exercise Files/Exercise files/
1-5-common-hotkeys-exercise-1.xlsx	199.8 KB
1-5-common-hotkeys.xlsx	8.8 KB
2-5-case-study-lookups-exercise-solution.xlsx	68.5 KB
2-5-case-study-lookups-exercise.xlsx	49.3 KB
3-4-using-names-exercise-solution.xlsx	51.2 KB
3-4-using-names-exercise.xlsx	50.6 KB
4-5-dynamic-named-range-exercise-4-solution.xlsx	14.4 KB
4-5-dynamic-named-range-exercise-4.xlsx	17.5 KB
5-5-bw-histogram-exercise-5-randomized.xlsx	322.2 KB
._5-5-bw-histogram-exercise-5-solution.xlsx	4.1 KB
5-5-bw-histogram-exercise-5-solution.xlsx	442.3 KB
5-5-bw-histogram-exercise-5.xlsx	313.1 KB
6-3-excel-data-model-exercise-solution.xlsx	262.9 KB
6-3-excel-data-model-exercise.xlsx	255.7 KB
6-7-pivot-charts-exercise-solution.xlsx	412.6 KB
6-7-pivot-charts-exercise.xlsx	382.2 KB
/.../004 Course Support Files/Support files/
1-7-excel-view-workbook.xlsx	15.3 KB
._2-2-hlookup-vlookup-worksheet.xlsx	4.1 KB
2-2-hlookup-vlookup-worksheet.xlsx	15.5 KB
2-4-index-function-worksheet.xlsx	17.4 KB
4-2-indirect-function-workbook.xlsx	53.8 KB
4-3-offset-function-workbook-withfunctions.xlsx	15.6 KB
4-5-dynamic-named-range-indirect.xlsx	54.2 KB
4-5-dynamic-named-range-offset.xlsx	17.8 KB
5-1-introducing-charts.xlsx	250.5 KB
5-6-chart-customization.xlsx	240.9 KB
5-7-combo-charts.xlsx	240.6 KB
6-1-data-management-invoicing.xlsx	55.0 KB
6-1-data-management-raw-dump.xlsx	142.8 KB
6-1-data-management.xlsx	54.1 KB
6-2-data-table-object.xlsx	61.7 KB
6-3-excel-data-model-invoicing.xlsx	517.6 KB
6-4-data-slicer-object.xlsx	11.0 KB
6-5-pivot-tables-invoicing.xlsx	533.3 KB
6-6-power-query-invoicing.xlsx	730.2 KB
6-7-pivot-charts-invoicing.xlsx	770.7 KB
6-8-get-pivot-data-function-invoicing.xlsx	770.0 KB
Excel Intermediate Exercise 5 RandComponent.xlsx	322.2 KB
/01 Excel Intermediate Introduction/
001 Course Introduction.mp4	20.0 MB
002 Essential Information for a Successful Training Experience.html	3.2 KB
003 Course Exercise Files.html	1.1 KB
004 Course Support Files.html	1.1 KB
005 Reviewing Excel Terminology.mp4	45.3 MB
006 Tips and Tricks in the Ribbon.mp4	23.9 MB
007 Escaping the Mouse-Trap.mp4	45.4 MB
008 Common Hotkeys.mp4	38.6 MB
009 Special Hotkey Commands.mp4	38.4 MB
010 Defining Your Excel View.mp4	46.6 MB
/02 Indexing and Lookups/
011 Defining Lookups and Arrays.mp4	22.4 MB
012 Using VLOOKUP and HLOOKUP.mp4	43.9 MB
013 Using MATCH.mp4	36.1 MB
014 Using INDEX.mp4	31.4 MB
015 Mixing LOOKUPS INDEX and MATCH.mp4	59.3 MB
/03 Named Ranges/
016 What is Important to You.mp4	22.0 MB
017 Simple and Quick Name Definitions.mp4	31.4 MB
018 Accessing and Using the Name Manager.mp4	24.1 MB
019 What can Names do.mp4	65.7 MB
/04 Dynamic Formula/
020 What is a Reference.mp4	18.3 MB
021 Using Indirect.mp4	57.5 MB
022 Using Offset.mp4	39.1 MB
023 Using Row Column and Cell.mp4	35.6 MB
024 Creating Dynamic Named Ranges.mp4	66.1 MB
025 Best Practices Regarding Dynamic Functions.mp4	55.2 MB
/05 Charts and Graphs/
026 Charts and Graphs Terminology.mp4	68.8 MB
027 Line Scatter and Bar Charts.mp4	76.7 MB
028 Radar and Surface Plots.mp4	19.7 MB
029 Waterfall Pie and Sunburst Charts.mp4	45.6 MB
030 The Box and Whisper Plot and Histograms Statistical.mp4	40.8 MB
031 Chart Formatting In Detail.mp4	36.5 MB
032 Mixing Chart Types.mp4	21.1 MB
033 The Bing Maps App.mp4	38.6 MB
/06 Working with Data/
034 How Do You Know If Youre Working With Data.mp4	79.3 MB
035 Introducing Data Tables.mp4	91.6 MB
036 Excel Data Model Relationships.mp4	51.9 MB
037 Data Slicers.mp4	40.4 MB
038 Pivot Tables.mp4	79.5 MB
039 Power Query Get And Transform.mp4	79.0 MB
040 Pivot Charts.mp4	38.8 MB
041 The GETPIVOTDATA Function.mp4	50.7 MB
042 Course Conclusion.mp4	28.9 MB
Total files 83