New Horizons Lexington KY Computer Training
New Horizons Computer Learning Center presents
 

Excel PowerPivot On-Site Training

This on-site training class is also available as Public Schedule Seminar.

In this course, students will make use of the PowerPivot add-in to import data from various sources and create a dynamic report.

Course Description/Agenda


Duration
Classroom Learning - 1 Day(s)
Online LIVE - 1 Sessions

Overview
In this course, students will make use of the PowerPivot add-in to import data from various sources and create a dynamic report.

Who Should Attend
This course is for students with a sound working knowledge of Microsoft Excel 2010 and general computing proficiency, including those who will be using Excel to make business decisions.

Prerequisite(s) or equivalent knowledge
Excel 2010 - Level 1
Excel 2010 - Level 2
Excel 2010 - Level 3

Outline
Lesson 1: Getting Started with PowerPivot
Explore the PowerPivot Application
Import Data from Various Data Sources
Refresh Data from a Data Source
Create Linked Tables
Lesson 2: Manipulating PowerPivot Data
Organize and Format Tables
Create Calculated Columns
Sort and Filter PowerPivot Data
Create and Manage Table Relationships
Lesson 3: Creating PowerPivot Reports
Create a PivotTable
Create PivotCharts
Filter Data Using Slicers
Present PivotTable Data Visually
Lesson 4: Using DAX Functions in PowerPivot
Manipulate PowerPivot Data Using DAX Functions
Extract Data from Tables Using Functions
Work with Time Dependent Data
Lesson 5: Distributing PowerPivot Data
Protect Reports
Save Reports in Different File Formats

 

More Seminar Information

New Horizons Computer Learning Center
New Horizons Lexington KY Computer Training

Delivery Method

 On-Site Training On-Site Training

Also Available As

 Seminar Seminar

  		Add to favorites Add to favorites
Email Email this page
 

On-Site Training
Information Request Form

Please complete the form for more information and/or a quote for this on-site class.

Name:

Email

Phone:

City and State

Company:

Number of students:
(at least 10 for consideration)

When do you want to hold the
seminar?

How long would you like for the
seminar?

Additional comments to trainer:

We value your privacy!