Here are all the new Excel blogs and webinars from the Excel Community in July 2025.
Webinars
Transform general ledger data with Power Query
Practise with this follow-along webinar looking at streamlining your ledger exports.
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
Welcome back to Excel Tips and Tricks! The Excel Community has been around for over 10 years, and last month we published our 500th Tip. In this tip, we take a look at what we have covered so far, and where our tips and tricks are headed next.
Blogs
Excel Community round up – June 2025
Here are all the new Excel blogs and webinars from the Excel Community in June 2025.
Reduce spreadsheet maintenance with a dynamic total row
When data changes, it is common to update formulas to accommodate the size of the data. However, less maintenance we need to do, the more efficient we can be. So, in this article we look at how to stop updating total rows by having them move position automatically.
Reach for the stars – joining the club
Following on from using conditional formatting in a Power BI report to highlight our 500th tips and tricks article, this time we are looking at adding stars to our on-demand courses resource page to highlight the most relevant posts for each of our 6 modules. As part of allocating stars to articles, we will look at different ways of relating tables to each other in a relational database.
Excel, what’s occurrin’ 12 – a fresh way to deal with stale values
Having dealt with a range of issues including many that cause numbers to appear not to add up correctly, for our last episode we are going to look at the most read post ever on the Excel Community and see how the key issue it concerns has now been addressed by a recent Excel enhancement.
Calculating car financing rates
Liam Bastick explains how to calculate the interest rate on a car loan, using Excel's RATE function and first principles to verify the quoted rate.
What is scalar lifting, and why should you care?
What happens when we provide multiple values to a function argument which expects a single value? We encounter the magic of Excel’s dynamic array calculation engine.
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.
