- 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
- Outline
- Speaker
- Additional information
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