Datascopic.net

Every day someone new is thrown into a data-driven/Excel situation and they don’t know where to start. So, they flail, panic, curse, pray and beg, and either figure it out or they don’t figure it out. I wondered, “what might a better introduction look...

One night I was up late, thinking about Excel, data and the many conversations around the different tools that we use to get our data to tell us something useful. But I was reminded of many years ago and why I have remained so passionate about data:...

As we move forward in 2016 you will see a lot more video from me and fewer long-form blogposts.  As 2015 closed there was a stretch where I’d uploaded 5 videos over 2 weeks. That level of production has never happened over the 5-ish years of this blog...

So many spreadsheets require basic math, but poor layout makes a spreadsheet unnecessarily complicated and brittle. They don’t need sophisticated dashboards, forecasts, statistical analysis, or connections to a database. They just need to perform basic...

This video has several layers. The ultimate goal is to create a table of summaries from a dataset that has granular data. One layer is the creation of the named ranges. You’ll see that I set up the named ranges and didn’t remove the blank rows or do...