Here are all the new Excel blogs from the Excel Community in September 2023.
Webinars
Power Tools Part 2: Harness the potential of Power BI
Discover the power of Power BI as we embark on a journey of data visualisation and analysis.
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
Excel Tips & Tricks #478 - Introduction to Power Automate
This week we have a Developer level post where we will demonstrate how to use Power Automate to run an Office Script against multiple Excel files simultaneously.
Excel Tips & Tricks #479 – Advanced Filter redux
This week we have a Creator level post where we will take another look at the ‘Advanced Filter’ feature.
Other blogs
Here are all the new Excel blogs from the Excel Community in August 2023.
How can “GO TO SPECIAL” help you understand a spreadsheet?
The second part of this three-article series will cover how to use the function to quickly understand a spreadsheet you’re not familiar with.
Excel, Teams, Power BI, Canva, Zoom, Google Sheets++: New tech features for Jun-Aug 2023
Our digest of new features across Microsoft 365 & other business tech products in written, images & video format covering the last three months.
How can “GO TO SPECIAL” help when reviewing logic on a spreadsheet?
This final part will cover how Go To Special can be used to identify logical inconsistencies in a model and mark them for review.
Advanced conditional formatting – part 1: automatic currency exchange
In the first part of a short series, we look beyond the default formats and include a practical example using number formatting.
Repeatable calculations with dynamic arrays - part 1: introducing the technique
In Part 1 of this four-part series, we cover the common requirements in building financial models including illustrating some common repeatable calculations.
Accessibility Features in Excel – Part 3: Best practices & features
Welcome to the third and final part of this blog series on Excel’s Accessibility features where Andrew Paw explores best practices for creating and designing accessible spreadsheets.
Advanced conditional formatting – part 2: the highlights
After looking in part 1 at some of the more advanced ways to use cell formats as part of conditional formatting, in this episode, we are looking in depth at the graphical conditional formats.
Repeatable calculations with dynamic arrays - part 2: key functions
The second part of this series covers the key functions required for repeatable calculations.
Your Questions Answered #8 – Does Power BI leave the underlying data source unchanged?
In a recent ‘Power Tools Part 2: Harness the potential of Power BI’ webinar, Monica Odysseos explored the fundamentals of Power BI, including loading data and understanding its structure. Monica returns to answer some questions.
Leveraging maths and stats in Excel for deeper data insights – part 4
The fourth part of this series will deep dive into a range of calendar functions that help with budgeting and interpreting monthly performance data.
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.
