by accountant for accountants

Date & time: Friday, 17 November 2023

Venue: to be confirmed

“If you can teach, Excel can do.”

This practical Excel course, led by an accountant, is specifically designed for accountants who want to improve their Excel skills and learn how to apply them to their daily work. The course will cover a range of Excel functions and best practices, including preparation of financial statements, balance sheet schedules, etc., tailored to the needs of accounting professionals.

Participants will learn how to use Excel to streamline their daily tasks, reduce manual efforts, and minimize errors. The course will include practical exercises and case studies that are relevant to auditing work, providing participants with the opportunity to apply their Excel skills to real-world situations.

By the end of the course, participants will have a solid foundation in Excel and will be able to apply it more effectively and efficiently to their daily work. The trainer’s experience as accountant ensures that the course content is relevant, practical, and geared towards the unique needs of accountants.

Why

“Knowing Excel functions is one thing, applying it to the right context is another.”

This course is conducted by an Excel enthusiast accountant, who understands your needs and challenges, as well as the solutions. Through the practical use cases in audit context, you will learn how to apply the right Excel functions to the right context.

What

• Get to know Excel again—the right mindset
  • What is Excel? Why Excel
  • What Excel can do for you?
  • Excel’s strength and weaknesses
  • The limits of Excel
  • Why spreadsheets fail you?
  • What makes a good spreadsheet designer
• How to train your best assistant, Excel?
  • 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
  • Workbook structure
  • Commonly-used functions for accountants (arithmetic, logical, lookup, discounting)
  • Formula nesting
  • Cell formatting
  • Cell referencing
  • PivotTables
• Practical use cases
  • Schedules for financial instruments at amortised cost (determine implicit rate, present value, amortisation schedule, segregating current and non-current)
  • Prepare financial statements / management accounts
  • Balance sheet schedules – open items & movements

Participants are required to bring along their laptops with Excel installed (preferably Office 365—app version, at least Excel 2013).

Who

This Excel course is ideal for accountants who want to improve their Excel skills and learn how to apply them to their daily tasks. To get the most value out of this course, have at least 1 year of experience in using Excel at work as an accountant.