Description
Why would you create a dashboard in Excel? The reason is simple: you can use it to visualise all your data. Dashboards are the ideal tool to report or present numbers. In our online ‘Excel Dashboards’ course, we’ll guide you through all the necessary steps, from importing and processing data to visualising everything in a dashboard.
During this course, you’ll use Office 365 features.
Objectives
After this training, you’ll be able to:
- Import data lists from external data sources via Power Query
- Transform data lists in Power Query into actionable data
- Use Power Pivot to analyse data from multiple tables
- Analyse data with PivotTables and charts
Collect analyses in a dashboard and effortlessly draw the correct conclusions
Prerequisites
Basic Excel knowledge is required. You know the standard formatting options, you can sort and filter data with AutoFilter, you know the basic functions (Sum, Min, Max, Average, Count, Counta) and you know how and why you should freeze cells (A1 and $A$1).
