The global body for professional accountants

7
UNITS

Webinar | ACCA

Power Query for Finance Professionals (Excel)

This immersive practical workshop is for accountants who want to push the boundaries of what they can achieve with Excel

Overview

Person touching huge screen

Designed specifically for professional accountants, this course provides practical, hands-on training in Power Query—a powerful Excel tool for automating and streamlining data preparation. Participants will learn how to connect to various data sources, clean and transform raw data, and build repeatable processes for reporting and analysis.

Through real-world accounting scenarios, learners will explore techniques such as merging and appending queries, splitting and formatting columns, applying conditional logic, and working with dates. The course also includes a foundational overview of Tables and PivotTables to support efficient data modeling. By the end, participants will be equipped to handle large volumes of financial data with greater accuracy and speed, enhancing both productivity and reporting quality.

Who should attend?

Excel users familiar with majority of Excel functionalities and wish to optimise efficiency in data cleaning and manipulation.

  • Tables
    • Why use Tables
    • Naming
    • Design
    • Autofill formulae and formatting
    • Slicers
  • Pivot Tables
    • Create PivotTable from Table
    • Names
    • Layout, sub totals and grand totals
    • Sorting and filtering
    • Slicers
    • Calculated columns
    • Field formatting
    • Set up Pivot Wizard
    • Consolidate Pivot Tables
  • Introduction to Power Query
    • What is Power Query, its use cases and limitations
    • Power Query Editor navigation
    • Data sources
    • Row/column manipulation
    • Sorting and filtering
    • Split/merge columns
    • Change data type
    • Replace values
    • Format text/text manipulation
    • Extract prefix/suffix
    • Merge/Append queries
    • Transpose
    • Index/Conditional/Custom column
    • Loading Queries
    • Query Dependencies and Connections
    • Working with Applied Steps
    • Duplicate Queries
    • Grouping Data
    • Date Functions

Vincent Chin FCCA

Vincent has held financial, continuous improvement and I.T. positions in the banking, shared services and hospitality industry. He is a FCCA, Certified Six Sigma Black Belt, Microsoft Certified Trainer, Microsoft Office Specialist and a PSMB-accredited trainer. His previous roles include being an internal change consultant of a global team, a financial shared-services local head and a finance regional head.

He currently trains professionals in Excel, Power BI and Lean Six Sigma covering topics related to finance, business intelligence tools, pivot tables, dashboards, VBA and process improvement.

Qualifications

  • Microsoft Certified Trainer| MICROSOFT | 2020
  • Microsoft Office Specialist Expert| MICROSOFT | 2020
  • Microsoft BI Reporting in Excel | MICROSOFT | 2019
  • Microsoft Office Specialist | MICROSOFT | 2017
  • Certified Trainer | PSMB | 2013
  • Certified Six Sigma Black Belt | ASQ | 2011
  • FCCA | ACCA | 1998

CPD units

Attendance to this session will accord you with 7.0 CPD units (ACRA Category: 5). A CPD certificate will be sent to you by email within 2 business days after your completion of this online workshop.

Requirements

  • Microsoft 365
  • Zoom
  • Recommended to use two computer monitors and utilise webcam for a better learning experience

ACCA Singapore CPD subsidy

ACCA Singapore is currently offering a special subsidy to active members, affiliates and students to support them in their professional development. This offer is available on selected courses here and on a limited basis. Terms and conditions apply.

Promotions

Group registration offer

Get 10% off when you sign up as a group of 2 or more (not applicable to Member / Affiliate / Student rates). Apply this discount code GROUP2MORE to your order on the payment summary. Offer is not valid for Super Early Bird rates.

Open to global participants

Please email us to book under ACCA rates if you are a global ACCA member / affiliate / student or for query on class status prior to booking.

Partner offer

CA ANZ, IIA Singapore, ICAEW, SCTP and ISCA members enjoy 10% off Public Rates.

UTAP funding

Claim 50% off regular workshop fees (excluding GST) that you pay if you are an NTUC Union member. Only applicable for self-funded workshops not funded by employers.

NTUC Union members can claim up to $250 per year or $500 per year (40 years and above, till Dec 2025) for your self-funded professional development.

Note: All workshops and courses listed are subject to change. Please contact us to confirm the workshop/course status of commencement if you are not based in Singapore, and require travel arrangements.

Price

Member 265 SGD

Affiliate 275 SGD

Approved employer 335 SGD

Student 275 SGD

Public 380 SGD

Location

Singapore

Date & time

12 September 2025, 09:00 - 17:00 Singapore time

Delivered by

ACCA logo