MOC 10994 - Data Analysis Fundamentals Using Excel Training Class | Webucator Database Classes

Training for your Team

2

                Days

Private Class for your Team
Online or On-location
Customizable
Expert Instructors

Request Onsite Class

Training for Yourself

$950.00

or 2 vouchers

Live Online Training
For Individuals
Expert Instructors
Guaranteed to Run
100% Free Re-take Option
1-minute Video

Upcoming Classes

May 24-25, 2018 10AM-6PM ET
Jun 28-29, 2018 10AM-6PM ET
Aug 2-3, 2018 10AM-6PM ET

Sep 6-7, 2018 10AM-6PM ET

Oct 11-12, 2018 10AM-6PM ET

Nov 15-16, 2018 10AM-6PM ET

Dec 20-21, 2018 10AM-6PM ET

See More Classes

Please select a class.

Request Onsite Class

Overview

The main purpose of this Data Analysis Fundamentals Using Excel training class is to give students the ability to add analysis capabilities to Excel spreadsheets.
This course is intended for anyone responsible for analyzing data with Excel

Goals

Learn to create an Excel report.
Learn to create an Excel table.
Learn to create a pivot table and pivot chart.
Learn to create a dashboard and analyze data.
Learn to create Hierarchies.
Learn to create an Excel data model and connect to external data.

Outline

Reporting in Excel
1. Filtering and Formatting Data
2. Charts
3. Lab: Create an Excel report
  1. Filtering Excel Data
  2. Formatting Excel Data
  3. Create excel Charts
Excel Tables
1. Excel Data Tables
2. Summarizing Data
3. Lab: Create an Excel Table
  1. Create an Excel Table
  2. Summarize Excel Data
Pivot Tables and Pivot Charts
1. Pivot Tables
2. Pivot Charts
3. Editing Pivot Tables and Pivot Charts
4. Lab: Importing Data from a CSV File
  1. Creating a Pivot Table
  2. Creating a Pivot Chart
  3. Editing Pivot Tables and Pivot Charts
Dashboards
1. Creating a Dashboard
2. Data Analysis in Excel Pivot Tables
3. Lab: Create a Dashboard
  1. Arranging Tables and Charts
  2. Slicing Data
  3. Data Analysis
Hierarchies
1. Hierarchies
2. Time Data
3. Lab: Creating Hierarchies
  1. Create a Hierarchy
  2. Configure Time data
  3. Create an Animated Time Chart
The Excel Data Model
1. Using an Excel Data Model
2. External Data
3. Lab: Explore an Excel Data Model
  1. Add Multiple Tables
  2. Create Relationships
  3. Add External Data

Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this SQL Server class:

Basic knowledge of the Microsoft Windows operating system and its core functionality.
Basic Knowledge of Excel spreadsheets.

Preparing for Class

Onsite: Course Setup
Live Online: Course Setup | WebEx Setup

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

98,438

Students who have taken Live Online Training

16,254

Organizations who trust Webucator for their training needs

100%

Satisfaction guarantee and retake option

9.44

Students rated our trainers 9.44 out of 10 based on 5036 reviews

A very comprehensive class for the time allotted.

Jason Ruark, E&J Gallo
Modesto CA

I highly recommend the Captivate 9 course for beginners.

Stephanie Patzius, Dent Wizard International
Bridgeton MO

Great class. I learned a ton. Thanks!!

Elizabeth Doolan, Granite Telecommunications
Quincy MA

I was expecting good interaction and real world examples, but I got far more than that. You could tell that the instructor loved what he was doing and as a result it showed in his teaching.

Bracey Fuenzalida, Dominion Endeavors
New York NY

More Testimonials