In this one day bootcamp, we will move beyond the basics of spreadsheet creation. We will dive into data manipulation and advanced functions to summarize and analyze data with multiple attributes. We will also introduce using slicers with Pivot Tables, creating interactive reports, and using advanced formulas. Interactive in-class exercises will be utilized to facilitate understanding.
Agenda
Participants will learn how to effectively streamline and analyze data using some of the more advanced features of Excel including: • Advanced Functions • Pivot Tables and Pivot Charts
This bootcamp is designed for participants with familiarity of basic features/functions in Excel (i.e. navigation, layout, basic formulas like SUM/COUNT, etc).