Material Detail

Excel 2016 Advanced

Excel 2016 Advanced

This user guide will introduce you to some of Excel’s more complex functionality. Specifically when analysing data.

You will learn how to:

  • Use Conditional Logic in a formula – IF statements
  • Use the SumIF and CountIF functions
  • Produce a chart
  • Sort and filter
  • Apply subtotals
  • Introduction to Pivot Tables
  • Introduction to Macros
Rate

Quality

More about this material

Browse...

Disciplines with similar materials as Excel 2016 Advanced

Comments

Log in to participate in the discussions or sign up if you are not already a MERLOT member.