Excel Level 5 – Dashboards

If the numbers you need to track are spread out across different systems, learn how to have everything on one screen so all you need to do is give it a glance. Yes, it’s time to make a dashboard.

It’s like the instrument panel for your business. Your car has one. Planes have one. Let us help you make one for your business too.

This course is will enable you to present business data in Excel without using Power BI. You’ll learn more advanced techniques to display the data for Management.

Watch a snippet of what’s involved in our Excel Dashboards Level 5 course here

Who is it for?

This One Day course is specifically designed for office users, managers, accountants and data analysts. Delegates on this course should have existing advanced knowledge of Excel, and we will turn you into an Excel expert. We will cover some of Excel’s best kept secrets and will look in detail at:

Course Content
Learn

  • The differences – Dashboards & Reports
    Questions before you start
    Dashboard design principles
    Golden Rules
    Formatting numbers effectively
    Custom Number formats
    Useful Formulas for Dashboards
    Data tables
    Charts
    • Sparklines
    • Charts that show trending
    • Side-by-side comparison charts
    • Secondary axis
    • Conditional Formatting
    • Using Symbols to enhance Reporting
    • Camera Tool
    • People graphs
  • Pivot Tables
    • Creating
    • Sorting
    • Filtering
    • Re-arranging
    • PivotCharts
    • Issues with file size
    • Pivot Table reports
    • Interactivity with slicers
    • Dynamically rearranging pivot table data
    Grouping & bucketing data
    Showing performance against target
    Macros
    • Useful macros for dashboards
    • Navigation buttons
    • Form Controls
    Time slicers
    Protecting your dashboards
    10 Questions before distributing your dashboard
Hands-on exercises

Hands-on exercises and demonstrations help you gain in-class practice creating engagement programs. Take-home your very own Microsoft Certified Manual to help extend your learning beyond the class as you apply what you have learned back in your job.

Pre-requisites: Delegates should have completed up to and including Excel Level 3 skills, (Advanced formulas) or equivalent experience, to ensure you can participate in this training.

These skills are not difficult to learn but you need a firm foundation in the basics so you can get the most from this course.

Ways to attend Onsite Classroom Training – Public courses are available or for group training we can deliver Onsite Training.

Online Training by appointment

Call us on 01952 581 550

Cost

£550 + VAT

For Group Training rates or more details please complete this enquiry form and we will call you!

Get A Quote

  • This field is for validation purposes and should be left unchanged.

Looking for other topics?

Excel header
Overview