Here are all the new Excel blogs and webinars from the Excel Community in August 2025.
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 Basic Level post explores some simple tips and tricks for formatting your data to maximise its impact.
Blogs
Excel Community round up – July 2025
Here are all the new Excel blogs and webinars from the Excel Community in July 2025.
Not dead yet – refreshing update for PivotTables
A new option has appeared for Excel Beta Channel users in the PivotTable Analyze ribbon tab, Data group – AutoRefresh.
40 years of Excel’s weird and wonderful quirks
The world’s favourite spreadsheet turns 40 in September, so before a full-on Excel-stential crisis (with a title like that you didn’t expect some bad puns?), let’s explore some oddities.
Summarising Vertical Lists Horizontally
For the second month running, Liam Bastick has an article inspired by recent consulting problems. Obviously, he will change the data! Imagine we have a table called Data (sorry, that’s as far as my imagination goes!) that contains details of some new items and their suppliers in a standard tabular format (i.e. a vertical list), as below. Let’s suppose we need to import this data into an inventory management system.
Seeing stars – managing relationships with Power BI
In our short series on Power BI and conditional formatting we have had the opportunity to look at data structures and joins between tables as well as conditional formatting itself. This time we will investigate the table joins in a bit more detail.
Introducing Excel’s new COPILOT function
Excel has launched its “latest and greatest” function, COPILOT. Currently it is in Beta and only available to users on the Beta Channel, through the Microsoft Insider Program.
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.
