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, …
#PivotTableProblems: Always be Refreshing
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 →
PivotTable Data Prep
PivotTable Data PreparationWe will start with a set of sales and profit by region, store, and quarter. Follow these rules to turn the data set into a PivotTable.YAt an office, spreadsheets are …
Out with the Stale, In with the Classic
Great piece in the WSJ about the future of education, an industry that has remained stubbornly resistant to technology.I've written a bit about this -- what I call "Yellow Checker Syndrome" (posts …
Continue Reading about Out with the Stale, In with the Classic →
Why PivotTables?
You probably didn’t expect etymology in this book, but it here goes. When I probably should have been learning Excel in high school, I took a Greek class instead.I haven’t used my Greek a lot, but one …
Anchors Away! A Better VLOOKUP
There is nothing wrong with the average vlookup. But do you really want to be average? The coveted analyst needs exceptional Excel skills. How can we make Vlookup even more accurate and …