Online course · Microsoft 365 Report Builders
Build one controlled Power Query folder or SharePoint-folder merge for a recurring Excel file set. You will document the sources, define the target columns, filter the folder before combining, repair the sample-file transform, map confirmed aliases per file…
Build one controlled Power Query folder or SharePoint-folder merge for a recurring Excel file set. You will document the sources, define the target columns, filter the folder before combining, repair the sample-file transform, map confirmed aliases per file, add visible column-drift and error checks, keep an exception log, use a recovery path when refresh breaks, and leave a refresh checklist another analyst can follow.
Learning with Collab365.
In our members’ words.
Build a useful skill
See what you’ll work on, then explore the lessons below.
Your learning, step by step
1 module · 5 lessons
Learn at your own pace.
The full course is included with access to Microsoft 365 Report Builders. See access options
Before you start
Excel-strong business analysts, reporting leads, finance and operations analysts, department power users, and accidental reporting owners who merge recurring Excel exports but are not data engineers or tenant admins.
Your next useful skill
Explore Microsoft 365 Report Builders, see what’s included and choose your access.
Source note
Course published by Collab365 Spaces, reviewed by Mark Jones on . Cite as "Merge Changing Excel Files in Power Query Without Weekly Rework", Collab365 Spaces.