
Excel Advanced Data Analysis – Session 2
Wednesday, September 24, 9:00 am – 12:00 pm
Excel Data Analysis Advanced: 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
Prerequisite- Intro to Data Analysis