Microsoft Excel Advanced Course 308 - Pivot tables, 3D Formulas, Advanced Formulas and Protection - EzyLearn MYOB & Xero Short Online Training Courses

~~$69.00~~ $49.00 inc GST

Understand 3D formulas between worksheets
Cleaning up data using advanced filter
Create a pivot table and change the value field settings, create a pivot chart to visually show the stats
Advanced functions like CHOOSE, VLOOKUP, HLOOKUP, MATCH and INDEX
Advanced functions within functions (Nested Functions) and how to protect the worksheet and workbooks.