ICAEW.com works better with JavaScript enabled.

Excel Community round up – April 2022

Author: Ian Pay

Published: 06 May 2022

Here are all the new Excel articles and webinars from the Excel Community in April 2022. Posts marked as public can be accessed by anyone; other articles are accessible to Excel Community subscribers and can be accessed by logging in to your ICAEW account.

Webinar

We are currently reviewing our plan for webinars for the rest of 2022, so watch this space!

In the meantime, you can view our archive of all previous webinars, many of which remain exclusive to Excel Community members.

Excel Tip of the Week

Excel Tip of the Week #440 - How to get better at Excel (public)
In David’s final TOTW post, he shares some of his best tips for getting better at Excel.

Excel Tips and Tricks #441 - Under the (Easter) Bonnet: What’s an XLSX file anyway?
A dive into Excel file types and the inner workings of an XLSX file – including what it means from a security perspective.

Excel Tips and Tricks #442 - Revisiting Screenshots
Refreshing how screenshots can quickly and easily be incorporated into Excel documents (including some hidden but very handy Windows functionality). 

Other blogs

New dynamic array functions – be careful what you wish for
Simon Hurst briefly explores some of the new functions coming soon to Excel and why, perversely, they undermine one of his strongest cases for using Power Query!

Exploring Charts (Graphs) in Excel - Part 12: Controlling zeros or missing data, using conditions to highlight attributes and saving a chart for use in other applications
For this final blog in the series, John Tennent sweeps up a few of the more unknown charting features that can add significant value to the display of data.

Excel how to: speed up formulae - using Excel tables
In the latest ‘how to’ guide for formulae, Simon Hurst explains how Excel tables can make formulae easier to enter, easier to understand, and easier to review.

Working with power query - don't think cells
An exploration of the language that sits behind Power Query – ‘M code’ – and how this helps us move away from cell-based thinking in Excel.

Multiple running totals
MVP Liam Bastick runs with the topic of running totals and the complexities of constructing them robustly.

 
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