South African Skills

Microsoft Office Excel Course
EXPERT
(2016 or 2019/365)

Employment Skills

---

Duration:
​2 Days

Price:
​​​R1250.00 per person
​(excl VAT)

Certificate of Training:
Yes

Version
​Microsoft Office 2016 or
​Microsoft Office 2019/365

---

Times & Venue:
​Stellenbosch (Address)​
​Mon - Thurs 09:00 - 16:00
​Saturday 09:00 - 16:00

OR

​Online Training 
100% Remote

Availability:
View Dates
Dates  are available every week

Add-on:
International Exam
​See Price
Practice Tests R599.00
​(excl VAT)

---

Recommended Prerequisite 
Microsoft Excel

Follow up courses
Microsoft Word Expert

Accredited | Better | Smarter

Microsoft Certified Trainers

• Course
• Course Outline

<

>

​Microsoft Office Excel Course

Overview:
This course covers all the content of Microsoft Office Excel 2016 or 2019/365 needed to become internationally certified.For those who have a good grounding in Microsoft Excel, this course will provide you with the knowledge and skills to use MS Excel at an expert level.
This training in Microsoft Excel will propel your Excel skills forward to an advanced level.
Over several lessons, you’ll become confident in a range of Excel’s more sophisticated features and learn how to use it to its full potential.

How does the training work?
You will need to commit to a full day of training, which can be done in the week or on a Saturday. 

Course Objectives:
This program has been designed to provide the student with multiple certificates and certification, both locally and internationally recognized by industry for maximum employability. On completion the student will earn the following: 

•  Internationally recognized Microsoft Certificate for each courses attended. 
• Microsoft Office Specialist certification after completion of the exam. 

Session 1:

• Manage workbook
• Manage workbook review

Session 2: 

• Apply custom formats and data validation  
• Apply advanced conditional formatting and filtering 
• Create and modify custom workbooks and elements
• Prepare a workbook for internationalization 

Session 3: 

• Apply functions in formulas
• Look up data by using functions 
• Perform data analysis and business intelligence 
• Troubleshoot formulas
• Define named ranges and formulas

Session 4: 

• Create advanced charts
  
• Create and manage Pivot Tables 
  
• Create and manage Pivot Charts 

One of the best.

StellieTech's Microsoft material is rated very highly in South Africa.