The Excel Bootcamp - Advanced 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.