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-2
slide-3
slide-4
slide-5
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

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 hours800+ unitshourshours800+ unitshourshours
Access period120 days120 days12 months12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team’s needs
Learn moreLearn moreLearn more
Recommended

Why not upgrade?

Find the best way to complete your CPD

Licence

All you need for this year and more.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12 months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Course

Need just a few unitshourshours?

Access to this course
Total CPD unitshourshours4 unitshourshours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs

Why not upgrade?

Find the best way to complete your CPD

Pick n Mix

All you need for this year's CPD.

Access to this course
Total CPD unitshourshours21 units20 hours21 hours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Team

Keep your whole team up to date.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Licence

Recommended

All you need for this year and more.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12 months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Course

Need just a few unitshourshours?

Access to this course
Total CPD unitshourshours4 unitshourshours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs

Pick n Mix

All you need for this year's CPD.

Access to this course
Total CPD unitshourshours21 units20 hours21 hours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Team

Keep your whole team up to date.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

You might also like

Take a look at some of our bestselling courses