Data Analysis Fundamentals using Excel [M10994]

Tijdsduur
Startdatum en plaats
Logo van Global Knowledge Network Netherlands B.V.
Opleiderscore: starstarstarstarstar_border 8,1 Global Knowledge Network Netherlands B.V. heeft een gemiddelde beoordeling van 8,1 (uit 21 ervaringen)

Tip: meer info over het programma, startdatum, prijs, en inschrijven? Download de brochure!

Startdata en plaatsen

Nieuwegein (Iepenhoeve 5)
2 sep. 2019 tot 3 sep. 2019
check_circle Startgarantie
Nieuwegein (Iepenhoeve 5)
14 okt. 2019 tot 15 okt. 2019
Amsterdam (Kingsfordweg 43)
25 nov. 2019 tot 26 nov. 2019
Zoetermeer (Centrum West 21)
6 feb. 2020 tot 7 feb. 2020
Amsterdam (Kingsfordweg 43)
29 apr. 2020 tot 30 apr. 2020
Nieuwegein (Iepenhoeve 5)
4 jun. 2020 tot 5 jun. 2020

Beschrijving

OVERVIEW

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.

OBJECTIVES

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

AUDIENCE

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.

Lees de volledige beschrijving

Veelgestelde vragen

Er zijn nog geen veelgestelde vragen.  

Nog niet gevonden wat je zocht? Bekijk deze onderwerpen: Data analytics, Data Analyse Excel, Excel, Big Data en Data analyse.

OVERVIEW

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.

OBJECTIVES

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

AUDIENCE

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.

CONTENT

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.

Bij Global Knowledge worden de klassikale trainingen gegeven door trainers die ook werkelijk expertise hebben: hooggekwalificeerde instructeurs die allen een pedagogische achtergrond hebben en hun praktijkervaring meenemen naar het klaslokaal. Trainers bij Global Knowledge hebben oog voor de persoonlijke leerstijlen om zo de trainingservaring van de cursisten te optimaliseren.

Blijf op de hoogte van nieuwe ervaringen

Er zijn nog geen ervaringen.

Deel je ervaring

Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.

Er zijn nog geen veelgestelde vragen.  

Download gratis en vrijblijvend de informatiebrochure

Aanhef
(optioneel)
(optioneel)
(optioneel)
(optioneel)
infoEr is een telefoonnummer vereist om deze informatieaanvraag in behandeling te nemen. (optioneel)
(optioneel)
(optioneel)
(optioneel)

Heb je nog vragen?

(optioneel)
We slaan je gegevens op om je via e-mail en evt. telefoon verder te helpen.
Meer info vind je in ons privacybeleid.