Great Canadian Training Company color logo

Microsoft 365 Upskilling 2024 Workshop

What You'll Learn in Microsoft 365 Upskilling 2024 Workshop

Course Length

2 hours (1 day)

Learning Objectives

In this Microsoft 365 Upskilling workshop, participants will unlock the full potential of Word, PowerPoint, Excel, and Outlook. Throughout this workshop you will learn to use the latest features to create engaging documents and presentations and to manage data more efficiently. You will:

  • Learn to work seamlessly with others using features like @Mentions, Track Changes, and Improved Co-authoring.
  • Discover tools like the Dictation Toolbar, Search Box, and Paste Values Shortcut to get more done in less time.
  • Master techniques for captivating presentations, including Closed Captions and the Morph Transition.
  • Dive into Excel's data analysis and visualization tools, like Analyze Data, Search Box, and Searchable Dropdown Lists.
  • Understand advanced formulas with Formula Evaluation Tooltips and simplify your data input with Insert Data from Picture.
  • In Outlook, learn to enhance communication with Reactions and ensure your emails are accessible to all through the Accessibility Checker.
  • Explore advanced Excel functions for text manipulation, combining arrays, shaping arrays, resizing arrays, and more to become an Excel pro.

Target Student

This workshop is designed for individuals with a Microsoft 365 subscription who want to make the most of the latest updates to Word, Excel, PowerPoint, and Outlook. Whether you're a beginner or have some prior experience, if you're eager to learn the newest tools and techniques for document creation, data management, presentation design, and effective communication, this course is tailored to meet your needs and help you excel in your Microsoft 365 tasks.

Course Outline

Collaboration and Co-authoring in Word

  • @Mentions
  • Track Changes


Productivity and Accessibility in Word

  • Dictation Toolbar
  • Search Box


Presentation Delivery and Collaboration in PowerPoint

  • Rehearse with Coach
  • Present in Teams
  • Save Media with Closed Captions


Productivity and Design in PowerPoint

  • Search Box
  • Morph Transition


Collaboration and Co-authoring in Excel      

  • Improved Collaboration with Co-authoring  


Data Analysis and Visualization in Excel       

  • Analyze Data  
  • Search Box     
  • Searchable Dropdown Lists   
  • Insert Data from Picture        


Formatting in Excel

  • Paste Values Shortcut


Formulas and Functions in Excel

  • Formula Evaluation Tooltips  


Communication Enhancements in Outlook 

  • Introducing Reactions


Accessibility in Outlook 

  • Check your Email Message for Accessibility Issues


Excel 365 New Functions

Text Manipulation

  • TEXTBEFORE() / TEXTAFTER()
  • TEXTSPLIT()    


Combining Arrays

  • VSTACK() / HSTACK()  


Shaping Arrays

  • TOCOL() / TOROW()  
  • WRAPCOLS() / WRAPROWS()


Resizing Arrays

  • CHOOSECOLS() / CHOOSEROWS()    
  • DROP() / TAKE()         


Honourable Mention

  • UNIQUE()     
A seal with “Guaranteed to Run” written on it. In the middle is a person giving a thumbs up, standing behind a checkmark

Delivered by Great Canadian Training

Microsoft 365 Upskilling 2024 Workshop

Upcoming Classes

All Public classes are held online
with a live instructor

No dates have been scheduled for this class. Please contact us for more information or request a private class.

Groups of 6 or more? Consider private training

I want a quote for private or customized training


Have questions about this course? See below or reach out to our training coordinators.

The Great Canadian Training & Consulting Company Advantage

When you train with us, your training will not just check a box. We make sure it is GREAT!

  • Experienced Trainers
  • Learn or Come Back Free Policy on Public Classes
  • 24/7 After Training Support

All of our courses include

PDF Reference Guide

Want a summary of what you’ve learned? Save paper and use your PDF Reference Guide, accessible on any of your devices.


24/7 After-Training Support

Receive a 30-day after-training support voucher, offering assistance as you apply your new skills on the job. Need help with a specific step? We’re here to provide extra support and clarity even after you’ve left the class!


Can I customize my course?
OF COURSE!

Use your own files instead of our exercise files

You can opt to use your working files in your private training sessions (instead of our standard exercise files). This allows you to see how the lessons apply directly to your day-to-day role and get work done while you train—a true win-win!