|
|
1. Introduction to Analysis in Excel.mp4
|
MP4
|
1.7 MB
|
|
|
1. Introduction to Analysis in Excel.vtt
|
VTT
|
2 KB
|
|
|
1. Introduction to Automation in Excel.mp4
|
MP4
|
3.9 MB
|
|
|
1. Introduction to Automation in Excel.vtt
|
VTT
|
6.3 KB
|
|
|
1. Introduction to Presentation in Excel.mp4
|
MP4
|
1.8 MB
|
|
|
1. Introduction to Presentation in Excel.vtt
|
VTT
|
3.2 KB
|
|
|
1. Introduction to working with data in Excel.mp4
|
MP4
|
3.4 MB
|
|
|
1. Introduction to working with data in Excel.vtt
|
VTT
|
5.1 KB
|
|
|
1. Introduction.mp4
|
MP4
|
3.9 MB
|
|
|
1. Introduction.vtt
|
VTT
|
4.8 KB
|
|
|
10. A useful VBA tool you can use to improve your pivot tables..mp4
|
MP4
|
5.9 MB
|
|
|
10. A useful VBA tool you can use to improve your pivot tables..vtt
|
VTT
|
6 KB
|
|
|
10. More Formulas.mp4
|
MP4
|
20.9 MB
|
|
|
10. More Formulas.vtt
|
VTT
|
20.7 KB
|
|
|
10.1 Excel Guru Other Formulas.xlsx
|
XLSX
|
9.8 KB
|
|
|
11. Mathematical Functions Quiz.html
|
HTML
|
102.4 B
|
|
|
11. VBA Forms - creating interactive forms for your spreadsheet.mp4
|
MP4
|
14.3 MB
|
|
|
11. VBA Forms - creating interactive forms for your spreadsheet.vtt
|
VTT
|
16.2 KB
|
|
|
12. Bonus Lecture.html
|
HTML
|
512 B
|
|
|
12. Learn any function.mp4
|
MP4
|
8.8 MB
|
|
|
12. Learn any function.vtt
|
VTT
|
8.4 KB
|
|
|
13. Using Paste Special.mp4
|
MP4
|
9.7 MB
|
|
|
13. Using Paste Special.vtt
|
VTT
|
9.5 KB
|
|
|
14. Cell validation.mp4
|
MP4
|
7.4 MB
|
|
|
14. Cell validation.vtt
|
VTT
|
7.9 KB
|
|
|
14.1 Excel Guru Cell Validation.xlsx
|
XLSX
|
8.9 KB
|
|
|
15. Cell styles.mp4
|
MP4
|
5.7 MB
|
|
|
15. Cell styles.vtt
|
VTT
|
5.3 KB
|
|
|
15.1 Excel Guru Cell Styles.xlsx
|
XLSX
|
9.9 KB
|
|
|
16. Formatting data as a table.mp4
|
MP4
|
8.9 MB
|
|
|
16. Formatting data as a table.vtt
|
VTT
|
9.4 KB
|
|
|
16.1 Excel Guru Tables.xlsx
|
XLSX
|
15.3 KB
|
|
|
17. Using named ranges.mp4
|
MP4
|
8 MB
|
|
|
17. Using named ranges.vtt
|
VTT
|
7.5 KB
|
|
|
17.1 Excel Guru Named Ranges.xlsx
|
XLSX
|
9 KB
|
|
|
18. Freeze Panes - navigating large data sheets.mp4
|
MP4
|
5.8 MB
|
|
|
18. Freeze Panes - navigating large data sheets.vtt
|
VTT
|
5.1 KB
|
|
|
18.1 Excel Guru Freeze Panes.xlsx
|
XLSX
|
902.6 KB
|
|
|
19. File Types - how to save your work in the right format.mp4
|
MP4
|
4.2 MB
|
|
|
19. File Types - how to save your work in the right format.vtt
|
VTT
|
7.6 KB
|
|
|
2. Basic Charts in Excel.mp4
|
MP4
|
10.4 MB
|
|
|
2. Basic Charts in Excel.vtt
|
VTT
|
10.4 KB
|
|
|
2. Conditional formatting basics.mp4
|
MP4
|
17.7 MB
|
|
|
2. Conditional formatting basics.vtt
|
VTT
|
14.9 KB
|
|
|
2. Some basic best practice principles.mp4
|
MP4
|
7.6 MB
|
|
|
2. Some basic best practice principles.vtt
|
VTT
|
8.7 KB
|
|
|
2. VBA Introduction.mp4
|
MP4
|
4.7 MB
|
|
|
2. VBA Introduction.vtt
|
VTT
|
6.7 KB
|
|
|
2.1 Excel Guru Basic Charts.xlsx
|
XLSX
|
17.8 KB
|
|
|
2.1 Excel Guru Conditional Formatting.xlsx
|
XLSX
|
11.1 KB
|
|
|
20. All Excel keyboard shortcuts cheat sheet.pdf
|
PDF
|
94.5 KB
|
|
|
21. All Excel functions and formulas cheat sheet.pdf
|
PDF
|
181.6 KB
|
|
|
3. An introduction to pivot tables.mp4
|
MP4
|
19.7 MB
|
|
|
3. An introduction to pivot tables.vtt
|
VTT
|
20.4 KB
|
|
|
3. NEW Scatter & Bubble Charts.mp4
|
MP4
|
22.1 MB
|
|
|
3. NEW Scatter & Bubble Charts.vtt
|
VTT
|
10.2 KB
|
|
|
3. NEW The 10 immutable laws of structuring data in Excel.html
|
HTML
|
7.3 KB
|
|
|
3. Using the Macro Recorder.mp4
|
MP4
|
10.5 MB
|
|
|
3. Using the Macro Recorder.vtt
|
VTT
|
12.1 KB
|
|
|
3.1 Excel Guru Pivot Tabes Basic.xlsx
|
XLSX
|
1.1 MB
|
|
|
3.1 Scatter & Bubble Chart Lesson Example.xlsx.xlsx
|
XLSX
|
31.7 KB
|
|
|
4. Advanced pivot tables.mp4
|
MP4
|
28.1 MB
|
|
|
4. Advanced pivot tables.vtt
|
VTT
|
20.9 KB
|
|
|
4. NEW VLOOKUP & HLOOKUP Functions.mp4
|
MP4
|
21.4 MB
|
|
|
4. NEW VLOOKUP & HLOOKUP Functions.vtt
|
VTT
|
9.4 KB
|
|
|
4. Pivot charts.mp4
|
MP4
|
9.6 MB
|
|
|
4. Pivot charts.vtt
|
VTT
|
8.4 KB
|
|
|
4. VBA Referencing.mp4
|
MP4
|
6.2 MB
|
|
|
4. VBA Referencing.vtt
|
VTT
|
9 KB
|
|
|
4.1 Excel Guru Pivot Charts.xlsx
|
XLSX
|
1.1 MB
|
|
|
4.1 Excel Guru Pivot Tables Advanced.xlsx
|
XLSX
|
1.1 MB
|
|
|
4.1 VLOOKUP-HLOOKUP-Lesson-Examples.xlsx.xlsx
|
XLSX
|
30.1 KB
|
|
|
5. NEW Challenge Add data from another table using VLOOKUP.html
|
HTML
|
307.2 B
|
|
|
5. Password protecting the workbook.mp4
|
MP4
|
9 MB
|
|
|
5. Password protecting the workbook.vtt
|
VTT
|
9.4 KB
|
|
|
5. Pivot slicers.mp4
|
MP4
|
6.9 MB
|
|
|
5. Pivot slicers.vtt
|
VTT
|
6.4 KB
|
|
|
5. VBA Variables.mp4
|
MP4
|
6.2 MB
|
|
|
5. VBA Variables.vtt
|
VTT
|
8.3 KB
|
|
|
5.1 CHALLENGE - Add data from another table using VLOOKUP.xlsx.xlsx
|
XLSX
|
18.5 KB
|
|
|
5.1 Excel Guru Slicers.xlsx
|
XLSX
|
1.2 MB
|
|
|
6. Designing Dashboards (Part 1).mp4
|
MP4
|
8.4 MB
|
|
|
6. Designing Dashboards (Part 1).vtt
|
VTT
|
8.7 KB
|
|
|
6. IF.mp4
|
MP4
|
7.3 MB
|
|
|
6. IF.vtt
|
VTT
|
6.7 KB
|
|
|
6. VBA IFs.mp4
|
MP4
|
3.7 MB
|
|
|
6. VBA IFs.vtt
|
VTT
|
4.1 KB
|
|
|
6.1 Excel Guru Dashboards.xlsx
|
XLSX
|
1.2 MB
|
|
|
6.1 Excel Guru IF.xlsx
|
XLSX
|
9.9 KB
|
|
|
7. Designing Dashboard (Part 2).mp4
|
MP4
|
20.5 MB
|
|
|
7. Designing Dashboard (Part 2).vtt
|
VTT
|
15.4 KB
|
|
|
7. IFERROR.mp4
|
MP4
|
8.4 MB
|
|
|
7. IFERROR.vtt
|
VTT
|
7.8 KB
|
|
|
7. VBA Loops.mp4
|
MP4
|
25.4 MB
|
|
|
7. VBA Loops.vtt
|
VTT
|
19.3 KB
|
|
|
7.1 Excel Guru IFERROR.xlsx
|
XLSX
|
9.7 KB
|
|
|
8. Hiding gridlines for presentation.mp4
|
MP4
|
1.5 MB
|
|
|
8. Hiding gridlines for presentation.vtt
|
VTT
|
1.4 KB
|
|
|
8. ISERROR.mp4
|
MP4
|
6.7 MB
|
|
|
8. ISERROR.vtt
|
VTT
|
6.5 KB
|
|
|
8. VBA Error handling.mp4
|
MP4
|
7.1 MB
|
|
|
8. VBA Error handling.vtt
|
VTT
|
10.5 KB
|
|
|
8.1 Excel Guru ISERROR.xlsx
|
XLSX
|
9.9 KB
|
|
|
9. Choosing the correct function.html
|
HTML
|
102.4 B
|
|
|
9. Creating buttons to run your macros.mp4
|
MP4
|
5.2 MB
|
|
|
9. Creating buttons to run your macros.vtt
|
VTT
|
3.8 KB
|
|
|
[FreeCourseLab.com].url
|
URL
|
102.4 B
|
