Excel Bootcamp - Learn everything you need to know to get proficient & productive in Microsoft Excel

Thomas Fragale, Microsoft Certified Trainer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
2 Lessons (4h 29m)
    • 1. Skillshare excel bootcamp

      0:44
    • 2. Excel 5 hour bootcamp

      267:57

About This Class

Microsoft Excel has become the main program to handle large amounts of data, charts, financial models, math formulas, reports, and just about everything else pertaining to business.

But using it can still be a mystery.

This video will show you everything you need to know about using Excel and getting more productive and efficient with it. The topics include:

  • Sorts
  • Filters
  • Advanced Filters
  • Formatted Tables
  • The Total Row in Formatted Tables
  • Using Slicers in Formatted Tables
  • The Sumif, Countif, and Averageif Formulas
  • The Vlookup Formulas
  • Subtotals
  • Charts
  • Pivot Tables
  • Dashboards in Pivot Tables
  • Power Pivot and PowerQuery
  • Automating tasks with Macros