MS Excel

Executive Excel is our famous two-day course that builds on the formulae and features learned in the Excel Basic and Intermediate courses. This Excel Advanced course covers some of the most advanced features and functions of Excel. On completion, the delegates will be in the top 10% of Excel users in Southern Africa.

Executive Excel
Executive Excel

Executive Excel – The Facts

On successfully completing the course you will have excellent Excel skills required 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.

Microsoft Excel is one of the world’s most widely used applications for numeric calculations, processing and reporting in both business and private environments. It is unfortunately also one of the most underutilised applications when it comes to processing and reporting capabilities.

Most business executives (middle management and upwards) and their PA’s or secretaries can perform basic calculations and create perhaps a handful of graphs. Excel functions like all the lookup functions, pivot tables and macros just sound too complicated to use, while they are in fact some of the most valuable tools built into this powerful business package.

Due to the lack of knowledge of the powerful functions of Excel, many hours are wasted in trying to find a way to measure, look up, calculate or represent certain info in different ways. This could have been calculated in a matter of seconds if the user knew these functions and formulas, already at their fingertips.

It is not as hard as one might think to go from a basic Microsoft Excel user to a power user, through the College Africa Group’s Excel Advanced one-day Training Course. The course focuses on data analysis and reporting in Excel, which are key aspects of any business.

We train any version of Microsoft and Mac for Office and Office 365.

Contact Arnold + 27 083 778 4903 or email [email protected] for dates in your area.

Who will benefit from this course?

CEO’s and MD’s
Sales Managers
System Analysts
NGO’s
SME Owners
Finance Managers
Lawyers
Business Analysts
Bankers
PA’s of Executives
HR Managers
IT Managers
Government Organisations
Consultants
Secretaries of Executives

What This Course Covers

Subtotal Function
Using the Subtotal Function
Using a Filter to Analyse Subsets
Modifying the Subtotal Function
Relative and Absolute Referencing
Relative Referencing
Absolute Referencing
Mixed Cell Referencing
Range Names
Data Validation
Create a List of Items
Creating a Data validation list
Create Restricted Entries
Create Custom Settings
Protect the List
Formulae
Simple Vlookup
VLOOKUP Approximate
COUNTIF
SUMIF
Left, Right and Mid Formulae
Flash Fill
Concatenate
Text to Columns
Working with Comments
Inserting Comments
Printing Comments
Pivot Tables & Pivot Charts
Creating a Pivot Table
Formatting the Pivot Table
Creating a Pivot Chart
Contents of the Budget Database
Adding more Columns
Drilling Down on a Balance
Breaking Down by Department
Hide detail and show detail

This courses will prepare the delegate for more advanced Excel Courses. The delegate receives a manual and an electronic attendance certificate on completion of the relevant Excel Executive Course.

We almost run on demand as we try to accommodate the client’s work schedule when possible. Contact Arnold + 27 083 778 4903 or email [email protected] for dates in your area?

ON and OFFSITE training are offered. See our Specials for Gauteng & KZN, other areas call Arnold 083 7784903. Offsite includes teas, light lunch, and an electronic attendance certificate. Group discounts apply. ONSITE, YOUR VENUE, a minimum of three delegates attending simultaneously. Prices on request.

View our Excel Video tips on Youtube  

These are great Executive Excel Tips resources

ExcelTips Daily Nuggets

Chandoo

Ablebits

We provide training throughout Southern Africa and have offices in all the major cities.

Johannesburg, Pretoria, Sandton, Midrand, Centurion, Roodepoort, Edenvale, Durban, Umhlanga, Cape Town. "Other Areas on Request"

You May Also Like

MS Excel

Excel

MS Excel software package has different levels which cover many courses.
MS Excel

Excel Guru

Excel Guru software package has different levels which cover many courses.
MS Excel

MS Office

MS Office software package has different levels which cover many courses.
MS Excel

Soft Skills

Soft Skills software package has different levels which cover many courses.
Skip to content