In this course, you will learn:
- Using pivot tables, you may create versatile data aggregations.
- Pivot charts can be used to visually represent data.
- Calculate margins and other typical ratios using a pivot table computation.
- Slicers in numerous pivot tables can be used to filter data.
- Using formula-based strategies, create aggregate reports.
- Learn about Excel tables and what is their advantage over regular ranges.
- Use a table to filter, sort and see totals.
- See how calculations can be used to add columns to the existing data in Excel table.
- Create our first pivot table.
- Use multiple pivot tables and pivot charts to create our first dashboard.
- Connect multiple slicers to the pivot tables.
- Explore in more depth the full power of pivot tables.
- See how to filter the data shown in the pivot in many ways to achieve interesting subsets of the data.
- Use calculated fields on top of the pivot table to calculate profitability and find anomalies.
- Use formulas to aggregate the data as an alternative to pivot tables for more flexible reporting layouts.
- See how a pivot can use more than one table and introduction to the Excel data table that is described in detail in the more advanced course in these series.