Excel Intermediate 2007 Training Course
Excel Intermediate 2007 training course brief
Do you currently use Excel but
would like to enhance your skills? Would you like to know how to
produce charts to show how well your department is performing? This
Excel Intermediate 2007 course will enhance your knowledge of
formulas and help you to create charts which can be incorporated
into a word document.
Target audience
The Excel Intermediate 2007 training
course is relevant to anyone who wants to improve their basic
Excel formula, formatting, and navigation skills.
Pre requisites
Experience of Excel is required to ensure
delegates have knowledge of the topics covered in the introductory
course.
Objectives
By the end of this course
you will be able to use Excel to perform basic calculations using
formula’s and functions, create and organise spreadsheets and
produce charts.
Excel Intermediate 2007 training course content
|
Working with sheets and tabs
- Moving and
copying sheets
- Working
with multiple sheets
- Moving
and copying sheets – different workbook
|
Sorting and
filtering
- Benefits
- Sorting
alphabetically
|
Formulas & functions
- More calculations
- Formulas to link sheets
- Using functions
|
Creating charts
- What charts to use
- How to create charts
|
Relative and absolute cell references
- Relative values
- Absolute values
- Making a
cell absolute
|
Copying/linking between
different applications
- Linking charts to word
documents
|
Excel Intermediate 2007 training course dates
IT training courses are run throughout the year. If you are
interested in registering for any of our IT training courses please
contact our training department on training@hughjames.com for more
information.
Training location
The training will take place
at our city centre training facility in Cardiff, South Wales.
It is also possible to arrange to conduct training courses
at your office or at any suitable location in England or
Wales. Please contact us for more information or to enquire
about other training locations.
Excel Intermediate 2007 training course fees
£90 per delegate
Download course outline (PDF)