Тренинги
- Cisco»
- Huawei
- Red Hat»
- NetApp»
- VMware»
- Fortinet
- Microsoft»
- Juniper»
- Amazon Web Services»
- Citrix»
- Arista
- SUSE
- Kaspersky Lab
- Aruba»
- ITIL®»
- Python
- Barracuda
- Brocade
- CWNP
- Gigamon
- Google Cloud»
- IBM»
- NotSoSecure
- Palo Alto Networks
- Ruckus
- Wireshark
- Экспресс-аудит
- Цифровая экономика»
- Бизнес-тренинги
- Программирование
- Облачные технологии
- Управление проектами
MS-10994
Classroom training
Длительность 2 дня
Цена
- Россия: Цена по запросу
-
SA Voucher:
2
hardcoded default SA
Online training
Длительность 2 дня
Цена
- Цена по запросу
-
SA Voucher:
2
hardcoded default SA
Currently no online training dates

Data Analysis Fundamentals using Excel (10994)
Программа курса
Module 1: Reporting in Excel
This module explains how to create a report in Excel
Lessons
- Filtering and Formatting Data
- Charts
Lab: Create an Excel report
- Filtering Excel Data
- Formatting Excel Data
- Create excel Charts
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
Lessons
- Excel Data Tables
- Summarizing Data
Lab: Create an Excel Table
- Create an Excel Table
- Summarize Excel Data
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.
Lessons
- Pivot Tables
- Pivot Charts
- Editing Pivot Tables and Pivot Charts
Lab: Importing Data from a CSV File
- Creating a Pivot Table
- Creating a Pivot Chart
- Editing Pivot Tables and Pivot Charts
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.
Lessons
- Creating a Dashboard
- Data Analysis in Excel Pivot Tables
Lab: Create a Dashboard
- Arranging Tables and Charts
- Slicing Data
- Data Analysis
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.
Lessons
- Hierarchies
- Time Data
Lab: Creating Hierarchies
- Create a Hierarchy
- Configure Time data
- Create an Animated Time Chart
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.
Lessons
- Using an Excel Data Model
- External Data
Lab: Explore an Excel Data Model
- Add Multiple Tables
- Create Relationships
- Add External Data
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.