Putting It Together: Microsoft Excel, part 2

Now that you know some of the more advanced tools available in Excel, let us take a look at our opening list of possible questions and match those with an Excel function we just covered.

  1. You want to see which month had your highest sales volume. You could see this by sorting your data Z to A (largest to smallest number).
  2. You have a total clothing inventory but you want to know how many pants you have in stock. You could see this using the COUNTIF function.
  3. You want to know how many months from last year you were under budget. You could see this with the IF function, just like in our learning example.
  4. You want to see a graphic that represents your data, instead of the actual numbers. You could chart your data in a full-sized chart or as a sparkline if you just want to see very basic trends.