Microsoft Excel Advanced

Microsoft Excel 97 to 2010

This is a one day course aimed at the experienced user of Microsoft Excel. The course will concentrate on increasing the users knowledge of Excel and its application in the workplace. User friendly course material and the assistance of an experienced trainer will allow delegates to develop their knowledge at their own pace.

User friendly course material and the assistance of an experienced trainer will allow delegates to develop their skills and knowledge at their own pace.

With the emphasis on a hands-on approach to learning, delegates may bring along work on the day to learn how to achieve the desired results giving real immediate benefits.

Delegates complete a pre-course checklist to identify areas where they may have prior experience and to identify personal objectives for attending the course.

The advanced course covers the items listed below which we can modify to allow individuals to achieve their personal objectives.

Course Content:

• Use pivot tables
• Use H & VLook Up
• Create scenarios
• Consolidate data
• Create custom views
• Import and Export data
• Insert clip art and pictures into spreadsheets
• Create shared workbooks
• Create and run macros

By the end of the course delegates will have:

Developed their knowledge of Excel that will allow them to create complex spreadsheets for analysing data at operational and strategic level.

Duration:

1 day course; contact us for available dates.

Cost:

£175 per delegate, this includes all course materials, refreshments and attendance certificate.