Spot the difference
Have a look at Value A and Value B. 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 still wrong. Below…
-
-
The NEW Keyboard Shortcut for Pasting in Excel
I can confirm that the new Ctrl + Shift + V shortcut is indeed a timesaver, according to my very scientific test. In case you didn’t know, we can now paste values into cells while preserving existing formatting — with…
-
How long does Excel take to learn?
Google finished rolling out its helpful content update last month, which was supposed to provide us with better search results. Well, it seems like it still has some way to go… I search for: “how long does it take to…
-
Calculate the running count in Excel
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,…
-
Border Styles Comparison
I’ve often wondered why the Format Cells window for conditional formatting only has half the border styles found in the standard one. I like the thick border styles because they stand out more. There have been numerous occasions when I’ve…
-
Power Query in the Ribbon
Interestingly, the words ‘Power Query’ feature in the Excel for Mac ribbon (albeit in brackets) but don’t in the Windows version. That’s despite the former having a non-existent editor (for now). In Excel 2010 and Excel 2013, Power Query was…
End of content
End of content