Advanced Excel Training w/ Dashboards | New York City

Data

New York City Campus

GA NYC (Manhattan), Classrooms
10 East 21st Street
New York NY 10010

Past Locations for this Workshop

New York City

Stay up to date

Follow this workshop to get an email the next time it’s scheduled.

Sign-up not required

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).