Data Consolidation using Power Query

July
22
2026 (Wednesday)
Time 10:00 AM PDT | 01:00 PM EDT
Duration: 90 Minutes
81 Days Left To REGISTER
Id: 212243
Instructor
Jai Malhotra 
Live
Recorded
Live + Recorded

Overview

Power Query can consolidate multiple files/sheets/folders into one standardized dataset-ideal for monthly MIS when formats are similar but sources are many.

Why you should Attend

  • Consolidating multiple files manually leads to errors and missed records
  • Folder-based consolidation can update with one click when new files arrive
  • Standardize inconsistent formats across teams and branches
  • Create a reliable data foundation for PivotTables, dashboards, and Power BI
  • Learn common patterns for consolidating files, sheets, and folders effectively

Areas Covered in the Session

  • Folder consolidation, combining 
  • Files/sheets
  • Standardizing headers 
  • Adding metadata
  • Refresh strategy 
  • Building a clean consolidated table

Who Will Benefit

  • Reporting & MIS Teams
  • Operations Teams
  • Finance Teams
  • Analysts who Consolidate data from many Sources Regularly

Speaker Profile

Jai Malhotra is Microsoft Certified Professional who has 11 years of rich training experience as Corporate Trainer. The Instructor has conducted more than 900 training sessions of Corporate Sessions and upskilled work forces in the domain of Microsoft Excel, Power BI, SQL, Power Point, ChatGPT and Copilot. He got opportunity to serve Companies like Deloitte, NTT Data, Hafel, Virtusa, SBI Cards, Tata AIG, Maruti Suzuki, Max Life Insurance, Volvo Eicher, XL-Catlin, L&T, M3M, WSP, Panasonic, PwC, Paisa Bazaar etc.
Access Recorded Version
One Attendee / Group Attendees

Unlimited Viewing Recorded Version for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)