VIP Microsoft Office Training

VIP Microsoft Office Training
Sage VIP

Sage VIP

Payroll and HR Training | VIP Microsoft Office Training

Enhance your Office knowledge

Our training courses include basic, advanced and problem solving solutions, designed to assist users of our software with their day-to-day responsibilities. Training is presented at any one of the 18 classrooms in South Africa, Namibia and Botswana. We also provide on-site training at client premises.

Available Microsoft Office training courses:

Excel on Steroids

Duration: 2 days (09:00 – 16:30)
Target audience: Directors. managers and anyone else who uses MS Excel extensively for report writing will benefit from this workshop.

Course detail

  • Copying and moving worksheets
  • Consolidating worksheets
  • Formulae and formulae protection
  • Sorting data lists by using the Custom List function
  • Using subtotals within data
  • Data capturing by using the Data Validation function
  • Grouping rows and columns
  • Understanding the definitions and layout of pivot tables
  • Summarising data using pivot tables
  • Creating formulae within pivot tables
  • Graphically representing your pivot table by creating a pivot chart

Book online now

Discovering Excel

Duration: 1 day (09:00 – 16:30)
Target audience: Users, who are familiar with the basics of MS Excel, but require knowledge of more advanced MS Excel features.
Course detail

  • File formats, columns and rows
  • Working with formulae
  • Managing and using multiple worksheets
  • Creating multiple views
  • Formatting and Editing worksheets
  • Defining the print and page setup
  • Using functions (Sum, AutoSum, Average, Max, Text, Conditional Formatting)
  • Creating and editing charts

Book online now