For over 15 years, the bedrock of an Excel worksheet has been its 1,048,576 row by 16,384 column grid to house our data, formulas, tables, and charts. It wasn’t always this way. Prior to Excel 2007, only 65,536 rows and…
Have a look at Value A and Value B on page 1. They’re the same, right? “They are definitely the same.” Nope, they’re not. “Okay, I’m guessing there’s an extra space at the end of one of them then.” You’re…
Running counts are useful for keeping track of how many times a value has occurred up to a certain point. There are multiple ways of doing this, so let’s look at some traditional and modern methods. Example On page 1,…
I love to hear about obscure uses for Excel. Why? Because it debunks the notion it’s purely a number-crunching tool used for a certain activity, by a certain group of people, in a certain place, and at a certain time….
Ever typed a phone number, identification number, or ZIP code, only to find Excel annoyingly strips away the leading zero and converts it into a numeric value? We might know that numbers have a use beyond mathematical operation, but Excel doesn’t. Thankfully,…
Important values strewn across a workbook are difficult to track. Whilst opening additional windows or splitting your view into panes are two ways of combatting the endless scrolling and tab switching — they’re not perfect. An alternative is the Watch…
End of content
End of content
