Advanced Excel Training  w/ Dashboards

Online Campus

Online
Anywhere
Online

Past Locations for this Workshop

Advanced Excel Training w/ Dashboards | Online

Online Campus

Online
Anywhere
Online

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

I have read and acknowledge General Assembly's Privacy Policy and Terms of Service. SMS message and data rates may apply.