Excel: Advanced Data Analysis – Session 2

In this two-part class, participants will learn:

• Essential Excel Skills
• Work with multiple worksheets and workbooks
• Share and protect workbooks
• Automate workbook functionality
• Introduction to Macros and VBA
• Dynamic arrays
• FILTER, SORTBY, UNIQUE and other functions
• Auditing Tools
• Forecast data
• Trends, Analyze Data tool, and Forecast Sheet
• Create sparklines
• Map data
• Maps and 3D Maps

Participants must attend both sessions:

• Thursday, September 14 (9am-12pm)
• Thursday, September 21 (9am-12pm)

Note: Excel: Introduction to Data Analysis is a prerequisite to this class.