Microsoft Excel 2002 Training Course Beginners

This course will give you the skills to create, edit, format, and print basic worksheets and charts in Excel.

Getting Started
- Identify What You Can Do with Excel
- Enter Data in a Worksheet
- Edit Data
- Change the Appearance of Data
- Save a Workbook
- Obtain Help
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
- Specify Number Formats
- Create a Custom Number Format
- Change Font Size and Type
- Apply Styles
- Add Borders and Color to Cells
- Find and Replace Formats
- Change Column Width and Row Height
- Align Cell Contents
- Merge and Center Cells
- Apply an AutoFormat
Working with Multiple Worksheets
- Format Worksheet Tabs
- Reposition Worksheets in a Workbook
- Copy Worksheets
- Change the Number of Worksheets
Creating and Modifying Charts
- Create a Chart
- Modify Chart Items
- Format a Chart
- Change the Chart Type
Setting Page Display and Printing Options
- Freeze Rows and Columns
- Set Print Title
- Set Page Margins
- Create a Header and Footer
- Change Page Orientation
- Insert and Remove Page Breaks
- Print a Range

Course Duration: 1 Day

Cambridge | Birmingham | Milton Keynes | Norwich | Peterborough Luton | Ipswich | Brentwood | Northampton | Leicester