Practical Fundamentals of Index and Match in Excel and Google Sheets
- 1x (Normal)
About This Class
Index and Match are both reference function in Excel and Google Sheets. If you combine both of these you will create a robust and dynamic two way lookup, to return values that you need.These are functions that should be mastered by every intermediate Excel or Google Sheets user.
In this class you will learn about the Index and Match, the syntax, how it works, and how to combine them in a formula to make a powerful lookup
Paula is a Qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management,Process improvement, Internal Audit, Group accountant, Operations management and Training. All across a broad range of industries and sectors. Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula also has courses for those wishing to up skill, especially in the area of Spreadsheets, Bookkeeping and Accounting.
Now an E-learning Educator 5+ years, Paula also has a focus on E-learning and online teaching. Drawn from her online teaching experience,Paula has a number of courses available to online teachers to help bridge the skills gap for those that teach or wish to teach online.