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

R850.00 incl. VAT

Out of stock

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.

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 Thysse – chantal@capechamber.co.za

Speaker: Yvonne Rossouw

______________________________________________

Part 3: Friday, 21 February 2020
Part 4: Friday, 28 February 2020

Event Details

Date: 14/02/2020

Start time: 13:00

End time: 15:00

Venue: Webinar

Phone: 021 402 4300

Email: chantal@capechamber.co.za


Category: Tags: ,