This Workshop will cover many useful (and some more complex) formula’s that will help you to take your spreadsheets to the next level.
These Workshops should be attempted after Basic / Intermediate & Advanced have been completed.
The Workshops will be delivered 1 Hour each Week.
Content of this workshop
Workshop 1: Trim / Iferror / Substitute / Left / Right / Mid / Len / Find Workshop 2: If Formula (with AND & OR) / Evaluate Formula Workshop 3: Vlookup v Index Match – Introduction to both plus Pro’s & Con’s of each