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 →
If the Patient is CEO, Then What’s the Analyst?
I recently finished Robin Farmanfarmaian's The Patient as CEO: How Technology Empowers the Healthcare Consumer. Robin describes a wonderful new world of healthcare, where the patient is the CEO of her …
Continue Reading about If the Patient is CEO, Then What’s the Analyst? →
Making Your Site a Center: #WCDayton Day 2
Today was Day 2 of Wordcamp. Read about Day 1 here.Wordcamps are impressive. People from all walks of life with various skill sets and experience levels come together to share how to use an …
Continue Reading about Making Your Site a Center: #WCDayton Day 2 →
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 →