And if you are an Excel Community subscriber, don’t forget that you need to renew your membership to keep access for 2022 – see our overview of what’s coming here.
Excel Tip of the Week
423 – Our Excel Christmas list (public)
Several of our bloggers chime in with their wishes for the program in 2022.
A review of the quintessential data sorting and filtering tool.
A Power Query data transformation tool with surprising depth.
There are plenty of places you can add passwords to Excel – but which are really reliable?
Other blogs
Conditional formatting and spreadsheet review – part two rules are better than one
Simon Hurst continues his look (following on from part one last month) at how to spot overzealous error catching formulas, using conditional formatting.
Modeller and MVP Liam Bastick continues his examination of how to allocate fees across non-even periods.
Displaying reports by date – Excel versus Power BI
Simon looks at the date visualisation options available in the two platforms.
Microsoft Office 2021’s new features (Excel, PowerPoint, Word and Outlook) (public)
MVP David Benaim returns with his latest roundup of everything new and exciting in Microsoft 365.
The 2021 Excel Community pantomime - Min and Max return! (public)
For a festive special, Simon Hurst with an Excel-lent challenge – how many function names can you spot?
John Tennent continues his series on all things data visualisation with this latest examination.
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.
