Here are all the new Excel blogs and webinars from the Excel Community in January 2024.
Webinars
Excel Tips and Tricks Live: your questions answered
Join our experts as they tackle your Excel questions, quandaries, and more.
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
Looking at how to create hyperlinks in your file, to aid quick navigation. We will also cover the differences between hyperlinks in Excel Online and the desktop versions.
Other blogs
Animated Excel Christmas Tree follow-up
Following the response to our 2023 Christmas special, we are extending our interactive Excel Christmas card to demonstrate some additional Conditional Formatting techniques.
Microsoft 365 Copilot or get the features without the pricey license
This article (or jump to the end of the article for a summary table) will cover Microsoft 365 Copilot’s capabilities and also describe alternative ways, beat for beat, to get to the same features, however, this is a non-exhaustive list based on capabilities in early 2024.
First Normal Form: the most important Excel concept nobody told you about
In his first article for the Excel community, Mark Proctor explores how to apply the basic principles of First Normal Form to Excel to reduce the complexity of working with data in spreadsheets.
Get your errors right
It can be very important to predict errors that might occur in your spreadsheet and then to build in mechanisms for highlighting them, or dealing with them automatically. Knowing the best functions to use can not only simplify your formulas, but also help to avoid your error handling making the initial problem even worse.
Don’t be a check box Charlie
In preparation for a very useful enhancement to the Excel check box feature that is currently available to those on the Insider update channel, we take a look at how check boxes work at the moment before seeing how much easier they will be to use in the near future.
Top 12 Excel Combinations: 12. IF IF (Nested IFs)
Liam Bastick introduces a new series counting down the “Top 12” of Excel function combinations - starting in 12th place, he considers Nested IFs.
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.
