Providing your organisation
with Quality Training and
Business Support

MS Excel 2010 Level 2 - Intermediate

Who should attend?

Those who wish to develop their skills of Excel 2010 and who are proficient in the basic use of the application but now need to learn the product beyond the basic skills.

Why should you attend?

Excel is a very popular spreadsheet application. Designed by Microsoft as part of the Office 2010 Suite, Excel is a desktop productivity tool that is designed to be useful in a wide range of applications. It can perform repetitive, complex calculations and adjust them automatically when parameters change. It can also manage large amounts of data - a database - and perfom analysis on it. This course builds on our Level 1 course for Beginners, starting to create more complex spreadsheets and tools.

Course Outline

Trainees must be familiar with Windows, able to use a PC confidently and should have attended our Level 1 Beginners course, or be conversant with its contents.

• Find Excel's built in functions and understand how to use the wizards to get them right first time
• Create complex formulae, using multiple calculations in a single cell
• Get Excel to make decisions based on business logic
• Customize and configure charts for data analysis
• Create tables to store large amounts of data
• Sort data for ease of use
• Filter data to find specific information
• Subtotal and analyse filtered data
• Get Excel to highlight specific information with conditional formatting
• Manipulate dates and text as well as numbers

Presenter

Orchard Professional

Availability

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

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

14th February 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... 19th June 2012 - 16th August 2012 - 14th February 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