WeCodeAcademy
❮ PreviousAll courses ❯

Case Study: Corner Shop, Analysis and Summary

Now the owner's questions. Each uses a tool from this course:

  1. Which items need reordering? Filter the list.
  2. Which goods are worth the most? Sort by value, largest first.
  3. How is stock value split by group? A PivotTable (here, SUMIFS).
  4. What share is each group? Divide by the total and format as a percentage.

Together these make a short report: one list, one ranking, one summary table.

Exampleexcel
Open in editor »
Quick check

Which tool answers 'how is value split by group'?

Your turn: write the code

Find the share of the total for the Food group: put SUMIFS for Food divided by the total in B6 as a decimal rounded to 2 places.

Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.

❮ PreviousAll courses ❯

Tip: use the left and right arrow keys to move between lessons.