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