Excel - Introduction to reporting with contingency table

You can create your own calculations in the PivotTable using calculation fields. Do you calculate the percentage expression? There is nothing easier than calculating percentages directly in the report using the built-in tool. For better telling ability, visualization can be delivered using conditional formatting.

Before creating a PivotTable, many users spend time editing the source data — joining multiple files together with the FIND function, removing duplicates and blank rows, or rewinding rows to columns to get the database form of the table. With Power Query, you can prepare the perfect data source for your PivotTable in almost one click.

Knowledge of Excel at a basic level.

To all Excel users.

Data source for PivotTables

• basic rules for a data source

PivotTable

• explanation of building a PivotTable model
• setting aggregation functions
• report filtering
• graphic filters - cross sections & timelines

Pivot chart

• creating a chart
• chart adjustment

• Know and edit data sources for PivotTables.
• Create, set up, and modify a PivotTable.
• Creating and editing a PivotChart.