Webinar
A comprehensive guide to PivotTables (2022)
David Lyford-Tilley walks through everything you need to know to get proficient with PivotTables, including the potent Power Pivot add-in.
There is also an accompanying blog post in which we break down all of your questions from the session here.
Excel Tip of the Week
SUBSTITUTE redux (public)
Take a look at how to do find-and-replace with a formula – or even how to make a complex function to handle multiple replacements in a single step.
Build a date from a day, month, and a year, or learn how to add and subtract months easily.
We consider the most common Excel file types, what they mean, and what each is best used for.
Revisiting making sets of PivotTables
Cycle through all the options in your report filters with our handy guide.
Other blogs
Dynamic Arrays – it's not just about the new functions and spilling
Simon Hurst dives into the greater advantages of Excel’s newer calculation engine.
Visio free tier: Flow charts, Venn & business matrices (public)
MVP David Benaim shows you how can make a variety of common visualisations easily, using Visio.
Exploring Charts (graphs) in Excel: 11 – Trendlines
John Tennent dips into how to add trendlines to your charts – plus how to get their equations outputted into cells.
Excel how to - speed up entering formulae part 1
Turbo-charge your formula efficiency, with Simon’s guide to shortcuts and other handy tips.
Data Validation dropdown lists – major improvement on the way
The latest changes to Excel are going to make using dropdown menus much easier.
Modeller Liam Bastick is here with a look at how to convert scores into grades with the aid of the classic LOOKUP 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.