Microsoft Excel for users of 2007 / Vista - Spreadsheet Construction - Basic
Course Code:DPZ112
Course Type:Short-course
Qualification: There is no associated qualification; however delegates receive a Central Sussex College Attendance certificate on completion.
Duration: 1 Day (7 Hours)
Date/Venue/Cost:
04 August 2010, Crawley Campus, £130.00
15 September 2010, Crawley Campus, £130.00
15 October 2010, Crawley Campus, £130.00
Suitable For: This course is ideal for users of Excel 2007 who wish to learn how to create and maintain their own spreadsheets.
Entry By: Direct Entry
Entry Requirements:
General Computer Experience.
Course Content:
This course provides learners with the necessary knowledge to create spreadsheets using formulae. Topics covered include:
- Saving and Retrieving
- Changing the Column Widths
- Adding
- Subtraction
- Division
- Multiplication
- Totalling Columns and Rows
- Functions
- Comments
- Copying Formulas
- Absolute Cell References
- Hiding Columns and Rows
- Inserting and Deleting Rows
- Moving and Copying
- Formatting Cells
- Currency Format
- Borders and Shading
- Autofill
- Freezing and Splitting
- Sorting
