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