Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Data Analysis Fundamentals Using Excel Training Course

Data Analysis Fundamentals Using Excel Training Course


Course Description:  The Data Analysis Fundamentals Using Excel course will train students on how add data analysis capabilities to their Excel spreadsheets. The course is designed for any Excel user who needs to perform basic data analysis.

Upon completion of the course, users will be able to:

  • Build a report in Excel
  • Create Excel Tables
  • Work with Pivot Tables and Pivot Charts
  • Create Excel Dashboards
  • Understand Heirachies
  • Learn about the Excel Data model

Training Dates
(Click on the course name below to view course details and full list of class dates)

Data Analysis Fundamentals Using Excel
Locations: Available Nationwide and Online
Class Date(s): 10/12/2020 - 10/13/2020
Course Fee : $995


Data Analysis Fundamentals Using Excel
Locations: Available Nationwide and Online
Class Date(s): 11/9/2020 - 11/10/2020
Course Fee : $995


Data Analysis Fundamentals Using Excel
Locations: Available Nationwide and Online
Class Date(s): 12/7/2020 - 12/8/2020
Course Fee : $995


Data Analysis Fundamentals Using Excel
Locations: Available Nationwide and Online
Class Date(s): 1/4/2021 - 1/5/2021
Course Fee : $995


Data Analysis Fundamentals Using Excel
Locations: Available Nationwide and Online
Class Date(s): 2/1/2021 - 2/2/2021
Course Fee : $995


Data Analysis Fundamentals Using Excel
Locations: Available Nationwide and Online
Class Date(s): 3/8/2021 - 3/9/2021
Course Fee : $995


Data Analysis Fundamentals Using Excel
Locations: Available Nationwide and Online
Class Date(s): 4/5/2021 - 4/6/2021
Course Fee : $995


Course Syllabus

Section 1: Reporting in Excel
This section explains how to Creating a report in Excel
Lessons
• Filtering and Formatting Data
• Charts
Lab : Creating an Excel report
• Filtering Excel Data
• Formatting Excel Data
• Creating excel Charts

Section 2: Excel Tables
This section explains how to Creating data tables in Excel
Lessons
• Excel Data Tables
• Summarizing Data
Lab : Creating an Excel Table
• Creating an Excel Table
• Summarizing Excel Data

Section 3: Pivot Tables and Pivot Charts
This section describes pivot tables and pivot charts and how to work with them.
Lessons
• 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

Section 4: Dashboards
This section describes Excel dashboards, how to Creating them and the role in data analysis in Excel pivot tables.
Lessons
• Creating a Dashboard
• Data Analysis in Excel Pivot Tables
Lab : Creating a Dashboard
• Arranging Tables and Charts
• Slicing Data
• Data Analysis

Section 5: Hierarchies
This section describes hierarchies and time data.
Lessons
• Hierarchies
• Time Data
Lab : Creating Hierarchies
• Creating a Hierarchy
• Configuring Time data
• Creating an Animated Time Chart

Section 6: The Excel Data Model
This section explores the Excel data model and looks at ways of extending it.
Lessons
• Using an Excel Data Model
• External Data
Lab : Explore an Excel Data Model
• Adding Multiple Tables
• Creating Relationships
• Adding External Data

Excel Analytics On-Site Group Training
Arrange a private Excel Analytics training class for your team with one of our Certified Instructors. Private instruction for your team members at a lower per-student price than attending the public courses. Learn More or complete the quote request form below.



Data Analysis On-Demand Training

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Business Computer Skills Microsoft Partner

Business Computer Skills BBB Profile