Excel

This comprehensive Executive Excel Advanced 2013 Course builds on the grounding which was learnt in the Excel Essentials and Intermediate 2013 courses. The Executive Excel Advanced 2013 course covers some of the most advanced features and functions of Excel 2013. On completion the delegates will be in the top 10% of Excel users in Southern Africa. The table of contents is below.

This is an intense two day course, 09h00 to 15h30, which will provide the delegate with sufficient 2013 Executive Excel Advanced skills to create sophisticated analytical spreadsheets, budgets and master intricate advanced formulae that are required in the workplace. This course is a must for Executives or those who are ambitious.

This course will prepare the delegate for even more advanced Excel 2013 courses. The delegate receives an Executive Excel Advanced 2013 manual and an electronic attendance certificate on completion of the Executive Excel Advanced 2013 Course.

We almost run on demand as we try to accommodate the client's work schedule when possible. Contact Arnold 083 778 4903 or email This email address is being protected from spambots. You need JavaScript enabled to view it. for dates in your area?

ENQUIRY FORMSpecials

 
 
 
YOUR VENUE, Group special R 30000 ex vat for up to 20 delegates. Includes travel, manuals and an electronic attendance certificate.T &C's apply. Do you have less employees who need to attend? Call Arnold now 0837784903!
 

 

Topic-Level Outline
  • Subtotal function
  • Relative and absolute referencing
  • Mixed cell referencing
  • Range names
  • Data validation
  • Vlookup
  • Pivot tables
  • Pivot table Charts
  • Using the goal seek
  • The scenario manager
  • Sparklines
  • PV formula
  • Advanced filtering
  • Hyperlinking
  • Working with Comments
  • Conditional formatting
  • Working with group sheets
  • Creating 3-d formulas
  • Writing a simple macro
 
 
 

ENQUIRY FORM

 

Contact Arnold 083 778 4903 or email This email address is being protected from spambots. You need JavaScript enabled to view it.

About college africa group

We, at College Africa Group offer training courses
which meet your needs and fit within your budget.

As a MICT Seta National Accredited Microsoft
Computer Training provider, College Africa Group
is the preferred choice for all computer related
training needs.

Contact Info

Mobile: Arnold Muscat + 27 (0)83 778 4903

Call Centre: +27 (0)11 881 5998

Email: sales@collegeafricagroup.com

Head Office:

Physical Address :2nd Floor, West Tower Maude

Street Nelson Mandela Square Sandton

South Africa 2196