ICAEW.com works better with JavaScript enabled.

Excel Community round up – February 2024

Author: Excel Community

Published: 01 Mar 2024

Here are all the new Excel blogs from the Excel Community in February 2024.

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

Excel Tips & Tricks #487 – An introduction to Slicers
We have a Basic User level post exploring the basics of setting up, customising and using slicers in Excel to filter and sort through data.

Blogs

Spreadsheet review – can Power Query help? Part 1
Legacy Excel supports a range of functions and techniques that can help identify potential errors and problems within a spreadsheet as part of a review process. However, it’s worth considering the addition of Power Query to your review toolkit on the grounds of simplicity and ease of use.

Office Scripts vs VBA: What’s the difference?
Office Scripts are a new scripting language for automating Excel. In this article, Mark Proctor explores how Office Scripts differ to VBA and what we can or cannot do with each.

Microsoft Loop: Edit things from multiple entry points
Loop Components allows users to edit a bullet list whilst in an Outlook email, whilst others edit in Teams’ meeting notes and it will update simultaneously in all places.

Spreadsheet review – can Power Query help? Part 2
In part 1 of this series, we looked at some of the advantages of adding Power Query to your review toolkit. In part 2 we are going to look in more detail at some of those tools and techniques.

Top 12 Excel Combinations: 11. IF ISERROR (Error Trapping)
In the latest instalment of his series counting down the “Top 12” of Excel function combinations, Liam Bastick examines IF ISERROR (Error Trapping).

Spreadsheet review – can Power Query help? Part 3
This time Simon Hurst moves on from the Profile table that he created in Part 2 to rearranging the Table and positioning it above his original data for ease of reference.

Excel’s new functions might change data analysis forever
Excitement is building, as a range of new functions introduced by Microsoft towards the end of last year are – hopefully – edging closer to general release.

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