Jun 20 & Jun 27 , 2025
CPD hours: 7
Aim
To equip participants with advanced Excel skills necessary for efficient data analysis, enhanced data visualization, and secure worksheet management in professional environments.
Objective
Participants will learn to:
1) Apply advanced Excel functions.
2) Use conditional formatting to highlight key data patterns and trends.
3) Efficiently manage and secure worksheets.
4) Create, modify, and analyze data using pivot tables, advanced sorting/filtering, and scenario tools.
5) Design professional charts, including sparklines and combined charts with customized elements and secondary axes.
Participants’ Profile
This seminar is ideal for finance professionals, data analysts, project managers, accountants, and auditors. Participants seeking ways to utilize all Excel features to create “smart sheets” or analyze data will find this course very useful.
Certification
All participants will be awarded a certificate. Each hour of attendance will account for one unit of Continuing Professional Development (CPD) as required for members of most professional bodies.