Data Analysis Fundamentals using Excel (10994)

 

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

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
    hardcoded default SA
E-Learning MOC on Demand

Duración 90 días

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
Sep 16, 2019 - Sep 17, 2019 Berlín
Oct 14, 2019 - Oct 15, 2019 Stuttgart
Nov 11, 2019 - Nov 12, 2019 Frankfurt
Dec 2, 2019 - Dec 3, 2019 Muenster
Italia
Nov 14, 2019 - Nov 15, 2019 Milano
Oriente Medio
Emiratos Árabes Unidos
Nov 27, 2019 - Nov 28, 2019 Dubai Lenguaje del curso: Inglés This course is being delivered by iTLS.
Africa
Egipto
Dec 4, 2019 - Dec 5, 2019 El Cairo Lenguaje del curso: Inglés