Microsoft Office Excel Level 1

Course Description

Lesson 1: Creating a Basic Worksheet
Explore the User Interface and the Ribbon
Navigate and Select in Excel
Obtain Help
Enter Data and Save a Workbook
Customize the Quick Access Toolbar
Lesson 2: Performing Calculations
Create Basic Formulas
Calculate with Functions
Copy Formulas and Functions
Lesson 3: Modifying a Worksheet
Manipulate Data
Insert and Delete Cells, Columns, and Rows
Search for Data in a Worksheet
Spell Check a Worksheet
Lesson 4: Formatting a Worksheet
Modify Fonts
Add Borders and Color to Cells
Change Column Width and Row Height
Apply Number Formats
Position Cell Contents
Apply Cell Styles
Lesson 5: Printing Workbook Contents
Print Workbook Contents Using Default Print Options
Set Print Options
Set Page Breaks
Lesson 6: Managing Large Workbooks
Format Worksheet Tabs
Manage Worksheets in a Workbook
Manage the View of Large Worksheets