Jul 25, 2021
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...
Jul 19, 2021
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...
Jul 10, 2021
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...
Jul 8, 2021
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...
Jul 5, 2021
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...
