Introduction
What Is Excel?
Opening Excel
Exiting Excel
Lesson 1.2
Help With Excel
Finding Help
The Office Assistant
Using Help
Lesson 1.3
Beginning Excel
The Standard Toolbar
The Formatting Toolbar
Working With Excel Menus
Excel Shortcut Keys
Lesson 1.4
The Basics Of File Management
New Workbooks
How To Open Existing Workbooks
How To Save Workbooks
How To Close Workbooks
Excel File Types
Lesson 1.5
Explore Your
Workbook
Switching Worksheets
The Active Cell
Selecting Cells
Exploring A Worksheet
The Zoom Feature
SECTION 2:
Excel Basics
Lesson 2.1
Working With Excel
Columns, Rows, Cells, And Ranges
Creating Worksheet Labels
Entering and Deleting Data
Printing Your Worksheet
Lesson 2.2
Basic Excel Features
What Is Autofill?
What Is Autosum?
What Is Autocomplete?
Working With Basic Formulas
Lesson 2.3
Editing Tools
Using Autocorrect
Using Spell Check
Using Find And Replace
Documenting A Worksheet With Comments
Lesson 2.4
Moving Your Data
Dragging And Dropping Cells
How To Cut, Copy, And Paste Cells
How To Cut, Copy, And Paste Multiple Cells And Items
How To Use Paste Special
How To Insert And Delete Cells, Rows, And Columns
Using Undo, Redo, And Repeat
Lesson 2.5
Using Smart Tags
And Option Buttons
What Are Smart Tags?
The Error Option Button
The Autofill Option Button
The Paste Option Button
SECTION 3:
Working With Excel
Lesson 3.1
Modifying Cells And Data
Changing The Size Of Rows Or Columns
Working With The Formatting Toolbar
Adjusting Cell Alignment
Rotating Text
Creating Custom Number And Date Formats
Lesson 3.2
Cell Formatting
Conditional Formatting
What Is The Format Painter
What Is Autoformat
Cell Merging And Autofit
Find And Replace Formatting
Lesson 3.3
Enhancing A Worksheet’s Appearance
Adding Patterns And Colours
Adding Borders
Adding Fill Effects
Working With Styles
Working With Charts
Creating A Chart
Formatting A Chart
Manipulating A Chart
Enhancing A Chart With Drawing Tools
Enhancing Your Chart With Titles And Tables
Lesson 3.6
Working With Charts And Data
Changing The Type Of Chart
Changing The Source Data
Creating 3-D Charts
Working With The Chart Axes And Data Series
Making Custom Charts
SECTION 4:
Workbook Management
Lesson 4.1
Organizing Your Workbook
Inserting And Removing Worksheets
Renaming, Moving, And Colour-Coding Worksheets
How To Split And Freeze A Window
Using Multiple Workbooks And Windows
Using A Watch Window
Creating A Custom View
Lesson 4.2
Formatting Your Workbook
Using Headers And Footers
Inserting Page Numbers
Changing Margins And Orientation
Hiding Rows, Columns And Worksheets
Lesson 4.3
Printing A Workbook
Microsoft Office Document Imaging
Choosing A Print Area
Setting Up Page Breaks
