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

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.)

This course is suitable for users of Excel 365, 2019 and 2016.