Bristol Community College

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.