Microsoft Excel Advanced Course 308 – Pivot tables, 3D Formulas, Advanced Formulas and Protection

$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.

Buy now Read more