MOC 10994: Data Analysis Fundamentals using Excel

Seminarinformationen

Seminar - Ziel

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.

Teilnehmer - Zielgruppe

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.

Kurs - Voraussetzungen

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.

Seminardauer

  • 2 Tage
  • 09:00 Uhr bis 17:00 Uhr

Schulungsunterlagen

  • nach Absprache

Seminar-Inhalt / Agenda

Module 1: Reporting in Excel

  • Filtering and Formatting Data
  • Charts

Module 2: Excel Tables

  • Excel Data Tables
  • Summarizing Data


Module 3: Pivot Tables and Pivot Charts

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

Module 4: Dashboards

  • Creating a Dashboard
  • Data Analysis in Excel Pivot Tables

Module 5: Hierarchies

  • Hierarchies
  • Time Data


Module 6: The Excel Data Model

  • Using an Excel Data Model
  • External Data

Weitere Schulungen zu Thema Power BI

DA-100: Analyzing Data with Power BI

- u.a. in Nürnberg, Berlin, Stuttgart, München, Köln

This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including ...

MOC 20779: Analyzing Data with Excel

- u.a. in Nürnberg, Berlin, Stuttgart, München, Köln

The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.