Home Events Mastering formulas and functions in Excel Session 2
Events

Mastering formulas and functions in Excel Session 2

  • Date: Tuesday, 27 February 2018
  • Time: 1.00pm - 2 30pm
  • Location: CPD Online

Roman Kondratiuk's two value-packed 90 minute sessions will effectively help you understand and work effectively with fundamental powerful calculation and analysis techniques in Excel.

 

This series effectively demonstrates and teaches specific functions, providing the perspective you need to understand the depth and scope of these Excel features.

 

This knowledge is vital in the fields of accounting and financial analysis and is a fundamental skill set in mastering Excel.

 

You will be provided with a comprehensive Learner Guide and practical “real-life” files to practice and explore the content presented. Your knowledge will be reinforced with selected polls, quizzes and Q&A opportunities.

 

You will also receive productivity tips, accelerator tools and shortcuts.

 

INTERMEDIATE FORMULAS & FUNCTIONS

 

- Concatenation – combine text and numbers in 2 or more cells
- VLOOKUP function – lookup and match data efficiently
- PMT function – calculate loan repayments and residuals with ease
- Key text functions – cleanse data from external sources
- Link between worksheets and workbooks – consolidate data from various sources
- Key Date functions – use dates in calculations
- Formula auditing – manage, trace and correct simple and complex formulas
- Shortcuts and tips – to boost your speed and efficiency

Price

Member: $220.00
Non-Member: $260.00
Student: $160.00

*Price above include GST

 

Please note that in order to maintain quality, places to the CPD online events are strictly limited.  Once an event is booked out, AAT will provide you with alternative options including access to a recording and/or the offer of attending other CPD Online events.

 

CPE

1.5 hours

Click here for info on the event

Event Registration Form
  1. Event Name*
    This field must be filled in!
  2. Location*
    Invalid Input
  3. Membership #
    Invalid Input
  4. Membership Body (if other than AAT Australia)
    Invalid Input
  5. Non Member
    Invalid Input
  6. First Name*
    Invalid Input
  7. Surname*
    Invalid Input
  8. Address*
    Invalid Input
  9. Postal Address*
    Invalid Input
  10. Suburb*
    Invalid Input
  11. State*
    Invalid Input
  12. Postcode*
    Invalid Input
  13. Telephone*
    Invalid Input
  14. Email*
    Invalid Input
  15. Special Dietary Requirements (if any)
    Invalid Input
  16. Promotional Code
    Invalid Input
  17. Payment Method*
    Invalid Input
  18. Please debit my credit card the sum of: $*
    Invalid Input
  19. Card Type
    Invalid Input
  20. Card number
    Invalid Input
  21. Expiry date*
    Invalid Input
  22. Cardholder's name*
    Invalid Input
  23. Register

Banner
Banner
Array ( [format] => html [Itemid] => 124 [option] => com_k2 [view] => item [task] => 899:mastering-formulas-and-functions-in-excel-series [id] => 899:mastering-formulas-and-functions-in-excel-series )