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 email@example.com
Speaker profile: Yvonne Rossouw