Few Excel functions warrant their own course – INDIRECT does. It can allow you to do things that no other function can do. It is often the function of last resort as it allows you to use text to create cell references and solve difficult issues.
The outcomes from this session will be
- learning the basics of the INDIRECT function
- discovering a common problem with sheet references and how to fix them
- seeing how to extract data from structured and unstructured data
- finding out the power and flexibility of using ranges names with the INDIRECT function
- learning how to link one data validation list to another
As always, you will discover a few other tips during the session.
Level: Intermediate
Duration: 1 hour
Price: AU$25