10994: Data Analysis Fundamentals using Excel 2016

Modality: Led-Training

Location: Puerto Rico Science, Technology & Research Trust Center (San Juan)



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 2016 or Power BI.

Audience profile
This course is intended for anyone who wants to take the data analysis technologies in Excel 2016 beyond formulas and add more advanced capabilities such as dashboards, hierarchies, and relationships.

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

Subject Timeline
Module 1: Reporting in Excel
Lab : Create an Excel report
Module 2: Excel Tables
Lab : Create an Excel Table
Module 3: Pivot Tables and Pivot Charts
Lab : Importing Data from a CSV File
Module 4: Dashboards
Lab : Create a Dashboard
Module 5: Hierarchies
Lab : Creating Hierarchies
Module 6: The Excel Data Model
Lab : Explore an Excel Data Model
Total Hours 16