Click here to send this to a colleague or friend.

Excel Level 2


Microsoft Office version 2010, 2013 and 2016

Master Microsoft Excel at the intermediate level

This one-day workshop offers delegates a transitional walkthrough of the Excel tools. 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.

Go further with Excel by learning to create charts and tables as well as learning time saving formatting and validation features.

In this course, you will create charts and tables;

Learn handy formatting and tools for error checking;

Create formulas to that use built-in functions to do advanced analysis;

Create shared workbooks and track changes in shared workbooks

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
NQF Level 3, credits 13


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


Certiport MOS - Microsoft® Office Specialist

Front Foot manage registration, purchase of exam and facilitate testing

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?

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
shadow

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
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
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: 2nd November 2017 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

8th November 2017 at Benvenuto Conference Centre in Randburg

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

13th 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

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