• Home
  • Excel for Accounting

Excel for Accounting

Course Information

  • Sessions 1 day
  • Duration 7.5 hrs
  • Level Beginner
  • Assessment NA

Venue

12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715. 5 mins walk from Woodlands (NS9) MRT station.

The venue is disabled-friendly.

Download Course Brochure

Certification

  • Certificate of Completion from Tertiary Courses - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Courses.

Excel for Accounting

Course Code: C104

7 Review(s) | Add Your Review

What's This Course About

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.

Funding Options

No funding is available for this course

Course Fee

$350.00 (GST-exclusive)
$381.50 (GST-inclusive)

Course Date

* Required Fields

Additional Note

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

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.

Cancellation & Reschedule Policy

  • You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commences.
  • We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
  • Note the venue of the training is subject to changes due to availability of the classroom.

Course Details

Course Details

What You'll Learn

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

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

Trainers

Bell Ang is a trainer and consultant with professional expertise in finance, auditing, and corporate governance. Having supported organizations in financial analysis, compliance, and reporting, she brings a practical and governance-focused perspective to financial training. For this program, Bell emphasizes interpreting financial statements through ratio analysis, guiding learners to uncover strengths, weaknesses, and risk factors in business performance. Her sessions highlight real-world applications, preparing participants to make informed financial decisions.

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 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.

Review

Customer Reviews (7)

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/30/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/21/2018)

Items 6 to 7 of 7 total

per page
Page:
  1. 1
  2. 2

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