About this course
This 1-day classroom course provides attendees with practice in creating sophisticated Logical and Lookup functions where multiple functions are nested togehter to achive more sophistication than single functions.
What you will learn
Nested Functions - I.E.
- IF with IF
- IF with AND/OR
- INDEX & MATCH
- VLOOKUP with MATCH
Recent reviews
A good session, with helpful insight into google sheets functionality. The pivot table section was useful to understand how to do those compared to Excel. And some of the shortcuts, like displaying formulas were great tips.
Jon T28 Oct 20
Thought this was a bit repetitive to the intermediate course.
Annabel C28 Oct 20