Twenty-five years ago, on November 15, 2000, I registered and launched my Contextures.com website. It had a few Excel tutorials, and a small selection of sample Excel files to download.…

Before we dig into Modern Excel, can you please help me out? What, exactly, is “Modern Excel”? I can’t find a standard definition on the Microsoft site, or anywhere else!…

Are you taking the day off, to celebrate Microsoft Excel’s 40th birthday? Or will you have a big party with your co-workers, at the office or remotely? And what were…

You can make quick lists with Excel’s AutoFill feature. In the short video below, I show two tricks for making weekday lists – only the Monday to Friday dates, with…

Let’s try something different. I will share a data analytics challenge here. Post your solutions in the comments. Our first challenge involves Employee Data Analysis. You can score maximum of…

In the video below, I show how to get started with the Excel FILTER function, which is available in Office 365. You can enter a formula in one cell, and…

If you operate a business in New Zealand (NZ) like me, chances are you too need to calculate GST on purchases & sales. Today, let me share the excel formulas…

Recently, a client shared data with me that is clearly a pivot table and wanted me to make another pivot from it using Excel. This is a common and annoying…

Learn how to use Excel XLOOKUP function with two sheets in this step-by-step tutorial. Why you may want to use XLOOKUP with two sheets? If you have data in two…

Have a bunch of CSV files in a folder and want to merge or combine them to one big file? Follow these simple instructions to combine multiple CSV files in…