artificial intelligence

Microsoft Copilot is your AI-powered companion, offering insightful answers, creative inspiration, and engaging conversation to make your life easier and more interesting.

This course covers the following main areas:

Introduction to Microsoft CoPilot

What is Artificial Intelligence?

Describe the purpose and functionalities of Microsoft 365 Copilot

Outline the working principles behind Microsoft 365 Copilot

Identify the core components integral to Microsoft 365 Copilot

Copilot and the internet

Features of using Copilot with the internet

Best Practices of using Copilot

Copilot in Outlook

Introducing Copilot in Outlook

Creating emails with Copilot

Replying to emails using Copilot

Searching your Outlook inbox using Co-pilot

Transform long emails into short summaries

Managing your Outlook Calendar using Copilot

Coach emails in Outlook using Copilot

Copilot in Teams

An Overview of Copilot in Teams and how it improves your communication

Using Copilot in in Teams in channel conversations

Using Copilot in chats

How Copilot can review and manage documents in Teams

How Copilot can assist in organising and structuring your upcoming meetings

Learn how to use Copilot to draft content in Teams Chat and Channel Conversations

Learn How Copilot summaries file information within Teams

Copilot in Word

Introduction to Copilot in Word

Creating new documents in Word using Copilot

Editing documents in Word using Copilot

Generating content in Word using Copilot

Summarising document in Word using Copilot

Inserting objects and table into Word using Copilot

Copilot in Excel

Introduction to Copilot in Excel

Data Analysis in Excel using Copilot

Formatting Excel Data with Copilot

Conditional Formatting using Copilot

Sorting, Highlighting and Filtering data using Copilot 

Creating Formulas in Excel using Copilot

Creating Xlookup using Copilot

Creating a Pivot in Excel using Copilot

Accessing Copilot Labs

Copilot in PowerPoint

Creating presentation using Copilot

Editing presentation using Copilot

Applying slide animations and transitions using Copilot

Integrate Word documents into PowerPoint using Copilot

Summarise detailed presentation into focused slides using Copilot

Time saving techniques using Copilot

Artificial Intelligence is reshaping the way professionals work with data, and Microsoft Copilot

in Excel is at the forefront of that change. 

It enables users to analyse, clean, format, automate,

and optimise spreadsheets with greater speed and efficiency.

This course covers the following main areas:

Foundations Of Using Copilot in Excel

What is Microsoft Copilot

Copilot and Excel

Formatting Excel Data with Copilot

Conditional Formatting with Excel

Sorting, Filtering and basic formulas using Copilot

Data Cleanup

Basic Charts and Copilot

Copilot Text Formulas

Flash Fill & Copilot

Excel Core Skills and Copilot

Ifs and Sumif with Copilot

Nested functions for complex calculations – Array Formulas with Copilot

Data Validation & Copilot

Copilot and Date Calculations

Converting Vlookup to Xlookup Using Copilot

Xlookup & Copilot

Further Xlookup searches using Copilot

Data Analysis with Copilot

Data Analysis and Writing Prompts

Identifying and correcting common data errors with Copilot

Sales Forecasting and Identifying Low and High Sales Performers with Copilot

What if Scenarios and Copilot

Linking Spreadsheet with Copilot

Linking & Xlookup with Copilot

Summarising Feedback Comments with Copilot

Summary Reports Using Copilot

Creating a spreadsheet by extracting data from a Word document

Extracting data from a website and using Copilot to summarise the data

Creating Subtotals using Copilot

Creating a Pivot Tables using Copilot & in-depth Analysis

Creating a Dashboard using Copilot

Populating data onto a new worksheet using Copilot

Further Advanced Formulas & Concepts 

Multiple Sort Using Copilot

Convert to any live Currency Exchange Rates

Comparing data with a 10-year forecast based on historical data

Creating Advanced Data Analysis and Dashboards in Copilot Using Python

Copilot and Creating Macros

Analyse Data (AI Insights & Querying)