Learning the tips and tricks for doing data analysis in Excel is great and all, but stepping back to see the bigger picture leads to better questions (and answers) you can ask as an analyst. Benn Stancil is one of the founders at Mode Analytics, a data visualization platform you may have used before. Benn […]
You may be filtering and sorting a big dataset in a Google Sheet and want to see that dataset in another Google Sheet without having to copying and pasting the data each time the “source” data is updated. To solve this problem, you need to somehow import the data from the “source” worksheet to your […]
In this episode, I had the pleasure of speaking with John Napoleon-Kuofie, a senior business intelligence analyst at Farfetch. In this conversation, we talked about how John’s career led him to Farfetch, a traffic dashboard he’s built for his stakeholders at Farfetch, and how Excel was his gateway into SQL and the wonderful world of […]
Have you ever wondered what an “array-entered formula” is? It’s an intermediate/advanced concept in Excel but in late 2018, Microsoft released dynamic array functions and formulas that “spill” into the cells below your current cell with a function. This makes writing formulas easier and less prone to human error, but there are some tradeoffs to […]
A few weeks ago I had the opportunity to teach a week-long data analytics course through General Assembly. The course was taught entirely online using Zoom. I discuss some of the topics the students learned in the class, and what the experience was like teaching an online class in real time. The topics we covered […]
Excel for the Real World I studentI use Excel and basic formulas already but there were basic techniques that I missed so this was great to fill in those gaps. On to class 2!
