Remove Protection When Password is Unknown

One of the Excel-related support calls that I get on a regular basis is along the following lines… “Mike, I need to <insert action here> and it seems the workbook/worksheet is protected and it’s asking for a password and the person who set it...

5 Reasons Why XLOOKUP Beats VLOOKUP

You’ve heard of VLOOKUP and possibly it’s much-under-used sibling HLOOKUP. Now meet the new(ish) kid on the block, XLOOKUP. I say newish because it was actually released in the early 2020. Although branded as a replacement for V-and-H-LOOKUP (or to use...

July 2021: Visual Updates to Excel

Microsoft recently announced visual updates for Office and those updates are now rolling out to users, like myself, who are enrolled in the Office Insider Beta program. Yesterday I fired up Excel on my Windows 10 Virtual Machine and up popped 1) a new startup screen...

Power Pivot and The Excel Data Model

I love Pivot Tables. You can do some amazing things with them. But some of the limitations annoy the heck out of me. Thankfully, these limitations can be overcome by using Power Pivot and The Data Model. This post will cover many of the points that are raised and the...

Storing List Based Data in Worksheet Cells: Pros v Cons

Whether it’s a small list that been manually entered or a large list that’s been imported, Excel is ideal for storing list-based (i.e. row-and-column based) data. Let’s take an example of a membership list for a local tennis club… The Pros...

Do You Want Early Access to Excel Updates?

Of course you do and in this blog post I’ll explain how to get it. A couple of weeks ago I wrote a blog post that explained the differences between Office 2019 and Office 365. If you missed it, you can read it here As I explained in that post, each month Microsoft...