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

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

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