Excel Certification Practice: Exam-Style Tasks for Core Skills (MO-200-Style)
Eight timed-style projects in the format of Excel associate exams: references, SUM/AVERAGE/COUNT, text functions, IF logic, conditional formatting, charts, RANK/COUNTIF and a 20-minute mixed project, every cell graded. Independent practice, not affiliated with Microsoft.
The first 2 lessons are free — no account needed.
About this course
Excel certification practice in the project format of associate-level exams such as MO-200, built as eight graded tasks for one fictional stationery company, each with a suggested time. You complete a price list with a locked tax-rate cell and fill a grid with mixed references, summarise store sales with SUM, AVERAGE, COUNT, MIN and MAX when two stores have not reported, clean an HR export with PROPER, UPPER, LEFT, RIGHT, LEN and CONCAT, decide targets, bonuses and ratings with IF, nested IF and AND, apply number formats and three conditional formatting rules, build a column chart and a pie chart with data labels, rank products with RANK.EQ, COUNTIF and LARGE and finish with a 20-minute mixed project. These are not real exam questions. Independent practice, not affiliated with or endorsed by Microsoft. Microsoft, Excel and MOS are trademarks of the Microsoft group of companies. The first two labs are free.
Lessons
- Project 1: Cell References and a Tax-Rate CellFree
- Project 2: SUM, AVERAGE, COUNT, MIN and MAXFree
- Project 3: CONCAT, PROPER, UPPER, LEFT, RIGHT and LEN Pro
- Project 4: IF, Nested IF and IF with AND Pro
- Project 5: Number Formats and Conditional Formatting Pro
- Project 6: Create and Modify Charts Pro
- Project 7: Sort and Filter Logic with RANK.EQ, COUNTIF and LARGE Pro
- Project 8: Timed Mixed Project (20 Minutes) Pro