ICAEW.com works better with JavaScript enabled.

Excel Community round up - April 2025

Author: Excel Community

Published: 01 May 2025

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

Webinars

50+ new Excel features from this half decade
This webinar will explore many new features and capabilities introduced over the last five years which have transformed the way we use 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

Excel Tips and Tricks #498 – Introducing TRIMRANGE
A Creator level post introducing one of Excel’s newer functions – TRIMRANGE. TRIMRANGE is a new function in Excel that allows users to easily exclude leading or trailing blank rows or columns in a range.

Blogs

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

Excel, what’s occurin’ 7 – Conditional formatting from bottom to top
Looking at applying multiple conditional formats to the same cell or range of cells and seeing why you might use a conditional format with no format.

Aligning data in PowerQuery
In this article, Ben Ducker explores how to use PowerQuery to align data and fields from several sources and time periods into one report.

Bringing financial reports alive in Excel with visualisations – building the report
This fifth and final article in the series covers bringing together the visualisations to build a financial report.

Excel, what’s occurin’ 8 – Data Validation
In this part of the series, Simon Hurst moves on from conditional formatting to look at data validation.

Adding calculated fields to the GROUPBY function
Mark Proctor explores the concept of PivotTable calculated fields and reimagining them with Excel’s new GROUPBY function. Discover how to build dynamic, formula-based summaries that can go beyond what PivotTables can do.

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