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.

Advances in AI coupled with modern features in MS 365 greatly simplify creating eye-catching and informative presentations. Effective usage of Copilot/ChatGPT cuts the time and manual input required for presenting and reporting on data, whether for regular meetings, ad-hoc assignments or regulatory requirements. This hands-on course will guide you through using AI Tools with MS 365 to efficiently and professionally present information.

This course shows participants how to automate data collection, processing, and reporting using AI, PowerQuery, VBA, and scripting tools. Learn to streamline workflows, reduce manual effort, and improve data accuracy. Automate report generation, reconciliation, and compliance tasks while leveraging AI for smarter decision-making. Gain hands-on experience building efficient, end-to-end data automation solutions.

The aim of the course is to provide a general introduction to spreadsheet modelling and related analysis. During the course, participants will create a model 'from scratch' and the use of this model for various outputs, as outlined below (ROI, dashboard outputs etc.). This is augmented by a feed of given data into the model from 'history' to allow comparisons etc. with the model outputs.

Power Automate is an online workflow service used to automate time-consuming business tasks and processes across apps and services. This example-driven course will give the confidence to select the right actions and logic for business workflows. Participants will learn how to navigate the Power Automate interface confidently, use templates, create workflows and triggers and how to use Artificial Intelligence to increase productivity.