| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/1-6-special-commands/1-6-special-commands-workbook.xlsx |
11 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/1-6-special-commands/Workbook A.xlsx |
8 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/1-6-special-commands/Workbook B.xlsx |
8 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/003 Course Exercise Files/Exercise files/1-5-common-hotkeys-exercise-1.xlsx |
195 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/003 Course Exercise Files/Exercise files/1-5-common-hotkeys.xlsx |
9 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/003 Course Exercise Files/Exercise files/2-5-case-study-lookups-exercise-solution.xlsx |
67 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/003 Course Exercise Files/Exercise files/2-5-case-study-lookups-exercise.xlsx |
48 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/003 Course Exercise Files/Exercise files/3-4-using-names-exercise-solution.xlsx |
50 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/003 Course Exercise Files/Exercise files/3-4-using-names-exercise.xlsx |
49 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/003 Course Exercise Files/Exercise files/4-5-dynamic-named-range-exercise-4-solution.xlsx |
14 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/003 Course Exercise Files/Exercise files/4-5-dynamic-named-range-exercise-4.xlsx |
17 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/003 Course Exercise Files/Exercise files/5-5-bw-histogram-exercise-5-randomized.xlsx |
315 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/003 Course Exercise Files/Exercise files/._5-5-bw-histogram-exercise-5-solution.xlsx |
4 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/003 Course Exercise Files/Exercise files/5-5-bw-histogram-exercise-5-solution.xlsx |
432 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/003 Course Exercise Files/Exercise files/5-5-bw-histogram-exercise-5.xlsx |
306 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/003 Course Exercise Files/Exercise files/6-3-excel-data-model-exercise-solution.xlsx |
257 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/003 Course Exercise Files/Exercise files/6-3-excel-data-model-exercise.xlsx |
250 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/003 Course Exercise Files/Exercise files/6-7-pivot-charts-exercise-solution.xlsx |
403 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/003 Course Exercise Files/Exercise files/6-7-pivot-charts-exercise.xlsx |
373 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/1-7-excel-view-workbook.xlsx |
15 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/._2-2-hlookup-vlookup-worksheet.xlsx |
4 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/2-2-hlookup-vlookup-worksheet.xlsx |
15 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/2-4-index-function-worksheet.xlsx |
17 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/4-2-indirect-function-workbook.xlsx |
53 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/4-3-offset-function-workbook-withfunctions.xlsx |
15 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/4-5-dynamic-named-range-indirect.xlsx |
53 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/4-5-dynamic-named-range-offset.xlsx |
17 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/5-1-introducing-charts.xlsx |
245 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/5-6-chart-customization.xlsx |
235 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/5-7-combo-charts.xlsx |
235 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/6-1-data-management-invoicing.xlsx |
54 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/6-1-data-management-raw-dump.xlsx |
140 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/6-1-data-management.xlsx |
53 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/6-2-data-table-object.xlsx |
60 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/6-3-excel-data-model-invoicing.xlsx |
506 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/6-4-data-slicer-object.xlsx |
11 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/6-5-pivot-tables-invoicing.xlsx |
521 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/6-6-power-query-invoicing.xlsx |
713 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/6-7-pivot-charts-invoicing.xlsx |
753 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/6-8-get-pivot-data-function-invoicing.xlsx |
752 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/attached_files/004 Course Support Files/Support files/Excel Intermediate Exercise 5 RandComponent.xlsx |
315 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/001 Course Introduction.mp4 |
19.1 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/002 Essential Information for a Successful Training Experience.html |
3 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/003 Course Exercise Files.html |
1 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/004 Course Support Files.html |
1 KB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/005 Reviewing Excel Terminology.mp4 |
43.2 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/006 Tips and Tricks in the Ribbon.mp4 |
22.8 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/007 Escaping the Mouse-Trap.mp4 |
43.3 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/008 Common Hotkeys.mp4 |
36.8 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/009 Special Hotkey Commands.mp4 |
36.6 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/01 Excel Intermediate Introduction/010 Defining Your Excel View.mp4 |
44.5 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/02 Indexing and Lookups/011 Defining Lookups and Arrays.mp4 |
21.4 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/02 Indexing and Lookups/012 Using VLOOKUP and HLOOKUP.mp4 |
41.9 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/02 Indexing and Lookups/013 Using MATCH.mp4 |
34.4 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/02 Indexing and Lookups/014 Using INDEX.mp4 |
30 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/02 Indexing and Lookups/015 Mixing LOOKUPS INDEX and MATCH.mp4 |
56.5 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/03 Named Ranges/016 What is Important to You.mp4 |
21 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/03 Named Ranges/017 Simple and Quick Name Definitions.mp4 |
30 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/03 Named Ranges/018 Accessing and Using the Name Manager.mp4 |
23 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/03 Named Ranges/019 What can Names do.mp4 |
62.6 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/04 Dynamic Formula/020 What is a Reference.mp4 |
17.4 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/04 Dynamic Formula/021 Using Indirect.mp4 |
54.8 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/04 Dynamic Formula/022 Using Offset.mp4 |
37.3 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/04 Dynamic Formula/023 Using Row Column and Cell.mp4 |
34 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/04 Dynamic Formula/024 Creating Dynamic Named Ranges.mp4 |
63 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/04 Dynamic Formula/025 Best Practices Regarding Dynamic Functions.mp4 |
52.6 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/05 Charts and Graphs/026 Charts and Graphs Terminology.mp4 |
65.7 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/05 Charts and Graphs/027 Line Scatter and Bar Charts.mp4 |
73.2 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/05 Charts and Graphs/028 Radar and Surface Plots.mp4 |
18.7 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/05 Charts and Graphs/029 Waterfall Pie and Sunburst Charts.mp4 |
43.5 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/05 Charts and Graphs/030 The Box and Whisper Plot and Histograms Statistical.mp4 |
38.9 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/05 Charts and Graphs/031 Chart Formatting In Detail.mp4 |
34.8 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/05 Charts and Graphs/032 Mixing Chart Types.mp4 |
20.1 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/05 Charts and Graphs/033 The Bing Maps App.mp4 |
36.8 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/06 Working with Data/034 How Do You Know If Youre Working With Data.mp4 |
75.7 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/06 Working with Data/035 Introducing Data Tables.mp4 |
87.4 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/06 Working with Data/036 Excel Data Model Relationships.mp4 |
49.5 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/06 Working with Data/037 Data Slicers.mp4 |
38.5 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/06 Working with Data/038 Pivot Tables.mp4 |
75.8 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/06 Working with Data/039 Power Query Get And Transform.mp4 |
75.3 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/06 Working with Data/040 Pivot Charts.mp4 |
37 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/06 Working with Data/041 The GETPIVOTDATA Function.mp4 |
48.4 MB |
| Learn Excel 2016 Intermediate Level - Beyond the Basics/06 Working with Data/042 Course Conclusion.mp4 |
27.5 MB |
Magnet link
