Providing your organisation
with Quality Training and
Business Support

MS Excel 2007 Level 3 - Advanced Users

Who should attend?

Those existing users of Excel 2007 who wish to develop their skills and who have mastered the skills covered by the Introduction and Intermediate courses.

Why should you attend?

Delegates 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.

Course Outline

After this course delegates will be able to:

• 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
• Record and write VBA macros to automate tasks
• Design complex user interfaces
• Enable and secure worksheets and cells from other users
• Use data maps to add graphical & statistical information across countries and continents
• Create Pivot tables and Pivot Charts
• 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

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

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

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

12th 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... 12th June 2012 - 11th September 2012 - 4th December 2012 - 12th 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