Excel: Copilot and Excel

by Alan Murray

Part of a series on 2024 Excel. In this short course we examine Copilot, a powerful AI-driven Microsoft Office feature, that can perform a variety of typical Excel tasks, from highlighting data that meets specific criteria, to writing formulas and producing PivotTables.

This module will enable you to

  • Highlight, sort, and filter data based on specific criteria
  • Use Copilot to answer "How to" questions
  • Create and develop more complex formulae with Copilot assistance
  • Analyse data to extract insights and create visualisations

About the module

The introduction of the wonderfully named Copilot - an AI assistant integrated into Microsoft 365 that uses natural language processing to assist with various tasks, will empower Excel users to achieve more.

You can use Copilot to write formulas, analyse data, and get answers to "how to" questions using natural language prompts.

Contents

  • Copilot and Excel
    • Getting started with Copilot
    • "How to" questions and answers
    • Copilot demo
    • Creating formulas with Copilot
    • Creating formulas with Copilot demo
    • Analyse data with Copilot

How it works

Author

Alan Murray

Alan has over 20 years’ experience as an Excel trainer and loves to help companies improve their business processes and learn how to harness the power of Excel.

Reviews

0
(0 reviews)
 
 
 
 
    Recommended

    Why not upgrade?

    Find the best way to complete your CPD

    Course

    Need just a few unitshourshours?

    Pick n Mix

    All you need for this year's CPD.

    Licence

    All you need for this year and more.

    Team

    Keep your whole team up to date.

    Access to this course
    Total CPD unitshourshours1 unitshourshours21 units20 hours21 hours1,500+ unitshourshours1,500+ unitshourshours
    Access period120 days120 days12 months12+ months
    Audit-proof CPD completion certificate
    Immediate access to our entire CPD catalogue
    Monthly webinars, 15-minute CPD Bites, video interviews with industry leaders, and more!
    Account manager on hand to support your team’s needs
    Learn moreLearn moreLearn more

    Why not upgrade?

    Find the best way to complete your CPD

    More in this series

    Take a look more modules from the series: Excel Updates 2024-25

    This course is only available as part of an accountingcpd licence.