In this 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 format 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.
Review questions are included at the end of each lesson to measure progress and reinforce the skills learned. There are also Exam Preparation Exercises 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.