MS Excel for bookkeepers
Presenters : Russel Ngobeni
Learning objectives
By the end of this event the participant should:
- Understand how to perform the bookkeeping to trial balance function on MS Excel;
- Understand how to format MS Excel worksheets so that data processing is quicker;
- Understand how to use MS Excel shortcuts to fast-track data processing; and
- Be able to draft basic management reports (Profit and Loss, Balance Sheet, etc.) using MS Excel.
Content
The webinar will cover the following topics:
- Processing sales & purchases journals on MS Excel.
- How to process cashbooks on MS Excel.
- Processing year-end journals on MS Excel.
- How to do basic VAT calculations on MS Excel.
- Basic payroll calculations on MS Excel.
- Preparing management reports on MS Excel.
Related Webinars
Back to Basics Companies Act Series - 5: Being a Director - Rights, obligations and responsibilities
1 Hour
R195.00
Drafting Companies Act Compliant Financial Statements (including COVID-19)
4 Hours
R287.50