10994: Data Analysis Fundamentals using Excel 2016

Modality: Led-Training

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

Date: 6 & 7 of November 2017 from 8:00am to 5:00pm

Description

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
2
Module 2: Excel Tables
Lab : Create an Excel Table
2
Module 3: Pivot Tables and Pivot Charts
Lab : Importing Data from a CSV File
3
Module 4: Dashboards
Lab : Create a Dashboard
3
Module 5: Hierarchies
Lab : Creating Hierarchies
3
Module 6: The Excel Data Model
Lab : Explore an Excel Data Model
3
Total Hours 16