Part of our range of Microsoft excel 2003 Training Courses in Manchester.

|
Course Overview For Microsoft Excel 2003 Training Courses - (Introduction)This Microsoft Excel Training Course is designed for the new or inexperienced user who has a need to use the Microsoft Excel 2003 on a regular basis, but who has had no formal or structured training and is likely to be self taught.
Delegates attending the Microsoft Excel Training Course will be able to create professional looking Spreadsheets, edit them, modify the formatting and use the various tools and shortcuts available within Microsoft Excel 2003 to do so in an efficient and timely manner. |
|
| |
Course Content Of Microsoft Excel 2003 Training Courses - (Introduction)
A typical course will cover the following:-
Microsoft Excel 2003 Orientation
- The Microsoft Excel 2003 Window
- Using Menus And Toolbars
- Getting Help
- Move Around The Workbook
- Exiting Excel 2003
Creating A Basic Microsoft Excel 2003 Workbook
- Create A New Workbook
- Enter Data In A Workbook
- Save A Workbook
- Open A Saved Workbook
- Create An Input Range
- Enter Dates
- Create A Simple Formula
- Editing Data
- Use Autofill
- Close A Workbook
Selecting Data in Microsoft Excel
- Select Contiguous Ranges
- Select Non-Contiguous Ranges
- Select Larger Ranges
- The Auto-Calculate Button
Adjusting An Excel 20003 Worksheet
- Insert And Delete Cells
- Insert Columns And Rows
- Delete Rows And Columns
- Resize Columns And Rows
- Hide And Show Grid Lines
Printing From Microsoft Excel
- Print Preview And Print Options
- Create Page Headers And Footers
- Print Formulas
|
Creating a Formula in MS Excel
- Understand Formulae
- Create A Formula That Adds
- Create A Formula That Subtracts
- Create A Formula That Multiplies
- Create A Formula That Divides
Working With Functions in Excel 2003
- Use The Sum Function
- Sum Non-Contiguous Ranges
- Calculate An Average
- The Maximum Function
- The Minimum Function
- The Count Function
Formatting Excel
- Apply Bold
- Italics
- Underline
- Change Cell Colours
- Copy Formats From One Cell To Another
- Align Cells And Ranges
- Centre A Heading Over A Range
- Change Cell Content Orientation
- Add Borders To Cells And Ranges
Move And Copy Data in Excel 2003
- Copy And Move Data From One Cell To Another
- Copy From One Cell To Multiple Cells
|
Download As A PDF
To find out more about how Copernicus Training can help your business, please call us on 0870 - 879 - 5327 or e-mail us at info@copernicus-training.com
|