Magic bullets with Excel - data validations


Excel is a fantastic tool that is unfortunately poorly used by most Accountants. 

What we’ll be covering:
- data validations – cell value restrictions, drop down list and drop down list variations
- vlookup and hlookups - match related data from different sources, vlookup variations and common uses and problems to overcome
- sumif and sumifs – applying criteria to summing, applying multiple criteria to summing.
- Goal seek – practical examples of applying goal seek in accounting and finance scenarios
- Other magic bullets like keyboard shortcuts, tracing dependents, formula auditing, flash filling

This session will increase your understanding of some key features of Excel and increase your workplace productivity.

  • Webinar Recording
    • PD hours: 1.25
    Stream this recording multiple times at your convenience.
    • $200.00 incl. GST

Coming Soon

All Coming Soon >>


Our webinars operate on a 'one-connection-one-fee' basis so you can have your whole team participate for one cost effective price and claim CPD points.


Like the topic but can’t make the time? Register for the Live Session and you’ll receive the Recording regardless! You can watch it as many times as you like for up to 6 months. You will also receive Supporting Documentation.