Advanced Excel Training  w/ Dashboards

New York City campuses

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

Past Locations for this Workshop

Advanced Excel Training w/ Dashboards

New York City

New York City campuses

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

Past Locations for this Workshop

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

Coming up near you

Let’s Keep You Updated

Enter your email to start following

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.