PivotTables and Data Analysis with Excel («MEPT»)

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

COURSE
Efficient calculations and visualizations with Microsoft Excel («ME2»)
2 days
• Basel, Berne, Geneva, Lausanne, Virtual Training, Zürich
CHF
1'140.–
Learn more