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.

Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources. This course provides a solid introduction to using Power BI Desktop to connect to data, create visualisations, query the data and publish reports.

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 introduces two of the most powerful Excel 365 reporting and analysis tools - Power Query and Power Pivot, using them to produce an Excel Dashboard. We will examine Excel tools for ‘What if’ and newer techniques in the very important data analysis areas of LOOKUP (especially XLOOKUP) and FILTERING. Finally, we will use the Excel Dashboard we have created to communicate the results via exchanges between Excel and PowerPoint.

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.