Course Description

•This course is designed for Excel beginners, especially for those who want to explore new interests or learn a new skill.

•Step-by-step guide to take you through the entire learning process.

•This course mainly covers on how to calculate break-even in 3 steps (step-by-step approach), or we can summarize 3-step process into just one single step (or one-click of a button). Then, we will also create a break-even table that automatically changes/updates itself whenever the assumptions are changed. (Please watch the Preview video)

Instructor

•I am Dennis, and a chartered accountant

•I am using Microsoft Excel almost everyday. Therefore, I would like to share my experience and tricks with you.

•In the past few years, I have completed a few projects solely using Microsoft Excel.

Objectives

•Calculate break-even points to improve business decisions and bottom line (your profit)

•Even if you don’t need it for work, it could still be fun to learn

What will you learn:

•You will first learn how to read a basic Profit and Loss Statement (just in case you do not know)

•Calculating break-even in quantity, selling price and cost with macros.

•Creating buttons, controlling visibility of buttons and assigning macros to buttons.

•Merging macros.

•In the end, you will be able to calculate break-even points with just one (or few) click of button.

•And more!