Microsoft Excel Introduction

Course Outline

Getting Started
Starting Excel
Opening a Workbook
Understanding the Display Screen
Working with the Ribbon
Exploring the File Tab
Working with the Quick Access Toolbar
Working with the Status Bar
Switching Between Opened Workbooks
Using Excel Help

Entering Data
Moving the Cell Pointer
Selecting a Range of Cells
Creating a New Workbook
Inserting, Renaming, and Deleting Worksheets
Entering Constant Values
Using Auto Fill to Enter Data
Saving a Workbook
Editing Cell Contents
Clearing Cell Contents
Working with Undo and Redo
Closing a Workbook

Using Formulas
Entering Formulas
Using Auto Fill with Formulas
Using the SUM Function
Summing Columns or Rows Automatically
Using Statistical Functions
Working with the Range Finder
Using Formula Error Checking

Working with Constant Values and Formulas
Copying and Pasting Constant Values and Formulas
Cutting and Pasting Constant Values and Formulas
Using Collect and Paste

Formatting Worksheets
Formatting Numbers
Changing the Font Format
Aligning Cell Contents
Merging Cells
Adding Borders
Applying Cell Styles

Modifying Columns and Rows
Changing Column Width
Changing Row Height
Inserting and Deleting Columns or Rows
Hiding Columns or Rows

Editing Workbooks
Working with AutoCorrect
Checking Spelling
Using Find and Replace

Printing Worksheets
Using Print Preview
Working with Print Settings
Using Page Setup Tools
Working in Page Layout View
Creating a Header and Footer
Using Page Break Preview
Printing a Worksheet
Exiting Excel