FOCUSING ON
• An Overview Of Pivot Tables
• Creating Pivot Tables
• Working With Pivot Table Components
• Analysing Multidimensional Data With Pivot Table

COURSE PREREQUISITES:
Participants should have already a basic understanding of Excel

WHO SHOULD ATTEND
This program is suitable for :
• Anyone who want to learn how to use Excel pivot tables more efficiently and effectively,
• Experienced Excel users who have already used or want to use pivot tables for data analysis
• Any Excel users and developers who want to learn how to produce and automate summary reports from large blocks of data in a matter of seconds

METHODOLOGY
• Lectures
• Case Exercises
• Practical Computer Hands-On Applications

PROGRAM LEADER
DR. LIM THOU TIN’s work experience includes working in large Singapore companies to MNCs in senior corporate, IT and project management positions. As a management consultant and practitioner, he has facilitated organisational initiatives/projects over a span of more than 15 years in the region, including Australia, Singapore, Malaysia, Mauritius, India, Indonesia and Thailand. He has also served in positions such as corporate advisor, chief information officer and chief operating officer in start-up companies in Singapore. His area of involvement includes helping organisations to plan their corporate IT to building and management of their financial decision support systems, corporate knowledge and ecommerce portals. His consulting work includes working with both the financial and services industries to help them to develop corporate, financial and knowledge models to address their decision-making needs.