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.
- 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).
- 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.
- 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.
- 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.