Here are all the new Excel blogs and webinars from the Excel Community in March 2025.
Webinars
Is this the end of Pivot Tables?
This webinar will explore the basics of Pivot Tables before diving into new and alternative functionality that can also be used to analyse and work with data in Excel.
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 Creator level post explores BYROW and BYCOL, functions that can help troubleshoot common issues when using Dynamic Arrays.
Blogs
Excel Community round up – February 2025
Here are all the new Excel blogs and webinars from the Excel Community in February 2025.
Using range functions in Excel
In this article, Mark Proctor explores a group of functions which can dynamically manipulate ranges in Excel for flexible calculations.
Your questions answered #13 – Mastering Copilot in Excel
In a recent webinar, David Fortin, Microsoft MVP and founder of Piggy Bank Accountant, explored how to get started with Microsoft’s Copilot and the basics of Copilot’s functionality in Excel. In this article, David returns to answer your most asked questions.
Excel, what’s occurin’ 5 – getting iffy with it
This series looks at some of the things that can go wrong in an Excel spreadsheet and at what we can do to avoid or resolve the issue. This time we are going to explore the use of the IF() function.
New tech features for December 2024 – February 2025: Excel, Teams, Power BI, Canva, Google Sheets++
Our digest of new features across Microsoft 365 and other business tech products in written, images and video format covering December 2024 to February 2025.
Calculated fields and calculated items
Liam Bastick looks at how calculated fields and calculated items can be used to solve problems in Excel, rather than resorting to more complicated functions.
Excel, what’s occurin’ 6 – Towards Zero
This series looks at some of the things that can go wrong in an Excel spreadsheet and at what we can do to avoid or resolve the issue. This time we conclude our exploration of dodgy numbers with a look at number formats and zeros.
Ranges vs Arrays – what’s the difference, and why you should care?
In this article, we look at the differences between ranges and arrays. Compared to ranges, we will see that arrays give us total flexibility for making many Excel calculations easy to perform.
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.
