MOC 10994 B: Data Analysis Fundamentals using Excel

Catalog Home Microsoft Infrastructure, Operating Systems & Desktop Applications Microsoft Office & Office 365

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.

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.

2 Days/Lecture & Lab

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.

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


Copyright © 2018 ProTech. All Rights Reserved.

Sign In Create Account

Navigation

Social Media