MS Excel for Accountants & Bookkeepers


CPD hours: 2 Hours

Price: R237.50

Video Type: Single

Presenter: Russel Ngobeni
BAP

Technology

Technology
...

MS Excel for Accountants & Bookkeepers

CPD Hours: 2

Price: R237.50


Back
Title / Topic

MS Excel for Accountants & Bookkeepers

Presenters : Russel Ngobeni


Overview   

MS Excel has come a long way from its early days when it was typically just used for listing numbers and adding them up. It is now an advanced tool that can be used for many tasks such as data management, accounting, budgeting, forecasting, financial modelling, financial analysis, time management, task management, charts and graphs, just to name a few. 

Coming as part of the Microsoft suite of apps (which nearly everyone has on their computer), all accountants and bookkeepers need to learn how to make full use of this spreadsheet program in their work.  


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;  

  • Understand how to use MS Excel in budgeting and forecasting; and 

  • Be able to draft basic management reports using MS Excel. 


Content   

The webinar will cover the following topics:  

  • Data processing and management on MS Excel. 

  • Bookkeeping on MS Excel. 

  • Helpful MS Excel shortcuts. 

  • Budgeting and forecasting using MS Excel. 

  • Processing year-end tasks on MS Excel. 

  • Financial reporting using MS Excel.  

Related Webinars

Technology
...

Getting digitally ready Part 3 (2019) - Webinar on demand


1 Hour
R0.00

Technology
...

Personal and Business Income Tax for bookkeepers


2 Hours
R237.50

Technology
...

Streamline Accounting Workflows with new Technologies


2 Hours
R450.00

Need Help ?

Explore Smarty