Course Code: 1346

Excel 2016 - 2019 Data Analysis with Power Pivot

Class Dates:
6/9/2023
8/11/2023
9/8/2023
Length:
1/2 Days
Cost:
$175.00
Class Time:
Technology:
Office
Delivery:
Instructor-Led Training, Virtual Instructor-Led Training

Overview

  • Course Overview
  • We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

    This course presents information and skills that are appropriate for users of either the Office 2016 or Office 2019 desktop applications. However, the instructional environment for the delivery of this course utilizes Office 2016.
  • Audience
  • Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using Power Pivot.

    Course Objectives:
    Upon successful completion of this course, you will be able to use Power Pivot along with Excel to analyze data from a variety of sources.

    You will:

    Get started with Power Pivot.
    Visualize Power Pivot data.
    Work with advanced functionality in Power Pivot.

Prerequisites

  • To ensure your success in this course, you should have experience working with Excel 2013 and PivotTables. You should already understand spreadsheet concepts and be comfortable creating and analyzing basic PivotTables.

  • Recommended Courses:

  • Excel 2016 Level 1
  • Excel 2016 Level 2
  • Excel 2016 Pivot Table

Course Disclaimer

*Course Cost listed does not include the cost of exam. Course is subject to a minimum enrollment to run. Course may run virtually as a Virtual Instructor-Led (VILT) class if the minimum enrollment is not met. For more information, please contact learn@vtec.org or call 207-775-0244.

Course Details