Microsoft Excel 2002  Beginners

Short course

In

Price on request

Description

  • Type

    Short course

  • Methodology

    Inhouse

  • Duration

    1 Day

This course will give you the skills to create, edit, format, and print basic worksheets and charts in Excel.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

This course will give you the skills to create, edit, format, and print basic worksheets and charts in Excel.Microsoft Excel 2002 Training Course (Beginners) Outline

  • Getting Started
    • Identify What You Can Do with Excel
    • Enter Data in a Worksheet
    • Edit Data
    • Change the Appearance of Data
    • Save a Workbook
    • Obtain Help
  • Editing Your Worksheet
    • Moving Data to Other Cells
    • Copy Data to Other Cells
    • Fill Cells with a Series of Data
    • Insert and Delete Rows and Columns
    • Undo and Redo an Entry
    • Find and Replace Numbers
    • Enter Data in a Range
    • Verify Data in a Range
  • Performing Calculations
    • Sum a Range of Data
    • Use a Built-in Function
    • Copy a Formula
    • Create an Absolute Reference
  • Formatting
    • Specify Number Formats
    • Create a Custom Number Format
    • Change Font Size and Type
    • Apply Styles
    • Add Borders and Color to Cells
    • Find and Replace Formats
    • Change Column Width and Row Height
    • Align Cell Contents
    • Merge and Center Cells
    • Apply an AutoFormat
  • Working with Multiple Worksheets
    • Format Worksheet Tabs
    • Reposition Worksheets in a Workbook
    • Copy Worksheets
    • Change the Number of Worksheets
  • Creating and Modifying Charts
    • Create a Chart
    • Modify Chart Items
    • Format a Chart
    • Change the Chart Type
  • Setting Page Display and Printing Options
    • Freeze Rows and Columns
    • Set Print Title
    • Set Page Margins
    • Create a Header and Footer
    • Change Page Orientation
    • Insert and Remove Page Breaks
    • Print a Range

Microsoft Excel 2002  Beginners

Price on request