Excel TutorialsA collection of written and video based Excel tutorials
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
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
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?
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?”
Until now Excel users have only been able to store text, numbers, dates and formulas in cells. Well now, Microsoft have added 2 new data types – Geography and Stocks. These data type will fundamentally change what’s possible with Excel