2024-25 Update: Excel

by Alan Murray

This course covers recent updates and improvements to Excel, including the latest tools to help you handle data, details of formula enhancements, an introduction to the GROUPBY, PIVOTBY, and PERCENTOF functions, as well as some uses for the generative AI powers of Excel’s Copilot.

price £75+vat
cpd hours 4 CPD hours
access 120 days' access

This course will enable you to

  • Get to grips with the latest updates and improvements to Excel
  • Use new data conversion options to import and handle data
  • Take advantage of the latest advancements in Excel formulas
  • Create better reports using the NEW PIVOTBY, GROUPBY, and PERCENTOF functions
  • Use the new generative AI powers of Excel’s Copilot

About the course

For many people who work with Excel, it’s the tech gift that keeps on giving, and the latest set of updates is no exception. In fact, they go a long way towards proving that Excel is still a giant in the world of data analysis. The key is having the know-how to get the full potential out of this powerful tool.

This course has some tips and guidance for beginners, but also covers some of the advanced new capabilities of Excel that can be used to improve efficiency and control of data, details of formula enhancements, an introduction to the GROUPBY, PIVOTBY, and PERCENTOF functions. Additionally, it introduces some uses for the generative AI powers of Excel’s Copilot that you might not have known were possible.

Look inside

imac
slide-1
slide-1-thumbnail
slide-2-thumbnail
slide-3-thumbnail
slide-4-thumbnail
slide-5-thumbnail

Contents

  • Updates and improvements
    • Data Validation list improvements
    • Calendar control
    • All about checkboxes
    • Checkboxes
    • Insert pictures into cells
    • IMAGE function demo
    • IMAGE function in Excel
  • Handling data
    • Automatic Data Conversion
    • Automatic Data Conversion demo
    • Workbook links
    • Power BI connected tables
    • Getting data from the web
    • Getting data from the web demo
  • Formula enhancements
    • Stale Value formatting
    • Formatting stale values
    • Value Preview Tooltip
    • The Advanced Formula Environment
    • Using the AFE in practice
    • Managing names and LAMBDA functions
    • Formula by Example
    • Excel for the web
  • GROUPBY and PIVOTBY
    • GROUPBY function
    • GROUPBY function demo
    • PIVOTBY function
    • PIVOTBY function demo
    • PERCENTOF Function
    • Advanced examples
  • 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 unitshourshours4 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

    You might also like

    Take a look at some of our bestselling courses