Microsoft Excel 2003: Introduction for Beginners (1 day)

About this class

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(R) Office Excel 2003 to manage, edit, and print data.

You will create and edit basic Microsoft(R) Office Excel 2003 worksheets and workbooks.

This training may be available onsite; please contact us if you are interested.

Who will the lesson benefit?

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

What delegates will learn

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.

Examination details

This course will prepare you for the following exams and certification tracks shown. Please note that the exam may not be included in the price shown: please contact us to check.

Microsoft® Certification Tracks  »
    Microsoft® Exams  »
       Exam excel2003: MOS: Excel 2003

What prerequisites are required

Delegates need to be able to:

• Use a mouse
• Type and use a keyboard
• Navigate through Windows files and folders
• Work with Windows - minimise, maximise, open and close

Contents of this class

• 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