03 39 25 333
+2 0128 16 2 16 12
- The duration of this course is 32 hours distributed over 16 days
- A computer for each trainee.
At the end of the course, you will be able to work with:
Pivot Tables and Pivot Charts.
- Analyzing data dynamically by using Pivot Tables.
- Filtering, showing, and hiding Pivot Table data.
- Editing Pivot Tables.
- Formatting Pivot Tables.
- Creating Pivot Tables from external data.
- Creating dynamic charts by using Pivot Charts.
- Count cells between dates.
- Count cells between two numbers.
- Count cells equal to.
- Count cells equal to case sensitive.
- Count cells equal to either x or y.
- Count cells equal to one of many things.
- Count cells greater than.
- Count cells less than.
- Count cells not equal to.
- Sum by month.
- Sum by week.
- Sum by week number.
- Sum by weekday.
- Sum if between.
- Sum if by year.
- Sum if cell contains text in another cell.
- Sum if cells are equal to.
- Sum if cells are not equal to.
- Sum if cells contain an asterisk.
- Sum if cells contain specific text.
- Sum if date is between.
- Sum if date is greater than.
- Sum if greater than.
- Sum if less than.
- Sum if not blank.