|
|
1. Getting Started with Excel Charts.mp4
|
MP4
|
112.7 MB
|
|
|
1. Getting Started with Excel Charts.srt
|
SRT
|
19.6 KB
|
|
|
1. Importing and Cleaning Data.mp4
|
MP4
|
91.8 MB
|
|
|
1. Importing and Cleaning Data.srt
|
SRT
|
13.5 KB
|
|
|
1. Introducing Excel.mp4
|
MP4
|
27.2 MB
|
|
|
1. Introducing Excel.mp4.jpg
|
JPG
|
134.9 KB
|
|
|
1. Introducing Excel.srt
|
SRT
|
5.6 KB
|
|
|
1. Introducing Formulas and Functions.mp4
|
MP4
|
28.4 MB
|
|
|
1. Introducing Formulas and Functions.srt
|
SRT
|
6.2 KB
|
|
|
1. Introducing Power Pivot.mp4
|
MP4
|
23.4 MB
|
|
|
1. Introducing Power Pivot.srt
|
SRT
|
4.5 KB
|
|
|
1. Introducing Visual Basic for Applications.mp4
|
MP4
|
73.7 MB
|
|
|
1.1 Academic Details.xlsx
|
XLSX
|
9.4 KB
|
|
|
1.1 Chapter 19.xlsx
|
XLSX
|
16 KB
|
|
|
1.1 Chapter 24.xlsx
|
XLSX
|
59.6 KB
|
|
|
1.1 Chapter 37.xlsx
|
XLSX
|
8.3 KB
|
|
|
1.2 Chapter 33-34 - Power Pivot.xlsx
|
XLSX
|
424.2 KB
|
|
|
1.3 Fee Structure.xlsx
|
XLSX
|
8.4 KB
|
|
|
1.4 Personal Details.xlsx
|
XLSX
|
10 KB
|
|
|
10. Making Your Formulas Error-Free.mp4
|
MP4
|
65.5 MB
|
|
|
10. Making Your Formulas Error-Free.srt
|
SRT
|
10 KB
|
|
|
10.1 Chapter 18.xlsx
|
XLSX
|
28.4 KB
|
|
|
2. Creating Custom Worksheet Functions.mp4
|
MP4
|
27.6 MB
|
|
|
2. Creating Custom Worksheet Functions.srt
|
SRT
|
8 KB
|
|
|
2. Entering and Editing Worksheet Data.mp4
|
MP4
|
49.1 MB
|
|
|
2. Entering and Editing Worksheet Data.srt
|
SRT
|
9.6 KB
|
|
|
2. Using Advanced Charting Techniques.mp4
|
MP4
|
262.1 MB
|
|
|
2. Using Data Validation.mp4
|
MP4
|
52.7 MB
|
|
|
2. Using Data Validation.srt
|
SRT
|
11.7 KB
|
|
|
2. Using Formulas for Common Mathematical Operations.mp4
|
MP4
|
56.2 MB
|
|
|
2. Using Formulas for Common Mathematical Operations.srt
|
SRT
|
8.3 KB
|
|
|
2. Working Directly with the Internal Data Model.mp4
|
MP4
|
43.8 MB
|
|
|
2. Working Directly with the Internal Data Model.srt
|
SRT
|
9.9 KB
|
|
|
2.1 Academic Details.xlsx
|
XLSX
|
9.4 KB
|
|
|
2.1 Chapter 10.xlsx
|
XLSX
|
16.9 KB
|
|
|
2.1 Chapter 20.xlsx
|
XLSX
|
81 KB
|
|
|
2.1 Chapter 25.xlsx
|
XLSX
|
9.6 KB
|
|
|
2.1 Chapter 38.xlsm
|
XLSM
|
15 KB
|
|
|
2.1 Formatting and Entering Data.xlsx
|
XLSX
|
11.8 KB
|
|
|
2.2 Chapter 33-34 - Power Pivot.xlsx
|
XLSX
|
424.2 KB
|
|
|
2.3 Fee Structure.xlsx
|
XLSX
|
8.4 KB
|
|
|
2.4 Personal Details.xlsx
|
XLSX
|
10 KB
|
|
|
3. Adding Formulas to Power Pivot.mp4
|
MP4
|
75.2 MB
|
|
|
3. Adding Formulas to Power Pivot.srt
|
SRT
|
16.1 KB
|
|
|
3. Creating Sparkline Graphics.mp4
|
MP4
|
34.4 MB
|
|
|
3. Creating Sparkline Graphics.srt
|
SRT
|
7.3 KB
|
|
|
3. Creating UserForms.mp4
|
MP4
|
40.2 MB
|
|
|
3. Creating UserForms.srt
|
SRT
|
8.2 KB
|
|
|
3. Creating and Using Worksheet Outlines.mp4
|
MP4
|
28.4 MB
|
|
|
3. Creating and Using Worksheet Outlines.srt
|
SRT
|
4.9 KB
|
|
|
3. Performing Basic Worksheet Operations.mp4
|
MP4
|
42.8 MB
|
|
|
3. Performing Basic Worksheet Operations.srt
|
SRT
|
8.6 KB
|
|
|
3. Using Formulas to Manipulate Text.mp4
|
MP4
|
75.1 MB
|
|
|
3. Using Formulas to Manipulate Text.srt
|
SRT
|
10.6 KB
|
|
|
3.1 Chapter 11.xlsx
|
XLSX
|
9.9 KB
|
|
|
3.1 Chapter 21.xlsx
|
XLSX
|
8.7 KB
|
|
|
3.1 Chapter 26.xlsx
|
XLSX
|
10.6 KB
|
|
|
3.1 Chapter 35 - Power Pivot.xlsx
|
XLSX
|
424.7 KB
|
|
|
3.1 Chapter 39.xlsx
|
XLSX
|
7.4 KB
|
|
|
3.1 Move Sheet to Another Workbook - Creating a Copy.xlsx
|
XLSX
|
9 KB
|
|
|
4. Linking and Consolidating Worksheets.mp4
|
MP4
|
43.1 MB
|
|
|
4. Linking and Consolidating Worksheets.srt
|
SRT
|
7.2 KB
|
|
|
4. Power Query.mp4
|
MP4
|
101.7 MB
|
|
|
4. Power Query.srt
|
SRT
|
12.8 KB
|
|
|
4. Using Formulas with Dates and Times.mp4
|
MP4
|
40.3 MB
|
|
|
4. Using Formulas with Dates and Times.srt
|
SRT
|
6.9 KB
|
|
|
4. Using UserForm Controls in a Worksheet through an Example.mp4
|
MP4
|
69.2 MB
|
|
|
4. Using UserForm Controls in a Worksheet through an Example.srt
|
SRT
|
15.8 KB
|
|
|
4. Visualizing with Custom Number Formats and Shapes.mp4
|
MP4
|
128.1 MB
|
|
|
4. Visualizing with Custom Number Formats and Shapes.srt
|
SRT
|
25.9 KB
|
|
|
4. Working with Excel Ranges and Tables.mp4
|
MP4
|
27.3 MB
|
|
|
4. Working with Excel Ranges and Tables.srt
|
SRT
|
4.6 KB
|
|
|
4.1 2018-2019.xlsx
|
XLSX
|
23 KB
|
|
|
4.1 Chapter 12.xlsx
|
XLSX
|
9 KB
|
|
|
4.1 Chapter 22.xlsx
|
XLSX
|
28.2 KB
|
|
|
4.1 Chapter 27.xlsx
|
XLSX
|
17.7 KB
|
|
|
4.1 Chapter 4.xlsx
|
XLSX
|
9.9 KB
|
|
|
4.1 Chapter 40.xlsm
|
XLSM
|
48.3 KB
|
|
|
4.2 2019-2020.xlsx
|
XLSX
|
23.7 KB
|
|
|
4.3 2020-2021.xlsx
|
XLSX
|
12.2 KB
|
|
|
4.4 2021-2022.xlsx
|
XLSX
|
16.2 KB
|
|
|
4.5 Chapter 36.xlsx
|
XLSX
|
84.8 KB
|
|
|
5. Formatting Worksheets.mp4
|
MP4
|
62.9 MB
|
|
|
5. Formatting Worksheets.srt
|
SRT
|
11.7 KB
|
|
|
5. Implementing Excel Dashboarding Best Practices.mp4
|
MP4
|
257.8 MB
|
|
|
5. Introduction to PivotTables and Data Analysis.mp4
|
MP4
|
122.1 MB
|
|
|
5. Using Formulas for Conditional Analysis.mp4
|
MP4
|
115.2 MB
|
|
|
5. Using Formulas for Conditional Analysis.srt
|
SRT
|
16.9 KB
|
|
|
5. Working with Excel Events.mp4
|
MP4
|
20.3 MB
|
|
|
5. Working with Excel Events.srt
|
SRT
|
5.4 KB
|
|
|
5.1 Chapter 13.xlsx
|
XLSX
|
13 KB
|
|
|
5.1 Chapter 23.xlsx
|
XLSX
|
449.3 KB
|
|
|
5.1 Chapter 28.xlsx
|
XLSX
|
21.7 KB
|
|
|
5.1 Chapter 41.xlsx
|
XLSX
|
8.3 KB
|
|
|
6. Creating Custom Excel Add-Ins.mp4
|
MP4
|
33.7 MB
|
|
|
6. Creating Custom Excel Add-Ins.srt
|
SRT
|
8.2 KB
|
|
|
6. Performing Spreadsheet What-If Analysis.mp4
|
MP4
|
102.4 MB
|
|
|
6. Performing Spreadsheet What-If Analysis.srt
|
SRT
|
19.4 KB
|
|
|
6. Understanding Excel Files and Templates.mp4
|
MP4
|
21.4 MB
|
|
|
6. Understanding Excel Files and Templates.srt
|
SRT
|
4.2 KB
|
|
|
6. Using Formulas for Matching and Lookups.mp4
|
MP4
|
88.7 MB
|
|
|
6. Using Formulas for Matching and Lookups.srt
|
SRT
|
13.5 KB
|
|
|
6.1 Chapter 14.xlsx
|
XLSX
|
17.1 KB
|
|
|
6.1 Chapter 29.xlsx
|
XLSX
|
12.9 KB
|
|
|
6.1 Chapter 42.xlsm
|
XLSM
|
9.2 KB
|
|
|
7. Analyzing Data Using Goal Seeking and Solver.mp4
|
MP4
|
95.5 MB
|
|
|
7. Analyzing Data Using Goal Seeking and Solver.srt
|
SRT
|
17.4 KB
|
|
|
7. Printing Your Work.mp4
|
MP4
|
88.8 MB
|
|
|
7. Printing Your Work.srt
|
SRT
|
8 KB
|
|
|
7. Using Formulas for Financial Analysis.mp4
|
MP4
|
87.8 MB
|
|
|
7. Using Formulas for Financial Analysis.srt
|
SRT
|
14.9 KB
|
|
|
7.1 Chapter 15.xlsx
|
XLSX
|
111.7 KB
|
|
|
7.1 Chapter 30.xlsx
|
XLSX
|
12.7 KB
|
|
|
7.1 Random Data - Printing File.xlsx
|
XLSX
|
81.5 KB
|
|
|
8. Analyzing Data with the Analysis ToolPak.mp4
|
MP4
|
48.2 MB
|
|
|
8. Analyzing Data with the Analysis ToolPak.srt
|
SRT
|
7.6 KB
|
|
|
8. Customizing the Excel User Interface.mp4
|
MP4
|
14.6 MB
|
|
|
8. Customizing the Excel User Interface.srt
|
SRT
|
2.1 KB
|
|
|
8. Using Formulas for Statistical Analysis.mp4
|
MP4
|
92.6 MB
|
|
|
8. Using Formulas for Statistical Analysis.srt
|
SRT
|
13.6 KB
|
|
|
8.1 Chapter 16.xlsx
|
XLSX
|
13.5 KB
|
|
|
8.1 Chapter 31.xlsx
|
XLSX
|
10.6 KB
|
|
|
9. Protecting Your Work.mp4
|
MP4
|
38.3 MB
|
|
|
9. Protecting Your Work.srt
|
SRT
|
5.2 KB
|
|
|
9. Understanding and Using Array Formulas.mp4
|
MP4
|
52.6 MB
|
|
|
9. Understanding and Using Array Formulas.srt
|
SRT
|
8.5 KB
|
|
|
9.1 Chapter 17.xlsx
|
XLSX
|
13.5 KB
|
|
|
9.1 Chapter 32.xlsx
|
XLSX
|
51 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|