Oct 3, 2021
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...
Sep 15, 2021
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...
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...
