Webinar Training Course

Basic Excel Session 2 - Exploring / Creating Formulae

Price: Firm/Group/Company - R1403.00 (VAT Incl.)
Individuals - R563.50 (VAT Incl.)
Price (MLU Subscriber): Firm/Group/Company - R1052.25 (VAT Incl.)
Individuals - R437.00 (VAT Incl.)
Presenter: Mr Tristan White
Date: 25 Mar '19
Times: 13H00-15H00
Duration: 2
CPD Hours: Attendance at this seminar will secure 2 hour/s verifiable CPD points including other professional bodies (SAICA, SAIBA, ACCA, IACSA & etc)
Platform: Web Based (Online)
Contact Person: Tristan White
T:  0118861395
E:  gillian@probetatraining.co.za
Back Book Now

Excel has powerful formula functionality. The goal of formulae is to automate process that would require manual execution. Formulae are used to save you time and give you the edge when completing daily tasks. Join us as explore basic formulae and attempt to increase your efficiency with helpful formulae that you will need daily in an office space.

Enabling delegates to: o Become comfortable with formulae that are typically used to increase efficiency in a finance space

• Building Formulae: o Exploring available library of formulae within Excel o Cell referencing within formulae ie relative and absolute references o Mathematical operators within Excel o Duplicating (dragging) formulae without retyping o Reviewing formulae o Flash fill (Excel 2013 and later only) • Financial formulae: SUM, SUBTOTAL, MAX, MIN, PMT, IPMT, NPV, IRR, FV and PV

• 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.