Maximizing PivotTable (50448)
Cours disponible en français ou en anglais - Training available in French or in English
Durée: 1 jour
Objectifs du cours :
This 1 day course provides students with the knowledge and skills to use the features and functions of Microsoft Office Excel PivotTable to accomplish analysis tasks.
Compétences acquises :
Les stagiaires seront à même d'effectuer les tâches suivantes :
Connaissances requises :
Before attending this course, students must have:
Cours disponible en français ou en anglais - Training available in French or in English
Durée: 1 jour
Objectifs du cours :
This 1 day course provides students with the knowledge and skills to use the features and functions of Microsoft Office Excel PivotTable to accomplish analysis tasks.
Compétences acquises :
Les stagiaires seront à même d'effectuer les tâches suivantes :
- Maximize the Power of PivotTable
- Determine the source needed for its PivotTable
- Create the PivotTable
- Working with the PivotTable
- Rearrange the layout of the PivotTable
- Adding, renaming New Field within the PivotTable
- Formatting Number in the PivotTable reports
- Changing Sorting Order
- Showing Top 10 values
- Refreshing Source data within the PivotTable
- Display grouping and subtotals for PivotTable
- Formatting PivotTable
- Organize PivotTable through the use of Slicer
- Create a Second Data Field within the PivotTable
- Changing Summary Function
- Displaying Numerical Value as a Percentage of the Total
- Create custom calculation within the PivotTable
- Use Formulas with the PivotTable
- Create a calculated field and item
- Using GetPivotData Function
- Turn off GetPivotData Function
- Creating PivotChart
- Publishing PivotTable to the Web
- Using Multiple Source Ranges to create PivotTable
Connaissances requises :
Before attending this course, students must have:
- Intermediate Excel experience