2023-24 Update: Excel

by Simon Hurst

Microsoft issues new features for Excel all the time, but are you making the most of them? This course delivers the latest Excel updates to help you work more effectively and efficiently, with practical downloadable spreadsheets in each module.

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

This course will enable you to

  • Make best use of the latest Excel features released in 2023.
  • Enhance your productivity and collaborate more effectively in Excel.
  • Make your worksheets smarter, more accessible, and easier to use.
  • Expand your knowledge and mastery of dynamic arrays.
  • Customise how Excel treats your data using Office Script, Power Query, LET and LAMBDA.

About the course

Microsoft issues new features for Excel all the time, but are you making the most of them? Taking the time to master the latest updates means you can make the most of their full power. Doing this will help you work more effectively and efficiently and keep your skills competitive in a rapidly evolving digital landscape.

This course introduces some major recent usability enhancements and outlines the latest improvements to dynamic arrays. Explore the new features which allow greater customisability and programming within Excel. You also get an overview of new and improved features that can simplify many of your day-to-day tasks, and enable you to deliver deeper insights to stakeholders. Plus, you’ll be able to put what you’re learning into practice with downloadable spreadsheets in each module.

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

  • Usability improvements
    • Excel updates
    • Data Validation dropdown lists
    • In action: Data Validation
    • Cosmetic and other interface changes
    • Accessibility
    • In action: Usability
    • Collaboration
  • Dynamic arrays: Excel unleashed
    • The formula revolution
    • Dynamic array functions
    • In action: Dynamic arrays
    • More dynamic array functions
    • Example: Dynamic arrays
    • Dynamic array deficiencies
  • LET and LAMBDA
    • In action: LET and LAMBDA
    • LAMBDA within LAMBDA
  • Text functions and more
    • Text functions
    • Additional text functions
    • In action: Text functions
    • In action: STOCKHISTORY
  • New and improved features
    • Data Types
    • In action: Geography Data Types
    • Office Scripts
    • Graphics
    • In action: 3D Models
    • Power Query changes
    • PivotTables and PowerPivot

How it works

Author

Simon Hurst

Simon Hurst is a chartered accountant who has been involved in computer software for the accountancy profession for the past 30 years. He is the proprietor of The Knowledge Base, an organisation that provides IT training and consultancy to practising accountants. Simon has lectured on Excel and other Microsoft applications for organisations such as the ICAEW and the ACCA, and contributed to several significant spreadsheet-related ICAEW publications. He has also had a book published on the use of Excel for working with financial data.

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