Techniques for collecting, sorting and validating data in Excel to inform management decision making


  • Designed to develop the core concepts and techniques for the analysis and presentation of management information, using Microsoft Excel
  • Explores the tools within Microsoft Excel to manipulate the data, and represent trends and observations via dashboards and reports
  • Provides specific data models for analysis and report presentation, including tools to expand and integrate the functionality of Excel


Upon completion of this workshop participants should be able to:

  • Apply Excel basics, formatting cells, rows and columns
  • Employ basic concepts of collecting and sorting / validating data in Excel
  • Use data import functionality and connect to multiple data sources and systems
  • Create and manage pivot tables, charts and graphs in Excel
  • Use formulae and calculations within and across sheets
  • Link sheets and multiple files
  • Create dashboards and reports in Excel
  • Use Excel templates and present results



  • Date: January 24th, 25th and 26th, 2018
  • Time: 8:30am to 4:30pm
  • Cost per participant is inclusive of all training materials and certificate.


  • Venue: Arthur Lok Jack Global School of Business
  • Max Richards Drive,
    Uriah Butler Highway North West
    Mount Hope
  • Tel: 645-6700 Fax: 662-1411
  • Email:
Download Brochure


[contact-form-7 404 "Not Found"]