Did you know that you can use the same value field twice in a #PivotTable? Follow these steps to include a % total or running total on your report. …
It’s Not What You Know, It’s How You Show.
It's not what you know, it's who you know.This line bothers me. It sounds almost conspiratorial, as if there is some group of others working together to hold you back.It's also a false dichotomy. How …
Continue Reading about It’s Not What You Know, It’s How You Show. →
Autosum = Awesome
The legendary "Mr Excel" Bill Jelen has shared that once at an Excel training seminar, someone asked him how we was adding up rows from within Excel."How do you add your data?" Bill asked."I get out …
PivotTables: Replace Blanks with Zeros
I love PivotTables because they do all the "data housework" for me, allowing me to analyze data rather than gather, manage, and format it.One undesirable feature of the PivotTable is how it treats …
Continue Reading about PivotTables: Replace Blanks with Zeros →
Find Duplicates in Excel
Conditional formatting is great for making quick sense of your data visually. It's a good idea to check for duplicates when receiving a dataset like this one. The next step of course is to figure out …
Copywriting and the Other Kind of Model
Think copywriting, and you likely picture shots of glamorous models with pithy slogans.I think of a different model: the business model. Cold, exacting, and anything but glamorous!In Dominic …
Continue Reading about Copywriting and the Other Kind of Model →