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

#SSSVEDA Day 17: Excel IFS Function (Not sure I like it)

/in /by

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

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

SSSVEDA Day 16: Flash Fill Part 2 and Splitting Names

/in /by

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

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

#SSSVEDA 14: Separating Text in Excel with Flash Fill

/in /by

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

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

#SSSVEDA Day 13: Excel Seating Chart Demo & Download

/in /by

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

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

SSSVEDA Day 10: Excel Book Giveaway!

/in /by

(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

SSSVEDA Day 10: Excel Book Giveaway!

/in /by

(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

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

SSSVEDA Day 9: What is Crap Data?

/in /by

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

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

SSSVDEA Day 8: Formatting a List of Twitter Handles

/in /by

#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/

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

#SSSVEDA Day 7: Every Team Needs Someone Who Understands Data

/in /by

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