Excel Level 3

Click here to send this to a colleague or friend.

Excel Level 3

Master Microsoft Excel 2007 & 2010 at the advanced level

Our Excel Level Three workshop aims to take you on to the next level of Excel functionality with an intensive one-day course offering. This is your opportunity to learn how to make the most of everything Excel has to offer - everyday.

Advanced Excel Functions Are Now Simple

Covering advanced functionality such as the consolidation of workbooks, automating worksheets, file collaboration, auditing features and more, this course allows you to confidently and efficiently maximise your use - and the full potential - of Microsoft Excel.

Please note: This course follows the beginner's and intermediate Excel Level One and Level Two workshops. Delegates will benefit from this course if they have mastered Excel Level One, or are at an intermediary level already.

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?

Automating Worksheets

Create a Macro
Edit a Macro
Create a Macro Button
Assign a Macro to the Quick Access Toolbar
Adjust Macro Settings
Create and Apply Digital Signatures

File Collaboration

Apply File Protection
Protect a Worksheet
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Workbooks

Data Analysis

Apply a Trend line to a Chart
Create Scenarios
Perform What-If Analysis with Goal Seek
Perform What-If Analysis with Solver
Create a PivotTable© Report
Create a PivotChart© Report
Perform Statistical Analysis with the Analysis ToolPak

Data Import With XML

Import XML Data/Maps
Export XML Data

Data Structure and Default Settings

Apply Conditional Formatting
Add Data Validation Criteria
Locate Invalid Data and Formulas
Group and Outline Data
Update a Workbook's Properties
Modify Excel's Default Settings

Auditing Features

Trace Cell Precedents
Trace Cell Dependents
Locate Errors in Formulas
Add a Watch and Evaluate Formulas

Working with Multiple Workbooks

Create a Workspace
Consolidate Data
Link Different Workbooks
Edit Links between Workbooks

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:	16th February 2012 at Benvenuto Conference Centre in Randburg 17th February 2012 at Benvenuto Conference Centre in Randburg 23rd March 2012 at Benvenuto Conference Centre in Randburg 20th April 2012 at Benvenuto Conference Centre in Randburg 24th May 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.