Microsoft Office









Preferred method of contact:

Analyzing Data with Excel 2016 (20779)

COURSE TYPE

Practitioner

Course Number

8433

View Schedule

This 3-day instructor led course is designed to give students the ability to add BI techniques to Excel data analysis, from importing data from various data sources, to creating data visualizations and Power BI dashboards.

This is a Microsoft Official Course (MOC) delivered by a Learning Tree expert instructor.

You Will Learn How To

  • Explore and extend a classic Excel dashboard
  • Explore and extend an Excel data model
  • Pre-format and import a .CSV file
  • Import data from a SQL Server database
  • Import data from a report
  • Create measures using advanced DAX functions
  • Create data visualizations in Excel
  • Create a Power BI dashboard with Excel

Important Course Information

Requirements:

  • Before attending this course, students must have:
    • Basic knowledge of the Microsoft Windows operating system and its core functionality
    • Good Knowledge of Excel spreadsheets, functions, and charts
    • Working knowledge of relational databases

Redeem Your Microsoft SATVs:

Course Outline

  • Module 1: Data Analysis in Excel

This module looks at the classic Excel dashboard and at ways to extend it.

Lessons

  • Classic Data Analysis with Excel
  • Excel Pivot Tables
  • Limitations of Classic Data Analysis

Lab: Building a Classic Excel Dashboard

  • Filtering and Formatting Data
  • Building a Pivot Table
  • Building a Pivot Chart
  • Building a Dashboard

After completing this module, students will be able to:

  • Describe classic data analysis with Excel
  • Describe Excel pivot tables
  • Describe the limitations of classic data analysis with Excel
  • Module 2: The Excel Data Model

This module looks at the classic Excel data model and at ways to extend it.

Lessons

  • Using an Excel Data Model
  • DAX

Lab: Explore an Excel Data Model

  • Create Calculated Columns
  • Format Data Model Data
  • Create Measures
  • Analyze the Data

After completing this module, students will be able to:

  • Describe an Excel data model
  • View data within an Excel data table Describe DAX
  • Module 3: Importing Data from Files

This module looks at pre-formatting and importing CSV files.

Lessons

  • Importing Data into Excel
  • Shaping and Transforming Data
  • Loading Data

Lab: Importing Data from a CSV File

  • Import and Transform Data from a CSV File
  • Add Data from a Folder

After completing this module, students will be able to:

  • Import data into excel
  • Shape and transform data
  • Load data
  • Module 4: Importing Data from Databases

This module looks at how to import data into Excel from a SQL Server database.

Lessons

  • Available Data Sources
  • Previewing, Shaping, and Transforming Data
  • Table Relationships and Hierarchies
  • Loading Data

Lab: Import Data from Multiple Sources

  • Import Data from SQL Server
  • Import Data from a CSV File
  • Create a Data Table

After completing this module, students will be able to:

  • Identify available data sources
  • Preview, shape, and transform data
  • Explain table relationships and hierarchies
  • Load data from various sources
  • Module 5: Importing Data from Excel Reports

This module describes how to import data from a report.

Lessons

  • Importing Data from Excel Reports
  • Transforming Excel report Data

Lab: Importing Data from a Report

  • Import Data from Excel
  • Transform the Excel Data
  • Load the Data into an Excel Data Model

After completing this module, students will be able to:

  • Import data from Excel reports
  • Transform Excel report data
  • Module 6: Creating and Formatting Measures

This module describes how to create and format measures.

Lessons

  • DAX
  • Measures
  • Advanced DAX Functions

Lab: Creating Measures using Advanced DAX Functions

  • Last year comparison
  • Year to date
  • Market Share

After completing this module, students will be able to:

  • Explain what DAX is and when to use it
  • Describe a measure
  • Use some of the advanced functions within DAX
  • Module 7: Visualizing Data in Excel

This module describes how to visualize data in Excel.

Lessons

  • Pivot Charts
  • Cube Functions
  • Charts for Cube Functions

Lab: Data Visualization in Excel

  • Create a Tabular Report
  • Create a Pivot Chart
  • Add Slicers to Charts

After completing this module, students will be able to:

  • Create and refine a pivot chart
  • Describe cube functions and when to use them
  • Describe a number of charts for use with cube functions
  • Module 8: Using Excel with Power BI

This module describes how to use Excel with Power BI.

Lessons

  • Power BI
  • Uploading Excel Data to Power BI
  • Power BI Mobile App

Lab: Creating a Power BI Dashboard with Excel

  • Uploading Excel Data
  • Creating a Power BI Dashboard

After completing this module, students will be able to:

  • Describe Power Bi and the various versions available
  • Upload Excel data to Power BI
  • Describe the Power BI App
Show complete outline
Show Less

Convenient Ways to Attend This Instructor-Led Course

Hassle-Free Enrollment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.

In the Classroom

Live, Online

?
With a blend of video, text, hands-on labs, and knowledge checks, you will receive the same high quality content as the live event, but you can attend on your own time, at your own pace.

On Demand +
Instructor Coaching

Private Team Training

In the Classroom — OR — Live, Online

Tuition — Standard: $2650   Government: $2355

Jul 19 - 21 (3 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Aug 30 - Sep 1 (3 Days)
9:00 AM - 4:30 PM EDT
Alexandria, VA / Online (AnyWare) Alexandria, VA / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Sep 13 - 15 (3 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Sep 27 - 29 (3 Days)
9:00 AM - 4:30 PM EDT
Online (AnyWare) Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online

Oct 25 - 27 (3 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Dec 20 - 22 (3 Days)
9:00 AM - 4:30 PM EST
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Jan 10 - 12 (3 Days)
9:00 AM - 4:30 PM EST
Online (AnyWare) Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online

Jan 24 - 26 (3 Days)
9:00 AM - 4:30 PM EST
Toronto / Online (AnyWare) Toronto / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Feb 14 - 16 (3 Days)
9:00 AM - 4:30 PM EST
Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Feb 28 - Mar 2 (3 Days)
9:00 AM - 4:30 PM EST
Washington, DC / Online (AnyWare) Washington, DC / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Apr 25 - 27 (3 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

May 16 - 18 (3 Days)
9:00 AM - 4:30 PM EDT
Online (AnyWare) Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online

Guaranteed to Run

Show all dates
Show fewer dates

On Demand + Instructor Coaching
Tuition — $895

With a blend of video, text, hands-on labs, and knowledge checks, you will receive the same high quality content as the live event, but you can attend on your own time, at your own pace.

PLUS, we include access to a Microsoft Certified Trainer (MCT) to help you prepare for your certification exam and help you apply your new skills immediately… Learning Tree knows how to bring learning to life!

  • Flexibility to take the course on your own time, at your own pace
  • Forever access to the digital course materials – for any refreshers
  • You will receive a code with your purchase. The code may be redeemed for online access to this On Demand course for up to six months
  • Upon course activation, the MOC On Demand videos and labs are available for three months
  • 2 FREE hours of individual coaching from an MCT Learning Tree Instructor
  • This delivery is also eligible for Microsoft Assurance Training Vouchers (SATVs)

GET STARTED

For enrolling multiple subscribers at the same time, contact us »

Private Team Training

Enrolling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.

For details, call 1-888-843-8733 or Click Here »

Tuition

Standard

Government

In Classroom or
Online

Standard

$2650

Government

$2355

On Demand

$895*

Private Team Training

Contact Us »

*prices exclude applicable taxes


Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

Prev
Next

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm

FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)

- ,

Prev
Next
Chat Now

Please Choose a Language

Canada - English

Canada - Français