MAC Microsoft Executive Excel Advanced 2011 Two Day Course

Excel for mac

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

This is an intense two day course, 09h00 to 15h30, which will provide the delegate with sufficient MAC 2011 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 more advanced Excel MAC 2011 courses. The delegate receives an Executive Excel Advanced 2011 MAC manual and an electronic attendance certificate on completion of the Executive Excel Advanced 2011 MAC Course. Prices from R 1495 ex vat, T&C's apply.

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 FORM

 

 

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
 

Download the table of contents (TOC)

Download TOCENQUIRY FORM

 

This courses will prepare the delegate for more advanced Mac Excel Courses. The delegate receives a Mac Excel manual and an electronic attendance certificate on completion of the relevant Executive Excel Advanced 2011 MAC 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?

ON and OFFSITE training are offered. See our Specials for Gauteng & KZN, other areas call Arnold 083 7784903. OFFSITE, OUR VENUE, prices from R 5395 ex vat. Includes teas, light lunch, and an electronic attendance certificate. Group discounts apply. ONSITE, YOUR VENUE, minimum of three delegates attending simultaneously. Prices on request.

ENQUIRY FORM

 

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

 

Subscribe to our free tips newsletter

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