Microsoft Excel Intermediate

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