ICAEW.com works better with JavaScript enabled.

Excel Community round up - February 2022

Author: David Lyford-Tilley

Published: 02 Mar 2022

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

A comprehensive guide to PivotTables (2022)

David Lyford-Tilley walks through everything you need to know to get proficient with PivotTables, including the potent Power Pivot add-in.

There is also an accompanying blog post in which we break down all of your questions from the session here.

Excel Tip of the Week

SUBSTITUTE redux (public)

Take a look at how to do find-and-replace with a formula – or even how to make a complex function to handle multiple replacements in a single step.

Date-creating formulas redux

Build a date from a day, month, and a year, or learn how to add and subtract months easily.

Revisiting Excel file types

We consider the most common Excel file types, what they mean, and what each is best used for.

Revisiting making sets of PivotTables

Cycle through all the options in your report filters with our handy guide.

Other blogs

Dynamic Arrays – it's not just about the new functions and spilling

Simon Hurst dives into the greater advantages of Excel’s newer calculation engine.

Visio free tier: Flow charts, Venn & business matrices (public)

MVP David Benaim shows you how can make a variety of common visualisations easily, using Visio.

Exploring Charts (graphs) in Excel: 11 – Trendlines

John Tennent dips into how to add trendlines to your charts – plus how to get their equations outputted into cells.

Excel how to - speed up entering formulae part 1

Turbo-charge your formula efficiency, with Simon’s guide to shortcuts and other handy tips.

Data Validation dropdown lists – major improvement on the way

The latest changes to Excel are going to make using dropdown menus much easier.

Looking up over a range

Modeller Liam Bastick is here with a look at how to convert scores into grades with the aid of the classic LOOKUP function.

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