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.

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.

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.

This course is designed to give Excel users a deeper knowledge of functions and formulas for a more effective way of reporting using charts, Pivot Tables and Data Tables.

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