Build an Infographic-Style Bar Chart in Excel

Until a few years ago it was enough to take a set of numbers and create a traditional bar chart or pie chart. Although in the right situation these charts are still appropriate, things have moved on and we’re constantly hearing words like Data Visualization and...

LAMBDA – A Beginner’s Guide

Excel contains somewhere between 400 and 500 built-in worksheet functions (Sum, Count, Lookup, etc etc). For those situations where a function doesn’t exist, the alternative is often a long-winded formula, the logic and maths of which you’d have to work...

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...