Guide to PivotTables in Excel

PivotTables are a very powerful tool to analyse data stored in Excel. In this tutorial we will see all the basics of PivotTables.

To enjoy the full tutorial is advisable to download the following file containing all the examples that are used.

PivotTables
------------------------------------------------------------------------------------------------------------------------


1. What are the PivotTables?

2. How to create a PivotTable

3. Formatting a PivotTable

4. Filtering PivotTables

5. Five cool tricks to PivotTables (coming soon)

6. Advanced Techniques for PivotTables (coming soon)

      1. Able to create monthly, quarterly and annual reports from daily data.
      2. Use the filter reports and generate multiple reports
      3. Slicers in PivotTables