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.
Candela Citations
CC licensed content, Original
- Putting It Together: Microsoft Excel, part 2. Authored by: Shelli Carter. Provided by: Lumen Learning. License: CC BY: Attribution