Microsoft Excel 2003 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. EXCEL 2003 – 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. EXCEL 2003 – 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. EXCEL 2003 – 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. EXCEL 2003 – 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. EXCEL 2003 – 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

 

Call Now Button