ICAEW.com works better with JavaScript enabled.
Exclusive

Excel Community round up - May 2023

Author: Tracy Gray

Published: 05 Jun 2023

Exclusive content
Access to our exclusive resources is for specific groups of students, users, subscribers and members.

Here are all the new Excel blogs and webinars from the Excel Community in May 2023.

Webinars

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

Financial modelling and scenario planning: mastering effective decision-making
The importance of scenario planning and how to use it effectively.

We are continuing to plan the webinar series for 2023 – check our list of upcoming webinars or refer to the latest newsletter.

Excel Tips & Tricks

Excel Tips & Tricks #471 – Refreshing GETPIVOTDATA
Refreshing our coverage of the PivotTable extraction function GETPIVOTABLE.

Excel Tips & Tricks #472 – Conditional formatting components
Exploring how to use difference components of conditional formatting including data bars, colour scales and icon sets.

Excel Tips & Tricks #473 – Refreshing customizing the ribbon
Dipping our toes back into the pool of customization options available through Excel.

Other blogs

Excel Community round up – April 2023
Here are all the new Excel blogs from the Excel Community in April 2023.

Excel fundamentals training – what should be included?
Should basic Excel training stick to simple formulas and functions or should it extend the horizons of learners to consider the likes of Dynamic Arrays, PivotTables and Power Query?

LOOKUP
LOOKUP may seem a less versatile function upon first glance, but it is quite useful for modelling.

Building an Excel model to test if you are a going concern
At times of uncertainty and high inflation, the assessment of an organisation’s going concern is going to be high on the agenda for the Board and in particular the accounts sign off meeting with the auditor.

OFFSET
This is a function modellers either love or hate. It considers disposition or displacement.

Avoiding another Find mess
A seemingly simple question during a lecture reveals the benefits of delving beneath the surface of Excel’s user interface in order to help find what you are looking for.

Is there anything that Power Query can’t do?
In this article we look at automating the changing of column heading text.

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