Advanced Data Management and Excel Techniques for Accounting & Finance

This workshop is designed for finance and accounting professionals, who are already familiar with the basic excel interface and willing to learn further to upskill themselves for their professional world and better career prospects.

Overview

This workshop is focused on complex calculations through dynamic formulas, sorting and filtering techniques, modifying charts, enhanced formatting to design reports in a impressive way thereby enabling meaningful and insightful information using excel. This workshop will also help participants learn new excel shortcuts that will help them increase their efficiency and productivity in their day to day work

Participants will work on multiple data sets during hands-on exercises and gain expertise in all the advanced functions, complex charting techniques with enhanced functionalities, mastering pivots and many more.

Outline
Speaker
Additional information

Managing and Data handling and data cleaning tips for large financial data and workbooks
Learning shortcuts to analyse data at your fingertips
Mastering Advanced Functions and latest Formulas to manage complex financial processes
Use of complex business formulas to convert raw data into meaningful information
Using advanced functions to process data and generate insights
Information Visualization through Excel - Using visual data techniques
Master the art of creating various Charts to include complex Key Performance Indicators (KPI)
Using appropriate charts according to different business problems
Combine different charts to represent multiple KPIs
Using eye catchy graphics to focus on key highlights
Working with Pivot Tables
Mastering the art of pivots and using it for business analysis
Create Report Filters Mastering Excel and its functionalities to further enhance productivity and efficiency in day to day work
Using Advanced Data cleaning techniques and examples
Creating Dynamic excel workbooks using quick tips and tricks
Quick tips on MACROS

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 workshop.

Requirements

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

We recommended the use of Microsoft Excel 2010 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.

Price

Member 405 SGD

Affiliate 415 SGD

Approved employers 455 SGD

Student 415 SGD

Public 490 SGD

Location

Singapore

Date & time

14 May 2025

Book on ACCA

Advanced Data Management and Excel Techniques for Accounting & Finance

Overview

CPD units

Requirements

What is Included

Course provider