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.

This course is not currently available

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

How it works

Author

Samuel Ellis

Sam has been using modern data technologies for the past decade to operate a lean and agile accounting function. He uses data analytics software e.g. Tableau to transform accounting reporting in a modern, shareable and actionable format whilst reducing time taken to prepare reports and streamlining content to minimise noise. Sam was a founding member and Chair of the ACCA’s Global Technology forum, steering ACCA’s approach to updating members around key technology developments and trends.

Reviews

You might also like

Take a look at some of our bestselling courses

This course is not currently available. To find out more, please get in touch.