Skip to content
2026/2027 in-house training dates are now open.Request a proposal →
Digital & AI training

Power Query for Financial Reporting Automation (Intermediate)

Combine, Reconcile and Refresh Monthly Finance Data

This two-day Intermediate level covers data transformation, combining monthly data, merging queries for account mapping, automated consolidation, reconciling two sources and refreshable reporting. All exercises use fictional company data, and the programme ends with a final project: a payroll reconciliation.

2 days
Power Query for Financial Reporting Automation (Intermediate) corporate training session

Learning outcomes

  • Reshape finance data for reporting, including unpivoting monthly columns.
  • Combine monthly and entity data into one table.
  • Merge queries to map accounts to report lines.
  • Reconcile two sources and list the unmatched items.
  • Build refreshable reports on top of Power Query.

Course outline

  1. 1

    DATA TRANSFORMATION

    • • Reshape data for reporting.
  2. 2

    COMBINING MONTHLY DATA

    • • Stack twelve months of data into one table.
  3. 3

    MERGING QUERIES

    • • Join tables the way lookups do, but at scale.
  4. 4

    AUTOMATED DATA CONSOLIDATION

    • • Consolidate entities or departments automatically.
  5. 5

    RECONCILING TWO SOURCES

    • • Find what matches and what does not.
  6. 6

    REFRESHABLE REPORTING

    • • Reports that update with one click.

Quick facts

How long is the programme?
2 days. The schedule can be adjusted, for example split into half-day sessions, to suit your operations.
Who should attend?
Finance Teams, Accounting Teams, Shared Services Teams.
Where is it held?
In-house at your premises, at an external venue or hotel of your choice, or virtually, anywhere in Malaysia including Kuala Lumpur, Selangor, Penang and Johor.
Can the content be customised?
Yes. We tailor examples, case studies and activities to your industry, KPIs and company values while keeping the programme's learning outcomes.

Related programmes