AI in Excel Using ChatGPT And Copilot

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