Duration: ​Course: Half day	Pricing: ​​​Course Price: R 750.00 per person excl VAT
Certificate of Training: 1 x StellieTech Certificate of Completion.	Recommended Prerequisite  Learners are required to have knowledge, comprehension and application of English at Grade 10 or equivalent. Excel 2016
Venue: ​Stellenbosch Academy (Address)​ OR Online Training (100% Remote) ​ Times: ​​Monday - Friday 09:00 - 16:00	Follow Up Courses: Microsoft Office Excel Microsoft Office Excel Expert

---

Microsoft Certified Trainers

Accredited | Better | Smarter

• Course Overview
• Detailed Course Outline
• Why Get Certified

<

>

Excel Pivot Table Course

Overview:
The Complete Excel 2016 Pivot Table course will take a student who knows nothing about Excel Pivot Tables to a competent and confident power user in no time

How does the training work?
You will need to commit to 1 day of training.   ​

Course Objectives:

• Master everything you need to know about Microsoft Excel Pivot Tables.
• Reach the top professional level of Microsoft Excel with no need for prior knowledge of the application.

How does it work?

​Our courses are fully facilitated and self paced, and can either be done at our training center or 100% remote (online). Upon successfully completing the course, you will receive a Certificate of Achievement from StellieTech and thereafter, you will be preparing to write the Internationally Accredited Certification Exam which you can book with your StellieTech Course Facilitator/Trainer. The exam can be done at the training center, or 100% remote (online). Should you pass your exam, you will be awarded the Internationally Accredited Certified Exam Certificate which you will receive from the certifying body: Certiport.​

WHEN DOING THE COURSE ONLINE

All you need is a laptop / desktop computer with a stable internet connection. You will receive an online enrolment document via email with your username and password as well as the web address where you will be accessing the course from. The enrolment document also outlines how the course is structured and how to navigate through the course. You will need to ensure that you have the software installed on your pc depending on which course you’ll be doing for example Microsoft Office or Adobe.​ You will have access to our dedicated support team who will be ready and available should you require any assistance.

WHEN DOING THE COURSE AT OUR TRAINING CENTER

You will be stationed at a desk with a computer that is already set up with the course material so you won’t need to bring a laptop. You will have access to a dedicated facilitator/ trainer that will assist you throughout your training. There is a coffee/ tea station (canteen area) and a coffee shop nearby where you’ll be able to get lunch. Training is from 09h00 – 16h00, Monday - Friday. Courses can be done consecutively or one day a week.

Each Course Includes:

• Video-based Instructions
• Exercise Labs
• Pre- and Post Assessments
• Flash Cards in addition to PDF Workbooks. The workbooks includes fill-in-the blanks, glossary terms and definitions and many other resources to reinforce learning.

Benefits:

• For students, Microsoft Office Specialist boosts academic performance and preps them for college and career.
• For educators, Microsoft Office Specialist courses provide targeted training and support every step of the way.
• For Administrators, Microsoft Office Specialist improves institutional results.

​Upon successfully completing the exam

• ​You will receive the Internationally Accredited Exam Certificate which gets sent to you directly from the certifying body: Certiport.
• StellieTech will email you your E-Certificate and Score Report.
• You will receive an "Acclaim" badge which can be added to your LinkedIn profile to prove that you are certified.

Pivot Table Course

• Understand when a pivot table is suitable
• Effectively create simple pivot tables
• Create pivot charts from pivot tables created
• Set up conditional formatting rules so to emphasize data
• Use multiple fields so to enhance data representation
• Use and insert slicers.
• Understand how to use google sheets and even more.

What is the value of a certification?

In a world where competition for jobs, pay increases, and academic success continues to increase, certifications offer hope because they are a credible, third-party assessment of one’s skill and knowledge for a given subject.
​
The Microsoft Office Specialist certifications that are available are Word Associate, Excel Associate, PowerPoint Associate, Outlook Associate, Access Expert, Word Expert & Excel Expert. The Microsoft 365 Apps and Office 2019 exams have been mapped to one set of revised objective domains to reflect the skills required in today’s modern workplace. The Microsoft Office Specialist Program now has multiple levels: Associate and Expert. Students still earn a certification for each exam they pass, however if a student earns any three of the four available associate certifications they will become a Microsoft Office Specialist - Associate and earn an additional certification for their accomplishment..

If students would like to advance even further and earn their Associate certification and any two of the three available expert certifications they will become a Microsoft Office Specialist - Expert and achieve the highest certification within the Microsoft Office Specialist Program.

​Some of the key benefits of certification include:

• Validation of knowledge
• Increased marketability
• Increased earning power
• Enhanced academic performance
• Improved reputation
• Enhanced credibility
• Increased confidence
• Respect from peers

​“South African employers need a workforce that is skilled, adaptable, creative, and equipped for success in the global marketplace.”