Overview:

This 2-day practical programme on “Formulas and Functions with AI” equips participants with the skills to use spreadsheet formulas and functions more effectively with the support of AI. Participants will learn how to create, explain, troubleshoot and optimise formulas using AI, while applying functions for calculations, logical decisions, data cleaning, lookups and analysis.

Through hands-on exercises and real-world business scenarios, participants will develop greater confidence in combining traditional spreadsheet skills with AI to improve productivity, accuracy and data-driven decision-making.

Pre-requisites:

Before starting or enrolling for this program, there are some vital prerequisites to consider. One must have a basic understanding of Excel functions and formulas for a quick grasp. Also having access to the ChatGPT and Copilot is also vital to get the best out of this program. Other notable requirements include having a stable internet connection, and a device with access to at least 2016 Microsoft Excel. Nonetheless, your potential interest in learning about this topic and acquiring additional knowledge and skills make this course apt for your career development.

(a)  Must bring along laptop (with at least MS Excel 2016 installed) and mobile phone/ tablet;

(b)  Access to MS Excel, Copilot and ChatGPT;

(c)  Understanding of Excel functions and basic terminologies;

(d)  A stable internet connection

Learning Outcomes:

Upon completion of this program, participants will be able to:

(1) Understand the fundamentals of spreadsheet formulas and functions and apply them effectively;

(2) Use AI to create, explain, troubleshoot and optimise formulas;

(3) Apply commonly used functions for calculations, logical analysis, text manipulation, dates and lookups;

(4) Use advanced functions such as XLOOKUP, SUMIFS, COUNTIFS, FILTER, SORT and UNIQUE;

(5) Develop effective AI prompts to solve spreadsheet-related tasks;

(6) Identify and correct formula errors with the assistance of AI;

(7) Analyse business data using formulas and AI-powered insights;

(8) Combine AI with spreadsheet functions to improve productivity, accuracy and reporting efficiency; and

(9) Apply the skills learned to real-world workplace scenarios and business datasets.

Who Should Attend:

Anyone with basic spreadsheet knowledge who wants to become more efficient by combining formulas, functions and AI.