2023-24 Update: Excel

(31 reviews)

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.

This course is not currently available

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-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

4
(31 reviews)
5
4
3
2
1
 
 
 
 
    Ud
    Urala D
    28 Dec 2024
    28 Dec 2024
    All areas are not necessary for accountants, may be for financial analysts
    HN
    Helen N
    18 Dec 2024
    18 Dec 2024
    Good, however I found it very wordy and could do with more videos. Could also give us some examples to do then a video to help with creating something with excel. Practice what we have just learnt.
    JT
    Julie T
    17 Oct 2024
    17 Oct 2024
    Great course explaining well the new features.

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.