MOD 10994: Data Analysis Fundamentals Using Excel

Description

This 2-day course is intended for students to learn how to add analysis capabilities to Excel spreadsheets

IT professionals who are responsible for analyzing data with Excel would benefit from this course.

Once the student has completed this course, the student 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

Prerequisites

Students that are interested in this course, it is recommended that they have:

Basic knowldege of the MIcrosoft Windows operating system and its core functionality
Basic knowledge of Excel spreadsheets

What’s included?

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.

Methods

  • Instructor Led (the best training format we offer)
  • Live Online Classroom – Online Instructor Led
  • Self-Paced Video

Speak to an Admissions Representative for complete details

Curriculum

Module 1: Reporting in Excel
Lessons

Filtering and Formatting Data
Charts
Lab: Create an Excel report

Filtering Excel Data
Formatting Excel Data
Create excel Charts
Module 2: Excel Tables
Lessons

Excel Data Tables
Summarizing Data
Lab: Create an Excel Table

Create an Excel Table
Summarize Excel Data
Module 3: Pivot Tables and Pivot Charts
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
Module 4: Dashboards

Lessons

Creating a Dashboard
Data Analysis in Excel Pivot Tables
Lab: Create a Dashboard

Arranging Tables and Charts
Slicing Data
Data Analysis
Module 5: Hierarchies
Lessons

Hierarchies
Time Data
Lab: Creating Hierarchies

Create a Hierarchy
Configure Time data
Create an Animated Time Chart
Module 6: The Excel Data Model
Lessons

Using an Excel Data Model
External Data
Lab: Explore an Excel Data Model

Add Multiple Tables
Create Relationships
Add External Data

Enrolled