Adding rows in Excel is part of the endless, Sisyphean work of an analyst. Here's a quicker way.Select the cells you wish to move down a row. Then hit Ctrl + Shift + = to launch a dialogue box that …
The Tangled Subtotal They Sent You
I'm not a huge fan of subtotals in Excel -- they're quite high-maintenance. Add a line or field and there's a good chance things won't add up anymore. Here's how to get rid of them so you instead put …
Data Lessons from Your Mom
Hello readers! It's been some time since my last LinkedIn post.I've been shifting more attention to my site at georgejmount.com, with my big goal to develop an online class based on the themes of my …
Quickly Fill Blanks Cells in Microsoft Excel
Hello Readers, Happy New Year!I've been unusually silent lately, in between the holidays and a nasty virus. Avast! I am back with more.I'm trying a new medium: YouTube video. This is a great platform …
Continue Reading about Quickly Fill Blanks Cells in Microsoft Excel →
Conditional Formatting Across Columns
Update: After getting clarification from the reader I developed the attached model. It was bit trickier than I thought at first and I am feeling a little under the weather tonight so have not gone …
Continue Reading about Conditional Formatting Across Columns →
Double Up on Pivot Magic
Did you know that you can use the same value field twice in a #PivotTable? Follow these steps to include a % total or running total on your report. …