Data Analysis Fundamentals using Excel (10994)

Descripcion de Curso Calendario Esquema del Curso
 

Resumen del Curso

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.

Quién debería asistir

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.

Prerrequisitos

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.

Objetivos del curso

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

Contenido del curso

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

Duración 2 días

Precio (sin incluir impuestos)
  • Panama: US$ 450,-
  • Argentina: US$ 450,-
  • Brasil: US$ 450,-
  • Chile: US$ 450,-
  • Colombia: US$ 450,-
  • Costa Rica: US$ 450,-
  • SA Voucher: 2
Fechas y Registro
Entrenamiento en línea
Modality: L
Precio (sin incluir impuestos)
  • Panama: US$ 450,-
  • Argentina: US$ 450,-
  • Brasil: US$ 450,-
  • Chile: US$ 450,-
  • Colombia: US$ 450,-
  • Costa Rica: US$ 450,-
Fechas y Registro
E-Learning MOC on Demand
Modality: P
Precio (sin incluir impuestos)
  • Panama: US$ 250,-
  • Costa Rica: US$ 250,-
Buy E-Learning
 
Presionar el boton sobre el nombre de la ciudad para reservar Calendario
América Latina
Europa
Alemania
Jan 28, 2019 - Jan 29, 2019 Hamburgo
Feb 25, 2019 - Feb 26, 2019 Düsseldorf
Mar 25, 2019 - Mar 26, 2019 Berlín
Apr 29, 2019 - Apr 30, 2019 Stuttgart
May 20, 2019 - May 21, 2019 Frankfurt
Jun 13, 2019 - Jun 14, 2019 Muenster
Italia
Jan 31, 2019 - Feb 1, 2019 Roma
May 23, 2019 - May 24, 2019 Milano
Oriente Medio
Emiratos Árabes Unidos
May 26, 2019 - May 27, 2019 Dubai Lenguaje del curso: Inglés This course is being delivered by iTLS.
Katar
May 26, 2019 - May 27, 2019 Doha Lenguaje del curso: Inglés
Africa
Egipto
May 26, 2019 - May 27, 2019 El Cairo Lenguaje del curso: Inglés