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
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 and download the Excel file: http://datascopic.net/seating/
Or, just download the file: http://datascopic.net/seating%20spreadsheet
The tool also accounts for other concerns like: a person on the list not being assigned a seat. Check it out!
My blog: http://datascopic.net/blog2-2
Guerrilla Data Analysis 2nd Edition
(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
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
#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
Darkness is Coming by Kevin MacLeod is licensed under a Creative Commons Attribution licence (https://creativecommons.org/licenses/by/4.0/)
Source: http://incompetech.com/music/royalty-free/index.html?isrc=USUAN1100584
Artist: http://incompetech.com/
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
Doing things the wrong way is different from being just plain wrong. Here, I describe having been wrong in my analysis and someone was issued a check for $5000 more than they were due.
The good news is that the problem was caught, decisions were made, and everyone survived. Being wrong is part of the reality of working with data.
My blog: http://datascopic.net/blog2-2
Guerrilla Data Analysis 2nd Edition
Today Alex Powers at ItsNotAboutTheCell posted a comment that reminded me that:
1. We all started using Excel all the wrong ways.
2. The Excel community is great about sharing knowledge and helping others not have to work so hard.
Here, I share a story about the olden days and doing things the hard way.
Check out Alex at:
My blog: http://datascopic.net/blog2-2
Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336