Microsoft Excel - Intermediate

Course details

The Aim of our Microsoft Excel Intermediate course is to build on the knowledge gained at the Introduction level, thereby giving the learners the skills to create & manipulate more complex worksheets.

Who Should Attend?

• This course would be for those people who having completed the Introductory Course (or already have that level of competence) wish to enhance their spreadsheet skills.

Course Objectives:

• Using spread sheets, be able to input complex data, formulas, templates charts & tables, and to manipulate the information.

Course Programme:

• Worksheet management - comparing, moving & copying
• Conditional Formatting
• Linking excel data between sheets
• Paste Specials
• Freezing/Hiding Rows & Columns
• Absolute Cell Referencing
• Naming Cells
• Working with Formulas & Ranges
• Sorting Data
• Creating Charts & Tables
• Templates
• Trace Errors
• Show Formula
• Format Painter
• Insert Comments
• Help Function - allows learner to print pages from electronic manual

Training Methods:

• Classroom based, using Microsoft programmes & interactive discussion.
• There will also be course hand-outs & exercises to do at home.

Additional Information:

• Maximum of 9 participants.
• National Training Solutions Certificate will be given to all participants who complete the course.
• ECDL Certification available.
• Price on application. We can also offer group discounts.