IN-STEP V.I.S.I.O.N. - Data Analysis & Dashboard Reporting using MS Excel with Power Query
2 days
HRD Corp claimable
Runs in-house for your team
Overview
Built for experienced Excel users, this programme shows how to clean large data sets with Power Query, analyse them and present the results as interactive dashboard reports.
The first half is about Power Query. Participants import data from CSV files, workbooks, PDFs, web pages and folders, fix spacing and date problems, append queries, and merge them using six join types. They then analyse the cleaned data with PivotTables and Excel 365 functions such as FILTER, UNIQUE, TEXTJOIN and XLOOKUP, and format PivotTable reports so they are easy to read and update.
Participants finish by building a one-screen dashboard from PivotCharts, slicers, timelines, sparklines and conditional formatting, ready to share.
Module topics
- Managing raw data with Power Query
- Appending data from folders, sheets and PDFs
- Merging queries with join types
- Lookup versus merge queries
- Data analysis with functions and PivotTables
- Excel 365 functions for multiple datasets
- Formatting PivotTable reports
- Building an interactive one-screen dashboard
- Preparing and distributing reports
Who runs this programme
At a glance
2 days
In-house at your premises or a venue you choose
HRD Corp claimable
More in this category
Microsoft Excel
2 days
2 days
Microsoft Excel
2 days