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.
Microsoft Excel Level 1 and 2 courses
METHOD OF DELIVERY
Integrated Learning™ System training facilitated by Academy of Learning Career College facilitators.
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.
Using Formulas to Project Values; Using the Analysis ToolPak; Using Goal Seek, Solver, and Scenario Manager
Understanding PivotTable and PivotChart Reports; Creating PivotTable and PivotChart Reports
Using the Formula Auditing Tools; Correcting Errors in Formulas
Modifying Workbook Properties; Customizing the Quick Access Toolbar; Customizing the Microsoft Excel Environment; Automating Tasks with Macros
Protecting a Workbook; Sharing a Workbook with Others; Reviewing and Consolidating Workbooks
Using Microsoft Excel with Other Microsoft Office Programs; Importing Data from External Sources; Using Microsoft Excel Data on the Web