Excel 2003 Level 1

1 Day Course
Hands On
Code DEX03L1

This course has been retired. Please view currently available User Microsoft Office Training Courses.

Modules

Hide all

Getting Started (4 topics)

  • Enter data in a worksheet
  • Edit data
  • Change the appearance of data
  • Save a workbook

Editing Your Worksheet (8 topics)

  • 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 (4 topics)

  • Sum a Range of Data
  • Use a Built-in Function
  • Copy a Formula
  • Create an Absolute Reference

Formatting (9 topics)

  • Number Formats
  • Custom number formats
  • Font Size and Type
  • Styles
  • Borders and Colours to cells
  • Column Width and Height
  • Align Cell Contents
  • Merge and Center Cells
  • AutoFormat

Working with multiple worksheets (3 topics)

  • Format worksheets Tabs
  • Reposition Worksheets in a workbook
  • Copy Worksheets

Customising layout (4 topics)

  • Split a worksheet
  • Arrange worksheets
  • Freeze and unfreeze rows and columns
  • Hide & Unhide worksheets

Page Display & Printing Options (7 topics)

  • Freeze rows and columns
  • Print Title
  • Set Page Margins
  • Headers and Footers
  • Page Orientation
  • Insert and remove page breaks
  • Print a range

Prerequisites

To ensure your success, we recommend you first take the following course or have equivalent knowledge: Microsoft Office Windows XP: Introduction If you have taken an introductory course for an earlier version of the Windows operating system, this will also meet the prerequisite.

Relevant Certifications

Sections