|
|
1 - Advanced Excel - Introduction & Scope.mp4
|
MP4
|
81.7 MB
|
|
|
1 - Advanced Excel - Introduction & Scope_en.srt
|
SRT
|
7.7 KB
|
|
|
1 - Final Words.mp4
|
MP4
|
9.4 MB
|
|
|
1 - Final Words_en.srt
|
SRT
|
2.5 KB
|
|
|
1 - Overview of Top Excel Formulas.mp4
|
MP4
|
69.3 MB
|
|
|
1 - Overview of Top Excel Formulas_en.srt
|
SRT
|
4.4 KB
|
|
|
1 - Overview of Top Excel Tips.mp4
|
MP4
|
39.4 MB
|
|
|
1 - Overview of Top Excel Tips_en.srt
|
SRT
|
2.7 KB
|
|
|
1 - YTD Calculations - SUM, SUMPRODUCT & OFFSET.mp4
|
MP4
|
52.3 MB
|
|
|
1 - YTD Calculations - SUM, SUMPRODUCT & OFFSET_en.srt
|
SRT
|
14.9 KB
|
|
|
10 - Formula 7 - Excel's Top Date Functions.mp4
|
MP4
|
147 MB
|
|
|
10 - Formula 7 - Excel's Top Date Functions_en.srt
|
SRT
|
21 KB
|
|
|
10 - Tip 7 - Audit & Debug Formulas.mp4
|
MP4
|
56.1 MB
|
|
|
10 - Tip 7 - Audit & Debug Formulas_en.srt
|
SRT
|
10 KB
|
|
|
11 - Formula 8 - OFFSET for Dynamic Calculations.mp4
|
MP4
|
64 MB
|
|
|
11 - Formula 8 - OFFSET for Dynamic Calculations_en.srt
|
SRT
|
15.3 KB
|
|
|
11 - Tip 8 - Improve Presentation with Customized Number Formatting.mp4
|
MP4
|
101.8 MB
|
|
|
11 - Tip 8 - Improve Presentation with Customized Number Formatting_en.srt
|
SRT
|
18.4 KB
|
|
|
12 - Formula 9 - FREQUENCY, SMALL & LARGE to Organize and Rank.mp4
|
MP4
|
62.5 MB
|
|
|
12 - Formula 9 - FREQUENCY, SMALL & LARGE to Organize and Rank_en.srt
|
SRT
|
15.9 KB
|
|
|
12 - Tip 9 - Solve Problems With Goal Seek.mp4
|
MP4
|
39.1 MB
|
|
|
12 - Tip 9 - Solve Problems With Goal Seek_en.srt
|
SRT
|
7.5 KB
|
|
|
13 - Formula 10 - SUMPRODUCT For the Gurus.mp4
|
MP4
|
106.2 MB
|
|
|
13 - Formula 10 - SUMPRODUCT For the Gurus_en.srt
|
SRT
|
16.1 KB
|
|
|
13 - Tip 10 - Use Excel PivotTables for Super Fast Analysis.mp4
|
MP4
|
111.8 MB
|
|
|
13 - Tip 10 - Use Excel PivotTables for Super Fast Analysis_en.srt
|
SRT
|
18.8 KB
|
|
|
14 - PDF to Download Top 10 Excel FORMULAS to Work Smarter.html
|
HTML
|
819.2 B
|
|
|
14 - Tip 10 - PivotTables Calculated Fields, Slicers & Helpful Tricks.mp4
|
MP4
|
105.6 MB
|
|
|
14 - Tip 10 - PivotTables Calculated Fields, Slicers & Helpful Tricks_en.srt
|
SRT
|
16 KB
|
|
|
15 - Tip 10 - PivotTables Valuable Design Tips.mp4
|
MP4
|
199.3 MB
|
|
|
15 - Tip 10 - PivotTables Valuable Design Tips_en.srt
|
SRT
|
23.6 KB
|
|
|
16 - Bonus Tip - Methods to Speed up Your Excel Files.mp4
|
MP4
|
18 MB
|
|
|
16 - Bonus Tip - Methods to Speed up Your Excel Files_en.srt
|
SRT
|
6.4 KB
|
|
|
16 - Infographic-steps-to-make-Slow-Excel-Files-Faster.pdf
|
PDF
|
280.8 KB
|
|
|
17 - Bonus Tip - The Possibilities & Limitations of Excel.mp4
|
MP4
|
29.9 MB
|
|
|
17 - Bonus Tip - The Possibilities & Limitations of Excel_en.srt
|
SRT
|
8.6 KB
|
|
|
18 - PDF to Download - Top 10 Excel TIPS to Work Smarter (in print and in detail).html
|
HTML
|
819.2 B
|
|
|
2 - 3 Ways to Lookup within Boundaries SUMIFS, SUMPRODUCT & INDEX.mp4
|
MP4
|
46.5 MB
|
|
|
2 - 3 Ways to Lookup within Boundaries SUMIFS, SUMPRODUCT & INDEX_en.srt
|
SRT
|
14.1 KB
|
|
|
2 - BONUS More Resources.html
|
HTML
|
4.8 KB
|
|
|
2 - DOWNLOAD these Files First.mp4
|
MP4
|
19.9 MB
|
|
|
2 - DOWNLOAD these Files First_en.srt
|
SRT
|
2.7 KB
|
|
|
2 - Excel-Advanced-Demo.xlsx
|
XLSX
|
440.3 KB
|
|
|
2 - Excel-Advanced-ExerciseBook.xlsx
|
XLSX
|
321.2 KB
|
|
|
2 - Formula 1 - SUMIFS, COUNTIFS, AVERAGEIFS to Account for Exceptions.mp4
|
MP4
|
97.7 MB
|
|
|
2 - Formula 1 - SUMIFS, COUNTIFS, AVERAGEIFS to Account for Exceptions_en.srt
|
SRT
|
14.8 KB
|
|
|
2 - Tip 1 - Become Faster with Excel's Keyboard Shortcuts.mp4
|
MP4
|
86.6 MB
|
|
|
2 - Tip 1 - Become Faster with Excel's Keyboard Shortcuts_en.srt
|
SRT
|
10.8 KB
|
|
|
2 - sample-raw-data.txt
|
TXT
|
716.8 B
|
|
|
3 - Course Outline for Quick Reference.html
|
HTML
|
409.6 B
|
|
|
3 - Formula 2 - IF (Nested Functions) Because Data Analysis is Often Not Simple.mp4
|
MP4
|
35.4 MB
|
|
|
3 - Formula 2 - IF (Nested Functions) Because Data Analysis is Often Not Simple_en.srt
|
SRT
|
12.2 KB
|
|
|
3 - Sum Alternate Columns based on Selection - SUMIFS & INDEX.mp4
|
MP4
|
42.7 MB
|
|
|
3 - Sum Alternate Columns based on Selection - SUMIFS & INDEX_en.srt
|
SRT
|
12.4 KB
|
|
|
3 - Tip 2 - Master the Simpler Tasks Part 1.mp4
|
MP4
|
149.6 MB
|
|
|
3 - Tip 2 - Master the Simpler Tasks Part 1_en.srt
|
SRT
|
19 KB
|
|
|
4 - Formula 3 - IFERROR for Credible Reports.mp4
|
MP4
|
30.4 MB
|
|
|
4 - Formula 3 - IFERROR for Credible Reports_en.srt
|
SRT
|
5.9 KB
|
|
|
4 - Sum Alternate Columns - SUMPRODUCT.mp4
|
MP4
|
41.1 MB
|
|
|
4 - Sum Alternate Columns - SUMPRODUCT_en.srt
|
SRT
|
12.3 KB
|
|
|
4 - Tip 2 - Master the Simpler Tasks Part 2.mp4
|
MP4
|
57.3 MB
|
|
|
4 - Tip 2 - Master the Simpler Tasks Part 2_en.srt
|
SRT
|
9.8 KB
|
|
|
5 - Formula 4 - VLOOKUP & HLOOKUP For Dynamic Lookups.mp4
|
MP4
|
35.7 MB
|
|
|
5 - Formula 4 - VLOOKUP & HLOOKUP For Dynamic Lookups_en.srt
|
SRT
|
11.4 KB
|
|
|
5 - Tip 3 - Quickly Navigate Larger Files.mp4
|
MP4
|
76.5 MB
|
|
|
5 - Tip 3 - Quickly Navigate Larger Files_en.srt
|
SRT
|
11.3 KB
|
|
|
6 - Formula 5 - INDEX & MATCH for Flexible Lookups.mp4
|
MP4
|
137.7 MB
|
|
|
6 - Formula 5 - INDEX & MATCH for Flexible Lookups_en.srt
|
SRT
|
16.5 KB
|
|
|
6 - Tip 4 - Inspect Workbooks for Hidden Information.mp4
|
MP4
|
30 MB
|
|
|
6 - Tip 4 - Inspect Workbooks for Hidden Information_en.srt
|
SRT
|
10.9 KB
|
|
|
7 - Formula 5 - INDEX & MATCH for Complex Real-Cases.mp4
|
MP4
|
132.8 MB
|
|
|
7 - Formula 5 - INDEX & MATCH for Complex Real-Cases_en.srt
|
SRT
|
20.8 KB
|
|
|
7 - Tip 4 Extended - Unhide Hidden Names with VBA.html
|
HTML
|
3 KB
|
|
|
8 - Formula 6 - The Most Useful Text Functions.mp4
|
MP4
|
79.9 MB
|
|
|
8 - Formula 6 - The Most Useful Text Functions_en.srt
|
SRT
|
13.7 KB
|
|
|
8 - Tip 5 - Use Protection Appropriately.mp4
|
MP4
|
90.6 MB
|
|
|
8 - Tip 5 - Use Protection Appropriately_en.srt
|
SRT
|
19 KB
|
|
|
9 - Formula 6 - Advanced TEXT functions.mp4
|
MP4
|
102.5 MB
|
|
|
9 - Formula 6 - Advanced TEXT functions_en.srt
|
SRT
|
19 KB
|
|
|
9 - Tip 6 - Import Text, CSV & Web Data Properly.mp4
|
MP4
|
61.9 MB
|
|
|
9 - Tip 6 - Import Text, CSV & Web Data Properly_en.srt
|
SRT
|
13.8 KB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
external-assets-links.txt
|
TXT
|
307.2 B
|
