|
Introducing Excel 2003
|
Office 2003 Overview
|
Excel 2003 Overview
|
|
Screen Layout
|
Title Bar, Menus & Toolbars
|
The Task Pane
|
|
Create & Open a Workbook
|
What Is A Workbook?
|
Creating a New Workbook
|
|
Use a Template
|
Open an Existing Workbook
|
Closing a Workbook
|
|
View a Workbook
|
What Is A View?
|
Page Break Preview
|
|
Custom Views
|
Splitting a Worksheet
|
Freeze Rows & Columns
|
|
Comparing Workbooks
|
Save a Workbook
|
Save & Save as Commands
|
|
Save a Workbook
|
Program
|
Print Workbooks
|
|
Print Worksheet & Workbooks
|
Modify Page Setup
|
Set Print Area
|
|
Help in Excel 2003
|
Microsoft Office Online
|
Type a Question for Help
|
|
Excel Help Task Pane
|
Detect and Repair
|
WORK WITH CELLS
|
|
Cell Basics
|
What Is A Cell Reference?
|
Select Cells
|
|
Navigating a Worksheet
|
Enter Data
|
Entering Data
|
|
What Is A Value?
|
What Is A Label?
|
Edit Data
|
|
Edit Worksheet Data
|
Find & Replace Data
|
Copy and Move Data
|
|
Copying & Moving Data
|
Copy & Move Data
|
Use the Office Clipboard
|
|
Insert & Delete Cells
|
Insert & Delete Cells
|
CALCULATE YOUR DATA
|
|
Formulas
|
What Is A Formula?
|
Create a Formula
|
|
Edit a Formula
|
Cell References
|
Types of Cell References
|
|
Using Relative References
|
Use Absolute References
|
Mixed References
|
|
Functions
|
What Is A Function?
|
Enter a Function Manually
|
|
Insert a Function
|
Use a Date Function
|
Financial Functions
|
|
Use a Financial Function
|
Logical Functions
|
Use a Logical Function
|
|
WORK WITH YOUR
|
WORKBOOK
|
Modify a Worksheet
|
|
Edit Rows & Columns
|
Resizing Rows & Columns
|
Resize Rows & Columns
|
|
Hide Rows & Columns
|
Modify a Workbook
|
Insert & Delete a Worksheet
|
|
Move/Copy a Worksheet
|
Workbook
|
Rename a Worksheet
|
|
Format Worksheet Tabs
|
FORMAT a WORKSHEET
|
Format Characters
|
|
Formatting Text & Numbers
|
Format Text
|
Formatting Numbers
|
|
Format Numbers
|
Use a Custom Number Format
|
Format Cells
|
|
Formatting Cells
|
Aligning Cell Content
|
Align Cell Content
|
|
Merge Cells
|
Apply Borders & Shading
|
Format Painter
|
|
Clear Cell Formatting
|
Cell Formatting
|
AutoFormat
|
|
Use AutoFormat
|
WORK WITH GRAPHICS
|
Work With Graphics
|
|
Graphics in Excel
|
Insert Clip Art
|
Add Charts
|
|
Adding Charts
|
The Chart Wizard
|
Modify a Chart
|
|
AUTOMATE YOUR WORK
|
AutoFill
|
What Is AutoFill?
|
|
Use AutoFill
|
AutoComplete
|
Using AutoComplete
|
|
Auto Calculate
|
Use Auto Calculate
|
COLLABORATE
|
|
Collaborate On Workbooks
|
Distributing Workbooks
|
E-Mail a Workbook
|
|
Work With Comments
|
Add Comments
|
|
.gif)
