I call formatting a necessary evil in Excel. It can easily take as long as the analysis itself -- but the nice thing is that good formatting makes for better, quicker data analysis.Keep the Ctrl+1 …
PivotTables: Replace Blanks with Zeros
I love PivotTables because they do all the "data housework" for me, allowing me to analyze data rather than gather, manage, and format it.One undesirable feature of the PivotTable is how it treats …
Continue Reading about PivotTables: Replace Blanks with Zeros →
Hell…
Escape Hell...Subscribe to the newsletter for more Excel tips and tricks. Plus, your free ebook! …
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 …
Multiply a Whole Range by the Same Cell
Here's a feature that takes advantage of the powerful "Paste Special" features in Excel. Say you've got a list of sales by employee and week. The sales reps get a 10% commission. You can easily …
Continue Reading about Multiply a Whole Range by the Same Cell →