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. […]
The new IFS function in Excel is one I’m not sure I like. It’d be great to hear from others how you like it. The idea behind IFS is the elimination of nested IF statements. However, the final argument in the syntax feels like a perversion. With an IF statement, there is an argument in […]
After posting the previous video, Rahym Aly asked about using Flash Fill to separate a list that’s more complex than first & last names. Here’s my response. It creates a strategy and uses Flash Fill in combo with COUNTIFS My blog: http://datascopic.net/blog2-2 Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
New in Excel 2013 and 2016 there is a magical way to peel bits of data apart. In this video, I show Flash Fill as a way to separate last names from first names, and strip out email domains from full email addresses. Check it out! My blog: http://datascopic.net/blog2-2 Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
We have to seat 36 people at 6 tables. BUT! You know reality. Reality says that some people must not sit together and some people must sit together. How can Excel help solve that puzzle? This video is a demo of the tool I created in Excel. Here, you can read about the technical details […]
(Giveaway details are at 4:22) I’m giving away 3 copies of my Excel book, Guerrilla Data Analysis 2nd Ed. In this video I describe what’s in the book and who it’s for. My blog: http://datascopic.net/blog2-2 Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336