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