2022-23 Update: Excel

by Samuel Ellis

Explore a range of new and improved functions including arrays, LAMBDA functions, the use of linked data and more. You'll be able to put what you're learning into practice with downloadable spreadsheets in each module.

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

This course will enable you to

  • Discover the latest Excel functions released in 2022 and improve your understanding of arrays.
  • Familiarise yourself with LAMBDA functions and their uses.
  • Use external data in your spreadsheets and learn about linked data types.
  • Update your knowledge of small user changes including accessibility checks, hiding and unhiding multiple sheets, and conditional formatting.

About the course

Are you getting the most out of Excel? When you're using it every day, it's easy to stick to the same functions and methods, and you can end up missing out on its new developments. Whether you're new to Excel or have been using it for years, there are always new features to explore to help you make the most of this powerful tool.

This course takes you through the newest updates in Excel. Explore a range of new and improved functions including arrays, LAMBDA functions, the use of linked data and more. What’s more, 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

  • Tips and tricks
    • Housekeeping
    • Hide and unhide multiple sheets
    • Conditional formatting
    • ODS files
    • Coping with wide columns
    • Navigation pane
    • Accessibility checker
    • Quick Access toolbar
  • New Excel functions
    • Vectors and delimiters
    • New functions
    • Even more new functions!
  • Introducing LAMBDA
    • Learning LAMBDA
    • Introducing LAMBDA
    • Simplify with LAMBDA
    • Calculating product cost
    • What's the margin?
    • Manipulating strings
    • Deleting characters
    • BYCOL
    • SCAN
    • Other LAMBDA functions
  • Using external data
    • Stocks
    • Custom data types

Author

Samuel Ellis

Samuel Ellis is a chartered accountant with experience working in private accounting firms and a number of high growth businesses. He has spent the past six years working as Head of Finance for InterWorks, a global specialist data consulting practice.

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