Introduction, Scope & Excel Files
  • Advanced Excel - Introduction & Scope
  • DOWNLOAD these Files First
  • Course Outline for Quick Reference
Top 10 Excel Tips to Save You Time
  • Overview of Top Excel Tips
  • Tip 1 - Become Faster with Excel's Keyboard Shortcuts
  • Tip 2 - Master the Simpler Tasks: Part 1
  • Tip 2 - Master the Simpler Tasks: Part 2
  • Tip 3 - Quickly Navigate Larger Files
  • Tip 4 - Inspect Workbooks for Hidden Information
  • Tip 4 Extended - Unhide Hidden Names with VBA
  • Tip 5 - Use Protection Appropriately
  • Test Your Knowledge - Top 5 Tips (Don't Skip)
  • Tip 6 - Import Text, CSV & Web Data Properly
  • Tip 7 - Audit & Debug Formulas
  • Tip 8 - Improve Presentation with Customized Number Formatting
  • Tip 9 - Solve Problems With Goal Seek
  • Tip 10 - Use Excel PivotTables for Super Fast Analysis
  • Tip 10 - PivotTables: Calculated Fields, Slicers & Helpful Tricks
  • Tip 10 - PivotTables: Valuable Design Tips
  • Test Your Knowledge - Top 10 Tips (Don't Skip)
  • Bonus Tip - Methods to Speed up Your Excel Files
  • Bonus Tip - The Possibilities & Limitations of Excel
  • PDF to Download - Top 10 Excel TIPS to Work Smarter (in print and in detail)
Top 10 Excel Formulas for Quick & Dynamic Analysis
  • Overview of Top Excel Formulas
  • Formula 1 - SUMIFS, COUNTIFS, AVERAGEIFS to Account for Exceptions
  • Formula 2 - IF (Nested Functions) Because Data Analysis is Often Not Simple
  • Formula 3 - IFERROR for Credible Reports
  • Formula 4 - VLOOKUP & HLOOKUP For Dynamic Lookups
  • Formula 5 - INDEX & MATCH for Flexible Lookups
  • Formula 5 - INDEX & MATCH for Complex Real-Cases
  • Test Your Knowledge - Top 5 Formulas (Don't Skip)
  • Formula 6 - The Most Useful Text Functions
  • Formula 6 - Advanced TEXT functions
  • Formula 7 - Excel's Top Date Functions
  • Formula 8 - OFFSET for Dynamic Calculations
  • Formula 9 - FREQUENCY, SMALL & LARGE to Organize and Rank
  • Formula 10 - SUMPRODUCT For the Gurus
  • Test Your Knowledge - Top 10 Formulas (Don't Skip)
  • PDF to Download: Top 10 Excel FORMULAS to Work Smarter
Formula Combinations for Real Cases
  • YTD Calculations - SUM, SUMPRODUCT & OFFSET
  • 3 Ways to Lookup within Boundaries: SUMIFS, SUMPRODUCT & INDEX
  • Sum Alternate Columns based on Selection - SUMIFS & INDEX
  • Sum Alternate Columns - SUMPRODUCT
Wrap Up
  • Final Words
  • BONUS! More Resources