[Johor] Essential Excel Skill for Accountants
Course Information
  • 26-Aug-2020
  • Amari Hotel, Johor Bahru
  • Stanley Wong
  • English
  • RM 620 RM 560
    Until 11 Aug 2020
  • 9:00am - 5:00pm
(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) 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

(C) 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

(D) METHODOLOGY
• 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: 26 August 2020 (Wed)
Time: 9AM - 5PM
Venue: Amari Hotel, Johor Bahru

(G) Fee
- Early Bird (before 28 Jul 2020) - RM500
- Special Offer (before 11 Aug 2020) - RM560
- Normal Fee - RM620

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

Discount
15% overriding discount for SST2u Learner 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 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.


(J) ENQUIRY & REGISTRATION

Email: sstcourse@gmail.com
Enquiry:
General (03 - 5888 7357)
Han (019 - 323 0507)
Teo (011 - 3178 9203)
Logesh (012 - 503 0346)
Siti (012 - 383 8603)