Microsoft Excel® Advanced (in person)

If you’re confident with Excel basics, you’re ready to move advance!

In this class, you will learn how to build nested formulas step by step, including text and date functions. You will link formulas across multiple worksheets and workbooks, and use Data Validation and conditional formatting to control data entry and highlight important results.

Using list tools, you will organize, clean and summarize large datasets. You’ll create PivotTables enhanced with Slicers, Timelines and PivotCharts. You will finish with practical skills, clearer insights and real Excel confidence.

Primary Topics Covered:

• Use advanced and nested formulas, including text and date functions
• Link across multiple worksheets and workbooks 3-D formulas
• Apply Data Validation and conditional formatting to control data entry and highlighting results
• Create PivotTables with Slicers, Timelines and PivotCharts for dynamic data analysis