Excel

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

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

EXCEL DASHBOARD TWO DAY COURSE

Johannesburg, Cape Town and Durban dates on request. Onsite training dates are flexible. Minimum of four delegates attending simultaneously. T&C’s apply.

Youtube Excel Dashboard link

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 complicate 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 in any business.

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

What This Course Covers

SUMPRODUCT
EOMONTH
IF
IF ERROR
TEXT
CONDITIONAL FORMATTING & IF
DYNAMIC DROPDOWN
SPARKLINES
COPY PASTE CAMERA TOOL
SHAPES AND TEXTBOX
SPARKLINES
INDEX AND MATCH
MAX
CONCATENATE
TEXT
EXCEL DASHBOARDS
DASHBOARDS DESIGN
ANAYLSE DATA
WOW YOUR BOSS!

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