Here are all the new Excel blogs from the Excel Community in August 2024.
Webinars
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
This Developer level post explores how to set up your custom ribbon with tailored buttons.
Other blogs
Excel Community round up – July 2024
Here are all the new Excel blogs and webinars from the Excel Community in July 2024.
Dramatically remove blank columns in Power Query
In this article, Mark Proctor walks through a simple and efficient method for removing blank columns using Power Query.
Simple but effective, Part 8
Continuing his series, Simon Hurst looks at structured references within a Table and some more advanced examples of how to use structured references.
Using spreadsheets to get to the top
Spreadsheets keep cropping up when you least expect them to. A spreadsheet might be the answer to all your lifestyle problems.
CPD made easy for Excel Community members
ICAEW’s revised CPD regulations came into effect on 1 November 2023. As we venture into the second half of the CPD year, if you’ve still not taken time to understand and explore these then there’s still plenty of time to do so before this year’s CPD period ends on 31 October 2024.
Can spreadsheets show us how to deal with online misinformation?
We seem to have learned to live with spreadsheets, despite them giving us the wrong answer 90% of the time. Are there any lessons to be learnt from our ability to adapt to fallible spreadsheets that can help us deal with online misinformation?
Top 12 Excel Combinations: 5. SCAN LAMBDA
In the latest instalment of his series counting down the "Top 12" of Excel function combinations, Liam Bastick considers SCAN LAMBDA.
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.