Microsoft Excel Level 1
In the Microsoft Excel Level 1 course, students learn to create and manage worksheets and workbook files; enter data and create basic formulas to perform calculations. They learn to edit and manipulate cell content, modify worksheet structure, view and format worksheets, and use Excel’s predefined functions. Students use the Find and Replace feature, use themes to format workbooks and practice preparing, previewing, and printing worksheets.
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 skills covered in the course.
A practice exercise and review questions are included at the end of each lesson to measure progress and reinforce 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.
Introduction to Windows course, or equivalent.
METHOD OF DELIVERY
Integrated Learning™ System training facilitated by Academy of Learning Career College facilitators.
Course manual is provided for on-going reference. There is a final exam upon completion of the course. Participants who receive 75% or higher on their exam will receive a certificate.
Exploring Microsoft Excel; Creating Workbook Files; Getting Help While You Work
Viewing Worksheets; Navigating Worksheets and Workbooks; Managing Worksheets and Workbook Files
Creating Basic Formulas; Editing Text and Values; Clearing, Moving, and Copying Cell Content; Modifying Worksheet Structure
Understanding Functions; Using Functions; Using Statistical Functions; Using Date and Time Functions;
Formatting Cells and Cell Content; Formatting Worksheets
Preparing Worksheets for Printing; Using Find and Replace; Previewing and Printing Worksheets