• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   User Microsoft Office Training Courses

Excel 2003 Level 1

View course dates

Course Duration: 1 Day

Course Code: DEX03L1

Course Description:

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.

 

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.

 

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.
  

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.

Follow on courses:

Excel 2003 Level 2

Excel 2003 Level 3

Relevant Certifications:

MOS: Office 2003 Editions Track

This course includes the following modules:

Getting Started

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

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

• 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

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

Customising layout

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

Page Display & Printing Options

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

 

Location	Duration	RRP	Oct	Nov	Dec	Jan	Feb	Mar
Click on course date to make a booking, check availability, or find out about available discounts.
Birmingham	1 days	£215	20 - 20	3 - 3	1 - 1	9 - 9
Bristol	1 days	£215			1 - 1
Edinburgh	1 days	£215	27 - 27	3 - 3	2 - 2
Exeter	1 days	£215			3 - 3
Glasgow (RenSt)	1 days	£215		10 - 10
Leeds	1 days	£215	29 - 29		1 - 1	5 - 5
London (Mid)	1 days	£215	16 - 16 29 - 29	4 - 4	18 - 18	6 - 6	2 - 2	9 - 9
London (Ros)	1 days	£215			5 - 5
London (Tab)	1 days	£215		13 - 13 27 - 27
Manchester (Exch)	1 days	£215	17 - 17	28 - 28
Manchester (Stock)	1 days	£215		24 - 24
Milton Keynes	1 days	£215		3 - 3	1 - 1
Newcastle	1 days	£215		7 - 7 25 - 25
Reading	1 days	£215	14 - 14	3 - 3

<< Previous 6 Months

Next 6 Months >>

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course