Analyzing Data with Excel

at NetCom Learning

(19)
Course Details
Price:
$1,775 6 seats left
Start Date:

Mon, Jun 28, 10:00am - Jun 30, 6:00pm Central Time (3 sessions)

Purchase Options
Description
Class Level: Intermediate
Age Requirements: 16 and older
Average Class Size: 6
System Requirements: Your Computer
  • Use a recent PC or Mac computer that is less than 4 years old.
  • Two display monitors are highly recommended
  1. one for joining the virtual classroom and, if applicable, viewing digital books
  2. the other for doing your labs
Your internet connection
  • Please use a wired, not wireless or wifi connection
  • Please use a broadband internet connection and not dial-up (modem)
Computer USB headsets (with headphone & microphone in one unit) that we recommend: 
  • Microsoft LifeChat LX-3000 or Logitech ClearChat H390.
Class Delivery: Live Online Training brings our award-winning classroom experience to you! Developed through rigorous testing of the leading virtual learning environments and multimedia technologies, Live Online Training - a.k.a. "LOT" - delivers the training industry's most complete remote classroom experience.

Features And Benefits Of Live Online Training Courses:

» Hands-on, live instructor-led training from any internet-accessible location
» Real-time remote access to class software and virtual lab environment
» Eliminate travel expenses and save the time spent in transit - Go Green
» LOT is compatible with PCs, Macs, and mobile devices

What Is Included In Your Live Online Training Tuition?
» NetCom's Award-Winning Training & Certification Prep
» Official Courseware and Lab Manuals for your class (PDF's - where applicable)
» Test-Prep Software if applicable

What you'll learn in this excel class:

The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.

This course is based on the objectives of the course version 20779B.

Course Objectives

  • 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

Course Outline

  • Data Analysis in Excel
  • The Excel Data Model
  • Importing Data from Files
  • Importing Data from Databases
  • Importing Data from Excel Reports
  • Creating and Formatting Measures
  • Visualizing Data in Excel
  • Using Excel with Power BI

SATV Eligible Course

  • 3 Days SATV Applicable

Who Should Attend

  • This course is intended for students who are experienced with analyzing data with Excel and who wish to add BI techniques.
  • The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.

Prerequisites

Required

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals
  • Working knowledge of relational databases
  • 10994: Data Analysis Fundamentals Using Excel

Related Courses

  • 20779: Analyzing Data with Excel

What Exam Do I Need To Get Certified?

  • 70-779 : Analyzing Data with Excel


Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Still have questions? Ask the community.

Start Dates (1)
Start Date Time Teacher # Sessions Price
10:00am - 6:00pm Central Time TBD 3 $1,775
This course consists of multiple sessions, view schedule for sessions.
Tue, Jun 29 11:00am - 7:00pm Central Time TBD
Wed, Jun 30 11:00am - 7:00pm Central Time TBD

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 17750 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at NetCom Learning (16)

Similar Classes

School: NetCom Learning

NetCom Learning

NetCom Learning delivers top-quality training and certification solutions to businesses, individuals and government agencies.

Experience
Since its inception in 1998, NetCom has trained over 95 percent of the Fortune 500, serviced over 23,000 business customers, and advanced the skills and careers of over...

Read more about NetCom Learning

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Online educator.

Ready to take this class?
BOOK NOW
Booking this class for a group? Find great private group events here