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
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
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 case the logical test fails. In an IFS statement, we are forced to either:
1. Account for every scenario, or
2. Make up a TRUE logical test, or
3. Have the function bomb out with an error.
What do you think about IFS?
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
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