Ms Office Excel Advanced 2013 Training Course

Introduction: Ms Office Excel Advanced 2013 training Course

Microsoft Office Excel Advanced 2013 follows Microsoft Office Excel Intermediate 2013. Here the more advanced and complex abilities of Excel will be taught with an emphasis on task automation. Here one will utilsie more advanced analysis methods on bigger data sets. In addition the student will be taught how to work on the same worksheets with others.

Sharing Excel data with other applications will also be taught.

 

Ms Office Excel Advanced 2013 Training Course

 

Outline: Ms Office Excel Advanced 2013 Training Course

Johannesburg (Sandton), Cape Town, Durban, Port Elizabeth, Pretoria – South Africa

Key outcomes of the course include:
Module 1: Advanced Formulas and Functions ( Logical, Text , time Conditional, Financial
Functions, Array formulas)

Module 2: Data Tables and Lookups

Module 3: Data Management – advanced ( Validations, filtering)

Module 4: Charting – advanced

Module 5: PivotCharts and PivotTables

Module 6: Importing and exporting

Module 7: Analytical Tools, Scenarios, Goal Seek

 

 

Course duration and fees: Ms Office Excel Advanced 2013 Training Course

Our two day training course is designed so that the knowledge acquired is applied practically, so that the business environment can be enhanced.

Please consult schedule for course costs or contact BOTI for a quote.

 

Recommended Prior Experience and Knowledge: Ms Office Excel Advanced 2013 Training Course

The course (Ms Office Excel Advanced 2013 Training Course) is designed for the following attendees: All
For the Ms Office Excel Advanced 2013 Training Course it is advisable that you have the following experience/knowledge:
Intermediate or equivalent experience on Excel 2013

Advanced Excel Quiz

Free test of your Advanced Excel knowledge- click below:

Course Schedule Saturday

Course Schedule Weekdays

Book Now!
View Calendar for the latest course

<