Excel TutorialsA collection of written and video based Excel tutorials
A short video covering the basics, calculating the difference between 2 dates and extracting a day name from a date
NEW: Cartoon People in Microsoft Office let’s you add a little fun to your Excel files as well as making them more engaging
Learn how to create an impressive, eye-catching and engaging infographic that will wow your audience
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.
If you lose or forget the password, it cannot be recovered. That is not 100% true. In this tutorial I show you how to do it.
XLOOKUP is branded as a VLOOKUP Killer but what’s so good about it. In this post I present 5 reasons why it’s time to switch
Microsoft recently announced visual updates for Office including a new startup screen and an updated Ribbon, replete with rounded corners.
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.
The row-and-column structure of Excel make it ideal for storing list-based data. But it’s not all sweetness and light