The legendary "Mr Excel" Bill Jelen has shared that once at an Excel training seminar, someone asked him how we was adding up rows from within Excel."How do you add your data?" Bill asked."I get out …
Find Duplicates in Excel
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 …