The Excel Bootcamp - Intermediate course is an overall introduction to using basic Formulas in Excel including Order of Operations, Relative & Absolute Cell references, and referring to data in another Worksheet. This course will review Excel’s built-in Formula Logical Functions such as: SUM, SUMIF, COUNT, AVERAGE, MIN and MAX. The Intermediate course will also introduce basic Lookup & Reference Formulas (VLOOKUP and HLOOKUP) with examples for working with large datasets.

Class Description:

The 4-hour Excel Bootcamp for Advanced Users course will focus on Excel’s advanced Formulas and functions to ensure data consistency and integrity. Topics include Restricting Cell entries to a range of Cells (Data Validation), Group & Ungroup data and Removing Duplicate rows from a worksheet. The Advanced course will allow students to create Charts and Graphics, and how to build Pivot Tables and basic Macros.