Description
This project provides the learner with 8 different tasks to complete in Microsoft Excel, using a real-world situation. This is on an intermediate level, and the content is for practicing what learners have already learned, not to teach how to use Microsoft Excel. Learners can also use this project to prepare for the Microsoft Office Specialist Exam.
Skills Addressed: Convert data from a range to a table, apply table styles, use AutoFill, nested functions, conditional formatting rules, create and move a chart, change/add chart elements, functions: IF(), SUM(), VLOOKUP(), MAX(), MIN()
The project comes with 2 Excel workbooks. One as a Data File for the learner and one for the Instructor which includes Microsoft Office Specialist Objectives. The instructor workbook is protected, but does not need a password.
Highlights
Description
This project provides the learner with 8 different tasks to complete in Microsoft Excel, using a real-world situation. This is on an intermediate level, and the content is for practicing what learners have already learned, not to teach how to use Microsoft Excel. Learners can also use this project to prepare for the Microsoft Office Specialist Exam.
Skills Addressed: Convert data from a range to a table, apply table styles, use AutoFill, nested functions, conditional formatting rules, create and move a chart, change/add chart elements, functions: IF(), SUM(), VLOOKUP(), MAX(), MIN()
The project comes with 2 Excel workbooks. One as a Data File for the learner and one for the Instructor which includes Microsoft Office Specialist Objectives. The instructor workbook is protected, but does not need a password.
