Excel 2010 Expert


Event Details

This event is running from 13 March 2017 until 11 June 2018. It is next occurring on May 8, 2017 8:30 am

  • Venue: Johannesburg (Sandton), Pretoria, Durban, Cape Town
  • Categories:
  • Upcoming Dates:

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:

0
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
 

Course Schedule Saturday

Course Schedule Weekdays

Book Now!
View Calendar for the latest course

Competitive Course Pricing: (PC) – one-day and non-specialized

BOTI’s pricing estimates are based on economies of scale i.e. the more delegates you send, the lower the price per delegate! Clients have the following options:

  • provide the training venue or request BOTI to provide the training venue; and/or
  • in the case of courses requiring laptops, provide the laptops for the course or alternatively request BOTI to provide the laptops.

The course costs under various scenarios are provided below.

Prices per delegate (including Vat)

Number of Delegates Course only Course plus  venue provided by BOTI Course plus laptop provided by BOTI (venue provided by client) Course plus laptop plus venue provided by BOTI
1 R 4,617 R 5,301 R 4,788 R 5,472
2 R 2,793 R 3,306 R 2,964 R 3,477
3 R 2,679 R 3,135 R 2,850 R 3,306
4 R 2,480 R 2,907 R 2,651 R 3,078
5 R 2,360 R 2,770 R 2,531 R 2,941
6 R 2,090 R 2,489 R 2,261 R 2,660
7 R 2,060 R 2,451 R 2,231 R 2,622
8 R 1,895 R 2,280 R 2,066 R 2,451
9 R 1,767 R 2,147 R 1,938 R 2,318
10 R 1,767 R 2,147 R 1,938 R 2,318
11 R 1,529 R 1,902 R 1,700 R 2,073
12 R 1,529 R 1,902 R 1,700 R 2,073
13 R 1,320 R 1,688 R 1,491 R 1,859
14 R 1,320 R 1,688 R 1,491 R 1,859
15 R 1,167 R 1,531 R 1,338 R 1,702

Total course price (including VAT)

Number of Delegates Course only Course plus  venue provided by BOTI Course plus laptop provided by BOTI (venue provided by client) Course plus laptop plus venue provided by BOTI
1 R 4,617 R 5,301 R 4,788 R 5,472
2 R 5,586 R 6,612 R 5,928 R 6,954
3 R 8,037 R 9,405 R 8,550 R 9,918
4 R 9,920 R 11,628 R 10,604 R 12,312
5 R 11,800 R 13,850 R 12,655 R 14,705
6 R 12,540 R 14,934 R 13,566 R 15,960
7 R 14,420 R 17,157 R 15,617 R 18,354
8 R 15,160 R 18,240 R 16,528 R 19,608
9 R 15,903 R 19,323 R 17,442 R 20,862
10 R 17,670 R 21,470 R 19,380 R 23,180
11 R 16,819 R 20,922 R 18,700 R 22,803
12 R 18,348 R 22,824 R 20,400 R 24,876
13 R 17,160 R 21,944 R 19,383 R 24,167
14 R 18,480 R 23,632 R 20,874 R 26,026
15 R 17,505 R 22,965 R 20,070 R 25,530

The prices above are indicative and subject to change from time to time. Please contact us for a detailed proposal.

<