Excel Level 2

Click here to send this to a colleague or friend.

Excel Level 2

Master Microsoft Excel 2007 & 2010 at the intermediate level

This one-day workshop offers delegates a transitional walkthrough of the Excel tools. The training course applies the basic toolkit taught in Excel Level One. All topics are comprehensively covered and clearly presented, using a guided, step-by-step training methodology.

Advanced Excel Functions Are Now Simple

Grow your current knowledge of Excel exponentially on this easy-to-follow training course. Empower yourself to utilise the full potential of one of Microsoft's most powerful Office Suite offerings.

Please note: This course follows the beginner's Excel Level One workshop. Delegates will benefit from this course if they have mastered Excel Level One, or are an intermediary level already. An advanced level course – Excel Level Three – is also available.

Accreditation:

Front Foot Strategic Consulting has been awarded accreditation status as a provider of Education and Training in terms of the South African Qualification Authority Act.

All Front Foot Microsoft workshop presenters are Certified Master Microsoft Application Specialists.

Register now for this workshop

WHAT WILL BE COVERED ON THIS ONE-DAY WORKSHOP?

Templates

Opening a Template
Creating a Template
Modifying a Template

Functions

The IF Function
How the IF Function works
Lookup Functions
How the VLOOKUP Function Works
The HLOOKUP Function
PMT & FV
Date & Time Functions
DSUM Function
Linking Cells

Comments and Web Features

Comments
Using Hyperlinks
Publish a worksheet to the Web

Working with Data

Sorting Data
Multiple Level Sorts
Filtering Data
Subtotals

Creating and Modifying Charts

Insert a Chart
Modify Charts
Printing Charts

Working with Graphic Objects

Adding a Shape
Resizing an AutoShape
Modifying an AutoShape
Change the Order of Objects
Grouping Objects

Named Range

Creating a Named Range
Removing a Name form a cell
Using Named Ranges in a calculation

Import and Export Data

Exporting Data from Excel
Importing Data from Excel

Who should attend?

Any decision maker who would like to get the most out of their software
Financial managers, bookkeepers, analysts and researchers
Secretaries and personal assistants

Training approach

Our courses use interactive tools that allow learners to learn by doing.

The experience for learners is fun, rewarding, lasting and integrative, whilst employers are assured of a high return on investment in training.

Event Information:
Date:	10th February 2012 at Benvenuto Conference Centre in Randburg 12th March 2012 at Benvenuto Conference Centre in Randburg 10th April 2012 at Benvenuto Conference Centre in Randburg 15th May 2012 at Benvenuto Conference Centre in Randburg 12th June 2012 at Benvenuto Conference Centre in Randburg
Time:	08:30 AM
Venue:	Benvenuto Conference Centre in Randburg
Map:	View map
Duration:	1 Day
Cost:	R2 350.00 excl VAT R2 679.00 incl VAT
Surcharge:	R50 (incl VAT) per delegate, per day for Strict Halaal and Kosher Meals
Upcoming Events: Visit our events calendar for more information. Upcoming Workshops: Visit our workshops calendar for more information.

Discount:

Group Bookings:
Group Bookings of 2 or more delegates from the same company qualify for a 10% discount

Out-of-town Delegates:
If you attending from out-of-town, we will give you a 15% discount on the cost of the workshop.
Contact us to find out more

Bookings:

Contact Adele on
011 880 4808 or email for
Bookings and Enquiries
Website | Email

Microsoft workshop presenters are Certified Microsoft Office Specialists; We offer on-going email support after attending any Microsoft workshop for an unlimited period of time; Workbooks and workshops are aligned to the prevailing Unit Standard; Front Foot provide business training to business people; Training is held at premium training venues.

Confidentiality Note: This message is for the sole use of the intended recipient(s) and may contain confidential and legally privileged information. Any unauthorised review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by replying and destroy all copies of the original message.