Course curriculum

    1. Sign Up for MS Copilot as A Single User

    1. Set up data for Copilot in Excel

    2. Writing Excel Formulas with Copilot

    3. Using Copilot in Excel for Data Analysis

    4. Conditional Formatting using Copilot

    5. Combine Columns in Excel with Copilot

    6. Multiple Conditional Formatting

    7. Testing the accuracy of Copilot

    8. Large Data Set: 90,000 Records

    9. NEW Feature: No Table Needed to Use Copilot

    10. Advanced Function: XLOOKUP

    11. Conditional Formatting with Multiple Colours

    12. Chat history

    13. List Separation excercise

    1. Create a Powerpoint presentation from a Word document

    2. Create a Powerpoint Presentation from Scratch using Copilot

    3. NEW feature: PDF straight to PPT

    4. Sections & Slides with 1 prompt

    1. Rewrite Text using Copilot

    2. Visualise A Bulleted List as a Table

    3. Creating a Business Plan

    4. Refine documents generated by Copilot

    5. Outline a Powerpoint in Word, with copilot

    1. Creating Announcements with Copilot

    2. Catch Up with Copilot in a Teams Meeting

    3. Summarise Interactions across apps: Chats, Emails, Files

    1. Creating insightful surveys with Copilot

About this course

  • $9.99
  • 31 lessons

Your instructor

Chris Menard

Chris Menard, a Microsoft Certified Trainer (MCT) at BakerHostetler, a leading national law firm with offices in 17 cities, is a skilled and experienced educator. With over two decades of training experience and a deep understanding of Microsoft 365, G-Suite, and eLearning, he is a sought-after speaker for organizations such as the Georgia Society of CPAs, the American Society of Administrative Professionals, EA Ignite Conference, and the University of Georgia. Chris’ impact extends beyond the lecture hall, with his popular YouTube channel boasting over 900 technology tutorials with a combined 15 million views. When not training and educating, Chris enjoys traveling and spending time with his family.

Take the Microsoft Copilot course

And receive lifetime access as well as new lessons as they are added

Enroll today