Last night while revelers stumbled past Hired with Excel HQ, I was working on the blog. In honor of St Patrick's day, here's a spreadsheet blessing. May your spreadsheets be received ready to …
When Negatives Don’t Count: MAX( ) Function in Excel
Subscribe and get more tips for the awesome analyst. Plus, your free ebook.The biggest operating expense of almost any business is payroll.And unless you're really masochistic, negative pay doesn't …
Continue Reading about When Negatives Don’t Count: MAX( ) Function in Excel →
Not Another Excel Knowledge Dump
So, you want to learn Excel, but you are intimidated by the complexity of many Excel sites. Endless forums and long, confusing posts. If you knew how to decipher this stuff, you wouldn't be looking …
Repeat Field Items in PivotTables
Have I mentioned I love PivotTables?While the default PivotTable isn't bad, here's one quick tweak that makes it even better.If you have a lot of data sharing an attribute, it can get difficult to …
But Seriously… Freezing Panes in Excel
This may be my biggest spreadsheet pet peeve. I'm scrolling through the report and after getting past a few dozen lines, I totally lose my bearings as the report labels aren't visible. So …
Continue Reading about But Seriously… Freezing Panes in Excel →
Display Negative Percentages Red in Excel
Analysts are constantly comparing actuals to budget. Because humans are better at processing colors than numbers, it's often a good idea to add some conditional formatting to your variances. A common …
Continue Reading about Display Negative Percentages Red in Excel →