# Microsoft Excel Level 1

## Course Info:

### Course Introduction

In this course, students learn to create and manage Excel worksheets and workbook files, enter data, and create basic formulas to perform calculations. They learn to format cell content, view and format work-sheets, and practice preparing, previewing, and printing workbooks.

Students accomplish the learning objectives for each module through a series of hands-on activities, and there are frequent opportunities to practice, apply, and develop the skills covered in the course.

### Course Prerequisite

Introduction to Windows course or equivalent.

### Course Notes

The course consists of 10 graded, end-of-module quizzes and a final exam, which consists of practical and online test components.

The course includes a digital Student Reference Guide and Let Me Try workbook. Printed versions of these may be purchased separately.

### Course Breakdown

Module 1: Introduction to Excel
The Excel Window; Mouse Basics in Excel; Backstage View

Module 2: Creating Workbooks
Entering Text and Numbers; Creating Basic Formulas; Relative References; Order of Operations; Working with Ranges

Module 3: Saving and Sharing Workbooks
Saving a Workbook; File Extension, Sharing, Exporting, and Publishing Files

Module 4: Navigating Workbooks
Opening Files; Working with Larger Files; Creating Freeze Panes; Split Screen

Module 5: Page Setup and Print Options
Headers and Footers; Print Titles; Working with Comments; Page Setup Options; Printing Workbooks

Module 6: Working with Rows, Columns, and Cells
Adding and Deleting Rows, Columns and Cells; Changing Column Width and Row Height

Module 7: Moving Data
Cut, Copy, and Paste; Copying Formulas

Module 8: Formulas and Functions
Overview of Formulas; Creating Formulas Using Functions; Using Absolute Values

Module 9: Working with Sheets
Adding, Deleting, Renaming and Grouping Sheets; Additional Sheet Tab Options; 3-Dimensional Formulas

Module 10: Formatting Worksheets
Formatting Cells; Formatting Numbers; Borders and Shading; Formatting a Range of Cells as a Table; Using Styles and the Format Painter; Protecting Sheets; Using the Fill Handle and Creating Custom Lists

### Upon Completion

Students may continue with Microsoft Excel Level 2.