Financial Wizardry with EXCEL: Essential Skills for Accountants

Course Description

Many asked, “With Power Automate, Power BI, Python, Alteryx, Tableau, etc, what is the value of learning Excel?” Despite the growing popularity of these tools (that address specific purposes or needs), we believe that Excel is still relevant today and it will continue to be in the foreseeable future. Excel is powerful yet flexible, multi-purpose, and therefore, the best tool to bridge the gap between ERP / accounting systems and accountants’ everyday needs. Becoming better in Excel will no doubt improve accountants’ work efficiency.

Becoming good at Excel is not about how many functions you know; it is about how well you can apply the few functions you know (very well) to the context and achieve your objective.

This is a 1-day classroom course designed by an accountant for accountants. We will apply Excel functions and best practices to various accounting scenarios to facilitate compliance with the requirements.

We will explain:

Get to know Excel again—the right mindset
- What is Excel and what it can do for you
- Its strengths and weaknesses
How to train your best assistant, Excel? – make it your buddy, not your enemy
- Design Approach
- Good practices
- Do’s and don’ts
- Common pitfalls
- Fix the laggy spreadsheets
Everything about Excel that accountants need to know
- The most useful shortcuts
- Commonly used functions for accountants
- Cell formatting
- PivotTables
Apply what you know—the case studies (you are encouraged to build the spreadsheets together)
- Prepare financial statements or management accounts
- Lease schedules (based on IFRS 16 requirements for lessees)
- Prepayment schedule
- Budget and forecast
- Financial analysis
- If you are a reviewer, how you can train Excel to make your life easier

To Enroll

Email: stsacademia@gmail.com

Mike Ng

Finance & Microsoft EXCEL Expert

Mr. Mike Ng, ACA, BFP, CA (Singapore), is a Microsoft Excel Expert. He is a passionate accountant and an Excel enthusiast, with more than 10 years of accounting experience and more than 25 years of Excel experience. He started his career as an external auditor at a Big 4 public accounting firm and managed a big portfolio consisting of clients from the real estate, hospitality, manufacturing, and trading industries. In his most recent appointment as a financial controller of a commercial firm, he spearheads the full spectrum of finance functions. Apart from his wealth of finance experience, he is involved in ERP implementation projects. He has also conducted numerous in-house training in his previous roles.