Class

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