ICAEW.com works better with JavaScript enabled.

Excel Community round up - February 2025

Author: Excel Community

Published: 03 Mar 2025

Contents

Here are all the new Excel blogs and webinars from the Excel Community in February 2025.

Webinars

Enhance Excel with Microsoft Copilot
This webinar will explore the basics of Microsoft Copilot in Excel. You will learn tips and tricks on how to incorporate Copilot into your daily use of 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.

Blogs

Excel Community round up – January 2025
Here are all the new Excel blogs and webinars from the Excel Community in January 2025.

Excel, what’s occurin’ 3 – incomplete ranges
In part 3 of the series, Simon Hurst investigates one of the most common causes for errors in Excel spreadsheets – references to ranges that omit vital cells.

Bringing financial reports alive in Excel with visualisation – comparing data sets
This third article will explore how to compare two data sets using a Waterfall Chart in Excel.

Category sums
Liam Bastick discusses summarizing dynamic arrays by category in Excel. It explores using functions like SUMPRODUCT, SUMIFS, and MMULT to achieve this. He also offers a quirky solution using SUBTOTAL and OFFSET for dynamic range summation.

Global Excel Summit 2025 – recap
This year, ICAEW’s Excel Community partnered with the Global Excel Summit, an award-winning conference for Excel enthusiasts. From the sessions hosted by MVPs and global experts we took away insights on a range of topics, including the latest Excel functionality, principles for best practice, and the skills required to advance in Excel. So, here's some of our highlights!

Excel, what’s occurrin’ 4 – number or text?
In part 4 of the series, Simon Hurst considers numbers that are not numbers.

Bringing financial reports alive in Excel with visualisation – Speedometers
This fourth article will explore ways to report achievements of plans in the form of a speedometer.

What does Excel proficiency look like in 2025?
With new Excel functions coming on stream all the time, three experts tell us what it means to make the most of the tools for tackling current accounting challenges.
https://www.icaew.com/insights/viewpoints-on-the-news/2025/feb-2025/what-does-excel-proficiency-look-like-in-2025

Why accountants must keep up with Excel functions
Excel is continuing to evolve to meet accountants’ needs. Three experts explain why professionals must keep up with its new features.

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.

Excel polaroid
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.

Open AddCPD icon

Add Verified CPD Activity

Introducing AddCPD, a new way to record your CPD activities!

Log in to start using the AddCPD tool. Available only to ICAEW members.

Add this page to your CPD activity

Step 1 of 3
Download recorded
Download not recorded

Please download the related document if you wish to add this activity to your record

What time are you claiming for this activity?
Mandatory fields

Add this page to your CPD activity

Step 2 of 3
Mandatory field

Add activity to my record

Step 3 of 3
Mandatory field

Activity added

An error has occurred
Please try again

If the problem persists please contact our helpline on +44 (0)1908 248 250