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
How to use an automated online lead generation funnel to get 2 new clients a month - Webinar on demand
0 Hour
R0.00
Important Considerations With Respect to Long Association with an Audit and Review Client
2 Hours
R450.00