Teaching analytics with modern Excel
A common reaction I get when people learn I'm an Excel blogger:"Oh, you know Excel? I should learn Excel. Tell me what to do."This is a hard question, because as the old disclaimer goes, "not all …
Continue Reading about How to Learn Excel from Scratch (Slides) →
It's not uncommon at my office to see "version 37" of a budget, sales plan, or other big project. Keeping track of all these changes can be a mess.While Excel has some functionality to track changes, …
Continue Reading about Hold that Date! Timestamped Printouts in Excel →
In blogging about Excel I have faced a dilemma: do I teach the user-friendly but impure Excel, or Excel for the initiated?I am not the savviest Excel guy in the blogging world. I make up for that with …
Continue Reading about Humanity First: In Defense of Helper Cells →
My recent post on how Excel has made me happier has received good attention within the Excel community. Many people have noted they too feel more creative with a strong command of Excel.I thought of …
Continue Reading about Beauty in the Cubicle, or Why Inspiration Is on You →
Subscribe for more Excel tips and tricks My recent "Spreadsheet Blessing" ended with the wish that you "find no hard-coded cells." One of the downsides of Excel is that because it is …
Continue Reading about Ctrl + G, Literally a Go-To Excel Shortcut →
I have been reading Stretch: How to Future-Proof Yourself for Tomorrow's Workplace by Karie Willyerd and Barbara Mistick, a guide to staying relevant -- and happy -- in today's workplace.It's well …
Continue Reading about How Learning Microsoft Excel Has Made Me Happier →
