Webinars
You can find our archive of all previous webinars here, many of which remain exclusive to Excel Community members.
How to review a spreadsheet (2022 edition)
Spreadsheet expert John Tennent explores the Community’s publication ‘How to review a spreadsheet’. John provides examples together with step-by-step instructions for using some of the tools and functions that are available.
We have a number of further webinars planned for the rest of the year– check our list of upcoming webinars or refer to the latest newsletter.
Excel Tips and Tricks
Excel Tips and Tricks #454 – Revisiting splitting workbooks with VBA
A Developer level post in which we are going to work through the VBA code required to take a workbook and cut it into one file for each sheet and save all the resulting files.
Excel Tips and Tricks #455 - Data Conversion
Hello all and welcome back to the Excel Tips and Tricks. This week, we have a General User post in which we are taking a closer look at how to convert data types in Excel.
Other blogs
Excel Community round up - August 2022 (public)Here are all the new Excel articles from the Excel Community in August 2022.
Dynamic Arrays – still one leg short of a table?
Coming soon: some additional functions for manipulating Dynamic Arrays, but will they do anything to rectify existing deficiencies?
New tech features for Jun-Aug 2022 (public)
Our digest of new features across Microsoft 365 & other business tech products in written, images & video format covering the last three months.
Excel how to: speed up data entry
We look at how to make entering data into an Excel workbook as quick and efficient as possible by knowing the effect of some key Excel options and features, together with some useful keyboard shortcuts.
How to Review a Spreadsheet Part 4: Design Principles and Formula Errors
The last three blogs in this series will now look at validating the details within the spreadsheet. The range of these items that should be applied will need to be proportionate to the context, scale and risk of the spreadsheet being reviewed.
TEXTBEFORE(), TEXTAFTER, TEXTSPLIT()
Three new text functions have been introduced in Excel to help extract values from text containing some sort of delimiter. We take a detailed look at some of the arguments available as part of these new functions to help you to get the most from them and also highlight some significant changes between the preview and release versions of the functions.
Clustered stack column chart (Public)
Pie and donut charts are not recommended for comparatives, this article suggests how to do them with a clustered stack column chart.
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.
