Microsoft 365 learning
Learn how to get started with Microsoft 365 applications. Create your first documents, forms, presentations and spreadsheets with this productivity suite.
Modules you'll cover
This module covers
Getting started with Microsoft Excel
Working with data
Knowledge check
This module covers
Adding data
Formatting data
Adding titles
Knowledge check
This module covers
What are formulas?
Formula basics
Cells and formulas
Knowledge check and challenges
This module covers
Filtering data
Sorting data
Using filter and sort together
Knowledge check
This module covers
What are logical functions?
What are IF, AND and OR functions?
Combining logical functions
Challenge and knowledge check
This module covers
What are lookup functions?
Using VLOOKUP and HLOOKUP
Using XLOOKUP, INDEX and MATCH
Challenge and knowledge check
This module covers
Data validation
Further data validation techniques
Conditional formatting
Combining data validation and conditional formatting
Knowledge check
This module covers
How to enter data
How to format your spreadsheet
How to use basic formulas
How to present data with graphs and charts
Knowledge check
This module covers
How to use data validation
How to use filters and sorting
How to use text based formulas
Presenting data with graphs and charts
Knowledge check
This module covers
What is Microsoft OneDrive?
This module covers
Adding email accounts
Explore the screen
This module covers
Sending emails
Replying
Knowledge check
This module covers
Folders, search and mark up
Rules and Quick actions
Knowledge check
This module covers
Using the calendar
Using To-do lists
Knowledge check
This module covers
Get started with Microsoft Teams
This module covers
Get started
Chatting options
Group chats
Controlling your alerts
Knowledge check
This module covers
Add text to your document
Formatting basics
Knowledge check
This module covers
Access
Files and folders
Sharing and permissions
Knowledge check
This module covers
What is Microsoft PowerPoint?
How to get started with Microsoft PowerPoint
This module covers
How to create and alter a title slide
Formatting slides
Knowledge check
This module covers
How to use text on your slides
How to use images on your slides
How to use align tools to improve your slide
How to use videos in your slides
Knowledge check
This module covers
How to use shapes in Microsoft PowerPoint
How to alter shapes in Microsoft PowerPoint
How to use multiple shapes to create unique designs and icons
Knowledge check
This module covers
How to add data to a slide
How to create charts
Knowledge check
This module covers
How to animate objects
Alter and combine animations
Using transitions
Knowledge check
This module covers
Host and control a meeting
Join a meeting
Meeting tools
Knowledge check
This module covers
Set up teams and channels
Posting messages and announcements
Collaborate with files
Knowledge check
This module covers
What is Microsoft Word?
Create and save a document
This module covers
Headers and footers
Tables and columns
How to use colour
Add images, icons and links
Knowledge check
This module covers
Create yourself a cover letter on Microsoft Word
This module covers
Reviewing
Collaboration
Knowledge check
