10994B | Data Analysis Fundamentals using Excel
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.
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:
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Advanced working knowledge of Excel spreadsheets including formulas.
At course completion:
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
COURSE OUTLINE:
Module 1: Reporting in Excel
Module 2: Excel Tables
Module 3: Pivot Tables and Pivot Charts
Module 4: Dashboards
Module 5: Hierarchies
Module 6: The Excel Data Model
10994B | Data Analysis Fundamentals using Excel
Duración 2 días Versión 2016 Temario Descarga aquí ⇩ Fechas Microsoft Consultar Métodos de entrega 👤 💻