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
(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
For #SSSVEDA Day 9 I’m taking a moment to describe what the heck I mean by “Crap Data.” In a word: motivation. My blog: http://datascopic.net/blog2-2 Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
#SSSVEDA Day 8: Here, a list of Twitter handles weren’t consistent with the ‘@’ symbol out front. How do we fix that? Don’t play around. Start by getting rid of all of them! My blog: http://datascopic.net/blog2-2 Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336 Darkness is Coming by Kevin MacLeod is licensed under a Creative Commons Attribution […]
Everything is data, and it’s important for teams to have someone–an insider–who at least understands data. They might not be able to “do” data, but at least understand data-related needs and how they connect to business rules and processes. In this video I describe the reasons why. My blog: http://datascopic.net/blog2-2 Guerrilla Data Analysis 2nd Edition […]