Teaching analytics with modern 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 →
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 …
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 …
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 →
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 →
In business, you're often fitting square pegs into round holes. Shipments of merchandise come in different quantities than you can display them.Join the MOD( ) squad!This Excel function will …
