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

Excel – Import a List of Tasks into Outlook

I created a short video in response to a question that I received via email… “Is it possible to import a due date listing on an Excel spreadsheet to Outlook and set up reminders for these due dates?”

read more