V.le P.A. Pirelli 6, Milano - academy@digi.it - 0269438264

Corsi Microsoft

Cerca un corso

Data Analysis Fundamentals using Excel

Codice corso: 10994B
Durata corso: 2gg

Introduzione

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.

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.

Obiettivi del corso

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

Prerequisiti

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.

Struttura del Corso

MODULE 1: Reporting in Excel

This module explains how to create a report in Excel

Lessons

After completing this module, students will be able to:

Filter and Format Data

Create charts

Lab : Create an Excel report

MODULE 2: Excel Tables

This module explains how to create data tables in Excel

Lessons

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

Lab : Create an Excel Table

MODULE 3: Pivot Tables and Pivot Charts

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

Lessons

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

Lab : Importing Data from a CSV File

MODULE 4: Dashboards

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

Lessons

After completing this module, students will be able to:

Arranging Tables and Charts

Data Analysis in Excel Pivot Tables

Filter Data Using a Slicer.

Creating a Dashboard

Add calculated columns to a dashboard.

Find anomalies.

Arranging Tables and Charts

Lab : Create a Dashboard

MODULE 5: Hierarchies

This module describes hierarchies and time data.

Lessons

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

Configure Time data

Create an Animated Time Chart

Lab : Creating Hierarchies

MODULE 6: The Excel Data Model

This module explores the Excel data model and looks at ways of extending it.

Lessons

After completing this module, students will be able to:

Explain an Excel Data Model and how to use it

Add Multiple Tables

Create Relationships

Add External Data

Link out to external data

Lab : Explore an Excel Data Model

P.IVA 06249920965
C.C.I.A.A. REA: MI - 1880014
Cap. Soc. € 12.000,00

Contatti

V.le P.A. Pirelli 6,20126 Milano
Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo.
Tel.: +39 02 694 382 64
Fax.: +39 02 694 382 35

© Copyright 2020 DI.GI. Academy
Privacy Policy | Cookie Policy