Advanced Excel Training w/ Dashboards | New York City

About this workshop

Put the power of Excel to good use, and build upon your existing knowledge. In this class — ideal for people working in business, management, or simply interested in getting more organized — you will take a set of raw data, and turn it into an executive-level interactive dashboard. We will work through the process step by step to import, categorize, and analyze the data. We will be using several formulas and functions, as well as pivot tables.

Takeaways

• VLOOKUPS & HLOOKUPS
• INDEX / MATCH
• Pivot Tables and Charts
• Record Macros

Prereqs & Preparation

A strong working knowledge of Excel is mandatory. Relative and absolute cell references, nested formulas, and functional understanding of Excel formatting. You do need a laptop w/ Excel loaded. (Google Sheets is an ok substitute, but not preferred).