The global body for professional accountants

7
UNITS

Webinar | ACCA

Power Query for Finance Professionals (Excel - in-person)

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

This immersive practical workshop is for accountants who want to push the boundaries of what they can achieve with Excel and the speed with which they can achieve their goals.

Various styles of activities and collaborative challenges have been designed to keep participants engaged and involved for the entire duration of the workshop for all participants to optimise their learning and value from attending this course.

These hands-on activities will allow participants to get familiar with Excel functions to optimise their workflow, get familiar with the Excel’s Power Query interface, learn about data automation, and apply this knowledge to their daily activities with Excel.

Who should attend?

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

Requirements

Please bring along your own laptop and charging cable with Microsoft Office and Excel installed for this session.

We recommended the use of Microsoft Excel 2016 and above for this workshop.

  • 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

Divya Arora

Divya is a thorough professional and has 13 years of Work experience and have core skills in field of Business Intelligence, Management reporting and analytics. She is excellent in her oration and has been responsible for training her teams and stakeholders in areas of Advanced Excel techniques, mastering the art of giving presentations, Business Intelligence, Dash boarding and visual presentations in alignment with organisation goals.

She has varied experience working with big giants like Glaxo Smith Kline, ABN AMRO and Max Life Insurance and various training institutes in India and Singapore.

Divya has worked across different industries like healthcare, consumer and insurance. She has been a key player in working across transition projects, transformation journey’s, new process set ups, data warehousing and Enterprise wide deployment of new Business Intelligence tools

Divya has been a key contributor to Quality and service excellence and is certified Green Belt Six Sigma professional.

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

Your own computer with Microsoft Office and Excel installed is required for this session.

We recommend the use of Microsoft Excel 2016 and above for this class.

What is Included

This workshop will include Lunch and two tea breaks. F&B Refreshments will be provided. Please check your dietary requirements when you book.

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.

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 405 SGD

Affiliate 415 SGD

Approved employer 455 SGD

Student 415 SGD

Public 490 SGD

Location

Singapore

Date & time

29 August 2025, 09:00 - 17:00 Singapore time

Delivered by

ACCA logo