| Name | Description |
| Make your Data AI-Ready |
A lack of usable data is to blame for the limited use of AI in many organisations, research suggests. Siloed systems and poor data quality remain the top barriers to the promises of AI-driven efficiencies. This one-day course shows how to use AI to fix messy data and simplify recurring reports. Participants learn how to use modern tools powered by artificial intelligence (AI) to bring together, clean, prepare and use data from many sources — without doing everything manually. It helps automate tasks such as preparing and producing regular period reports, so you can spend more time analysing results and less time organising the data.
Through hands-on exercises and real-world case studies, you’ll master AI-assisted data workflows—making your data preparation faster, smarter, and more efficient. |
| AI-Assisted Data Automation |
In an increasingly data-driven world, automation is key to improving efficiency, reducing errors and accelerating decision-making. AI-Assisted Data Automation is designed to help professionals automate data collection, processing and reporting using a combination of PowerQuery, VBA, command-line tools, task scheduling and AI-powered scripting.
This course will take you step by step through automating repetitive data tasks, such as retrieving data from multiple sources, cleaning and transforming datasets and generating reports on a schedule. You’ll explore VBA for Excel automation, PowerQuery refresh automation, file handling via command-line scripting and AI-driven enhancements to make your workflows smarter and more efficient.
By the end of this course, you’ll be able to build fully automated workflows that streamline data integration, minimize manual effort and leverage AI to optimize your automation processes. Whether you're a business analyst, data professional, or automation enthusiast, this course will equip you with the tools and techniques to take your data automation skills to the next level.
|
| AI in Excel using ChatGPT and Copilot |
The potential opportunities offered by AI are enormous, but how do you apply them to reap their benefits in Microsoft Excel? This course will help to unveil the power of artificial intelligence, exploring key concepts, applications, and cutting-edge tools like ChatGPT and Copilot. Participants will gain practical skills in using AI and learn Prompt Engineering techniques to carry out intermediate and advanced tasks in Excel. |