TIMELINE 0:00 – Context. Explanation of the need for cross-footing. “How would you know if the numbers are wrong?” 2:59 – My ghost pepper coffee recipe 4:57 – Example of Cross-footing This video begins with a story about an accountant who was annoying the hell out of me. She asked, “how would you know if […]
Today: a review of a fundamental element in Excel formulas: relative and absolute cell references. Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336 My blog: http://datascopic.net/blog2-2
Download the workbook here: http://datascopic.net/wine-calc This video is the result of someone at a wine restaurant who said he had transaction data by the glass and bottle but wanted a final calculation of “number of bottles” at the end of the week. Here’s high-speed footage of my actual development. I had no idea how I’d […]
Download the workbook here: http://datascopic.net/wine-calc This video is the result of someone at a wine restaurant who said he had transaction data by the glass and bottle but wanted a final calculation of “number of bottles” at the end of the week. Here’s high-speed footage of my actual development. I had no idea how I’d […]
George Mount asked about my experience taking Improv classes at Chicago’s Second City Training Center. In this video I share several things that have stuck with me. One lesson: the audience wants you to win. So, whatever anxiety we may have when we’re in front of people, it helps to know that the audience wants […]
One way to get good with Excel is to dig into the real-world spreadsheets that other people built. Try to understand their formulas and layout. See how formulas and features are woven together. Here are some Excel power users who make their spreadsheets available for downloading. Check them out. Kevin Lehrbass https://www.youtube.com/user/MySpreadsheetLab/videos Alex Powers http://itsnotaboutthecell.com/ […]
My blog: http://datascopic.net/blog2-2 Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
Thanks to George Mount for asking this question: How do you respond to the request “Teach me Excel”” That’s a tough question. One thing that needs to be made clearer to the public is that: Excel is a development tool. It’s more that something for budgets and making lists. Thus, with a vague request like […]
#SSSVEDA Day 23. 7 days left and I invite you to ask questions or suggest content for these final 7 days of Vlog Every Day in April. In this video, I describe the time I had to train someone who started crying. We were in a situation where we had to do some intense data […]