NEED TO UNDERSTAND EXCEL?

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? Then join us for these 4 two-hour webinars where we introduce delegates

to Microsoft Excel.

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 is to enable delegates to become comfortable with formulas that are typically used to increase efficiency in a finance environment.

Content Discussed:

• 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.

MS YVONNE ROSSOUW | B.Com Honours(SA), CA (SA)

Yvonne Rossouw is a CA(SA) with a passion for doing the right thing. With ten years of experience in the auditing and accounting profession, Yvonne applies the knowledge she has obtained towards uplifting and training others. Yvonne started her professional career as an academic clerk at the University of Pretoria, where she was an assistant lecturer to the CTA students. This is where she developed her enthusiasm for teaching and developing others. She completed her articles at BDO South Africa Inc and pursued her dream of training those in the auditing and accounting profession. Yvonne joined ProBeta team in 2015 as a public speaker and consultant, facilitating auditing and legislative courses to a range of different audiences. When she is not presenting, Yvonne consults clients on auditing and accounting matters, as well as compliance with legislation such as FICA and POPI. Yvonne also volunteers on various committees and working groups within IRBA and SAICA to provide input and guidance in the development of the auditing and accounting profession.

Please note that this link is unique to you. Transferring this link to another user is an infringement of copyright. If you have subscribed to a course, the cost is per delegate, not per screen.