PivotTables and Data Analysis with Excel («MEPT»)

• Cleaning, structuring, filtering and optimising lists for further use
• Summarising, analysing and evaluating data with PivotTable reports
• Visualising data effectively and dynamically using PivotCharts
• Learning the first steps towards dashboards/cockpits

1 Sorting data

• Easy sorting
• Sort by multiple criteria
• Sort by custom criteria
• Sort by colors and cell icons

2 Filter data

• The simple filter
• Extended filter (special filter)

3 PivotTables and PivotCharts

• Requirements
• Static and dynamic areas
• Create a PivotTable report
• Areas of the PivotTable
• Filter pivot data
• Use timelines and slicers to filter data
• Functions in the value range
• Sort data
• Group data
• Analyze values
• Calculated fields
• Function GETPIVOTDATA
• Consolidate data from multiple tables (PowerQuery)
• Customize layout and format
• Conditional Formatting
• Update data
• Pivot charts

4 External data

• From Microsoft Access
• From text files
• From CSV files

Component of the following courses

• From Zero to Hero with Microsoft Excel («MEZH»)

Advanced users, who would like to use the large possibilities of Excel to analyse data.

This is not a beginner course. You should have good Excel skills, especially formulas and functions (IF function, Vlookup, Min, Max, Average, Sum, Count, Counta, etc.)