MS Excel Advanced

MS Excel Advanced

MS Excel Advanced is part of Our Famous Excel Advanced TWO-DAY Course builds on the formulae and features learned in the Excel Essentials and Intermediate courses. This MS Excel Advanced one-day 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.

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 those who are ambitious and want to climb the Corporate ladder.

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

MS Excel Advanced Who Needs It?

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 or guru 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 in any version of Microsoft and Office 365.

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

View our Excel Video tips on Youtube  

MS Excel Advanced Excel Tips Resources

ExcelTips Daily Nuggets

Chandoo

Ablebits

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 Advanced 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, minimum of three delegates attending simultaneously. Prices on request.

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