Microsoft Excel Intermediate
Vocational qualification
In Southampton
Description
-
Type
Vocational qualification
-
Location
Southampton
-
Class hours
8h
This course aims to develop participants' skills in spreadsheet techniques and terminology.
Facilities
Location
Start date
Start date
About this course
Delegates should have knowledge of Windows 2000, XP or 2003 and be able to use a keyboard and mouse.
Reviews
Course programme
Microsoft Excel Intermediate
About the course:
This course aims to develop participants' skills in spreadsheet techniques and terminology.
By the end of the course, delegates will be able to customize workbooks, use list; incorporate functions to determine IF, OR, FV, PMT, and NOW, format worksheets, work with objects, templates, the Web and use 3-D references.
Course Content:
Customising Workbooks
- Rename Worksheets
- Change Worksheet Tab Colours
- Select and Move Sets of Worksheets
- Copy, Insert, Delete Hide and Unhide Worksheets
- Rename Folders while Saving
Using Lists
- Learn About Database Features
- Find and Replace Cell Contents
- Freeze and Unfreeze, hide and unhide rows and columns
- Sort Lists
- Understand Filters
Working With Functions
- Understand Inserting Functions
- Use the IF, OR, FV, PMT and NOW functions
Formatting Worksheets
- Understanding autoFormatting
- Define, Apply and Remove Styles
- Indent and Rotate Text
- Page Breaks
- Find and Replace Cell Formats
Working With Objects
- Understand Inserting Objects
- Insert, Move, Delete, Create and Modify Graphics
- Add, Edit and Remove Comments
Using 3-D References
- Understand 3-D References
- Link Worksheets Using 3-D References
- Split and Arrange Workbooks
- Link Workbooks Using 3-D References
Using Excel with the Web
- Look at Online Information and The Web
- Understand, Create and Edit Hyperlinks
- Save Worksheets and Workbooks as Web Pages
- Examine the Research tool
Using Templates
- Explore Templates
- Create Workbooks Based on Templates
- Create New Templates
Equipment Requirements:
All equipment will be supplied by City Business.
Assessment:
Due to the workshop nature of this one day course, there are no formal examinations or assessments.
Progression:
Delegates may wish to extend their knowledge by attending an Excel Advanced course after successfully completing the Intermediate level.
Code : Time : Duration : Day : Tuition Fee : Admin Fee
B02151 003 09:30 - 16:30 14/10/2009 - 14/10/2009 Wednesday Fee Enquiry
B02151 010 09:30 - 16:30 29/04/2010 - 29/04/2010 Thursday Fee Enquiry
Microsoft Excel Intermediate