Advanced Excel Training  w/ Dashboards

Washington, D.C. campuses

GA D.C., 1776
1133 15th Street NW, 8th Floor
Washington D.C. 20005

Past Locations for this Workshop

Advanced Excel Training w/ Dashboards

Washington, D.C.

Washington, D.C. campuses

GA D.C., 1776
1133 15th Street NW, 8th Floor
Washington D.C. 20005

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.