EXCEL Part 2 of 4: Exploring and Creating Formulas – CPD Webinar

R850.00 incl. VAT

Out of stock

10 Discussion Points Excel has powerful formula functionality. The goal of formulas is to automate processes that would require manual execution. Formulas are used to save you time and give you the edge when completing daily tasks.

Join us to explore basic formulas and increase your efficiency with helpful formulas that you will need daily.

The objective of Excel Part 2 is to enable delegates to become comfortable with formulas that are typically used to increase efficiency in a financial environment.

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

Certificate of 3 CPD hours issued on completion of course.

Event organiser: Chantal van Schalkwyk on 021 402 4300 or email chantal@capechamber.co.za

Speaker profile: Yvonne Rossouw


Part 3: Friday, 22 November 2019
Part 4: Friday, 29 November 2019

Event Details

Date: 15/11/2019

Start time: 13:00

End time: 15:00

Venue: Webinar

Phone: 021 402 4300

Email: chantal@capechamber.co.za