Teaching analytics with modern Excel
If you follow my blog, you'll know I write a lot about data analysis, Microsoft Excel, and other related topics. It's my goal to catalog everything I've learned as an analyst over the past few …
Continue Reading about No More Blast Invites! LinkedIn for Aspiring Analysts →
The Big Data Panel at Case Western Reserve University Homecoming, 10/9/15Last week was Homecoming at my graduate school alma mater, Case Western Reserve University. The Weatherhead School of …
You've heard about "big data," "data analytics," and related fields (buzzwords?). Maybe you've thought about how to make a career out of it.One obstacle -- you've spent college reading Chaucer, not …
Continue Reading about From Chaucer to Clusters: Data Analytics for Liberal Arts Grads →
PivotTables are analytics machines. Think of all the ways you can slice and dice this data.Let’s take it even further — profit margin. Click inside your PivotTable. The home ribbon will have a couple …
Continue Reading about PivotTables: Add a Calculated Field →
Your PivotTable is looking good! Let’s make a few adjustments to supercharge it. You may be asking, why all the tweaks? We are modifying the PivotTable for the reasons we tweaked our vlookup formula. …
Continue Reading about #PivotTableProblems: Tweak Your View →
Subscribe for more Excel tips and tricks. Avoid GETPIVOTDATAYou are hacking the PivotTable. All these little tricks are going to make you such a better analyst.There is one more trick I want to show …
Continue Reading about #PivotTableProblems: Avoid GETPIVOTDATA →
