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.

COURSE PREREQUISITE(S)

Introduction to Windows course, or equivalent.

METHOD OF DELIVERY

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

COURSE NOTES

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.

LESSON 1

Exploring Microsoft Excel; Creating Workbook Files; Getting Help While You Work

LESSON 2

Viewing Worksheets; Navigating Worksheets and Workbooks; Managing Worksheets and Workbook Files

LESSON 3

Creating Basic Formulas; Editing Text and Values; Clearing, Moving, and Copying Cell Content; Modifying Worksheet Structure

LESSON 4

Understanding Functions; Using Functions; Using Statistical Functions; Using Date and Time Functions;

LESSON 5

Formatting Cells and Cell Content; Formatting Worksheets

LESSON 6

Preparing Worksheets for Printing; Using Find and Replace; Previewing and Printing Worksheets

.

0 hours
Course Duration
Request Information