Learning Microsoft Excel

Unit 1: Spreadsheet Basics

 

The Application Window - Tools and Features

Title Bar

Menu Bar

Toolbars

Formula Bar

Status Bar

The Document and Workbook Window -

Tools and Features

Title Bar

Workbook Page

Scroll Bars

Sheet Tabs and Scrolling Buttons

Basic Terms and Definitions (Missing File, Sorry)

Cell

Active Cell or Selected Cell

Block

Workbook

Constant Values

Formulas

Basic Document Activities

Moving Around in the Spreadsheet

Marking a Block

Data Entry

Editing Data

Entering Formulas

Saving the Workbook

Printing the Workbook

Quitting Excel

Open versus New

Unit 1 Exercises and Questions

 

Unit 2: Common File Modifications

Changing Column Widths

Inserting and Deleting Columns and Rows

Inserting a Column or Row

Deleting a Column or Row

Recover with an Undo

How Do Insertions and Deletions Affect Formulas?

Simple Formatting Changes (Missing File, Sorry)

Bold and Italic

Font Changes

Alignment Changes

Copying and Moving

Copying

Moving

Using Dates

Using Style Options on the Formatting Toolbar (Missing File, Sorry)

Unit 2 Summary

Unit 2 Exercises and Questions (Missing File, Sorry)

Back to TIPS Main Page