Excel: Analysing Data
- Bechtle-Nr.: EDU128423
- Type training: Seminar waarbij je persoonl. aanwezig moet zijn, Live online training
- Doelgroep: Gevorderde gebruikers, Leerkrachten, Medewerkers Controlling, Office-gebruikers
- Duur: 1 dag(en)
Kies:
€ 420,99
Brutoprijs: € 509,40 incl. € 88,41 btw
1
Alle informatie op een rij
Type training
Seminar waarbij je persoonl. aanwezig moet zijn, Live online training
Duur
1 dag(en)
Vereisten:
Good basic knowledge of using Excel e.g. Everything covered in the "Excel: Basics" course.
Doel:
You'll get to know Excel as a database tool. You'll search, sort and filter list data and learn how to organise lists into groups. Using PivotTables, you'll create dynamic analyses and statistical reports For Office 2013, 2016, 2019 and O365.
Inhoud:
- Importing and processing data
- Using the sort feature
- Filtering, selecting and extracting data
- Functions to evaluate data and database lists
- Mapping datasets and finding duplicates
- Data tables
- Subtotals and related functions
- Creating and working with pivot tables
- Creating and working with pivot charts
- Filtering pivot tables using slicers
Commentaar:
This training consists of 2 modules that make up the standard content of in-person training, but which can also be booked as half-day webinars.