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 →
Join the MOD( ) Squad
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 …
Don’t Weight to use SUMPRODUCT
Weighted averages aren't intuitive, but they come up in business all the time. Fortunately, Excel has a quick function for calculation weighted averages. If you're a student, you may be more familiar …
Don’t be dim… use MID()!
MID( ) is intimidating for such a short function.But when you're in the process of data "wrangling" -- that is, transforming it for more useful analysis -- it can be very useful.Many numbers in …