Click here to send this to a colleague or friend.

Excel Level 3

Microsoft Office version 2010, 2013 and 2016

Master Microsoft 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 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.

shadow

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.

SAQA US ID 61591
End user computing
N
QF Level 3, credits 13

Our Microsoft workshop presenters are Microsoft Certified Trainers and Microsoft Certified Technology Specialists.



FRONT FOOT IS AN EME
- 100% RECOGNITION

shadow
Discount:

10% discount for two or more delegates

10% discount if you attend two or more workshops

15% discount for four or more delegates


In-house at your offices
25%
discount for 5 or more delegates

30% discount for 8 or more delegates

35% discount for 10 or more delegates

We provide laptops for in-house computer-based training sessions

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
shadow

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
shadow shadow

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.

shadow
shadow
Front Foot courses are compiled and presented by subject matter experts
and industry specialists to ensure the highest and most current standard of excellence in all our workshops and training
Event Information:
Date: 6th July 2017 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

13th July 2017 at Benvenuto Conference Centre in Randburg

3rd August 2017 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

10th August 2017 at Benvenuto Conference Centre in Randburg

7th September 2017 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

14th September 2017 at Benvenuto Conference Centre in Randburg

5th October 2017 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

12th October 2017 at Benvenuto Conference Centre in Randburg

3rd November 2017 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

9th November 2017 at Benvenuto Conference Centre in Randburg

7th December 2017 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

14th December 2017 at Benvenuto Conference Centre in Randburg

Map: View map
Duration: 1 Day
Cost: R2 350.00 excl VAT
R2 679.00 incl VAT
Surcharge: Strict Halaal and Kosher meals carry an additional surcharge

Upcoming Events:
Visit our events calendar for more information.

Upcoming Workshops:
Visit our workshops calendar for more information.
shadow

shadow

Bookings:

Contact Adele on
011 867 7299 or email

Bookings and Enquiries
Website | Email

Screenshot: http://www.frontfoot.co.za
shadow
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