*All four course dates are included in the Bootcamp

Course I: Basic Mathematical Operations and Cell Referencing

Saturday, January 5th | 2:30p – 5:00p

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

Course II: Pivot Tables Part I 

Saturday, January 12th | 2:30p – 5:00p

  • Review the navigation of Pivot Tables
  • Change Data Sources
  • Sort and Filter data within Pivot Tables

Course III: Pivot Tables Part II

Saturday, January 19th | 2:30p – 5:00p

  • Introduction of Slicers
  • Pivot Table Review

Course IV: Vlookup 

Saturday, January 26th | 2:30p – 5:00p

  • Cell References
  • Vlookup

Course V: Logic Statements

Saturday, February 9th | 2:30p – 5:00p

  • IF Statements
  • Nested IF Statements
  • Aggregate IF Statements (SUMIF, AVERAGEIF, COUNTIF)