Home / Course catalog / Excel level 3 – 1 Consolidatin... (Bus_Excel_03-01)

Business tools

Excel level 3 – 1 Consolidating multi‑source data with power query (Bus_Excel_03-01)


Description

This module helps learners import and combine data from multiple sources with minimal manual handling. It directly addresses the need to consolidate simulator exports and recurring extracts reliably by using Power Query to import, transform, and refresh data into clean operational tables.

Content
  • How to import, edit, load, and consolidate data with power query
  • Optional : Power query – source reference as file path in cell
  • How to merge content of all files in folder with power query
  • Optional : Managing external data connection in advanced Excel
Completion rules
  • All units must be completed