Excel 2003 Foundation Courseware

Microsoft Excel 2003 Foundation Training Materials

Foundation Level Training Materials

Courseware Training Manual

1. INTRODUCTION TO MICROSOFT EXCEL 2003 WHAT IS EXCEL?

  •     Microsoft Excel 2003
  •     Using Excel as a Spreadsheet
  •     Using Excel as a Database
  •     Analyzing Data
  •     Microsoft Web Site

EXCEL FILE TYPES

  •     Spreadsheet files
  •     Online Publishing files
  •     XML files
  •     Template files

EXCEL ENVIRONMENT

  •     Working with the Excel window
  •     Using the Formula Bar
  •     Using the Task Pane
  •     Using the New Workbook Pane
  •     Using the Clipboard Pane
  •     Using the Basic Search Pane
  •     Using the Insert Clip Art Pane
  •     Using the Status Bar
  •     Exiting Excel 2003

TOOLBARS

  •     Using Toolbars
  •     Showing a Toolbar
  •     Hiding a Toolbar
  •     Moving a Toolbar
  •     Using the Standard Toolbar
  •     Using the Formatting Toolbar

OFFICE ASSISTANT

  •     Understanding the Microsoft Office Assistant
  •     Using Tips of the Day
  •     Displaying the Office Assistant
  •     Displaying Tips
  •     Hiding the Office Assistant
  •     Customizing the Office Assistant

WORKBOOKS AND WORKSHEETS

CREATING AND OPENING WORKBOOKS

  •     Creating a new Workbook
  •     Creating a new Workbook using a template
  •     Opening an existing Workbook

WORKING WITH WORKBOOKS

  •     Understanding Workbooks and Worksheets
  •     Minimizing a Workbook
  •     Saving Workbooks
  •     Saving a backup copy
  •     Saving Summary Information
  •     Closing Workbooks

WORKING WITH WORKSHEETS

  •     Zooming the Worksheet View
  •     Renaming Worksheets
  •     Changing the Sheet Tab color
  •     Inserting Worksheets
  •     Reordering Worksheets
  •     Deleting Worksheets
  •     Customizing Worksheet Views

WORKING WITH CELLS

  •     Understanding Cells and Ranges
  •     Understanding the Active Cell

NAVIGATING WITHIN A WORKSHEET

  •     Navigating to a specific Cell
  •     Moving around the Worksheet
  •     Moving within a selection

NAVIGATING THE WORKBOOK

  •     Navigating between Worksheets using the mouse
  •     Moving between Worksheets using the keyboard
  •     Moving from one Workbook to another

2. SPREADSHEET DATA

ENTERING DATA

  •     Entering text
  •     Entering numbers as numeric values
  •     Entering numbers as text
  •     Entering dates
  •     Entering current date
  •     Entering current time
  •     Customizing the movement of the Active Cell
  •     Entering data into a range of cells
  •     Filling a range of cells with the same data

USING TIME SAVING FEATURES

  •     Using AutoComplete
  •     Using a Pick List
  •     Using AutoCorrect
  •     Viewing items that will be corrected
  •     Adding items to AutoCorrect
  •     Deleting an AutoCorrect item
  •     Using Smart Tags
  •     Turning Smart Tags on

CHECKING THE SPELLING

  •     Checking spelling in a Worksheet
  •     Correcting spelling errors

3. FORMATTING AND CUSTOMIZING DATA

SELECTING ITEMS IN EXCEL

  •     Selecting a Cell
  •     Selecting a Row
  •     Selecting a Column
  •     Selecting a Range
  •     Selecting a non-contiguous Range
  •     Selecting an entire Worksheet
  •     Selecting several Worksheets
  •     Selecting all Worksheets

FORMATTING TEXT

  •     Changing the Font
  •     Changing the Font size
  •     Changing the Font style
  •     Changing the Underline
  •     Changing the Font effects
  •     Resetting Font formatting
  •     Changing the default Font characteristics of the current Workbook
  •     Changing the default Font in new Workbooks

FORMATTING NUMBERS

  •     Formatting numbers using the Formatting Toolbar
  •     Applying the Currency Format
  •     Applying the Percent Format
  •     Applying the Number Format
  •     Applying custom formatting
  •     Setting a fixed decimal places for numeric values

MANIPULATING DATA

  •     Aligning data horizontally within a cell
  •     Aligning data vertically within a cell
  •     Centering headings over multiple columns
  •     Wrap multiple lines of data in a cell
  •     Indenting data within a cell
  •     Changing the text orientation

FORMATTING COLUMNS AND ROWS

  •     Changing the Column width numerically
  •     Changing the Column width visually
  •     Changing Column width to fit data
  •     Setting the default Column widths
  •     Changing the Row height numerically
  •     Changing the Row height visually
  •     Changing the Row height to fit data

ADDING AND EDITING BORDERS

  •     Selecting a Border style
  •     Applying Borders
  •     Removing Borders
  •     Changing the style and color of Borders

USING AUTOFORMAT

  •     Using AutoFormat

4. EDITING SPREADSHEETS

CUTTING, COPYING, AND PASTING

  •     Cutting data
  •     Copying data
  •     Pasting data
  •     Inserting copied Cells
  •     Copying multiple items to the Office Clipboard
  •     Pasting items from the Office Clipboard
  •     Deleting items from the Office Clipboard
  •     Copying data by dragging and dropping
  •     Copying data over several cells
  •     Copying an object to another Worksheet location

INSERTING AND DELETING

  •     Inserting Rows
  •     Inserting Columns
  •     Inserting Cells
  •     Deleting Rows or Columns
  •     Deleting the contents of a Cell or Range
  •     Deleting data without deleting the cell formatting
  •     Removing cell formatting without deleting the data
  •     Deleting Cells
  •     Deleting Objects

USING FIND AND REPLACE

  •     Searching for text or numbers
  •     Replacing text or numbers

USING UNDO AND REDO

  •     Undoing the last action
  •     Undoing multiple actions
  •     Redoing the last Undo
  •     Redoing multiple Undos

5. FORMULAS AND FUNCTIONS

ENTERING FORMULAS

  •     Understanding a Formula
  •     Using the Formula toolbar
  •     Entering a Formula
  •     Entering a Cell or Range reference
  •     Using relative and absolute Cell references
  •     Editing Formulas

ENTERING FUNCTIONS

  •     Understanding a Function
  •     Entering Functions
  •     Using the AutoSum Functions
  •     Using the SUM Function
  •     Using the AVERAGE Function
  •     Using the COUNT Function
  •     Using the MAX Function
  •     Using the MIN Function

USING NAMED CELLS AND RANGES IN FORMULAS

  •     Choosing names for Cells and Ranges
  •     Naming Cells or Ranges
  •     Navigating Workbooks using Cell or Range names
  •     Creating named Ranges based on Cell values
  •     Deleting named Cells or Ranges
  •     Using named Cells and Ranges in Formulas

6. PRINTING

USING PAGE SETUP

  •     Changing page orientation
  •     Setting the scale of the page
  •     Setting paper size
  •     Setting print quality
  •     Beginning page numbering with a different number

MARGINS

  •     Changing the Margins
  •     Changing the Header and Footer Margins
  •     Changing the Margins in Print Preview
  •     Centering the data on a page

HEADERS AND FOOTERS

  •     Using Headers and Footers
  •     Creating custom Headers or Footers

PRINTING A SPREADSHEET

  •     Setting the print area using Print Area
  •     Setting the print area using Page Setup
  •     Printing Row or Column titles on every page
  •     Selecting elements to print
  •     Previewing a Worksheet
  •     Setting the order pages are printed
  •     Printing a Workbook