Excel Advanced with AI

Course Objectives

• Leverage data analytics to generate valuable business insights and intelligence within organisation.
• Utilise statistical and computational techniques alongside effective data visualisation tools.
• Integrate AI-powered methods to efficiently manage datasets, explore various worksheet calculations with Data Tables and Goal Seek, and automatically summarise data using pivot tables.

Learning Outcomes

• Tabulate data and summaries using summary, lookup and database functions.
• Transform, clean and prepare data into high-quality, digestible datasets.
• Compute advanced summary calculations and extract records based on criteria.
• Apply various protection techniques to maintain worksheet integrity.
• Manage data ranges using advanced filtering techniques and subtotal.
• Apply data summarisation and analysis using Pivot Tables and Pivot Charts.
• Perform what if analysis to examine multiple possibilities of calculations in a dataset.
• Automate tasks by recording macros.

Reward

• E-Certificate of Completion by Kaplan will be awarded upon completion of the course