Duration: ​Course: 3 Days + 1 day for Internationally Certified Exam	Pricing: ​​​Course Price: R 2675.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 Excel  ​ 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 Course

Click here to Download Course PDF

The Microsoft Office Excel 2016 or 2019/365 covers all the content needed to become internationally certified. This three day course is designed to prepare you for everything you will need to know in order to write an official Microsoft Office certification, 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 Excel tasks, such as creating and managing worksheets and workbooks, managing data cells and ranges, creating tables, perform operations with formulas and functions, creating charts and objects.

The straightforward Excel evaluation challenges individuals to complete a comprehensive projects 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.

Create Worksheets and WorkbooksPart

• Create a Blank Workbook
• Create a Workbook Using Templates
• Add Data to a Worksheet
• Import Data
• Add a Worksheet
• Copy a Worksheet
• Move a Worksheet​

Format Worksheets and Workbooks

• Change Worksheet Tab Color
• Rename a Worksheet
• Change Worksheet Order
• Modify Page Setup
• Insert and Delete Columns or Rows
• Change Workbook Themes
• Adjust Row Height and Column Width
• Insert Headers and Footers

Customize Options and Views Part

• Hide and Unhide Worksheets
• Hide and Unhide Columns and Rows
• Customize the Quick Access Toolbar
• Change Workbook Views
• Change Window Views
• Modify Document Properties
• Change Magnification
• Display Formulas

Prepare Files for Distribution

• Set a Print Area
• Save Workbooks in Other Formats
• Print All or Part of a Workbook
• Set Print Scaling
• Display Repeating Row and Column Titles
• Inspect for Hidden Properties
• Inspect for Accessibility Issues
• Inspect for Compatibility Issues​​​​

Navigate in Worksheets and Workbooks

• Search for Data
• Navigate and Workbook
• Insert and Remove Hyperlinks

Manage Data Part

• Insert Data in Cells and Ranges
• Replace Data
• Replace Data
• Cut and Paste Data
• Copy and Paste Data
• Paste Data with Special Paste Options
• Using AutoFill to Fill Cells
• Insert and Delete Cells

Format Cells and Ranges

• Merge Cells
• Modify Cell Alignment and Indentation
• Use Format Painter to Format Cells
• Wrap Text Withing Cells
• Apply Number Formats
• Apply Cell Formats
• Apply Cell Styles​

Summarize and Organize Data

• Insert Sparklines
• Outline Data
• Create Subtotals
• Apply Conditional Formatting

Create Tables, Manage Table Styles and Options

• Create and Manage Tables
• Create an Excel Table from a Cell Range
• Convert a Table to a Cell Range
• Add or Remove Table Rows and Columns
• Apply Styles to Tables
• Configure Table Style Options
• Insert Total Rows

Filter and Sort a Table

• Filter Records
• Sort Data by Multiple Columns
• Sort Data by Custom Lists
• Change Sort Order
• Remove Duplicate Records​

Calculations with Formulas and Functions

• Use Basic Formulas and Functions
• Use Absolute and Mixed References
• Using Formulas Across Worksheets
• Calculate with the SUM Function
• Use the MIN and MAX Functions
• Use the COUNT Functions
• Use the AVERAGE Functions
• Formula and Function Tips

Use Conditional Functions

• Use the IF Function
• Use the SUMIF Function
• Use the AVERAGEIF Function
• Use the COUNTIF Function

​Use Text Functions

• Use the LEFT Function
• Use the MID Function
• Use the RIGHT Function
• USE the UPPER and LOWER Functions
• Use the PROPER Function
• Use the CONCAT Function

Create Charts and Objects

• Create a New Chart
• Add Additional Data Series
• Switch Orientation of Source Data
• Use Quick Analysis to Analyze Data

Format Charts

• Resize Charts
• Add and Modify Chart Elements
• Data Labels and Legends
• Gridlines
• Apply Chart Layouts and Styles
• Change Chart Type
• Create Secondary Axis
• Move Charts to a Chart Sheet

Insert and Format Objects

• Insert Text Boxes and Shapes
• Insert and Modify Images
• Add Alternative Text to Objects

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