Data Analysis Fundamentals using Excel (10994)

Descrizione del Corso Schedulazione Contenuti del Corso
 

Chi dovrebbe partecipare

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.

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.

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

Contenuti del Corso

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.

  • Reporting in Excel
  • Excel Tables
  • Pivot Tables and Pivot Charts
  • Dashboards
  • Hierarchies
  • The Excel Data Model
Formazione in Aula
Modality: C

Durata 2 Giorni

Prezzo (IVA esclusa)
  • Italia: 710,- €
Date e prenotazione
 
Clicca sulla città per iscriverti Schedulazione
Europa
Italia
23.05. - 24.05.2019 Milano
05.09. - 06.09.2019 Roma
14.11. - 15.11.2019 Milano
Svizzera
01.07. - 02.07.2019 Zürich
Germania
29.04. - 30.04.2019 Stuttgart
20.05. - 21.05.2019 Francoforte
13.06. - 14.06.2019 Münster
01.07. - 02.07.2019 Monaco
22.07. - 23.07.2019 Amburgo
19.08. - 20.08.2019 Düsseldorf
16.09. - 17.09.2019 Berlino
14.10. - 15.10.2019 Stuttgart
11.11. - 12.11.2019 Francoforte
02.12. - 03.12.2019 Münster
Medio Oriente
Emirati Arabi
26.05. - 27.05.2019 Dubai Lingua Corso: Inglese This course is being delivered by iTLS.
27.11. - 28.11.2019 Dubai Lingua Corso: Inglese This course is being delivered by iTLS.
Qatar
26.05. - 27.05.2019 Doha Lingua Corso: Inglese
Africa
Egitto
26.05. - 27.05.2019 Cairo Lingua Corso: Inglese
04.12. - 05.12.2019 Cairo Lingua Corso: Inglese
 

I cookies ci aiutano a fornirti un servizio adeguato. Utilizzando i nostri servizi acconsenti all'utilizzo dei cookies.   Acconsento.