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.

Date-creating formulas redux

Build a date from a day, month, and a year, or learn how to add and subtract months easily.

Revisiting Excel file types

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.

Looking up over a range

Modeller Liam Bastick is here with a look at how to convert scores into grades with the aid of the classic LOOKUP function.