Excel Tutorials

A collection of written and video based Excel tutorials

LAMBDA – A Beginner’s Guide

Need to know LAMBDA? Need to know it FAST? This is the video for you! No prior knowledge needed and in 15 minutes you’ll be up to speed with one of the most powerful function in Microsoft Excel.

read more

Power Pivot and The Excel Data Model

This post will cover many of the points that are raised and the questions that are asked when I talk about Power Pivot and The Data Model in my Excel training sessions.

read more

Do You Want Early Access to Excel Updates?

Each month Microsoft release a new “version” of Excel to Office 365 subscribers. By signing up to The Office Inside Program you can get early access. This post explains how to do so

read more

Why You Should NOT Buy Excel 2019

Hopefully I’m not too late with my advice. Hopefully nobody has yet bought Microsoft Office 2019. So why am I recommending the you don’t buy it?

read more