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.
Pre-requisites
No prior experience in AI required. The course covers foundational concepts before delving into how to use AI with Excel. This course provides an understanding of using ChatGPT and Copilot to enhance your capabilities in data analysis, reporting and decision-making.
Who Will Benefit?
This course is designed for participants seeking to future-proof their skill set and stay at the forefront of technological advancements. Excel users who want to harness the power of artificial intelligence in their work will benefit greatly.
Software setup required
Participants should have Microsoft Excel 365.
Prior to the course, all participants should register for a free account on ChatGPT so they can complete the hands-on exercises. Participants should also have a Microsoft account to log in to https://copilot.microsoft.com/ and should do this prior to the course.
Introduction to Artificial Intelligence
Introduction to AI
LLMs and Natural Language Processing
Examples of AI tasks
Limitations of AI assistants
Data security implications
Some Prompt Engineering basics
AI & Excel
Use AI to:
Create a formula
Explain what a formula does
Ask for instructions carrying out a task
Intermediate Level Excel Tasks
Asking ChatGPT and Copilot for instructions for intermediate tasks
Conditional formatting
Using PowerQuery
Using recently added functions like RANDARRAY(), VSTACK(), HSTACK() and REGEXEXTRACT()
Advanced Level Excel Tasks
Asking ChatGPT and Copilot to:
Explain the LAMBDA function
Explain the LET function
Create a User Defined function using LAMBDA
Create simple automation using VBA
Create more advanced automation using VBA
For further information click here
