Microsoft Excel Training for African Countries

Sage Africa 

 

As one of the most important tools for payroll administrators and directors alike, you can learn how to use MS Excel to your advantage – whether for payroll or report writing purposes. Sage offers Excel Intermediate and Excel on Steroids training.

 

Excel Intermediate

Whether you use Microsoft Excel for financial or operational reporting, our Excel Intermediate course will help users with a basic knowledge to deepen their application of the Excel functionality required in their role.

 

Course Outline

The coursework covered includes:

  • File formats, styles, types, columns and rows
  • Working with formulae
  • Creating multiple sheets
  • Formatting and editing worksheets
  • Defining the print and page setup
  • How to apply functions
  • Creating and editing charts

 

Target Learners

This part of the training course is targeted at users who know the basics of Excel, but need to  learn some of the more advanced features.

 

Duration

The course runs over one full day (7 hours).

 

Delivery Methods

Self-study methods and facilitated workshops.

 

Excel on Steroids

Whether you use Microsoft Excel for financial or operational reporting, our Excel on Steroids course will catapult your knowledge and skills in the software and make your report writing process easier and more efficient.

 

Course Outline

The coursework covered includes:

  • Copying and moving worksheets
  • Consolidating worksheets into one
  • 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 and using pivot tables and pivot charts
  • Vlookups – using this function to find data in a table

 

Target Learners

This advanced part of the training course is targeted at users like directors and managers, and anyone else who uses MS Excel for report writing.

 

Duration

The course runs over two full days (14 hours).

 

Delivery Methods

Self-study methods and facilitated workshops.