Lesson 1: Entering Text and Numbers
-
The Microsoft Excel Window
-
Moving Quickly Around the Microsoft Excel Worksheet
-
Selecting Cells
-
Entering Data
-
Editing a Cell
-
Changing a Cell Entry
-
Wrapping Text
-
Deleting a Cell Entry
-
Entering Numbers as Labels or Values
-
Smart Tags
-
Saving a File
-
Closing Microsoft Excel
Lesson 2: Formatting Text and Performing Mathematical
Calculations
-
Choosing a Default Font
-
Adjusting the Standard Column Width
-
Cell Alignment
-
Adding Bold, Underline, and Italic
-
Changing the Font, Font Size, and Font Color
-
Working with Long Text
-
Changing a Single Column Width
-
Moving to a New Worksheet
-
Setting the Enter Key Direction
-
Making Numeric Entries
-
Performing Mathematical Calculations
-
The AutoSum Icon
-
Automatic Calculation
-
Formatting Numbers
-
More Advanced Mathematical Calculations
-
Cell Addressing
-
Deleting Columns
-
Deleting Rows
-
Inserting Columns
-
Inserting Rows
-
Creating Borders
-
Merge and Center
-
Adding Background Color
-
Using Auto Format
-
Saving Your File
-
Closing Microsoft Excel
Lesson 3: Numbers and Mathematical Calculations
-
Reference Operators
-
Functions
-
Typing a Function
-
Calculating an Average
-
Calculating Min
-
Calculating Max
-
Calculating Count
-
Filling Cells Automatically
-
Saving Your File
-
Closing Microsoft Excel
Lesson 4: Cool Stuff
-
Data Entry Validation
-
Sorting Data
-
Filter Data
-
Data Entry Forms
-
Lookup Formulas
-
VLOOKUP
-
HLOOKUP
-
LOOKUP
-
Autoformat a Worksheet
-
Transpose Rows
-
Create Labels
-
Freeze Panes
Lesson 5: Creating Charts
-
Creating a Column Chart
-
Changing the Size and Position of a Chart
-
Modify Your Chart
-
Saving Your File
-
Closing Microsoft Excel
Lesson 6: Printing
-
Page Breaks
-
Page Setup
-
Preview
-
Print
Keyboard Shortcuts
-
Adding Sheets, Rows and Columns
-
Resizing Rows and Columns
-
Selecting Cells
-
Moving and Copying Cells