Here are all the new Excel blogs and webinars from the Excel Community in December 2024.
Webinars
Speedometers: tracking year-to-date expectations
Learn how to set up speedometers in Excel, customise their appearance, and use them to report on year-to-date achievements. We’ll discuss optimal ranges, needle placement, and visual cues.
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 – November 2024
Here are all the new Excel blogs and webinars from the Excel Community in November 2024.
Excel, Teams, Power BI, Canva, Zoom, Google Sheets++: new tech features for Sep-Dec 2024
Our digest of new features across Microsoft 365 and other business tech products in written, images and video format covering the last three months.
Spoiler alert: the answer is 364
It’s festive-themed quiz season. We use a common Christmas quiz question as the pretext for examining a range of LAMBA() based Excel functions.
Your questions answered #12 – getting started with Office Scripts
Following on from ‘A beginner's guide to automating in Excel using Office Scripts’ webinar, Mark Proctor, Microsoft MVP and Director at Excel Off The Grid, returns to address more of the questions that came out of the webinar on how to get started with Office scripts to automate tasks and processes in Excel.
Your 2025 Excel Community Guide
As we step into a new year, we’re delighted to welcome all our members to the growing Excel Community. With over 1,000 articles, over 490 tips, 4 thought leadership guides and an extensive archive of webinar recordings, we realise that it can sometimes be tricky to find what you’re looking for. So, here is a guide that you can use as a starting point to make the best use of your community.
From numbers to pictures – using INDEX() with MAKEARRAY()
Having in the previous post used several of the new LAMBDA() helper functions, most notably MAKEARRAY(), to calculate the total number of gifts given across the 12 days of Christmas, Simon Hurst now looks at replacing our numbers with pictures that represent each of the gifts.
Top 12 Excel Combinations: 1. INDEX MATCH
This month’s offering makes it very clear that this is a highly subjective list. If you don’t like this month’s suggestion, that’s fine; life would be boring if we were all in agreement.
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.
