Mastering Data Analysis Tools Using Microsoft Excel for Accountants
Course Information
  • 05-Mar-2020
  • DoubleTree Hilton, Johor Bahru
  • Stanley Wong
  • English
  • RM 580
  • 9am - 5pm
(A) INTRODUCTION
This course is designed for accounting professionals that are using MS Excel as their spreadsheet tool to develop reports and calculation for operation purpose. The objective is to bring awareness of more MS Excel PivotTable features that can enhance the operation analytical quality. This course focuses to illustrate the the building of an accounting dashboard based on data extraction.

(B) LEARNING RESULT
At the end of this program, the participants shall gain knowledge on the following:
• Able to use MS Excel PivotTable with confidence
• Able to manage data by using useful table management functions and charts

(C) WHO SHOULD ATTEND
• Anyone who wants to know more about Excel Pivot Table
• Anyone who needs PivotTable to check data accuracy
• Operation professionals who are managing their reports in MS Excel and plan to perform pivot reporting in tabular form

(D) TRAINING METHOD
• Tutorial by Facilitator using presentation tools
• Series of exercise to practice different types of functions and features
• Group Discussion

(E) REQUIREMENT
• Delegates enroll for this course shall possess MS Excel skill
• The course can be performed in either Excel 2016 or Offce 365 Excel Application on Laptop

(F) DATE/VENUE

Date: 5 March 2020 (Thu)
Time: 9AM - 5PM
Venue: DoubleTree Hilton, Johor Bahru

(G) Fee
- Normal Fee - RM580

* Fee includes Course Notes, Lunch, Refreshments/ Tea Breaks, Certificate of Attendance & 6% Government Service Tax

Discount
10% overriding discount for SST2u Loyalty Card members

(H) COURSE SCOPE
Data Extraction and Table Management
• Data extraction from audit file in accounting software
• Convert raw data into a meaning mini-database
• Create customized columns by Excel formulas and functions

Introduction to Pivot Table and Chart
• Introduction to Pivot Table Menu
• Convert table into a pivot table
• Build reports from pivot table
• Analyzing the reports with filter, grouping and sorting of a pivot table

Introduction to Chart and Pivot Chart
• Build the ordinary Excel chart
• Introduction to Pivot Chart Menu
• Create Pivot Chart and Pivot Table

Introduction to Financial Dashboard
• Build a simple dashboard
• Data validation, parameter and shapes
• Formulas and Functions for the dashboard
• Worksheet and Workbook Protection

(I) Speaker Profile

STANLEY WONG
HR CONSULTANT

STANLEY WONG is a Project Management Professional (PMP) and a HRDF certified trainer. He holds MSc in IT degree specializing in project management. He is a Chartered Accountant and a member of MIA. He attended a number of workshops in Singapore and UK to bring back insights on the subject matters that relatively new but important to Malaysia. He delivers training on the following subject matters, SST 2.0 – Sales and Service Tax, Business Mind Mapping, Forensic Investigation, Crisis Management, Business Continuity, Essential Excel Skills for Accountants, Project Management as well as study on Chinese metaphysics and Yi Jing.

(J) ENQUIRY & REGISTRATION

Email: sstcourse@gmail.com
Enquiry:
General (03 - 8082 3357)
Teo (011 - 3178 9203)
Logesh (012 - 503 0346)
Siti (012 - 383 8603)