Here are all the new Excel blogs and webinars from the Excel Community in October 2024.
Webinars
Charting and reporting monthly results
Learn how to effectively present monthly reporting using charts.
Excel tips and tricks live: your questions answered
Join our experts as they tackle your Excel questions, quandaries and more.
Power tools part 5: Transform work processes with Power apps
This webinar will cover use cases and show how Power Apps connects with common data sources like SharePoint.
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 General User level post explores the ‘Check Performance’ functionality to improve workbook performance in Excel.
Blogs
Excel Community round up – September 2024
Here are all the new Excel blogs and webinars from the Excel Community in September 2024.
Using slicers with PIVOTBY, GROUPBY and FILTER
The newest functions, GROUPBY and PIVOTBY will be rolling out to users over the next few months. In this article, Mark Proctor uncovers the techniques we can implement for using slicers with these new functions.
Unsend your emails
Simon Hurst looks at how Outlook can help protect us from ourselves.
Multiple conditional formats
It is possible to apply multiple conditional formats to the same cell or range of cells. In this article we look at making sure that your rules are in the right order.
Excel’s real-life superpowers
Useful as some features are when used in a spreadsheet, they could be even more empowering if available in real-life. In this article, we consider some examples and explore the use of AI in illustrating the possibilities.
Solving the array of arrays issues
In this post, we explore the “array or arrays” issue in Excel’s calculation engine. We demonstrate how this leads to unexpected results and how we can work around the issue.
Top 12 Excel Combinations: 3. IFERROR FORMULATEXT
In the latest instalment of his series counting down the “Top 12” of Excel function combinations, Liam Bastick considers IFERROR FORMULATEXT.
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.
