Microsoft Office Specialist: Excel Expert 2007/2010

PrerequisitesNewSpecial£

Having studied Microsoft Office Excel you should be able to navigate the software at the feature and functionality level. You will be familiar with and know how to use at least 80% of the features and capabilities of Microsoft Office Excel. You will be able to use Microsoft Office Excel 2010 to create and edit professional-looking spreadsheets for a variety of purposes and situations. When you pass Exam 77-881 or 77-888 you complete the requirements for the certification Microsoft Office Specialist at either Core or Expert Level.

There is a £150 fee for this course which includes a set book, a practice exam, an exam, a re-take and your certificate. If you are interested in taking the course please register your interest, indicating if you prefer Excel 2007 or 2010 in the special requirements section. Please also let us know if you are intending to work towards the Core or Expert level exam, if you are not sure which is best for you then give the Training Team a ring to chat it through: 01223 334662.

All University and College staff and students

Basic familiarity with Excel

Number of sessions: 7

For Core

• Managing the Worksheet Environment
• Applying formulas and functions
• Presenting data visually
• Sharing worksheet data with other users
• Analyzing and Organizing Data

For Expert

• Sharing and Maintaining Documents
• Formatting Content
• Tracking and Referencing Documents
• Performing Mail Merge Operations
• Managing Macros and Forms

• Formatting Cells and Worksheets
• Managing Worksheets and Workbooks
• Sharing worksheet data with other users
• Analysing and Organising Data

Presentation and demonstrations with practical exercises from the set book. You may need to work around 3 hours per week between each class depending on your current skill level.

If your institution is funding your place please raise a PO for £150 then either email (training@ucs.cam.ac.uk), fax (01223 334679) or post it to: UCS Training Services New Museums Site Pembroke Street Cambridge CB2 3QH

If you are self funding please telephone us with your credit card details: 01223 334662.

6 half day sessions and the exam

Once a year

• IT Certification Courses
• Techlinks & IT Support Staff