Call +65 6100 0613 Email: enquiry@tertiaryinfotech.com

Enhance Your Employability with Certified Skills and Courses in Singapore - WSQ , IBF-STS, Skills Certification

Excel for Accounting

Gain a competitive edge in the accounting field with our comprehensive Excel for Accounting course. Designed for professionals seeking to enhance their financial analysis and reporting skills, this course covers key aspects such as creating robust financial models, automating repetitive tasks, and generating error-free financial reports. Through hands-on training, participants will master advanced Excel functions like VLOOKUP, PivotTables, and macros, ensuring they can efficiently handle large datasets and complex calculations.

This course also delves into budgeting and forecasting techniques using Excel, enabling accountants to provide insightful financial advice and strategic decision support. By the end of the program, participants will be equipped with the skills to streamline financial processes, improve data accuracy, and contribute significantly to their organization's financial health.

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

Funding and Grant Applications

No funding is available for this course

Course Code: C104

Course Booking

The course fee listed below is before subsidy/grant, if applicable. We will apply for the grant and send you the invoice with nett fee.

$300.00 (GST-exclusive)
$327.00 (GST-inclusive)

Course Date

* Required Fields

Post-Course Support

We provide free consultation related to the subject matter after the course. Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts and get back to you asap.

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.


Course Details

Topic 1 Major Tasks in the Accounting

  • Basics of accounting
  • Cash flow budgeting
  • Profit and Loss

Topic 2 Financial Analysis Using Excel

  • Quarterly profit and loss tracking in Excel
  • Taxes and Excel record-keeping
  • Tracking business performance in Excel
  • Pivot tables for accountants
  • Corporate financial statements in Excel
  • Financial statement links in Excel
  • Key corporate accounting ratios

Topic 3 Business Valuation in Excel

  • Historical statements to forward projections
  • Terminal values in Excel
  • Constructing a business valuation using cash flow analysis
  • KPIs and Excel
  • Waterfall charts in Excel
  • Using financial ratios in Excel
  • Variances in Excel
  • Using Excel for regressions

Course Info

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

Minimum Entry Requirement

Knowledge and Skills

  • Able to operate using computer functions
  • Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

  • Positive Learning Attitude
  • Enthusiastic Learner

Experience

  • Minimum of 1 year of working experience.

Target Age Group: 18-65 years old

Minimum Software/Hardware Requirement

Software:

TBD

Hardware: Window or Mac Laptops

Job Roles

  • Financial Analyst
  • Accountant
  • Budget Analyst
  • Audit Specialist
  • Accounts Payable Specialist
  • Accounts Receivable Clerk
  • Financial Controller
  • Tax Specialist
  • Treasury Analyst
  • Cost Accountant
  • Payroll Administrator
  • Credit Analyst
  • Financial Planner
  • Risk Analyst
  • Compliance Officer
  • Management Accountant
  • Internal Auditor
  • Corporate Finance Analyst
  • Investment Analyst
  • Business Analyst

Trainers

Bell Ang Chai Huat: Bell Ang is a ACTA certified trainer. Bell Ang is a Certified Practicing Accountant, member of CPA Australia. Approved mentor of Singapore Accountancy Commission. She is an ACTA Certified trainer and Xero Certified Advisor.

With more than 40 years working experience, Bell has held positions both in the Accounting/Finance and IT consultancy positions in various industries.
As an IT consultant, Bell specialises in the financial systems for example, Oracle financial, Scala. She has successfully led and handled more than 20 projects with full implementation and conducted several in-house and clients' trainings.

Gary Chan: Gary Chan is a ACTA certified trainer. Gary Chan is a Chartered Accountant (ACCA, UK) and a member of the Institute of Singapore Chartered Accountants (ISCA). He has a MBA in International Business from Henley University (UK) and a Master degree in Strategic Marketing (Ireland). He is an ACTA certified trainer.

Gary has more than 20 years in business and financial management responsibilities in multinationals and local SMEs and more than 10 years’ experience of teaching/training/consulting in financial, business management & development, sales and marketing and leadership.

Malcolm Soo: Malcolm Soo is a ACTA certified trainer. He is a chartered Accountant. Have more than 20 years Accounting/Tax Experience. Currently, a freelance accountant and trainer for the following: LCCI 1 & 2, Accounting for Non-Financial Professional and QuickBook.

Customer Reviews (6)

will recomnend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 11/15/2024)
Steven is a very knowledgeable instructor. Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Steven is a very knowledgeable instructor. He makes his lesson lively and he can explain complicated terms with simple layman terms so that it’s easier for me who is a complete beginner to grasp the concepts. He is quite experienced in REITs and he could quote many interesting examples to substantiate his teaching. Would definitely recommend others to attend his course and hope to attend any of his future courses. Thank you Steven! (Posted on 10/26/2022)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 9/15/2020)
A great learning start for REIT investment Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
A course provides me with basic required knowledge to understand different sectors of REITs and methodologies to identify good ones to invest. (Posted on 10/10/2019)
course is great Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
trainer steven is knowledgeable and experienced. Very clear and patient in explaining concepts of REITS. I learnt a lot from his teachings and experience. Very good overall (Posted on 5/31/2019)
Might Recomemnd Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
More hands on exercise and detailed

Everything is good. Very basic in nature. (Posted on 6/22/2018)

Write Your Own Review

You're reviewing: Excel for Accounting

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
  • Reload captcha
    Attention: Captcha is case sensitive.

You May Be Interested In These Courses

WSQ - Data Analytics with Excel

WSQ - Data Analytics with Excel

97 Review(s)
$720.00 (GST-exclusive)
$784.80 (GST-inclusive)
WSQ - Accounting for Non-Finance Managers

WSQ - Accounting for Non-Finance Managers

17 Review(s)
$800.00 (GST-exclusive)
$872.00 (GST-inclusive)
WSQ - Statistical Data Analysis with Excel for Beginners

WSQ - Statistical Data Analysis with Excel for Beginners

62 Review(s)
$350.00 (GST-exclusive)
$381.50 (GST-inclusive)
WSQ – Software Automation with Excel VBA Programming

WSQ – Software Automation with Excel VBA Programming

54 Review(s)
$750.00 (GST-exclusive)
$817.50 (GST-inclusive)
WSQ - Create Interactive Dashboard Using Excel

WSQ - Create Interactive Dashboard Using Excel

50 Review(s)
$350.00 (GST-exclusive)
$381.50 (GST-inclusive)
WSQ - Python Programming for Finance

WSQ - Python Programming for Finance

25 Review(s)
$1,000.00 (GST-exclusive)
$1,090.00 (GST-inclusive)