The Practical Accounting Course
The Only Course You Need to Get Your Accounting Career Started.
The Practical Accounting Course sets out to train students on the practical aspects of Accounting which is fundamentally different from what is taught in school.
The course will focus on the use of MS Excel to prepare financial statements. We will get practical by using source documents to create a profit and loss statement and a balance sheet. You would be taken a journey that would explore how the different books tie and relate to one another. The different elements like the:
- Takings b00k,
- Purchase Day Book
- Petty Cash,
- Sales Day Book
- Withholding taxes
- VAT Trial Balance etc would be looked at deeply. With the knowledge of these areas, you will get a grasp of Accounting and you can easily use what you have just learnt to pass interviews easily.
We will then move to the next stage which is preparing with the same source document the financial statements using a cloud-based software.
The good thing about learning how to use accounting softwares is tat it is easy to transfer that knowledge to quickly learn how to use any other software. The commands/rules are always identical, as all you have to do is to know how whichever one you plan to use operates.
Below are what you will learn while using Excel:
Excel Training Course Content
- Creating worksheets, formatting text
- Simple and complex formulas
- Handling rows and columns
- Average, max and min functions and using charts.
- Use of IF Formula
- Summing Techniques
- Cell References
- Formula Linking
- Tables and Bordering
- Look up References (Vlookup, Hlookup,etc)
- Data Validation
- Conditional Formatting
- Date & Time Formulas
- Charts & Graphs
- Protection & Security
- Creating Pivot Table
- Pivot Table Analysis
I was once in your shoes as a fresh graduate when I had not been exposed to practical accounting. I then paid for a similar program in London and my fortunes changed immediately as I was now confident at interviews and the difference showed.
This course complies with the current realities in the world right now as Covid-19 has made many companies alter the way their staff work as many workers now work remotely. We would be using a cloud-based accounting software