10994 - Data Analysis Fundamentals Using Excel
CLASS DATE(s):
9/10/2020 - 9/11/2020
11/9/2020 - 11/10/2020

COURSE LENGTH: 2 Days

COURSE COST: $995.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

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 AND PREREQUISITES

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. 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.

  

*Course cost listed does not include the cost of courseware. Please contact us @ learn@vtec.org or 207-775-0244 for additional pricing information or if you have any questions. Course is subject to minimum enrollment. If minimum is not met this class may run as a LDL / Virtual class. Note: This course is eligibile for Microsoft SATVs.

COURSE TOPICS:


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

Module 1: Reporting in Excel -
This module explains how to create a report in Excel
Filtering and Formatting Data
Charts
Lab: Create an Excel report
Filtering Excel Data
Formatting Excel Data
Create excel Charts

Module 2: Excel Tables
This module explains how to create data tables in Excel
Excel Data Tables
Summarizing Data
Lab: Create an Excel Table
Create an Excel Table
Summarize Excel Data

Module 3: Pivot Tables and Pivot Charts
This module describes pivot tables and pivot charts and how to work with them.
Pivot Tables
Pivot Charts
Editing Pivot Tables and Pivot Charts
Lab: Importing Data from a CSV File
Creating a Pivot Table
Creating a Pivot Chart
Editing Pivot Tables and Pivot Charts

Module 4: Dashboards
This module describes Excel dashboards, how to create them and the role in data analysis in Excel pivot tables
Creating a Dashboard
Data Analysis in Excel Pivot Tables
Lab: Create a Dashboard
Arranging Tables and Charts
Slicing Data
Data Analysis

Module 5: Hierarchies
This module describes hierarchies and time data.
Hierarchies
Time Data
Lab: Creating Hierarchies
Create a Hierarchy
Configure Time data
Create an Animated Time Chart

Module 6: The Excel Data Model
This module explores the Excel data model and looks at ways of extending it.
Using an Excel Data Model
External Data
Lab: Explore an Excel Data Model
Add Multiple Tables
Create Relationships
Add External Data