If you have little to no Excel experience or looking for a smooth refresher, then our Excel courses are for you. You will learn the essential basic and intermediate formulas and functions of Microsoft Excel via a Fortune 500 case study.

Beginner’s Microsoft Excel

  • Workbooks vs. Worksheets
  • Cell References
  • Formatting
  • Basic Math Operations
  • Excel Basics

Intermediate Microsoft Excel: Logic Statements

  • Cell References
  • IF Statements
  • Nested IF Statements
  • ISNA and IFERROR

Intermediate Microsoft Excel: Aggregate Logic Statements

  • Cell References
  • SUMIF(s)
  • AVERAGEIF(s)
  • COUNTIF(s)

Intermediate Microsoft Excel: Vlookup

  • Cell References
  • Vlookup
  • Index & Match

Microsoft Excel: Pivot Tables

  • The Pivot Table Quadrant
  • Slicers
  • Calculated Fields
  • Pivot Charts
  • Formatting and Sorting

Microsoft Excel: Visualization

  • Reviewing different charts and graphs types
  • Utilization of Dynamic Charts and Graphs

After the bootcamp, homework will be assigned through Showbie and students will be assigned a Completion Certificate.