10994B | Data Analysis Fundamentals using Excel

 

About this course:

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.

 

Audience profile:

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.

 

Prerequisites:

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Advanced working knowledge of Excel spreadsheets including formulas.

 

At course completion:

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

 

COURSE OUTLINE:

Module 1: Reporting in Excel

Module 2: Excel Tables

Module 3: Pivot Tables and Pivot Charts

Module 4: Dashboards

Module 5: Hierarchies

Module 6: The Excel Data Model

 

10994B | Data Analysis Fundamentals using Excel

SKU: MICROSOFT-10994B
NETEC
DESCUENTOS Y PAGOS
Suscríbase a nuestro newsletter
  • Facebook Netec
  • Twitter Netec
  • Linkedin Netec
  • Youtube Netec
  • Instagram Netec

Copyright 2019 Netec. Todos los derechos reservados.