Advanced Microsoft Excel Formulas and Dashboards

DOWNLOAD BROCHURE              

Go to registration form

Creating an impressive, interactive Excel Dashboard from scratch is not easy! You used to stare at your empty sheet and wonder where to even start? You need a structured process in place to go from idea to outcome in a smooth way.
You’ll find out all about it in the course. We setup two fully functioning dashboards from scratch. This course doesn’t just teach you a set of functions and features, but how you can use them together to create impressive reports. It teaches you how to approach a new Dashboard project and how to structure your work so maintaining the dashboard becomes very easy not just for yourself but for anyone else.

WHAT YOU WILL LEARN

• How to approach an Excel dashboard project from idea to delivery
• How to add interactivity to your Excel reports – No VBA required
• Impress management with reports that make the decision-making process faster
• Clever use of Excel core functionality for responsive spreadsheets
• Learn how to create a professional KPI dashboard from scratch
• Create impressive, non-standard Excel charts using smart techniques
• Build Pivot Table-based dashboards for easy interactivity
• Use powerful visual techniques so your content has more effect

This course teaches you to create well-designed Excel dashboards so you and your colleagues
can see trends and make quick decisions informed by data.
This Excel Dashboard course comes with templates, tools and checklists that can be applied
directly to your Excel reports.
Checklists and design guidelines.
Excel workbook to follow along.

What is the target audience?

• Business Professionals who use Excel to create dashboards
• Data analysts
• You currently use Excel and want to improve your skills
• You’d like to learn how to create interactive reports
• You’d like to improve the design of your existing Excel report