Conditional formatting is great for making quick sense of your data visually. It's a good idea to check for duplicates when receiving a dataset like this one. The next step of course is to figure out …
Dude, Where’s my Pivot Table Data?
Working with other peoples' spreadsheets can be harrowing.When working with new data, a good analyst will ask: "Where is this data coming from?" You want to go ad fontes, as they say in philosophy -- …
Time for an Excel Timestamping Shortcut
Time for another Excel shortcut, of course! This is related to Ctrl + ; which will give you today's date (demonstration on my Instagram -- be sure to follow @gjmount!)Ctrl+Shift+; will give you …
Continue Reading about Time for an Excel Timestamping Shortcut →
Get In Line!
A good Excel analyst thinks about formats. Do these borders, colors and blocks help drive the overall narrative of your data? Or do they just make it look busy?Formatting can be a significant …
Randomly Sort a List in Excel
At work I often graph individual physician statistics against each other but want to do this anonymously. To do this, I sort my source data randomly.Be sure to subscribe to the newsletter for more …
What day is it? Excel knows.
Ever been in such flow with your spreadsheet that you forgot what day it is? Here's a nice keyboard shortcut. Ctrl + ; will insert today's date. …