Providing your organisation
with Quality Training and
Business Support

MS Excel 2010 Level 3 - Advanced Users

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.

Why should you attend?

Building on the regular user's skills, this course will demonstrate use of macros, merging of data with existing databases, complex questioning styles and data mapping. Designed for the high level user who wants to design custom interfaces and act as an administrator for other colleagues, this course will release the enormous potential of Excel.

Course Outline

Trainees should be competent at the Windows interface with the concept of files and folders. Attendees should be comfortable with data entry into Excel, multiple sheets and OLE features. This 1 day course is intense, and competent use of Excel is assumed to give the class maximum benefit.

• 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

Presenter

Orchard Professional

Availability

21st June 2012 (9:30 AM - 4:30 PM) @ Twigworth Court Business Centre

19th September 2012 (9:30 AM - 4:30 PM) @ Twigworth Court Business Centre

7th March 2013 (9:30 AM - 4:30 PM) @ Twigworth Court Business Centre

Cost

Course: £160.00 +VAT

Contact

0845 8389964
training@glosenterprise.co.uk

Booking

Online booking form for emailing or printing

Start Booking

If you are booking on behalf of someone else please complete all sections in this box:

Personal Details

Your Title Please select... Mr. Miss. Mrs. Ms. Your name Your email address Your telephone number Delegate Title Please select... Mr. Miss. Mrs. Ms. Delegate name Delegate email address Delegate telephone number Special dietary requirements Accessibility requirements Company name Company postcode

Next

Course details

Course Date Please select... 21st June 2012 - 19th September 2012 - 7th March 2013 - Method of Payment: Invoice Credit Card: Cheque: Arranged:

Back | Next

If you have not used our services previously, please supply us with the following information.

Your company details

Company name Status Please select... Sole Trader Partnership Limited Public Limited Company Address 1 Address 2 Town/City County Postcode Invoice Address 1 Invoice Address 2 Invoice Town/City Invoice County Invoice Postcode Nature of your business Number of employees Contact preference Email Telephone Mailing Please select... Bi Monthly Newsletter Email Newsletter Both How did you hear about us? Please select... Referral from Colleague/Company Advertising Literature Email Search Engine Other

Back | Next

 

 

Back