Webinars
You can find our archive of all previous webinars here, available to ICAEW members and members of the Excel Community.
Excel vs Google Sheets: the battle of the spreadsheets
Covering a range of themes including core formulae, collaboration, visualisations and advanced functionality.
We are now planning the webinar series for 2023 – check our list of upcoming webinars or refer to the latest newsletter.
Excel Tips and Tricks
Excel Tips & Tricks #462 – New text manipulation functions – TEXTBEFORE and TEXAFTER
Looking at specific examples of using the new TEXTBEFORE and TEXTAFTER functions in Excel.
Excel Tips & Tricks #463 – Top Tips of 2022
Pausing to look back at the best content from the Excel Community this year.
Other blogs
Liam Bastick looks at the Risk Bubble Charts in Excel, This is part two of the article.
Excel, Teams, Power BI, PowerPoint, Zoom, G Sheets, Meet – new tech features for Sep-Dec 2022
Our digest of new features across Microsoft 365 & other business tech products in written, images & video format covering the last three months.
You might be familiar with GIFs from their use in Social Media applications or as short, silent animations within online training material. As well as demonstrating how much you are laughing out loud at a friend’s latest message, GIFs can be very useful as a training or troubleshooting aid.
Excel – smarten up your dashboards
Investing just a few more minutes on improving the presentation of your dashboard can give it greater impact and help it communicate its message even more effectively.
Looking at the common ‘clean up’ problem in Excel – how to separate text and numbers
The OFFSET() function – can it survive in the era of Dynamic Arrays?
Useful as the OFFSET() function can be, it is ‘volatile’ and breaks the Excel formula auditing chain. The INDEX() function can often be used to replace OFFSET() and now the latest Dynamic Array developments mean that there might be even fewer reasons to stick with the OFFSET() function.
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.