Teaching analytics with modern Excel
I recently came across this quote from Isaac Asimov -- it is so true:I absolutely love this quote. Breakthroughs hardly happen when you expect them. This requires a level of humility and even …
Continue Reading about Did that just work? Case formatting in Excel →
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 …
MID( ) is intimidating for such a short function.But when you're in the process of data "wrangling" -- that is, transforming it for more useful analysis -- it can be very useful.Many numbers in …
I call formatting a necessary evil in Excel. It can easily take as long as the analysis itself -- but the nice thing is that good formatting makes for better, quicker data analysis.Keep the Ctrl+1 …
A good Excel analyst thinks about formats. Do these borders, colors and blocks help drive the overall narrative of your data? Or do they just make it look busy?Formatting can be a significant …
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 …
