Microsoft Excel 2003 Basic and Intermediate

 

 

Objective:

Participants will learn how to use Excel to perform calculation and some simple functions, creating chart and understanding the use of spreadsheet.

Course Outline

  • 1. Microsoft Excel 2003

    • What's New in Excel 2003?
    • Understanding the Screen Display
    • Workbook Management
    • Moving the Cell Pointer
    • Navigating a Worksheet
    • Entering Labels in a Worksheet
    • Using AutoFill

    2. Formatting a Worksheet

    • Formatting Fonts with the Formatting Toolbar
    • Formatting Values
    • Adjusting Row Height and Column Width
    • Changing Cell Alignment
    • Adding Borders
    • Applying Colors and Patterns
    • Using the Format Painter
    • Using AutoFormat
    • Creating a Custom Number Format
    • Formatting Cells with Conditional Formatting
    • Merging Cells, Rotating Text, and using AutoFit
    • Finding and Replacing Formatting

    3. Managing Workbooks and Worksheets

    • Changing the Number or Worksheets in a New Workbook
    • Selecting Multiple Worksheets
    • Switching Between Sheets in a Workbook
    • Gridlines
    • Hide/Unhide a Workbook Window
    • Hide/Unhide a Sheet
    • Inserting and Deleting Worksheets
    • Renaming and Moving Worksheets
    • Move or Copy Sheets
    • Splitting and Freezing a Window
    • View Multiple Sheets or Workbooks at the Same Time
    • Compare Workbooks Side By Side

    4. Perform Calculations

    • Expanded Autosum Functionality
    • Entering Formulas
    • Formula Error Checking
    • Name a Cell or a Range Of Cells
    • Cell Linking Vs. Data Consolidation

    5.Prepare and Print Worksheets

    • Adjusting Page Orientation
    • Print a Worksheet to Fit a Paper Width or a Number of Pages
    • Adjusting Page Margins and Centre Print Out
    • Create Headers, Footers & Page Number
    • Print With or Without Cell Gridlines
    • Adding Print Titles
    • Print a Worksheet with Formulas Displayed
    • Hiding Columns, Rows, and Sheets
    • Print a Selected Area of a Worksheet

    6. Create and Manage Charts

    • Create a Chart
    • Change the Chart Type of an Existing Chart
    • Change the Location, Display Size, or Position of a Chart
    • Change the Fill, Border, Line Style, or Color of Chart Elements
    • Change the 3-D View of a Chart
    • Change the Size or Position of an Embedded Chart in the Worksheet
    • Add or Remove Pictures in a Chart