Front Foot Workshops :: Your Learning and Information Platform

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.

MICROSOFT CERTIFICATION

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

DETAILS

Date and Venue:
22nd September 2010 at Benvenuto Conference Centre in Randburg

22nd October 2010 at Benvenuto Conference Centre in Randburg

26th November 2010 at Benvenuto Conference Centre in Randburg

15th December 2010 at Benvenuto Conference Centre in Randburg

Map:
Click Here

Time:
8:30 AM

Duration:
1 Day

Cost Per Delegate:

R2 180.00	ex VAT
R2 485.20	incl VAT

Surcharges:
R50 (Incl VAT) per delegate, per day for Strictly Halaal and Kosher Meals

Group Bookings:
Bookings of 2 or more delegates qualify for a 10% discount.

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

CONTACT US

Register Now

Get More Information

Make a group
booking and get a
10% discount

Contact us or call us on 011 880 4808

See our other workshops

IN HOUSE

This workshop is also available under Front Foot’s in-house menu.
Front Foot is proud to offer you a comprehensive array of customised in-house training solutions that are focused on your unique business needs. For more information in this regard, please contact us.

EXCEL 2003/2007 ADVANCED

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

Discover the full potential of this powerful offering
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: In order to maximise the benefit of this course, delegates are required to already have a good working knowledge of all basic functions available on Excel. Where delegates do not meet this criterion, Front Foot offers comprehensive Excel training in our workshops
Excel - Level One and Excel - Level two Workshop.

REGISTER NOW

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

ONE DAY WORKSHOP OUTLINE

Automating Worksheets

Data Structure and Default Settings

	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

	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

File Collaboration

Auditing Features

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

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

Data Analysis

Working With Multiple Workbooks

	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

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

Data Import With XML

	Import XML Data / Maps
	Export XML Data

OTHER WORKSHOPS YOU MIGHT ENJOY

Other workshops you may enjoy include:

Killer Excel Dashboard Reports 2003 and 2007

Specialised Excel Functions

Visual Basic for Excel 2003 and 2007

Making Head or Tail of Pivot Tables

View all our other workshops

Recommend this workshop on Facebook