Here’s the problem:
WyattD
KWilliam
UBrian
We need to separate the First Name and Last Initial but, for some names, the Last Initial is out front. So, we need to turn these into:
Wyatt D
William K
Brian U
Solution: CODE and Flash Fill
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My blog: http://datascopic.net/blog2-2
Here’s my raw accent. The one that I try to cover over in my Excel tutorials.
I recently discovered Accent Tag videos and decided to do one. I’m often asked about my accent and I don’t know where it came from. Most of my life has been spent in Chicago, but I’m asked if I’m from places I’ve never been before.
If there’s a linguist out there who can help solve this mystery, I’d be glad to buy you some coffee. :)
My blog: http://datascopic.net/blog2-2
Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
SSSVEDA 2016 has been great. A lot of good content was created. I’ve appreciated the comments, support and feedback. So, here’s a video thanking y’all, and sharing lessons I learned.
LESSONS
– A project like this reveals what a person gives a damn about. Being committed to something like this isn’t something you can phone in. So, whether it’s conscious or not, sticking with this is discovery of what matters in regards to content, style, and the medium.
– Commit to a creative idea and see if through.
The days that I missed were because I had so many creative ideas and kept thinking of more and more and more.
I think my best videos happened when I went all-in on an idea and had fun.
Please. It’d be great to have you as a subscriber. Let me hear from you. Let me know what you’d like to see. I don’t want to be the only one having fun. :)
Guerrilla Data Analysis 2nd Edition
My blog: http://datascopic.net/blog2-2
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 your numbers are wrong?”
My response was, basically, “because I’m experienced and know what I’m doing.” That wasn’t good enough for her. This lead to her teaching me the valuable concept of ‘cross-footing.’
‘Cross-footing’ is a way of ensuring that you’ve accounted for all of your data and it adds up correctly. This is so important that I added a section on cross-footing in my book, Guerrilla Data Analysis, 2nd Ed.
In the second half of the video I share a simple example of crossfooting. It’s a real-world example of a non-profit that receives donated items, and a way of keeping track of them all.
Along the way, you get to see my coffee recipe. :)
Guerrilla Data Analysis 2nd Edition
My blog: http://datascopic.net/blog2-2
Today: a review of a fundamental element in Excel formulas: relative and absolute cell references.
Guerrilla Data Analysis 2nd Edition
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 approach this until I turned the camera on.
Please subscribe to my channel and let me know your real-world needs with Excel. Maybe it’ll turn into a video.
Guerrilla Data Analysis 2nd Edition
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 approach this until I turned the camera on.
Please subscribe to my channel and let me know your real-world needs with Excel. Maybe it’ll turn into a video.
Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My blog: http://datascopic.net/blog2-2
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 us to win. They’ve invested time–and possibly money–in partnering with us to be successful.
Guerrilla Data Analysis 2nd Edition
My blog: http://datascopic.net/blog2-2
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
Alex Powers
http://itsnotaboutthecell.com/
Chris Macro
http://www.thespreadsheetguru.com/
ExcelIsFun
https://www.youtube.com/user/ExcelIsFun/videos
Download the workbook:
http://datascopic.net/cafeteriarandomizer
Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My blog: http://datascopic.net/blog2-2