Home > Courses Certifications > Microsoft Office > Excel 2003 Level 1 synopsis

Microsoft Excel 2003 - Level 1

Prerequisites: Windows XP Level 1

Duration: 1 day

Chapter 1: Getting Started with Excel

• An Overview of Excel
• Navigate in Excel
• Select Data
• Enter Data
• Save a Workbook
• Obtain Help

Chapter 2: Modifying a Worksheet

• Move and Copy Data Between Cells
• Fill Cells with Series of Data
• Edit Cell Data
• Insert and Delete Cells, Columns, and Rows
• Find, Replace, and Go To Cell Data
• Spell Check a Worksheet

Chapter 3: Performing Calculations

• Create Basic Formulas
• Calculate with Functions
• Copy Formulas and Functions
• Create an Absolute Reference

Chapter 4: Formatting a Worksheet

• Change Font Size and Type
• Add Borders and Colour to Cells
• Change Column Width and Row Height
• Merge Cells
• Apply Number Formats
• Create a Custom Number Format
• Align Cell Contents
• Find and Replace Formats
• Apply an AutoFormat
• Apply Styles

Chapter 5: Developing a Workbook

• Format Worksheet Tabs
• Reposition Worksheets in a Workbook
• Insert and Delete Worksheets
• Copy and Paste Worksheets
• Copy a Workbook

Chapter 6: Printing Workbook Contents

• Set a Print Title
• Create a Header and a Footer
• Set Page Margins
• Change Page Orientation
• Insert and Remove Page Breaks
• Print a Range