MS Excel 2010 Level 3 - Advanced Users

Date & Time

20 August 2013 | 09:30 - 16:30

21 February 2014 | 09:30 - 16:30

Venue

Leigh Court

Cost

£168 + VAT

Members of the Chamber of Commerce save 10%, join today! 

Course Benefits:

• Demonstrate use of macros
• Merge data with existing databases
• Learn complex questioning styles
• Learn data mapping
• Ultimately, explore the enormous potential of Excel

Course Outline

• Utilise and create custom templates and styles
• Import data from external sources to save time and automate routines
• Fully customise the Quick Access Toolbar, Ribbons and Tabs
• Record and write VBA macros to automate tasks
• Design complex user interfaces
• Enable and secure worksheets and cells from other users
• Reference data in other workbooks using Lookups
• Create Pivot tables and Pivot Charts
• Use Scenarios
• Use goal seek
• Use consolidation on data rows and columns
• Design complex queries to select specific data
• Use auditing tools to trace routes of calculations

Who should attend?

This course is aimed at those who are competent using Excel and who wish to develop their skills beyond our intermediate course.

Book

Call 0845 8389 964. Alternatively, use the booking form below.