VOGATE
Excel Novice (Session 2)
Do you want Excel training?
Are you new to Excel or have very little or no knowledge of how to even begin? Do your staff struggle with spreadsheets, formulas and sorting data? Join us for session 2 of the Excel Series Online Course.
SESSION 2 - EXPLORING AND CREATING FORMULAS
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 as explore basic formulas and attempt to increase your efficiency with helpful formulas that you will need daily in an office space.
The objective of SESSION 2 Excel training is to enable delegates to become comfortable with formulas that are typically used to increase efficiency in a finance environment.
Excel isn’t only about data entry. It gives the ability to visualize and manipulate data. It also helps you clean up data, analyze information, and balance accounts.
Building formulas
Exploring available library of formulae within Excel
Cell referencing within formulas i.e. relative and absolute references
Mathematical operators within Excel
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.
Excel Novice (Session 2)
Do you want Excel training?
Are you new to Excel or have very little or no knowledge of how to even begin? Do your staff struggle with spreadsheets, formulas and sorting data? Join us for session 2 of the Excel Series Online Course.
SESSION 2 - EXPLORING AND CREATING FORMULAS
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 as explore basic formulas and attempt to increase your efficiency with helpful formulas that you will need daily in an office space.
The objective of SESSION 2 Excel training is to enable delegates to become comfortable with formulas that are typically used to increase efficiency in a finance environment.
Excel isn’t only about data entry. It gives the ability to visualize and manipulate data. It also helps you clean up data, analyze information, and balance accounts.
Building formulas
Exploring available library of formulae within Excel
Cell referencing within formulas i.e. relative and absolute references
Mathematical operators within Excel
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.