Microsoft Excel – Full Course

Microsoft Excel Outlines

Lesson #1 Learning Objectives

Open Excel
Excel Interface
Common Screen Elements
Use Tabs
Open Ribbons
Use Tools
Excel Modes
Examine Defaults
Define Pointer
Navigate Excel
Page Break Preview
Enter Data
Make Corrections
Print Preview
Save Spreadsheet

Learning Objectives Lesson #2

Open Existing File
Display Page Break
Change page Orientation
Enter Values
Use Autofit
Format Cells
Format Text
Change Alignment
Use Merge & Center
Type Paragraphs
Use Accounting Number Formats
Use Format Painter
Use Clear Formats
Use Save AS

Learning Objectives Lesson #3

Open Existing File
Display Page Break
Copy Text
Wrap Text
Use Fill Handle
Insert Rows & Columns
Identify A Range
Insert Chart
Edit Chart
Move Chart
Use Borders Tool
Use Save As

Learning Objectives Lesson #4a

Open Excel
Display Page Break
Change Orientation
Rename Worksheet
Use Borders Tool
Create Form
Identify Range
Create Time Card

Learning Objectives Lesson #4b

Define Template
Use Template
Open Template
Replace Text
Keep Structure
Save Template

Learning Objectives Lesson #5

Create Folder
Display Page Break
Change page Orientation

Change Margins
Use Fill Handle
Rename Worksheet
Use Autofit
Use CTRL +S
Rotate Text
Insert Column
Use Drag & Drop
Conditional Formatting
Use AutoSum
Use Sheet Styles
Use Format Painter
Center On Page
Print Preview