Courseware Objective
The main objective of this courseware is to introduce you to the basic commands, functions, and capabilities of Microsoft Office Excel 2003. It is designed for computer users who are new to spreadsheets, or who only plan to use Excel occasionally.
Courseware Outline
About This Courseware
Courseware Conventions
Using the Book
Working with the Exercises
Courseware Objectives and Prerequisites
Prerequisite Windows Skills
A Quick Review of Basics
System Requirements
Obtaining Support
Starting Excel
Courseware Setup
Moving Around
Moving Around on the Screen
Getting Help
Exiting Excel
Introduction
Objectives of Section 1
Overview
What is an Electronic Spreadsheet?
What is Excel?
Looking at the Excel Screen
Understanding Basic Terminology
Mouse Symbols
Using the Excel Menus
Moving Around Dialog Boxes
Using the Excel Toolbars
Identifying Screen Symbols
Using Task Panes
Handling Files
Creating a New Blank Workbook
Creating a New Workbook from a Template
Opening Workbooks
Closing a Workbook
Saving Workbooks
Creating and Renaming Folders
Entering Data in the Worksheet
Types of Data
Entering Text
Entering Numbers
Entering Dates and Times
Inserting Symbols and Special Characters
Moving Around the Worksheet
Summary of Section 1
Using the Worksheet
Objectives of Section 2
Selecting Cells
Editing Cells and Undoing Changes
Copying and Moving Data
Cutting, Copying and Pasting Data
Using the Clipboard
Copying and Moving Cells Using The Mouse
Adjusting the Columns or Rows
Changing the Column Widths
Using AutoFit
Adjusting the Row Height
Inserting and Deleting Rows and Columns
Inserting Rows and Columns
Deleting Rows and Columns
Inserting and Deleting Cells
Summary of Section 2
Formulas & Common Functions
Objectives of Section 3
Creating and Editing Simple Formulas
Using Common Functions With Cell Ranges
Using Absolute & Relative Cell References
Managing Worksheets
Renaming Worksheets
Inserting or Deleting Worksheets
Moving or Copying Worksheets
Summary of Section 3
Formatting Worksheets
Objectives of Section 4
Formatting a Cell
Formatting Numbers and Decimal Digits
Changing Cell Alignment
Fonts and Sizes
Cell Borders
Colors and Patterns
Clearing Cell Contents and Formatting
Using AutoFormat
Formatting Worksheets
Adding Color to the Worksheet Tabs
Changing the Worksheet Background
Summary of Section 4
Looking at Windows & Printing
Objectives of Section 5
Print Previewing the Worksheet
Adding and Previewing Page Breaks
Customizing the Printout
Page Settings
Page Margins Tab
Header and Footer Tab
Sheet Tab
Printing the Worksheet
Using Window Panes
Creating and Arranging Window Panes
Splitting Panes
Freezing Panes
Hiding and Unhiding Workbooks
Summary of Section 5
