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.
