Excel 2003 Foundation Courseware Materials

Microsoft Excel 2003 Foundation Training Materials for IT Trainers

Foundation Level Computer 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

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 standard 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

 

Excel 2003 Foundation Courseware Materials
3 (60%) 2 votes