Here are all the new Excel blogs and webinars from the Excel Community in July 2024.
Webinars
Practical tips for the auditor’s review of management spreadsheets
This joint webinar from the Audit and Assurance Faculty and Excel Community will provide practical tips for reviewing spreadsheets.
Harness the potential of Power BI to solve data challenges
Power BI is a powerful took that can quickly transform data into insightful and interactive visualisations.
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.
Excel Tips & Tricks
This Developer level post explores how to get started with creating a basic custom ribbon in your workbook using VBA.
Blogs
Excel Community round up – June 2024
Here are all the new Excel blogs and webinars from the Excel Community in June 2024.
Simple but effective, part 6
Simon Hurst shows how Slicers can be used in practice to create an interactive dashboard from an Excel Table.
The underused Table feature in Excel and Google Sheets
Every spreadsheet user already considers their data to be in tables, simply by virtue of data being in rows & columns, but very few have ever used the actual feature called “Tables” which means sadly that almost every regular user is missing out on one of spreadsheets’ most useful features.
The truth about the FILTER function
In this article, Mark Proctor takes us deep into the world of TRUE and FALSE to demonstrate creative ways of using the FILTER function.
Article archive portal – new resource report page
A new report page available in the article portal helps users of the new on-demand Excel course series to discover additional content on relevant topics.
Your questions answered #11 – Tips and Tricks Live extended
David Benaim returns to answer some of the unanswered questions from the webinar.
Top 12 Excel Combinations: 6. MAP LAMBDA
In the latest instalment of his series counting down the “top 12” of Excel function combinations, Liam Bastick considers MAP LAMBDA.
Simple but effective, part 7
In this episode, Simon Hurst starts looking at the structured references that can be used to refer to all or part of an Excel Table and how they can make your formulas easier to understand.
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.