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.
Contents

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?