EXCEL BASICS DAY 4: ANALYZE THAT DATA

Without decisions we can't make progress. Without information we can't make decisions.

We keep hearing this term BIG DATA. It's probably pretty big then right? You betcha. Pretty much the more data you have, the more powerful you are. You can make repeatable, more calculated decisions with logic on your side.

Enough of me droolin about data, let't get to it. This is a very simple analysis. We will go into more and more depth on the road to come. I figure this is a good start to our data journey. I hope you enjoy!

Video Breakdown

5 seconds: DATA tab and ‘Remove Duplicates’

• You copy off a full column to an empty space. Make sure this new column is selected and go to your DATA tab. There will be a ‘Remove Duplicates’ button in the Data Tools section of the ribbon.

15 seconds: =AVERAGEIF(CriteriaRange,Criteria,AverageRange) function

• This might look tricky but the logic is straight forward! Pretend we are back in 5th and we have 3 classes in our grade. We want to know which class, on average, is taller. We can use an =AVERAGEIF() function and fill out our parameters like this:
  • CriteriaRange: All kids in 5th grade.
  • Criteria: Miss M Class. (1 of 3 classrooms).
  • AverageRange: All heights in 5th grade.

25 seconds: =MINIFS(MinRange,CriteriaRange,Criteria)

• This is a very similar one to =AVERAGEIF(), however, you switch the order of parameters. Back to the classroom example, except were looking for the shortest kid.
  • MinRange: All heights in 5th grade.
  • CriteriaRange: All kids in 5th grade.
  • Criteria: Miss M Class. (1 of 3 classrooms).

34 seconds: =MAXIFS(MaxRange,CriteriaRange,Criteria)

• Same as =MINIFS(). Back to the classroom example, except were looking for the tallest kid.
  • MaxRange: All heights in 5th grade.
  • CriteriaRange: All kids in 5th grade.
  • Criteria: Miss M Class. (1 of 3 classrooms).