Attending the course and successfully completing the post-assessment, will grant you
2 hour/s verifiable CPD, recognised by the various
professional bodies (SAICA, SAIBA, ACCA, IACSA, IRBA & etc). Please note that the
CPD certificate will only be issued once the post-assessment has been completed.
Web Based (Online)
Tristan White
0118861395
gillian@probetatraining.co.za
If you or your firm use Excel for multiple hours each day, imagine what the wasteful labour cost must be from using it inefficiently?
ProBeta Training has designed a course for those individuals and offices that are heavily reliant on Microsoft Excel as part of their day-to-day work duties, be it in audit, accounting or office administration.
The goal of this course is to
- Freshen up your Basic Excel knowledge,
- Improve your efficiency and
- Show you alternative ways to get the same things done.
This session focuses on the value-add elements like VLookUps, Pivot Tables, Concatenating text, and Financial formulae, amongst others -- for those with an already established basic-level of Excel knowledge.
Enabling delegates to:
o Enter and edit data in a variety of ways
o Understand complexities of formula referencing
o Introduction to intermediate functionality including Pivot Tables, VLookUps and Financial formulae
• Data Editing: Sorting / filtering / conditional formatting / data validation / Subtotal formula.
• Data Searching: VLookUps / CountIf formula / If statements / Search and Replace text.
• Data Extraction (basic): Flash fill / Text-to-Columns / Concatenate.
• Building Formulae: Cell referencing within formulae i.e. relative and absolute references.
• Financial Functions: PMT, RATE, IPMT, NPV, FV and PV
• Tables / Graphs: Pivot tables.
• Delegates that make use of Microsoft Excel as part of their daily work duties in a receptionist capacity or other administrative area.
• Delegates that are involved in various finance fields including auditing, accounting, taxation and financial management.
• Delegates that prepare reports and need to be able to edit text and numbers.
