Cart
You have no items in your shopping cart
Data Analysis Fundamentals using Excel M10994 In-company
Data Analysis Fundamentals using Excel M10994 In-company
€1.999,00

Cheaper somewhere else?

Let us know!

+31367601019 info@officeelearningmenu.nl

Data Analysis Fundamentals using Excel M10994 In-company

Click to enlarge
€1.999,00 Excl. tax
€2.418,79 Incl. tax
Maak een keuze: *
In stock
You have got counting... hours
  • MOS Master gecertificeerde docenten
  • Award winning e-learning
  • E-learning, na betaling, direct starten
Information

Training Data Analysis Fundamentals using Excel M10994 In-company
The main goal of the course is to give students the opportunity to add analytics to Excel spreadsheets and to provide students with a basis to learn about more advanced data analysis with Excel or Power BI.

Target audience
This course is intended for anyone who wants to use data analysis technology in Excel further than formulas and adds more advanced functions such as dashboards, hierarchies and relationships.

Training objectives
After completing this course, students can:

Create an Excel report
Create an Excel table
Make a pivot table and pivot table
Create a dashboard and analyze data
Create hierarchies
Create an Excel data model and connect to external data


Course content Training Data Analysis Fundamentals using Excel M10994 In-company


Module 1: Reporting in Excel

This module explains how to create a report in Excel

Filter and format data
Graphs
Lab: create an Excel report

Filtering Excel data
Format Excel data
Create Excel charts
After completing this module, students can:

Filter and format data.
Make charts.
Module 2: Excel tables

This module explains how data tables are created in Excel

Excel data tables
Summarize data
Lab: create an Excel table

Create an Excel table
Summarize Excel data
After completing this module, students can:

Explain what Excel data tables are.
Sorting, filtering and validating data.
Summarize data.
Formula summarized data.
Module 3: pivot tables and pivot charts

This module describes pivot tables and pivot tables and how to work with them.

Pivot tables
Pivot tables
Edit pivot tables and pivot charts
Lab: Import data from a CSV file

Create a pivot table
Create a pivot table
Edit pivot tables and pivot charts
After completing this module, students can:

Describe pivot tables and how to make them.
Describe the different elements of a pivot chart.
Edit pivot tables and pivot tables.
Module 4: Dashboards

This module describes Excel dashboards, how to create them and the role in data analysis in Excel pivot tables.

Create a dashboard
Data analysis in Excel pivot tables
Lab: create a dashboard

Organize tables and graphs
Cut out data
Data analysis
After completing this module, students can:

Describe a dashboard.
Filter data using a slicer.
Add calculated columns to a dashboard.
Search for anomalies.
Module 5: Hierarchies

This module describes hierarchies and time data.

hierarchies
Time data
Lab: create hierarchies

Create a hierarchy
Configure time data
Create an animated time graph
After completing this module, students can:

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 examines the Excel data model and examines ways to expand this.

Use an Excel data model
External data
Lab: explore an Excel data model

Add multiple tables
Creating relationships
Add external data
After completing this module, students can:

Explain and use an Excel data model.
Import and use external data.
Link to external data.

 

 

 

Heeft u niet gevonden wat u zocht?
Let us help!
Specifications
Product
Tax:21%
Colli:1
General properties
:
:
:
:
:
:
:
:
:
:
:
:
:
Reviews
average of 0 review(s)
No reviews found
Read or write a review
Write a review




Please accept cookies to help us improve this website Is this OK? Yes No More on cookies »