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 →
Feel the Slow Burn: #WCDayton Day One
We just finished Day 1 of Wordcamp Dayton. If you're not familiar with Wordcamp, think of it as the TEDx of Wordpress. They're independently organized events featuring talks on all things Wordpress, …
Continue Reading about Feel the Slow Burn: #WCDayton Day One →