Excel & Google Sheets lesson

Weekly report

Put it all together

About 5–10 minutes · no sign-up needed

Key points

SUM, AVERAGE, ROUNDTotals and typical values, rounded for the report.

SUMIF, COUNTIF(S), XLOOKUPTotals and counts that match a condition, and one value looked up.

IF and a pivotA yes/no answer for the manager, then the breakdown by store.

Eight numbers and a pivot table: the everyday toolkit of an entry-level analyst.

Try each one in your head first, then open the answer.

1. In I2, total all the revenue.

=SUM(F2:F9)

2. In I3, find the average order value, rounded to 2 decimal places.

=ROUND(AVERAGE(F2:F9),2)

3. In I4, total the revenue from Lagos.

=SUMIF(C2:C9,"Lagos",F2:F9)

4. In I5, count the orders worth more than 50.

=COUNTIF(F2:F9,">50")

5. In I6, count the Lagos orders for Earbuds.

=COUNTIFS(C2:C9,"Lagos",D2:D9,"Earbuds")

Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.

About 5–10 minutes · no sign-up needed