Excel

This comprehensive Excel Intermediate course builds on the grounding which was learnt in the Excel Basics course. The Excel Intermediate course covers some of the more advanced features and functions of Excel. This is an intense one day course, 09h00 to 15h30, which will provide you or your staff with sufficient Excel Intermediate skills to create sophisticated analytical spreadsheets and master advanced formulae. Prices from R 995 ex vat for large groups of 10+ ONSITE. T&C’s apply.

This course will prepare you or your staff for more advanced Excel courses, like Excel Advanced Executive Excel, Excel Dashboarding and Powerpivot.  Read more about PowerPivot Consultancy services that we provide. You or your staff will receive an Excel Intermediate manual and an electronic attendance certificate on completion of the Excel Intermediate Course. We almost run on demand as we try to accommodate the client’s work schedule when possible.

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

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

What This Course Covers

Finding & replacing data
PMT function
FV function
IF function
Creating a database
Absolute cell addressing
Using defined/range names
Working with dates
Working with tables
Creating an array
Linking files
Hiding columns
Group & outline
Freezing columns & rows
Working with comments
Working with templates
Protecting your data
Chart/Graphs

This course 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 Essentials 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.

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