Register
A1
A B C D E F G H I J K L M N O P R S T U V Z

Leila Gharani
Microsoft Excel MVP and instructor

Impress with interactive dashboards

Work smarter with advanced formulas

What you will learn?

In this hands-on session we create an impressive, interactive KPI (Key performance Indicator) Dashboard from scratch.

You don’t just learn how to create the KPI dashboard, you also learn:

  • The process you should follow for a successful Excel dashboard Project.
  • Advanced formulas that will come in handy if you ever do complex analysis in Excel.
  • Smart use of Excel’s core functionality to get impressive results.
  • Form controls without VBA to add impressive interactivity to any of your reports.

Registrations have been closed

Impress with Interactive Dashboards Masterclass

Creating an Excel Dashboard from Scratch is hard if you don’t use the right techniques.
The process gets harder if your raw data is not in a well-structured tabular format, but rather messy like this:

Picture 1: raw data

 

Working with raw data in this form is quite common if you use an Excel-addin to connect to third party applications like SAP or Oracle.
In the masterclass we take the above data set and transform it with smart formulas to get this interactive dashboard:

Picture 2: end result

We blend in form controls for interactivity and Chart and formatting tricks for optimal design.

By the end of the masterclass you will have learnt:

  1. The steps you need to take to go from report idea to delivery
  2. How to structure your spreadsheet
  3. Apply advanced formulas to transform & analyze data
  4. Use form controls with formulas to add interactivity to your reports
  5. Chart tricks you can apply at work for better visualization

Who is right for this class:

  • You use Excel to create dashboards and reports
  • You’d like to learn how to create interactive reports
  • You’d like to get ideas & inspiration to create your own reports

Who isn’t right for this class:

  • You’re rather new to Excel
  • You’re not confident using Excel formulas such as IF & VLOOKUP
Registration
Register

For the proper functioning of this site, sometimes small data files, called cookies, are loaded onto your device. System cookies that are necessary for operation are already allowed. However, your choice is to allow or deny analytics and marketing cookies that offer a better user experience, easier use of the page, and an overview of the offer that is relevant to you. About cookies