Data Analysis Fundamentals Using Excel (10994)

Microsoft | SQL Server

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.

Course Audience

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.

Course Prerequisites

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 Objectives

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

This module explains how to create a report in Excel

 

Lessons

  • Filtering and Formatting Data
  • Charts

 

Lab: Create an Excel report

  • Filtering Excel Data
  • Formatting Excel Data
  • Create excel Charts

 

After completing this module, students will be able to:

  • Filter and format data.
  • Create charts.

 

Module 2: Excel Tables

This module explains how to create data tables in Excel

 

Lessons

  • Excel Data Tables
  • Summarizing Data

 

Lab: Create an Excel Table

  • Create an Excel Table
  • Summarize Excel Data

 

After completing this module, students will be able to:

  • Explain what Excel Data tables are.
  • Sort, filter, and validate data.
  • Summarize data.
  • Format summarized data.

 

Module 3: Pivot Tables and Pivot Charts

This module 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

 

After completing this module, students will be able to:

  • Describe pivot tables and how to create them.
  • Describe the various elements of a pivot chart.
  • Edit 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.

 

Lessons

  • Creating a Dashboard
  • Data Analysis in Excel Pivot Tables

 

Lab: Create a Dashboard

  • Arranging Tables and Charts
  • Slicing Data
  • Data Analysis

 

After completing this module, students will be able to:

  • Describe a dashboard.
  • Filter data using a slicer.
  • Add calculated columns to a dashboard.
  • Find anomalies.

 

Module 5: Hierarchies

This module describes hierarchies and time data.

 

Lessons

  • Hierarchies
  • Time Data

 

Lab: Creating Hierarchies

  • Create a Hierarchy
  • Configure Time data
  • Create an Animated Time Chart

 

After completing this module, students will be able to:

  • Describe hierarchies.
  • Create levels within a hierarchy.
  • Explain why time data is different and how to work with it.

 

Module 6: The Excel Data Model

This module 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

  • Add Multiple Tables
  • Create Relationships
  • Add External Data

 

After completing this module, students will be able to:

  • Explain an Excel Data Model and how to use it.
  • Import External Data and use it.
  • Link out to external data.

Now you can build Microsoft technical experience while balancing the demands of your schedule. MOC On-Demand combines high-quality video, reading, live hands-on labs and knowledge checks in a self-paced format to help you build skills on Microsoft technologies as you schedule allows – all at once or five minutes at a time. The modular, self-directed course structure adapts to your learning needs and learning style.

Brought to you by the people who write the software, Microsoft Official Courses On-Demand are only available through certified Microsoft Learning Partners like Tandem Solution.

Our On-Demand Solution Includes all of the following:

  • 90-day access to training videos
  • 90-day access to hands-on labs
  • 90-day access to exercises
  • Knowledge Checks

The benefits of our On-Demand solution are: 

  • MICROSOFT OFFICIAL: The content is based on the same official courseware used in instructor-led training and maps to the MOC flow
  • LIVE HANDS-ON LABS: Unlike other on-demand offerings that offer simulated labs, MOC On-Demand gives you a live, real-time environment for hands-on learning
  • SELF-PACED LEARNING: With MOC On-Demand, you can build deep technical skills on a range of Microsoft technologies when you choose, where you choose
  • HIGH-QUALITY CONTENT: The high-quality videos offer in-depth technical content delivered by engaging instructors
  • IMMEDIATE FFEDBACK: Knowledge checks at the end of each module and each course tells you whether you’ve mastered the content and are ready to move on

On-Demand Add-ons:

  • Lifetime eBook available at an additional cost
  • 6 month lab access available at an additional cost

*SATV Vouchers are accepted

Instructor-Led Dates
July 19 Register
September 27 Register
December 06 Register

Live | Virtual | Guaranteed

Duration: 2 Day Training class

*Click on date for more information

Delivery Options
$1,050.00 Register
$595.00 Register

Request Information
Full Name:
Company:
Email Address:
Phone Number