ICAEW.com works better with JavaScript enabled.

Excel Community round up - August 2022

Author: Excel Community

Published: 02 Sep 2022

Here are all the new Excel articles from the Excel Community in August 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.

Excel Tips and Tricks

Excel Tips and Tricks #451 – Sparklines refreshed

Looking at another under-utilised piece of functionality within Excel – the Sparkline, last covered in TOTW #290.

Excel Tips and Tricks #452 – Named Ranges refreshed

A refresher on Named Ranges in Excel, last covered way back in TOTW #188, and discusses their use and practical tips for working with them.

Excel Tips and Tricks #453 – Revisiting audit sampling with dynamic arrays

This post revisits how to build (and use) a template to assist with audit sampling using dynamic arrays, last covered in TOTW #353.

Other blogs

Excel Community round up July 2022 (public)

Here are all the new Excel articles and webinars from the Excel Community in July 2022.

Filter tips 2 – more fun with FILTER()

Simon Hurst looks at how to construct an aggregate formula to include all the items that are matched against an entire list of criteria values.

Excel how to: speed up formatting using Excel Styles – part 2

See how three particular Excel Styles can help you apply the best possible number format with a single click.

Pro-rating hours in a month

Offering a method for pro-rating hours in a month that works in all versions of Excel.

Currency exchange rates in Excel – not for you

The Currencies Data Type has recently been added to the gallery of available Data Types for users of certain versions of Excel. It allows for the display of the current exchange rate and other associated information for designated pairs of currencies. 

Webinars 

You can find our archive of all previous webinars here, many of which remain exclusive to Excel Community members. 

We have a number of further webinars planned for the rest of the year– check our list of upcoming webinars or refer to the latest newsletter.

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