Price:
R345.00 (VAT Incl.)
Level:
Business Professionals
Sub-level:
Microsoft
Lecturer:
Tristan David-Crewe White
Duration:
90 Minutes
Additionals:
R345.00 (VAT Incl.)
Level:
Business Professionals
Sub-level:
Microsoft
Lecturer:
Tristan David-Crewe White
Duration:
90 Minutes
Additionals:
CPD Assessment
Certificate
Certificate
Lesson Outline
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.
• 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
Join us as explore basic formulae and attempt to increase your efficiency with helpful formulae that you will need daily in an office 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