eICPAS

Course Objective

Today's executives are faced with satisfying the information requirements of management that grow and becoming more demanding every day.

Are you overwhelmed by the massive volume of data?

Do you want to see trends and patterns at a glance?

Do you encounter long and expensive development cycles required by enterprise software?

In this program, you will master PivotTable reports turning hundreds or thousands of pieces of data into information that makes sense, revealing the meanings behind the data. Each PivotTable report gives you a different view of your data, answering your questions on the spot, and is customized to your needs.

By the end of this program, you will
- Discover the key secrets to success with Pivot Tables.
- Confidently move pieces of information around to create different views of the business
- Easily supplement PivotTable Report with meaningful exceptions or variance reports to aid performance evaluation
- Combine dynamic data range with pivot table to create interactive reports
- Design PivotTable reports useable by people without knowledge of pivot table
For more course details, please click here

Download course brochure, please click here
Special Feature about the course:

Small class size with individual attention from trainer, so that you maximize your learning. With one computer to each person, you will develop your skills on this application through practical exercises, and will return to work fully equipped to turn your learning into action.

Bonus for this programme:
- $200 voucher for Business Analysis & Reporting (BAR) Programme *
* Terms & Conditions Apply
- Non-transferable and not exchangeable for cash
- Valid for 3 months
Who Should Attend

For all Microsoft Excel users who want to generate powerful business reports rapidly from large volumes of data.
Training Instructor

The instructor, Mr. Tang Kok Kwai, has extensive experience in financial reporting and analysis using Microsoft Excel. He is the developer and chief trainer of the ICPAS program - Business Analysis and Reporting, which has given many accountants new tools to produce business reports rapidly and incorporating what-ifs simulation for budgeting purposes.

In this one day programme, Mr. Tang will bring you to a higher level of mastery of Pivot Table.

Mr Tang Kok Kwai, a Chartered Accountant and Certified Public Accountant, has an IT background and is currently the Chairman of ICPAS IT Services Committee.

He runs an IT consultancy company and has helped many corporations in developing reporting solutions, providing powerful reporting capabilities to these companies. During the course, Mr. Tang will share his unique insights into real-life complex business solutions.
Total Fee (excl GST)

$400 for ICPAS Members / Past BAR participants
$500 for Non Members

Participants who want to utilize SAA voucher(s) should send it together with the rest of the course fee via post.
Course Detail
- Training Duration: 9am to 5pm (1-day training)
- ICPAS CPE Hours Awarded: 7 CPE Hours