Principes fondamentaux de l’analyse de données à l’aide d’Excel | ||
| Langue : FR | Référence : 10994 | Durée : 2 jours |
| Formation à distance ou en vos locaux. | Prix : 790.00 € (Euro) | |
Ainsi, un grand nombre de nos formations propose une réduction tarifaire.
Veuillez nous contacter pour plus de renseignements.
After completing this course, students will be able to:
- Create an Excel report
- Create an Excel table
- Create a pivot table and pivot chart
- Create a dashboard and analyze data
- Create Hierarchies
- Create an Excel data model and connect to external data
About this course:
The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.
Course Outline
Module 1: Reporting in Excel
This module explains how to create a report in Excel
After completing this module, students will be able to:
- Filter and format data.
- Create charts.
Module 2: Excel Tables
This module explains how to create data tables in Excel
After completing this module, students will be able to:
- Explain what Excel Data tables are.
- Sort, filter, and validate data.
- Summarize data.
- Format summarized data.
Module 3: Pivot Tables and Pivot Charts
This module describes pivot tables and pivot charts and how to work with them.
After completing this module, students will be able to:
- Describe pivot tables and how to create them.
- Describe the various elements of a pivot chart.
- Edit pivot tables and pivot charts.
Module 4: Dashboards
This module describes Excel dashboards, how to create them and the role in data analysis in Excel pivot tables.
After completing this module, students will be able to:
- Describe a dashboard.
- Filter data using a slicer.
- Add calculated columns to a dashboard.
- Find anomalies.
Module 5: Hierarchies
This module describes hierarchies and time data.
After completing this module, students will be able to:
- Describe hierarchies.
- Create levels within a hierarchy.
- Explain why time data is different and how to work with it.
Module 6: The Excel Data Model
This module explores the Excel data model and looks at ways of extending it.
After completing this module, students will be able to:
- Explain an Excel Data Model and how to use it.
- Import External Data and use it.
- Link out to external data.
Audience profile:
This course is intended for anyone who wants to take the data analysis technologies in Excel beyond formulas and add more advanced capabilities such as dashboards, hierarchies, and relationships.
Prerequisites:
Before attending this course, students must have:
Basic knowledge of the Microsoft Windows operating system and its core functionality.
Advanced working knowledge of Excel spreadsheets including formulas.