The other day at work I was presented with a list of physicians for whom I needed to find some information. This was necessary only for physicians with ID numbers over 3 characters long.Rather than …
Happy boss > Fancy formula
Chandoo runs a great Excel site at chandoo.org. I really like his site because he frames Excel problems from the viewpoint of a real life data analyst. He's been one and he knows what makes analysts …
Never Fear, Excel is Here (to stay!)
Image from Gartner study If you're worried that your Excel skills may soon become obsolete, take comfort. A recent Gartner study positions Microsoft as an industry leader in BI and Analytics. I'm …
Continue Reading about Never Fear, Excel is Here (to stay!) →
Cleese, Jobs, and Disorderly Dots
A couple of weeks ago I heard John Cleese speak about creativity and reinvention at Content Marketing World. Among his many mind-blowing statements, my favorite was one thing that separating creative …
Marshall on Modeling
The 19th Century economist's famous steps on building and communicating economic models. One of my all-time favorite quotes. …
Excel Tip: Multiple Pivots with Report Filter Pages
If you've read my blog, you'll know that I love PivotTables.Subscribe for more Excel tips and get your free ebook on getting "Hired with Excel." One nuisance with PivotTable is report maintenance. If …
Continue Reading about Excel Tip: Multiple Pivots with Report Filter Pages →