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

OVERVIEW

  • 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

LEARNING OBJECTIVES

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

DETAILS

Date

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

Location

  • 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: openerolment@lokjackgsb.edu.tt
Download Brochure

Register

[contact-form-7 id=”432″]