Filename | Size |
| 1. Introduction, Scope & Excel Files/1. Advanced Excel - Introduction & Scope.mp4 | 81.7 MB |
| 1. Introduction, Scope & Excel Files/1. Advanced Excel - Introduction & Scope.srt | 7.7 KB |
| 1. Introduction, Scope & Excel Files/2. DOWNLOAD these Files First.mp4 | 42.1 MB |
| 1. Introduction, Scope & Excel Files/2. DOWNLOAD these Files First.srt | 2.6 KB |
| 1. Introduction, Scope & Excel Files/2.1 sample_raw_data.txt | 172 B |
| 1. Introduction, Scope & Excel Files/2.2 Excel_Advanced_ExerciseBook.xlsx | 321 KB |
| 1. Introduction, Scope & Excel Files/2.3 Excel_Advanced_Demo.xlsx | 440.3 KB |
| 1. Introduction, Scope & Excel Files/3. Course Outline for Quick Reference.html | 397 B |
| 1. Introduction, Scope & Excel Files/3.1 Detailed_Course_Outline_Excel_Advanced.xlsx | 15.1 KB |
| 2. Top 10 Excel Tips to Save You Time/1. Overview of Top Excel Tips.mp4 | 39.5 MB |
| 2. Top 10 Excel Tips to Save You Time/1. Overview of Top Excel Tips.srt | 2.8 KB |
| 2. Top 10 Excel Tips to Save You Time/10. Tip 6 - Import Text, CSV & Web Data Properly.mp4 | 61.9 MB |
| 2. Top 10 Excel Tips to Save You Time/10. Tip 6 - Import Text, CSV & Web Data Properly.srt | 13.6 KB |
| 2. Top 10 Excel Tips to Save You Time/11. Tip 7 - Audit & Debug Formulas.mp4 | 24.9 MB |
| 2. Top 10 Excel Tips to Save You Time/11. Tip 7 - Audit & Debug Formulas.srt | 10.2 KB |
| 2. Top 10 Excel Tips to Save You Time/12. Tip 8 - Improve Presentation with Customized Number Formatting.mp4 | 128.9 MB |
| 2. Top 10 Excel Tips to Save You Time/12. Tip 8 - Improve Presentation with Customized Number Formatting.srt | 18.3 KB |
| 2. Top 10 Excel Tips to Save You Time/13. Tip 9 - Solve Problems With Goal Seek.mp4 | 52.1 MB |
| 2. Top 10 Excel Tips to Save You Time/13. Tip 9 - Solve Problems With Goal Seek.srt | 7.3 KB |
| 2. Top 10 Excel Tips to Save You Time/14. Tip 10 - Use Excel PivotTables for Super Fast Analysis.mp4 | 59.3 MB |
| 2. Top 10 Excel Tips to Save You Time/14. Tip 10 - Use Excel PivotTables for Super Fast Analysis.srt | 18.4 KB |
| 2. Top 10 Excel Tips to Save You Time/15. Tip 10 - PivotTables Calculated Fields, Slicers & Helpful Tricks.mp4 | 70.2 MB |
| 2. Top 10 Excel Tips to Save You Time/15. Tip 10 - PivotTables Calculated Fields, Slicers & Helpful Tricks.srt | 15.5 KB |
| 2. Top 10 Excel Tips to Save You Time/16. Tip 10 - PivotTables Valuable Design Tips.mp4 | 91.5 MB |
| 2. Top 10 Excel Tips to Save You Time/16. Tip 10 - PivotTables Valuable Design Tips.srt | 24 KB |
| 2. Top 10 Excel Tips to Save You Time/17. Test Your Knowledge - Top 10 Tips (Don't Skip).html | 138 B |
| 2. Top 10 Excel Tips to Save You Time/18. Bonus Tip - Methods to Speed up Your Excel Files.mp4 | 18.9 MB |
| 2. Top 10 Excel Tips to Save You Time/18. Bonus Tip - Methods to Speed up Your Excel Files.srt | 6.6 KB |
| 2. Top 10 Excel Tips to Save You Time/18.1 Infographic_steps_to_make_Slow_Excel_Files_Faster.pdf | 280.8 KB |
| 2. Top 10 Excel Tips to Save You Time/19. Bonus Tip - The Possibilities & Limitations of Excel.mp4 | 26.3 MB |
| 2. Top 10 Excel Tips to Save You Time/19. Bonus Tip - The Possibilities & Limitations of Excel.srt | 8.4 KB |
| 2. Top 10 Excel Tips to Save You Time/2. Tip 1 - Become Faster with Excel's Keyboard Shortcuts.mp4 | 54.5 MB |
| 2. Top 10 Excel Tips to Save You Time/2. Tip 1 - Become Faster with Excel's Keyboard Shortcuts.srt | 10.9 KB |
| 2. Top 10 Excel Tips to Save You Time/2.1 Click the link for a more detailed list of Excel Shortcuts available on the Microsoft Office website.html | 246 B |
| 2. Top 10 Excel Tips to Save You Time/20. PDF to Download - Top 10 Excel TIPS to Work Smarter (in print and in detail).html | 799 B |
| 2. Top 10 Excel Tips to Save You Time/20.1 Excel_Advanced_Top10TIPS_Documentation_LeilaGharani.pdf | 3.3 MB |
| 2. Top 10 Excel Tips to Save You Time/3. Tip 2 - Master the Simpler Tasks Part 1.mp4 | 63.7 MB |
| 2. Top 10 Excel Tips to Save You Time/3. Tip 2 - Master the Simpler Tasks Part 1.srt | 18.1 KB |
| 2. Top 10 Excel Tips to Save You Time/4. Tip 2 - Master the Simpler Tasks Part 2.mp4 | 36.9 MB |
| 2. Top 10 Excel Tips to Save You Time/4. Tip 2 - Master the Simpler Tasks Part 2.srt | 9.7 KB |
| 2. Top 10 Excel Tips to Save You Time/5. Tip 3 - Quickly Navigate Larger Files.mp4 | 44.3 MB |
| 2. Top 10 Excel Tips to Save You Time/5. Tip 3 - Quickly Navigate Larger Files.srt | 11.1 KB |
| 2. Top 10 Excel Tips to Save You Time/6. Tip 4 - Inspect Workbooks for Hidden Information.mp4 | 30 MB |
| 2. Top 10 Excel Tips to Save You Time/6. Tip 4 - Inspect Workbooks for Hidden Information.srt | 11.3 KB |
| 2. Top 10 Excel Tips to Save You Time/7. Tip 4 Extended - Unhide Hidden Names with VBA.html | 3.1 KB |
| 2. Top 10 Excel Tips to Save You Time/7.1 Unhide Hidden Names.pdf | 193.8 KB |
| 2. Top 10 Excel Tips to Save You Time/8. Tip 5 - Use Protection Appropriately.mp4 | 72.1 MB |
| 2. Top 10 Excel Tips to Save You Time/8. Tip 5 - Use Protection Appropriately.srt | 19 KB |
| 2. Top 10 Excel Tips to Save You Time/9. Test Your Knowledge - Top 5 Tips (Don't Skip).html | 138 B |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/1. Overview of Top Excel Formulas.mp4 | 69.3 MB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/1. Overview of Top Excel Formulas.srt | 4.3 KB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/10. Formula 6 - Advanced TEXT functions.mp4 | 123.5 MB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/10. Formula 6 - Advanced TEXT functions.srt | 18.7 KB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/11. Formula 7 - Excel's Top Date Functions.mp4 | 161.5 MB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/11. Formula 7 - Excel's Top Date Functions.srt | 20.9 KB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/12. Formula 8 - OFFSET for Dynamic Calculations.mp4 | 39.2 MB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/12. Formula 8 - OFFSET for Dynamic Calculations.srt | 15.3 KB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/13. Formula 9 - FREQUENCY, SMALL & LARGE to Organize and Rank.mp4 | 62.5 MB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/13. Formula 9 - FREQUENCY, SMALL & LARGE to Organize and Rank.srt | 15.5 KB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/14. Formula 10 - SUMPRODUCT For the Gurus.mp4 | 110.9 MB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/14. Formula 10 - SUMPRODUCT For the Gurus.srt | 15.3 KB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/15. Test Your Knowledge - Top 10 Formulas (Don't Skip).html | 138 B |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/16. PDF to Download Top 10 Excel FORMULAS to Work Smarter.html | 829 B |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/16.1 Excel_Advanced_Top10FORMULAS_Documentation_LeilaGharani.pdf | 1.5 MB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/2. Formula 1 - SUMIFS, COUNTIFS, AVERAGEIFS to Account for Exceptions.mp4 | 136.2 MB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/2. Formula 1 - SUMIFS, COUNTIFS, AVERAGEIFS to Account for Exceptions.srt | 14.3 KB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/3. Formula 2 - IF (Nested Functions) Because Data Analysis is Often Not Simple.mp4 | 96.7 MB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/3. Formula 2 - IF (Nested Functions) Because Data Analysis is Often Not Simple.srt | 12.2 KB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/4. Formula 3 - IFERROR for Credible Reports.mp4 | 42.2 MB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/4. Formula 3 - IFERROR for Credible Reports.srt | 5.9 KB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/5. Formula 4 - VLOOKUP & HLOOKUP For Dynamic Lookups.mp4 | 116.8 MB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/5. Formula 4 - VLOOKUP & HLOOKUP For Dynamic Lookups.srt | 11.4 KB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/6. Formula 5 - INDEX & MATCH for Flexible Lookups.mp4 | 73 MB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/6. Formula 5 - INDEX & MATCH for Flexible Lookups.srt | 16.6 KB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/7. Formula 5 - INDEX & MATCH for Complex Real-Cases.mp4 | 190.3 MB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/7. Formula 5 - INDEX & MATCH for Complex Real-Cases.srt | 20.9 KB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/8. Test Your Knowledge - Top 5 Formulas (Don't Skip).html | 138 B |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/9. Formula 6 - The Most Useful Text Functions.mp4 | 103.3 MB |
| 3. Top 10 Excel Formulas for Quick & Dynamic Analysis/9. Formula 6 - The Most Useful Text Functions.srt | 13.9 KB |
| 4. Formula Combinations for Real Cases/1. YTD Calculations - SUM, SUMPRODUCT & OFFSET.mp4 | 31.1 MB |
| 4. Formula Combinations for Real Cases/1. YTD Calculations - SUM, SUMPRODUCT & OFFSET.srt | 14.6 KB |
| 4. Formula Combinations for Real Cases/2. 3 Ways to Lookup within Boundaries SUMIFS, SUMPRODUCT & INDEX.mp4 | 34 MB |
| 4. Formula Combinations for Real Cases/2. 3 Ways to Lookup within Boundaries SUMIFS, SUMPRODUCT & INDEX.srt | 14 KB |
| 4. Formula Combinations for Real Cases/3. Sum Alternate Columns based on Selection - SUMIFS & INDEX.mp4 | 28.7 MB |
| 4. Formula Combinations for Real Cases/3. Sum Alternate Columns based on Selection - SUMIFS & INDEX.srt | 12.3 KB |
| 4. Formula Combinations for Real Cases/4. Sum Alternate Columns - SUMPRODUCT.mp4 | 23.2 MB |
| 4. Formula Combinations for Real Cases/4. Sum Alternate Columns - SUMPRODUCT.srt | 12.2 KB |
| 5. Wrap Up/1. Final Words.mp4 | 40.8 MB |
| 5. Wrap Up/1. Final Words.srt | 2.6 KB |
| 5. Wrap Up/2. How to get my other courses & more useful materials.html | 3.5 KB |