Providing your organisation
with Quality Training and
Business Support

MS Excel 2003 Level 3 - Advanced Users (In-House Only)

Who should attend?

This one-day course is fairly intense and competent use of Excel is assumed, particularly working with multiple sheets. You should also be competent in using Windows, files and folders

Why should you attend?

Getting the best out of ones PC often requires us to go to levels that many textbooks and self learning can't reach. This course builds on and extends normal user skills and begins to demonstrate the use of macros, merging data with existing spreadsheets, complex questioning styles and data mapping. In short, this course will help you to release the enormous potential of MS Excel.

Course Outline

This subject is only delivered as an In-House Course - at your premises or ours

The cost for up to 6 people is £825 + VAT
The cost for up to 12 people is £1148 + VAT

The workshop will guide delegates through the following modules:

• Utilise and create custom templates and styles
• Import data from external sources to save time and automate routines
• Fully customise the desktop to display preferred toolbars and pull down menus
• Use auditing for financial approval and formulae checking
• Design Complex user interfaces
• Enable and secure worksheets and cells from other users
• Use consolidation on data rows and columns
• Design complex queries to select specific data
• Use outlining techniques to summarise tabular information
• Use cell value validation to verify contents and cells
• Macros
• Pivot Tables
• Protection of workbooks and cells

Presenter

Orchard Professional

Availability

Cost

Course: £825.00 +VAT

Contact

0845 8389964
training@glosenterprise.co.uk