Excel 2013 Core: Advanced
This is a free textbook offered by BookBoon.
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