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

Anne Hui San Teoh

Excel, Power Query and Copilot trainer

At a glance

2 days

In-house at your premises or a venue you choose

HRD Corp claimable