Here are all the new Excel blogs and webinars from the Excel Community in May 2024.
Webinars
What’s new in Excel, PowerPoint, Teams & Microsoft 365 from the last year (2023-24)
This will webinar will showcase the new features and updates in everyday workplace software through live demos and an interactive Q&A.
You can find our archive of all previous webinars here, many of which remain exclusive to Excel Community and ICAEW members.
Check our list of upcoming webinars or refer to the latest newsletter to see what is planned for the rest of the year.
Excel Tips & Tricks
Excel Tips & Tricks #490 – Revisiting data entry shortcuts
This Basic User level post revisits simple keyboard shortcuts that help expedite entry of data into Excel.
Excel Tips & Tricks #491 – Creating a dynamic lead schedule
This Creator level post explores how to use VSTACK, CHOOSECOLS and FILTER to create a dynamic lead schedule and dynamic dropdown options.
Blogs
Excel Community round up – April 2024
Here are all the new Excel blogs from the Excel Community in April 2024.
Top 12 Excel Combinations: 9. NOT ISNUMBER
In this instalment of his series counting down the “Top 12” of Excel function combinations, Liam Bastick considers NOT ISNUMBER.
Simple but effective, part 3 – extending Tables
Continuing his series of the capabilities of Excel Tables, Simon Hurst will consider the changing of the dimensions of Tables manually.
Top 12 Excel Combinations: 8. INDEX SEQUENCE
In this instalment of his series counting down the “Top 12” of Excel function combinations, Liam Bastick considers INDEX SEQUENCE.
Avoid column name errors in Power Query
Changing column names are a frequent cause of Power Query errors. This article explores a few techniques to avoid those errors and ensure Power Query refresh runs smoothly.
Simple but effective, part 4
This time, Simon Hurst focuses on the use of Data Validation and Dynamic Arrays to automate the creation of summary reports.
Join the Excel Community
Do you use Excel in your organisation? Are you using it to its maximum potential? Develop your skills and minimise spreadsheet risk with our Excel resources. Membership is open to everyone - non ICAEW members are also welcome to join.
Archive and Knowledge Base
This archive of Excel Community content from the ION platform will allow you to read the content of the articles but the functionality on the pages is limited. The ION search box, tags and navigation buttons on the archived pages will not work. Pages will load more slowly than a live website. You may be able to follow links to other articles but if this does not work, please return to the archive search. You can also search our Knowledge Base for access to all articles, new and archived, organised by topic.
