CERTIFIED MICROSOFT OFFICE TRAINING
AGT Service Provider (Pty) Ltd is a registered ATC (Approved Training Center) for Microsoft Office through MasterSkill.
Microsoft Office - Word
By completing our three-day Microsoft Office - Word course and passing your exam, you will be certified with a certificate of competency through MasterSkill.
​
Covered in this course:
-
Getting Started with Word
-
Formatting Text and Paragraphs
-
Working More Efficiently
-
Managing Lists
-
Adding Tables
-
Inserting Graphics/Objects
-
Controlling page Appearance
-
Preparing to Publish a Document
-
Organizing Content Using Tables and Charts
-
Customizing Formats Using Styles and Themes
-
Inserting Content Using Quick Parts
-
Using Templates to Automate Document Formatting
-
Controlling the Flow of a Document
-
Simplifying and Managing Long Documents
-
Using Mail Merge to Create Letters, Envelopes, and Labels
-
Manipulating Images
-
Using Custom Graphic Elements
-
Collaborating on Documents
-
Adding Document References and Links
-
Securing a Document
-
Using Forms to Manage Content
-
Automating Repetitive Tasks with Macros
​
Microsoft Office - Excel
By completing our three 1 day Microsoft Office - Excel course and passing your exam, you will be certified with a certificate of competency through MasterSkill
​
Covered in this course:
-
Getting Started with Excel
-
Performing Calculations
-
Modifying a Worksheet
-
Formatting a Worksheet
-
Printing Workbooks
-
Managing Workbooks
-
Working with Functions
-
Working with Lists
-
Analyzing Data
-
Visualizing Data with Charts
-
Analyzing Data with PivotTables and PivotCharts
-
Working with Multiple Worksheets and Workbooks
-
Using Lookup Functions and Formula Auditing
-
Sharing and Protecting Workbooks
-
Automating Workbook Functionality
-
Creating Sparklines and Mapping Data
-
Forecasting Data
Microsoft Office - Outlook
By completing our two-day Microsoft Office - Outlook course and passing your exam, you will be certified with a certificate of competency through MasterSkill.
​
Covered in this course:
-
Getting Started with Outlook
-
Formatting Messages
-
Working with Attachments and Illustrations
-
Customizing Message Options
-
Organizing Messages
-
Managing Your Contacts
-
Working with Calendars
-
Working with Tasks and Notes
-
Modifying Messages and Setting Global Options
-
Organizing, Searching, and Managing Messages
-
Managing Your Mailbox
-
Automating Message Management
-
Working with Calendar Settings
-
Managing Contacts
-
Managing Activities by Using Tasks
-
Sharing Workspaces with Others
-
Managing Outlook Data Files
Microsoft Office - PowerPoint
By completing our two-day Microsoft Office - PowerPoint course and passing your exam, you will be certified with a certificate of competency through MasterSkill.
​
Covered in this course:
-
Getting Started with PowerPoint
-
Developing a PowerPoint Presentation
-
Performing Advanced Text Editing Operations
-
Adding Graphical Elements to Your Presentation
-
Modifying Objects in Your Presentation
-
Adding Tables to Your Presentation
-
Adding Charts to Your Presentation
-
Preparing to Deliver Your presentation
-
Modifying the PowerPoint Environment
-
Customizing Design Templates
-
Adding SmartArt and Math Equations to a Presentation
-
Working with Media and Animations
-
Collaborating on a Presentation
-
Customizing a Slide Show
-
Securing and Distributing a Presentation
Microsoft Office - Access
By completing our three-day Microsoft Office - PowerPoint course and passing your exam, you will be certified with a certificate of competency through MasterSkill.
​
Covered in this course:
-
Getting Started with Access
-
Working with Table Data
-
Querying a Database
-
Using Forms
-
Generating Reports
-
Designing a Relational Database
-
Joining Tables
-
Using Data Validation
-
Creating Advanced Queries
-
Organizing a Database for Efficiency
-
Using Advanced Reporting Techniques
-
Implementing Advanced Form Design
-
Sharing Data Across Applications
-
Using Macros to Improve User Interface Design
-
Using VBA
-
Using Advanced Database Management