Excel 2003 Level 1

1 Day Course
Hands On
Code DEX03L1

Book Now - 1 Delivery Method Available:

Scheduled Online Onsite

Overview

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft‚® Office Excel 2003 to manage, edit, and print data.

You will create and edit basic Microsoft‚® Office Excel 2003 worksheets and workbooks.


     

Objectives

Upon successful completion of this course, students will be able to:

  • Create a basic worksheet.
  • Modify a worksheet.
  • Perform calculations.
  • Format a worksheet.
  • Develop a workbook.
  • Print the contents of a workbook.
  • Customize the layout of the Excel window.

Target Audience

 This course is designed for persons preparing for certification as a Microsoft® Office Specialist in Excel, who already have knowledge of the Microsoft‚® Office Windows 98 (or above) operating system, and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft‚® Excel 2003 worksheets.

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

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

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections