Microsoft Office Courses

Step-by-Step Video Lessons from R99 per month

Join Now!


Microsoft Office 2016 Online Course

Hi, my name is Frans and I am your Regional Account Manager for ATTI Online Learning in South Africa. My role is to look at simple, and effective ways to develop your Office skills using our step-by-step online video tutorials.

If you are worried that you might be to old to learn about computers or fear that you might not be able to do this, then I want to reassure you that if you are serious about this we are commited to helping you learn.

We have trained thousands of people from all walks of life, every sector, every industry and every age group. We are very passionate about training and to me it is extremely satisfying to help a person grow and see them master a computer course like Microsoft Office.

Online courses do require a more self-motivated learning style than traditional classes and for some the first online learning experience can be a little intimidating, but once you get the hang of it, I promise you, you will do fine.

In our Office Online Courses you will learn everything you need to know to be proficient in Microsoft Word 2016, Microsoft Excel 2016, Microsoft PowerPoint 2016 and Microsoft Outlook 2016.

Microsoft Office is probably the most popular office suite on the planet today and is available as a subscription using Office 365 or as a stand alone version or alternatively you can use the Free Office Online Version, which allows you to create and edit files using the lightweight, web browser-based versions of Microsoft Office.

Microsoft Office is used in every sector and industry and it also plays an important role in all levels of education starting from school level up to university.

Computer literacy is an essential skill in almost every workplace and without it you will most certainly be unable to get into most jobs or advance in your career.

On successful completion of the course learners will receive an attendance certificate as well as a transcript on what was covered.

Learners can also assess their office skills with the Microsoft Office Specialist Certification at approved Certiport Testing Centres all over the country. The Microsoft Office Specialist Certification is optional and the fees for the microsoft office certification might differ between the testing centers.


Microsoft Office Training Methodology

This office online course is modular and each module consists of short video tutorials between 3 and 10 minutes long. In certain cases, some office videos might exceed 10 minutes due to the nature of the lesson.

The facilitator will demonstrate on their screen step by step a feature or function during each office tutorial and if necessary, have created sample exercise files that you can download, so that you can follow along and see if you can apply and understand what was covered in the video lesson.


Courses Included in this Microsoft Office Course

Microsoft Word Course Info

Since Microsoft Word 2007 this classic desktop application is used in almost every sector and industry for writing, editing and the production of letters with a strong focus on maximum productivity. From Microsoft Word 2010 to Microsoft Word 2013 we have not noticed any major changes in terms of the interface. Just a few new features and minor adjustments.

Microsoft Word 2016 has become the document writing and editing program that for the moment rules the market and it allows you to quickly produce professional documents using the rich authoring features.

Share, present, and work together on projects with built-in team collaboration tools and access your documents in the cloud whenever and wherever you need them. Your Word, always good, is now better than ever.


Microsoft Word Target Audience:

This course is intended for delegates who want to learn the fundamentals skills of working with Microsoft Word 2016, such as creating, editing, and formatting documents, inserting simple tables and creating lists, and employing a variety of techniques for improving the appearance and accuracy of document content.

The course then moves on to cover some of the more advanced features such as macros and building blocks, proofing, sharing and reviewing documents with others.

Microsoft Word Course Outline

Fundamentals and Exploring the workspace

  • Document navigation, minimize, maximize and restore, ribbons, title, Quick access toolbar and backstage view
  • Open and close documents in Microsoft Word
  • Create different kinds of documents with different layouts
  • Save a document in word or other format
  • Printing a document using different settings
  • Convert and create pdf files
  • Use the assistant help function to perform tasks

Working with text

  • Inserting text, different alignment options and the find and replace function
  • Different ways of selecting text
  • Different ways to use the cut, copy and paste function
  • Use the find and replace function in a document
  • Using the undo and redo function
  • Inserting different types of font and applying different styles
  • Changing fonts, their size, color and alignment
  • Change case of text in a document
  • Using Outlines, Shadows, Reflections, Glow and 3-D Format text effects

 

Formatting Pages

  • Adjust page margins, change the layout and size of a page in a document
  • Add different types of content to the header and footer in a document
  • Insert and remove breaks, apply different headers to each section
  • Insert and customizing the page border, color and adding a watermark
  • Using style templates and changing the theme of a document
  • Create your own custom style to use in a header
  • Saving your own custom style or theme
  • Enable or disable editing restrictions to content
  • Using the navigation pane to navigate to headings

 

Formatting Paragraphs

  • Selecting text in a document and using the alignment function
  • Add or remove lines before or after paragraphs
  • Adding borders and shading to paragraphs
  • Add tab stops to ruler and using them in a document
  • Binding sections together

Bullets and Numbering

  • Create bulleted and numbered lists
  • Add an edit text in an existing list
  • Using different multileveled lists

Using Columns and Tables

  • Divide paragraphs into columns and format their settings
  • Create a table and insert data
  • Change the layout and properties of a table using styles
  • Add or remove rows and columns and changing their width
  • Modify and manipulate cells and content in a table
  • Sort data inside a table
  • Convert text into a table and modify table properties
  • Converting table to text
  • Insert and modify data from Microsoft Excel

Using graphics and video

  • Add shapes and images to a document
  • Resize and position shapes and objects
  • Changing the text wrapping of a picture
  • Changing table borders and organizing content
  • Use Shadow, Reflections, Glow, Soft Edges, 3-D
  • Modify the brightness, colors, contrast, saturation, sharpness and cropping an image in a document
  • How to create, insert, remove and modify WordArt in a document
  • How to create, insert, remove and modify charts in a document
  • How to create, insert, remove and modify Smartart in a document
  • Capture a screenshot from a website
  • Explore different ways to embed video in a document

 

Macros and Building Blocks

  • Create and use a macro
  • Modify and use existing macros
  • Navigate and Insert a cover page from the building block organizer
  • Creating and saving Quick Parts

Proofing Your Documents

  • Creating and using Quick Parts in a document
  • Find and correct spelling mistakes in a document
  • Using synonyms, the thesaurus, smart lookup and translating selected text

Sharing Documents with Others people

  • Explore document properties and compatibility
  • Sending a document using email or as a pdf
  • Add or remove passwords to protect your documents
  • Using Microsoft OneDrive cloud to share documents

Reviewing Documents with Others

  • Display and add comments to a document
  • How to review changes in a document
  • Navigate, Accept and Reject
  • Compare 2 documents and reject or accept changes

Customizing Microsoft Word

  • Explore and customize the setting in word
  • Customize the Ribbon using tabs and groups
  • Add commands and change the appearance of the Quick Access Toolbar

Microsoft Excel Course Info

Microsoft Excel is a spreadsheet application, which allows users to store, edit and manipulate data within a group of table-like structures known as a workbook. Since Microsoft Excel 2007 we have noticed a huge change in the interface with lots of added features with added productivity.

From Microsoft Excel 2010 to Microsoft Excel 2013 we have noticed nothing major in terms of the interface. Just a few new features and minor adjustments.

Microsoft Excel consists of basically a workbook that uses a collection of worksheets to organize data within a system or rows and columns split into cells. Users can enter data or numbers into these cells to create easy ways to calculate simple or complex formulas. Users can insert objects such as charts and graphs into their workbook to graphically represent their entered data in many unique ways.

With new chart types and improvements to PivotTables and business intelligence, Microsoft Excel 2016 makes it easier to work with large amounts of data and give it even more meaning. Unlock insights, and tell the story in your data by organizing it in spreadsheets (workbooks). View your data in context, and use the analytic capabilities of Microsoft Excel to make more informed decisions.

Microsoft Excel Target Audience

This course is intended for delegates who want to learn the fundamental skills of working with Microsoft Excel 2016, such as creating, editing, and formatting documents, inserting and formatting tables and creating charts, creating formulas and functions and employing a variety of techniques for improving the appearance and accuracy of an Excel spreadsheet.

The course then moves on to cover some of the more advanced excel features such as IF, VLOOKUP, Power Function, Pivot Tables, Data Management and Analysis Tools as well as macros.

Microsoft Excel Course Outline

Getting Started with Excel

  • Introduction to Excel
  • Exploring the Ribbon and the backstage view
  • Add, remove and Customize the quick access toolbar
  • Exploring the spreadsheet layout
  • Explore and understand the formula bar
  • Explore and customize the status bar
  • Switch between worksheets and workbooks
  • Customize the mini toolbar using the right click menu
  • Creating new workbooks and using document templates
  • Smart Lookup, help and the Tell Me Assistant
  • Entering Data
  • Insert data and resize columns
  • Different ways of quickly inserting data by using Autofill
  • Working with dates and times
  • Step forward and back using the undo and redo function
  • Add and remove comments
  • Save and understand the different ways to save a spreadsheet

Creating Formulas and Functions

  • Working with different types of formulas
  • Copying and reusing a formula to save time
  • Calculating year-to-date totals and adding them to charts
  • Calculate percentage and understand Excel logic when it comes to formulas
  • Working with relative, absolute, and mixed references
  • Looking at different ways the AutoSum function can be used
  • Using other popular functions

Formatting

  • Format text and change fonts
  • Adjusting row heights and column widths
  • Aligning, wrapping, text angles and Merging cells
  • Add and customize borders
  • Explore different format options using numbers, dates and time
  • Using conditional formatting
  • Add rows and columns, using functions and changing table formatting
  • Using Shapes, Images and SmartArt

Adjusting Worksheet Layout and Data

  • Insert and remove columns or rows
  • Hide or unhide columns or rows
  • Moving, copying, and inserting data
  • Find and replace text or formatted data

Printing

  • Exploring the Page Layout tab and Page Layout view
  • Page break preview and printer settings
  • Working with Page Setup and printing controls

Charts

  • Inserting a chart using existing data
  • Creating different chart types
  • Changing the design and styles of charts
  • Format the layout, design and work with chart elements
  • Explore different types of charts

Adjusting Worksheet Views

  • Freeze, unfreeze a column or row
  • Splitting screens horizontally and vertically
  • Collapsing and expanding data views with outlining

Multiple Worksheets and Workbooks

  • Displaying multiple worksheets and workbooks
  • Renaming, inserting, and deleting sheets
  • Moving, copying, and grouping sheets
  • Using formulas between worksheets and workbooks
  • Formula notifications and locations

IF, VLOOKUP, and Power Functions

  • Using IF functions and relational operators
  • Getting approximate table data with the VLOOKUP function
  • Getting exact table data with the VLOOKUP function
  • Using the COUNTIF family of functions

Security and Sharing

  • Unlocking cells and protecting worksheets
  • Protecting workbooks
  • Assigning passwords to workbooks
  • Privileges and sharing options
  • Setting up and working with changes

Data Management Features

  • Sorting data in a column
  • Inserting subtotals in a sorted list
  • Adding filters to columns
  • Splitting data into multiple columns
  • Using Flash Fill to automatically fill cells
  • Removing duplicates from a worksheet
  • Using validation tools

Data Analysis Tools

  • Using Goal Seek to calculate changes needed
  • Using the solver to calculate values needed
  • Add and view scenarios
  • Create and edit a data table

Pivot Tables

  • Create and edit a Pivot Table
  • Customize a Pivot Table
  • Grouping dates in a Pivot Table
    Grouping by other factors
  • Using slicers to clarify and manipulate fields
  • Create and edit a Pivot Charts

Introduction to Macros

  • When can we use a macro?
  • Creating and assign a macro
  • Run and access macros

Microsoft PowerPoint Course Info

Since Microsoft PowerPoint 2007 a person ensured that they grab and maintain their audience's focus when asked to create and present important information in the ppt format. From Microsoft PowerPoint 2010 to Microsoft PowerPoint 2013 we have not noticed any major changes in terms of the interface, only a few new features.

In this Microsoft PowerPoint Online course you will learn how to use PowerPoint to create engaging visual presentations. We will look at the vast array of features and functionality contained within Microsoft PowerPoint 2016. We will look at organising content as well as enhancing it with high-impact visuals allowing you to deliver dynamic multimedia presentations.

Microsoft PowerPoint 2016 is here to help you create, share, and co-author powerful presentations.With new features—including modern chart types, screen recordings, and the Microsoft Office Mix add-in with enhanced screen recording functionality—PowerPoint 2016 allows you to bring your presentations to a whole new level.

Microsoft PowerPoint Target Audience

This course is intended for delegates who want to learn the fundamental skills of working with Microsoft PowerPoint 2016, such as creating, editing, and formatting documents, inserting and formatting tables and creating charts, using multimedia and animation and employing a variety of techniques for improving the appearance of a PowerPoint presentation.

Microsoft PowerPoint Course Outlines

Fundamentals and Exploring the workspace

  • Exploring the PowerPoint interface
  • Outline View, Slide Sorter, Notes Page, Reading view, Enable/disable the ruler, gridlines and guides, Change the colour of your slides)
  • Sign in with Microsoft Account and Link OneDrive to PowerPoint)
  • Create a new blank presentation, add content, new slides and save the presentation)
  • Creating a new presentation from a theme or template and use placeholder text)
  • Changing and customizing themes)
  • Changing the master slides)
  • Insert data into the header and footer)
  • Using the Backstage view

Working with Slides

  • Add and remove slides, pictures to slides and change the layout)
  • Use and create custom layouts, add placeholders)
  • Slide sorter view, adding sections and header slides, importing slides from other presentation)
  • Rearrange slides)

Using Images in Slides

  • Add pictures, use placeholders and change the background of a slide)
  • Using guidelines to align pictures)
  • Customize pictures, remove backgrounds, do corrections and add artistic effects)
  • Change the stacking order of pictures)
  • Change the order of pictures
  • Use the eyedropper tool to change text and background colors

 

 

Working with content

  • Insert, customize and indent list using bullets and numbers)
  • Explore and add content on Outline mode)
  • Overview of Outline Mode
  • Convert text to word art and add effects)
  • Insert, move and duplicate textboxes in a slide)
  • Insert a table, data and change the style and layout)
  • Use Smart Lookup and translate text)

Working with shapes and charts

  • Add different shapes and change them)
  • Changing shape styles, adding effects and formatting shapes)
  • Crop a picture into a shape)
  • Move, Merge, Duplicate and Group shapes together)
  • Insert, format charts and designs, import chart from an excel spreadsheet)
  • Insert, change the layout and design of SmartArt)
  • Explore and use Equation tools)

Using multimedia and Animation

  • Insert and style videos from YouTube)
  • Overview of video playback options)
  • Record audio and explore audio options)
  • Add and edit slide transitions)
  • Apply animation to enhance your presentation)

 

 

Planning the Presentation

  • Adding speaker notes to slides)
  • Print and configure printing options of print handouts)
  • Plan and use the Rehearse Timings function)
  • Adding and viewing comments on a slide)
  • Accept and Reject changes, merging 2 presentations and save a final copy

Present Your Presentation

  • Turning recorded timings off and viewing the slideshow)
  • Open and navigate the presenter view)
  • Opening the presenter view
  • Tools to enhance your presentation)
  • Creating and setting up an unattended slideshow using kiosk function

Reusing and Sharing Presentations

  • Setting up and Creating a custom show)
  • Inspecting and remove information in a presentation)
  • Choose a slide or presentation to save as a template)
  • Configure printer options and print a presentation)
  • Add and Remove narration and timings to a slide show)
  • Configure video and audio settings and export as video)
  • Exporting and view the presentation as a PDF or JPEG)
  • Explore sharing options and saving and sharing using One Drive)
  • Start, Share and end an online presentation)

Microsoft Outlook Course Info

In this online course with the help of our video tutorials you will learn everything you need to know to be proficient in Microsoft Outlook 2016. In this course, we will show you how to use Microsoft Outlook 2016 to manage your email communications. We will be looking at composing, reading, and responding to emails, schedule appointments and meetings, manage contact information, schedule tasks and create notes, customise message response options; and organise your mail.

Microsoft Outlook is not only used for sending and receiving messages and attachments but it is also used as a personal information manager.

The Outlook Calendar feature is used to create appointments and events, while you can also create and track tasks in Outlook until they are completed.

The Microsoft Outlook contact manager enables users to easily store and find contact information, such as names, addresses and telephone numbers. You can also use notes in Outlook as an electronic replacement for paper sticky notes.

 

Microsoft Outlook Target Audience

This course is intended for delegates who want to learn the fundamentals skills of working with Microsoft Outlook 2016, such as receiving, arranging, creating and sending of mail as well as working with contacts, calendar, tasks and notes.

The course then moves on to cover some of the more advanced features such as backup and restore.

Microsoft Outlook Course Outlines

Introduction

  • Getting familiar with the Outlook interface
  • Explore and customise the status and navigation bar
  • Add, remove and synch an email account
  • Manually adding an IMAP (Gmail or POP account
  • Syncing incoming and outgoing email
  • Connecting OneDrive to Outlook

Receiving Mail

  • Reading your email
  • Customize and explore different views
  • Working with file attachments
  • Searching sent and received emails
  • Creating a search folder
  • Flagging spam emails as junk
  • Using search and filter options

Organize and Arrange Mail

  • Using conditional formatting to distinguish emails
  • Categorizing emails and creating flags
  • Sort and Organize mail using folders
  • Using Quick Steps to control messages
  • Using mail rules to control messages
  • Archive and clean mailbox

 

 

Creating and Sending Mail

  • Compose a new email message
  • Replying to and forwarding a received message
  • Formatting a message
  • Creating voting buttons in a message
  • Adding a signature
  • Exploring delivery options
  • Creating personal stationery
  • Exploring other mail settings

Managing Contacts and User Access

  • Working with and exploring the People hub
  • Creating a new contact
  • Creating a new contact group
  • Categories and favourites
  • Create and edit folders and groups

 

 

Calendar, Tasks and Notes

  • Quick overview of the calendar
  • Explore and customize views
  • Creating a new appointment
  • Creating a new meeting
  • Manage and Update meeting
  • Handling meeting requests
  • Emailing and printing a calendar
  • Create and switch between calendars
  • Creating more than one calendar
  • Changing the calendar options
  • Overview of tasks
  • Create and follow up on tasks
  • Create and customize notes

Backup, Restore and Advanced Options

  • Backup and export Outlook files
  • Creating Quick Parts
  • Changing general Outlook options

Pricing and Subscription strong>Options

Pay as you go: Access to all our courses for R199 R99 per month!

The #1 Selling option for our eLearning Portal.
*50% off Special Promotion!

6 Months: Access to all our courses for R999 R499 once-off!

Save R95 when you pay 6 months upfront.
*50% off Special Promotion!

12 Months: Access to all our courses for R1999 R999 once-off!

Save R189 when you pay 12 months upfront.
*50% off Special Promotion!



Companies we have trained over the years