Microsoft Excel - Essentials (Spreadsheet Construction) - for users of 2007 / 2010
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:
12 June 2012, Horsham Training Centre, £130.00
10 July 2012, Horsham Training Centre, £130.00
07 August 2012, Horsham Training Centre, £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
