Microsoft Excel Level 2
The Microsoft Excel Level 2 course teaches students intermediate to advanced-level concepts and features of the Microsoft Excel application. In this course, students learn to customize Microsoft Excel and streamline workflow by building upon the basic skills learned in the Microsoft Excel – Level 1 course. They learn to use named references, validate and consolidate data, use links and hyperlinks, and reference external data. Students learn to use cell comments, custom and conditional formatting, styles, and templates. They also practice working with graphics, charts, diagrams, and databases (lists).
Students accomplish the learning objectives for each lesson through a series of hands-on tasks, for which they are given step-by-step instructions and desired result checkpoints. The tasks provide ample opportunity for students to practice, apply, and develop the Microsoft Excel skills covered in the lesson.
A practice exercise and review questions are included at the end of each lesson to measure progress and enforce the skills learned. There is also a lab exercise at the end of the course to provide further practice and review, to reinforce the topics learned throughout the course, and to help prepare students for the exam.