Teaching analytics with modern Excel
It's wild to think that everything we do with computers comes down to manipulating its 0 and 1 states. So, it makes sense that using Boolean logic (that is, the manipulation of 0 and 1 or FALSE and …
Continue Reading about Three-way lookups in Excel with SUMPRODUCT() →
Excel 2016 has some awesome improvements over prior versions, but maybe the best is the ability to group dates within PivotTables.Learn how to analyze data across multiple date ranges effortlessly in …
Continue Reading about Grouping Dates in PivotTables: Excel 2016 Improvements →
Here is an introductory Slideshare to my Guide to PivotTables.I love PivotTables so much that I often perplexed old coworkers and supervisors because almost everything I did was in a PivotTable.I'm …
Continue Reading about Slideshare: “PivotTables: The WD-40 of Excel” →
I call PivotTables the “WD-40 of Excel” because they allow you to loosen up and extract meaning and trends out of your data.Introductory SlideShare:Here are a few of my top posts …
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 …
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 →
