There’s a reason why Excel is the most widely used spreadsheet in the world: it’s designed to help you work more quickly, efficiently and effectively. Of course, to truly tap into the awesome power of Excel, you need to know more than the basics. Discover the secrets of the incredibly practical PivotTables tools in this course. Do you want to take your Excel skills even further? Follow up this course with another one from the range of Excel courses at Cevora.
- Training type
- Duration of training
- Available languagesEN
- Training code
You would like to work more efficiently with Excel PivotTables.
You have a basic knowledge of Excel.
- Creating a PivotTable;
- PivotTable formatting;
- Modifying and grouping data;
- Adding a second sequence of values;
- The ‘Show values as’ tool;
- Filtering and sorting;
- Custom formulas, calculated fields and items;
- PivotTables based on multiple source tables;
- Conditional formatting in a PivotTable;
- PivotTable options;
- Field settings.