10994: Data Analysis Fundamentals using Excel

Aveiro
03 Out 2018
a 04 Out 2018
Laboral

09h30 - 17h30

Chat

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.

  • 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

Destinatários

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.

Pré-Requisitos

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

Programa

  • Reporting in Excel
  • Excel Tables
  • Pivot Tables and Pivot Charts
  • Dashboards
  • Hierarchies
  • The Excel Data Model
  • Explore an Excel Data Model

Reporting in Excel

  • Filtering and Formatting Data
  • Charts

Excel Tables

  • Excel Data Tables
  • Summarizing Data

Pivot Tables and Pivot Charts

  • Pivot Tables
  • Pivot Charts
  • Editing Pivot Tables and Pivot Charts

Dashboards

  • Creating a Dashboard
  • Data Analysis in Excel Pivot Tables

Hierarchies

  • Hierarchies

The Excel Data Model

  • Using an Excel Data Model
  • External Data
Chat

Quero saber mais informações sobre este curso

10994: Data Analysis Fundamentals using Excel

Base de Dados | 14h - Laboral: 09h30 - 17h30


Notas

Pretende mais informação sobre este curso?

Preencha o formulário com os seus dados e as suas questões e entraremos em contacto consigo para lhe darmos todas as informações pretendidas.

Obrigado!