Here are all the new Excel blogs and webinars from the Excel Community in November 2024.
Webinars
Financial modelling best practice
Financial modelling is a discipline. A good financial model needs to tell a story and create confidence for the users and decision makers.
Waterfall Charts: bridging budget to actual
Dive into the world of waterfall charts – a powerful tool for understanding the factors behind budget to actual differences.
A beginner’s guide to automating in Excel using Office Scripts
Office Scripts is a feature that allows users to automate repetitive Excel tasks.
You can find our archive of all previous webinars here, many of which remain exclusive to Excel Community and ICAEW members.
Check our list of upcoming webinars or refer to the latest newsletter to see what is planned for the rest of the year.
Blogs
Excel Community round up – October 2024
Here are all the new Excel blogs and webinars from the Excel Community in September 2024.
Ticks, crosses and noughts
Experimenting with an Excel tip in a recent LinkedIn post leads to an exploration of the use of conditional formatting for adding ticks and crosses to Excel cells, and the discovering of a surprising comparison capability.
Taking the new GROUPBY() and PIVOTBY() functions further
Looking at one aspect of their use in a bit more detail: the ability to use functions and formulas within the individual arguments of each function.
Top 12 Excel Combinations: 2. SUMPRODUCT OFFSET
In the latest instalment of his series counting down the “Top 12” of Excel function combinations, Liam Bastick considers SUMPRODUCT OFFSET.
Bringing financial reports alive in Excel with visualisation
This the first article in a series that supports the lunch and learn webinars that will show you how to bring the financial reports alive in Excel with visualisation. This article will explore the journey from raw data to actionable insights.
Separating your clients
Based on the use of one or more delimiter characters to separate the client name from additional information, we are going to look at using the TEXTBEFORE() function with different delimiter alternatives.
Excel’s GROUPBY and PIVOTBY functions vs PivotTables
One of Excel’s most significant updates this decade is without a doubt the new GROUPBY and PIVOTBY functions, these can replicate PivotTables functionality through formulas. David Benaim compares and contrasts both methods whilst providing possibly the most complete guide on the internet currently of GROUPBY.
Your Excel Community – highlights from 2024
As we approach a new year, it’s time to reflect on the best content from the Excel Community in 2024 and look ahead as the community grows and develops. Whether you’re new or an existing member, we invite you to explore the insights and learnings the community has delivered for you over the last year.
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.
