
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