Teaching analytics with modern Excel
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 →
Anatomy of a PivotTable You have a blank slate, a clean PivotTable. What’s great about PivotTable is that you can make pretty much any attribute into any one of features. It has Filters, Columns, …
Remember to Refresh!By using whole columns as your PivotTable reference, you will never mistakenly leave out new data from your report. But you do still need to refresh your data.Let’s say that you …
Continue Reading about #PivotTableProblems: Always be Refreshing →
