​Duration: ​1 Days + 1 day for Internationally Certified Exam	Price: ​​​Course Price: R1250.00 per person (excl VAT) ​Exam Price: R850 with re-write excl VAT (Optional)
Certificate of Training: 1 x StellieTech Certificate of Completion 1 x Internationally Accredited E-Certificate	Recommended Prerequisite  Learners are required to have knowledge, comprehension and application of English at Grade 10 or equivalent. Computer literacy
Venue: ​Stellenbosch Academy (Address)​ OR Online Training (100% Remote) ​ Times: ​​Monday - Friday 09:00 - 16:00	Follow Up Courses: Microsoft Office PowerPoint  ​Microsoft Office Outlook ​ Official Exam: Internationally Accredited Microsoft Office Specialist Exam Preparation: Assessment, Simulation, and Video's

Microsoft Certified Trainers

Accredited | Better | Smarter

• Course Overview
• Detailed Course Outline
• Why Get Certified?

<

>

​Microsoft Office Excel Expert 

Click here to Download Course PDF

The Microsoft Office Excel Expert 2016 or 2019/365 covers all the content needed to become internationally certified. This one day course is designed to prepare you for everything you will need to know in order to write an official Microsoft Office Expert certification exam, and to be able to set yourself up for success in your work environment.
Certified individuals will establish their ability to perform a number of Word tasks, such as creating and managing documents, formatting text, paragraphs and sections, creating tables and lists, applying references and inserting and formatting objects.

The straightforward Word evaluation challenges individuals to complete a comprehensive project that depicts real-world functionality with project and standards-based outcome testing. You also have the chance of becoming a Microsoft Office Associate should you pass 3 of the Microsoft 2019/365 internationally certified exams.

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.

Manage Workbooks

• Save a Workbook as a Template
• Copy Macros Between Workbooks
• Reference Data Across Workbooks
• Structured References
• Enable Macros in a Workbook
• Display Hidden Ribbon Tabs

Manage Workbook Review

• Restrict Editing
• Protect a Worksheet
• Configure Formula Calculations
• Protect Workbook Structure
• Manage Workbook Versions
• Encrypt a Workbook with a Password

​Custom Data Formats and Validation

• Create Custom Number Formats​
• Advanced Fill Series Options
• Configure Data Validation

Conditional Formatting and Filtering

• Custom Conditional Formatting
• Formulas in Conditional Formatting
• Manage Conditional Formatting Rules​​​

Custom Workbook Elements

• Create Custom Color Formats
• Create and Modify Cell Styles
• Create and Modify Custom Themes
• Create and Modify Simple Macros
• Insert and Configure Form Controls​

Prepare for Internalization

• Display Data in International Formats
• Apply International Currency Formats
• Multiple Body and Heading Font Options

Apply Functions in Formulas

• AND Function​
• OR Function, NOT Function
• Nested Functions
• SUMIFS Function
• AVERAGEIFS Function
• COUNTIFS Function​

Look Up Data with Functions

• VLOOKUP Function
• HLOOKUP Function
• MATCH Function
• INDEX Function

Data Analysis and Business Intelligence

• Import and Transform Data
• Consolidate Data
• Goal Seek
• Scenario Manager
• Cube Functions
• Financial Functions

Advanced Date and Time Functions

• NOW and TODAY Functions
• Serialize Numbers​​

​​ Troubleshoot Formulas

• Trace Precedents
  
• Watch Window
• Validate Formulas
• Evaluate Formulas​

Define Named Ranges and Objects

• Name Cells and Data Ranges
• Name Data Ranges
• Name Tables
• Manage Named Ranges and Objects​

Create Advanced Charts and Tables

• Add Trendlines to Charts
• Create Dual-Axis Charts
• Save a Chart as a Template

Create and Manage PivotTables

• Create PivotTables
• Modify Field Selections and Options
• Create Slicers
• Group PivotTable Data
• GETPIVOTDATA Function
• Add Calculated Fields
• Format Data

Create and Manage PivotCharts

• Create PivotCharts
• Manipulate PivotChart Options
• Apply Styles to PivotCharts
• Drill Down into PivotChart Details

​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.”