STELLIETECH
  • Home
  • Information
    • FAQ
    • Blog
    • About us
  • Courses
    • Microsoft Office Courses >
      • Microsoft Word
      • Microsoft Word Expert
      • Microsoft Excel
      • Microsoft Excel Expert
      • Microsoft Access
      • Microsoft Access Expert
      • Microsoft Outlook
      • Microsoft PowerPoint
    • Adobe Suite Courses >
      • Adobe After Effects
      • Adobe Dreamweaver
      • Adobe Illustrator
      • Adobe InDesign
      • Adobe Photoshop
      • Adobe Premiere Pro
    • IT Specialist >
      • HTML 5 Application Development
      • Cloud Computing
      • Computational Thinking
      • Device Configuration and Management
      • HTML and CSS
      • Python Course
      • Java Course
      • Javascript Course
      • Network Security
      • Networking Course
      • Databases Course
    • Introduction to Computers >
      • Typing Course
      • Computer Literacy
      • Digital Literacy
    • Office Administration
    • CompTIA Courses >
      • CompTIA Security+ Course
      • CompTIA Network+ Course
      • CompTIA A+ Course
    • Cyber Security >
      • Ethical Hacking Associate (EC-Council)
    • Health and Safety Courses >
      • Working at Heights
      • Health and Safety Representative
      • Covid-19 Workplace Readiness
    • MTA Courses >
      • MTA - Cloud Fundamentals
      • MTA - Database Administration Fundamentals
      • MTA - HTML5 Application Development Fundamentals
      • MTA - Introduction to Programming using Java Course
      • MTA - Introduction to Programming using JavaScript Course
      • MTA - Introduction to Programming using HTML and CSS Course
      • MTA - Mobility and Devices Fundamentals
      • MTA - Networking Fundamentals
      • MTA - Security Fundamentals
      • MTA - Software Development Fundamentals
      • MTA - Windows Operating System Fundamentals
  • Certify
    • Exams
    • Practice Tests
  • E-learning
    • Learn Online
    • Course Creation
    • Custom E-learning
    • Virtual event hosting
  • Contact
    • Request a Quote

​Microsoft Excel Course

View Course
Microsoft Office 2016 Excel Course
Excel Course
Picture
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,

Picture
Microsoft Office 2016 Excel Trainer
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.
Picture

​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
Picture

    Request a quote for this course.

    Any Questions?
Submit
Picture
​“South African employers need a workforce that is skilled, adaptable, creative, and equipped for success in the global marketplace.” 
Powered by Create your own unique website with customizable templates.
  • Home
  • Information
    • FAQ
    • Blog
    • About us
  • Courses
    • Microsoft Office Courses >
      • Microsoft Word
      • Microsoft Word Expert
      • Microsoft Excel
      • Microsoft Excel Expert
      • Microsoft Access
      • Microsoft Access Expert
      • Microsoft Outlook
      • Microsoft PowerPoint
    • Adobe Suite Courses >
      • Adobe After Effects
      • Adobe Dreamweaver
      • Adobe Illustrator
      • Adobe InDesign
      • Adobe Photoshop
      • Adobe Premiere Pro
    • IT Specialist >
      • HTML 5 Application Development
      • Cloud Computing
      • Computational Thinking
      • Device Configuration and Management
      • HTML and CSS
      • Python Course
      • Java Course
      • Javascript Course
      • Network Security
      • Networking Course
      • Databases Course
    • Introduction to Computers >
      • Typing Course
      • Computer Literacy
      • Digital Literacy
    • Office Administration
    • CompTIA Courses >
      • CompTIA Security+ Course
      • CompTIA Network+ Course
      • CompTIA A+ Course
    • Cyber Security >
      • Ethical Hacking Associate (EC-Council)
    • Health and Safety Courses >
      • Working at Heights
      • Health and Safety Representative
      • Covid-19 Workplace Readiness
    • MTA Courses >
      • MTA - Cloud Fundamentals
      • MTA - Database Administration Fundamentals
      • MTA - HTML5 Application Development Fundamentals
      • MTA - Introduction to Programming using Java Course
      • MTA - Introduction to Programming using JavaScript Course
      • MTA - Introduction to Programming using HTML and CSS Course
      • MTA - Mobility and Devices Fundamentals
      • MTA - Networking Fundamentals
      • MTA - Security Fundamentals
      • MTA - Software Development Fundamentals
      • MTA - Windows Operating System Fundamentals
  • Certify
    • Exams
    • Practice Tests
  • E-learning
    • Learn Online
    • Course Creation
    • Custom E-learning
    • Virtual event hosting
  • Contact
    • Request a Quote