Material Detail

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

*NOTE: Can read for free for 30 days. Otherwise, cost is $8.99. Join for $5.99 per month.

This will delete the comment from the database. This operation is not reversible. Are you sure you want to do it?

Thank you for reporting a broken "Go to Material" link in MERLOT to help us maintain a collection of valuable learning materials.

If you feel this material is inappropriate for the MERLOT Collection, please click SEND REPORT, and the MERLOT Team will investigate. Thank you!

You are being taken to the material on another site. This will open a new window.

Do not show me this again