Workshop: Essential Excel Skill for Accountants
Course Information
  • 04-Nov-2019
  • TH Hotel & Convention Centre, Kuala Terengganu
  • Stanley Wong
  • English
  • RM 500 RM 420
    Until 08 Oct 2019
(A) INTRODUCTION
Microsoft Office Excel was designed to support accounting functions such as budgeting, preparing financial statements and creating balance sheets. It integrates with external data to allow you to import and export banking information and financial data to and from other accounting software.

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 OUTCOMES
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) COURSE SCOPE
- Morning – Session 1
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

- Morning – Session 2
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

- Afternoon – Session 1
Introduction to Chart and Pivot Chart
• Build the ordinary Excel chart
• Introduction to Pivot Chart Menu
• Create Pivot Chart and Pivot Table

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

(E) DETAIL & FEE [HRDF Claimable]
Date: 4 November 2019 (Mon)
Time: 9.00AM - 5.00PM
Venue: TH Hotel & Convention Centre, Kuala Terengganu

Early Bird (before 8 Oct 2019) - RM 420
Special Offer (before 22 Oct 2019) - RM 460
Normal Fee - RM 500

- Incl. meals, course notes, certificate, CPD 8 hours, 6% Service Tax

**DISCOUNT**
(i) 10% for Group Registration of 3 pax and above
(ii) 10% Overriding Discount for SST2u Loyalty Card members

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

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

(H) SPEAKER PROFILE

STANLEY WONG

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 has 25 years of working experience in system implementation project management, specializing in financial management application. In addition, he is involved in providing training and advisory in relation to business mind mapping as a ThinkBuzan License Instructor accredited by Tony Buzan. Besides, Stanley is also a much sought after speaker for Sales & Service Tax (SST) and Goods & Services Tax (GST).

(I) REGISTRATION

Email: SSTcourse@gmail.com
Enquiry:
- Han (019 - 323 0507)
- Logesh (012 - 503 0346)
- Siti (012 - 383 8603)
- Teo (011 - 3178 9203)
- Phang (03 - 8082 3357)