Project 2: SUM, AVERAGE, COUNT, MIN and MAX
This lesson is part of the course
In this lesson
Suggested time: 8 minutes. You summarise one week of sales for 12 Fernhill stores, two of which have not reported yet: total, average, number of stores reported and the spread.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Project 1: Cell References and a Tax-Rate Cell Locked
- Project 2: SUM, AVERAGE, COUNT, MIN and MAX Locked
- Project 3: CONCAT, PROPER, UPPER, LEFT, RIGHT and LEN Locked
- Project 4: IF, Nested IF and IF with AND Locked
- Project 5: Number Formats and Conditional Formatting Locked
- Project 6: Create and Modify Charts Locked
- Project 7: Sort and Filter Logic with RANK.EQ, COUNTIF and LARGE Locked
- Project 8: Timed Mixed Project (20 Minutes) Locked