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:
- The steps you need to take to go from report idea to delivery
- How to structure your spreadsheet
- Apply advanced formulas to transform & analyze data
- Use form controls with formulas to add interactivity to your reports
- 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