http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336

SSSVEDA Day 26: Lessons from My Improv Classes

/in /by

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

https://www.youtube.com/user/MySpreadsheetLab/videos

SSSVEDA Day 25: One Way to Get Good with Excel

/in /by

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

http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336

Messy Data Horror Stories Session 2 25APR16

/in /by

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 24 Responding to “TEACH ME EXCEL!”

/in /by

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 “teach me Excel” it’s hard to know if the person will need financial modeling, data cleansing, web scraping, database connection, data vis, payroll management … etc.

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 23: Raw Data, Reports & Tears

/in /by

#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 cleansing before we could get to the main task.

We couldn’t trust the reports that had been made for the task so, we had to start with the raw data. Wailing and gnashing of teeth ensued.

Guerrilla Data Analysis 2nd Edition

My blog: http://datascopic.net/blog2-2

http://bit.ly/216UMkp

SSSVEDA Day 22: Blab scheduled to discuss “messy data horrors!”

/in /by

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 PDT session:

Link to the 6pm PDT session:
http://bit.ly/1VIY5Pu
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

http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336

SSSVEDA Day 21 Prince: Cleansing a list of his hit songs

/in /by

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 hit songs that needs to be cleaned up in Power Query (Get & Transform).

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 20: Connect Dynamic Text to a Shape in Excel

/in /by

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

SSSVEDA19: Excel, Music, Data, R Kelly & D’Angelo

/in /by

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. So I devised a method in Excel to help me visualize songs and recognize patterns. So, I share that with you.

Let me hear from you. Do you use music and Excel together?

My blog: http://datascopic.net/blog2-2

Guerrilla Data Analysis 2nd Edition