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 […]
Sunday, 24APR16 at 10am PDT and again at 6pm PDT, Bob King and I will be discussing the horrors of bad data; the consequences, and what can be done about it. Also, I will be giving away a copy of my Excel book, Guerrilla Data Analysis, at each session. Join us! Link to the 10am […]
This was a tough morning! It was so sad to hear that Prince died at the age of 57. In his honor, I share a couple of memories of hearing his music. Then, I show how to deal with data that’s pasted into Excel from a web page. The example is a list of Prince […]
You’ve got calculations and you want a clear statement of the bottom line: Over of Under Budget! Here’s how to connect that variable text/comment to a shape to make it big and obvious. My blog: http://datascopic.net/blog2-2 Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
EVERYTHING is data. After exchanging comments with Sherwinn “Dupes” Brice (https://www.youtube.com/user/DupesDidIt) I decided to revisit the crossroads of music, Excel and data. This video looks at important parts of 2 different songs: – R Kelly’s “All I Really Want” – D’Angelo’s “Spanish Joint” Being a bassist diagnosed with ADHD, learning songs was hard for me. […]