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

• Business Intelligence with Excel and PowerBI – Basics («BUINGL»)
• 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
Advanced Techniques in Microsoft Excel («ME2»)
2 days
• Basel, Berne, Geneva, Lausanne, Virtual Training, Zürich
CHF
1'140.–
Learn more