Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Excel Level 4 Dashboards

Knowing your numbers - your core metrics - is absolutely critical to your success. Sometimes the numbers you need to track are spread out across different systems. It's so useful to have everything on one screen and all you need is to 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's make one for your business too.

Description

This material will be taught over two x 3 hour sessions

The differences between Dashboards and 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

 

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

People graphs

Protecting your dashboards

10 Questions before distributing your dashboard

Prerequisites

Delegates should have completed up to and including Level 3 Excel skills, or equivalent experience.

Similar courses

Excel Level 1 Secrets

Our Excel Level 1 course covers Tips & Tricks for selection, navigation and using shortcuts for all the things that normally would take twice the time (which you do a lot!). You’ll learn all the basics to create and manage spreadsheets yourself and we cover the 5 basic formulae everyone should know! We teach the secrets of formatting super-fast to make your spreadsheets look great.

More Information
Excel Level 2 Ninjas

To help you become an Excel Ninja we cover manipulating multiple files and worksheets, 3D formulas, linking cells and special number formats to speed up data entry; ways to collapse large workbooks to see the totals you need and advanced charting; Making amazing tables in one click with secret built in formula; You'll learn how to speed up navigation around your spreadsheet and use range names in formula;

More Information
Excel Level 3 Gurus

On this course you’ll learn how to use Logical functions to work out ‘What IF’ questions. We cover The 5 Most Popular Math and Statistical Functions for Geeks but in a way that makes them easy to understand and conquer! Learn the new XLOOKUP function. You'll be looking at the Advanced Data Management features and how you can use them; You'll use Goal Seek and Solver to show how to answer business questions; We will look at what macros are, best practise and create a simple macro in our session.

More Information
Excel Level 5 BI

This course is designed for an Advanced Excel user to Understand the capability of the new Business Intelligence tools in Excel and use them to create great data visualisations and dashboards. Our Excel Business Intelligence course has been developed to fill the gap with this first look at the new data manipulation features. Intended for Advanced Excel users this course runs through how to use the tools – Get & Transform, Power Pivot, Power Maps and Desktop BI Visualisations.

More Information
Excel Level 6 BI Visualisations

A practical guide to using Desktop Power BI app to manipulate large data sets using DAX formulas, measures and calculated columns in Power Query.

More Information

Press enter to see more results