Microsoft Excel Data Analysis and Dashboard Reporting

  • VLOOKUP() Function for Looking up Information

  • INDEX()/MATCH() Functions a Powerful Alternative to VLOOKUP

  • TEXT() Function for Formatting

  • CHOOSE() for Ultimate Flexibility in Presenting Data

  • Advanced Filtering

  • Summarizing Data with PivotTables and Pivot Charts

  • Interactive Features to Create User Friendly Reports

  • VBA Magic to Create Dynamic Content

  • and more....