ICAEW.com works better with JavaScript enabled.

Excel Community round-up - January 2022

Author: David Lyford-Tilley

Published: 03 Feb 2022

Here are all the new Excel articles and webinars from the Excel Community in January 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

Excel Tip of the Week Live: your questions answered (Winter '22 edition) (public)

Our latest free webinar sees “Excel Tip of the Week” author David Lyford-Tilley answer questions from all corners, tackling your spreadsheet conundrums. You can also check out the accompanying blog – equally free! – going over all the questions we received here.

Excel Tip of the Week

427 – Power Query: Word frequency analysis (public)

Take a dataset and break it down to discover the most common words – and even exclude certain common words – using our step-by-step guide.

428 – Converting between statistical measures

Have a standard deviation, but need a confidence interval? Or have a probability, but need the standard deviation? Excel can help you do the computations you need.

429 – Revisiting cross-sheet formulas

Formulas can point from one worksheet to another – but there are plenty of wrinkles to be aware of.

430 – 3D maps

Create a tour of your data that moves through space and time.

Other blogs

Christmas pantomime answers – Part 1, Part 2 (public)

Simon Hurst goes over all the functions hidden in his Christmas pantomime post, along with links to where you can read more about many of them.

Weighted averages await

Modeller Liam Bastick explores how to compute weighted average payments accurately and efficiently.

Automated text search solution (public)

Simon shows how to dynamically remove unwanted characters from text with Power Query.

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