Webinar

Power Pivot for Management Reports
In David Lyford-Tilley’s last Excel Community webinar (for now!), he explores the Power Pivot add-in that allows you to combine datasets into a single model to make simple but effective management reporting dashboards.

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

Working with times (public)
Following on from TOTW #238, this tip looks at how to work with time data in Excel.

Trimming excess space redux
A deep dive into one of the most annoying (and necessary) data cleaning tasks – removing excess spaces.

Revisiting dynamic arrays
A timely second look at one of the most significant changes to Excel formulas in recent years, the dynamic array formulas.

Power Query: Creating custom functions
This Developer level tip looks at creating your own custom functions in Power Query.

Power Pivot - Creating a running total
A deeper dive into Power Pivot measures, in the context of creating a running total.

Other blogs

Excel how to - speed up entering formulae part 2
Part 2 of our ‘how to’ on formula entry from Simon Hurst, focusing on how to effectively refer to cells and ranges of cells in formulas.

New tech features for Sep 21 – Feb 22 (public)
A look at the features introduced across the Microsoft 365 suite and beyond in the last 6 months.

Multiple Excel Tables in a single worksheet – avoiding Cell Clash
Simon Hurst shares with us his recent experience of working with multiple tables in a single worksheet, and how to manage their potential changes in size to avoid clashes.

From 287 PDFs to a sales column chart
Do we now have an Excel-based solution to the perennial challenge of extracting data from PDFs? This article looks at how Power Query can be used to do just that.

Dynamic Lookups (public)
MVP Liam Bastick looks at how to take your lookups to the next level so they automatically adjust with your data.