Tutorvo

Project 8: Timed Mixed Project (20 Minutes)

Lesson 8 of 825 minLab

This lesson is part of the course

In this lesson

Suggested time: 20 minutes, like a real project in a timed exam. You price ten orders, clean the customer names and build a region summary with SUMIF and AVERAGEIF.

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

  1. Project 1: Cell References and a Tax-Rate CellLab15 min Locked
  2. Project 2: SUM, AVERAGE, COUNT, MIN and MAXLab12 min Locked
  3. Project 3: CONCAT, PROPER, UPPER, LEFT, RIGHT and LENLab15 min Locked
  4. Project 4: IF, Nested IF and IF with ANDLab15 min Locked
  5. Project 5: Number Formats and Conditional FormattingLab15 min Locked
  6. Project 6: Create and Modify ChartsLab15 min Locked
  7. Project 7: Sort and Filter Logic with RANK.EQ, COUNTIF and LARGELab15 min Locked
  8. Project 8: Timed Mixed Project (20 Minutes)Lab25 min Locked