Excel intermediate

Introduction:

The programme is designed to increase users'' knowledge of some of the more advanced features of the Excel product
Objective:

To build on the fundamental skills, to be able to understand and use Excel''s sophisticated functions

Programme Synopsis:

Create and format worksheets
Use absolute, missed and further references
Carry out number formatting
Change styles
Freeze frames and control view
Generate charts, non-adjacent data, picture charts, multiple charts
Provide analysis, forecasts and trends
Use scenarios
Solve reports using the solver option
Understand the basic functions of macros
Use forms
Link and consolidate
Handle data
Employ workbook management
Customise Excel
Duration:One (1) Day
Course Code:TSCEXCELINT
Certification:Training Solutions 2000
Last Updated ( Wednesday, 09 July 2008 )