Microsoft Excel Level 3

The Microsoft Excel Level 3 course teaches students advanced-level concepts and features of the Microsoft Excel application. In this course students will build upon the skills learned in the Microsoft Excel Level 1 and Level 2 courses,  and will cover more advanced level concepts and features of Microsoft Excel. They will learn to increase productivity and enhancements of spreadsheets using some of Excel’s more advanced level features. Students will be given ample opportunity to explore and practice these techniques throughout the course.
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 and 2 courses

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

Using Formulas to Project Values; Using the Analysis ToolPak; Using Goal Seek, Solver, and Scenario Manager

LESSON 2

Understanding PivotTable and PivotChart Reports; Creating PivotTable and PivotChart Reports

LESSON 3

Using the Formula Auditing Tools; Correcting Errors in Formulas

LESSON 4

Modifying Workbook Properties; Customizing the Quick Access Toolbar; Customizing the Microsoft Excel Environment; Automating Tasks with Macros

LESSON 5

Protecting a Workbook; Sharing a Workbook with Others; Reviewing and Consolidating Workbooks

LESSON 6

Using Microsoft Excel with Other Microsoft Office Programs; Importing Data from External Sources; Using Microsoft Excel Data on the Web

0 hours
Course Duration
Request Information