Excel Advanced Data Analysis (Session 1 of 2)

Prerequisite- Intro to Data Analysis

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

This is part of the Data Analysis Series

Attendance is required both sessions, April 7 and 14, 9am- 12 pm