Microsoft Excel Level 22015-07-05T07:18:58+00:00

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.

COURSE PREREQUISITE(S)

Microsoft Excel Level 1 course.

METHOD OF DELIVERY

Integrated Learning™ System training facilitated by Academy of Learning Career College facilitators.

COURSE NOTES

Course manual provided for on-going reference. Upon completion of the course, there is a final exam. Participants who receive 75% or higher on their exam will receive a certificate.

LESSON 1

Creating Custom Themes; Working with Quick Styles; Using Conditional and Custom Formatting

LESSON 2

Referencing Data; Using Hyperlinks; Ensuring Data Integrity

LESSON 3

Creating Tables; Sorting and Filtering Data; Grouping and Outlining

LESSON 4

Creating Charts; Modifying and Formatting Charts

LESSON 5

Using Conditional Logic in Formulas; Using Formulas to Look Up Data; Using Formulas to Modify or Format Text; Using Formulas for Financial Calculations; Using Arrays

LESSON 6

Using SmartArt; Inserting Graphic objects; Modifying and Formatting Graphic objects

0 hours
Course Duration
Request Information