Discover how to add decision making structures into your spreadsheets to make them more flexible. There’s a lot more to learn than just the IF function.
The session covers
- using logic calculations without the IF function
- validations
- the IF, AND as well as the OR functions
- nesting IF functions and formula shortening techniques
- working with parameters for reasonableness checks
- error handling
- IS functions
- New IFS function
As always, you will also pick up a few tips and tricks along the way.
Level: Intermediate
Duration: 1.25 hours
Price: AU$25