Description

Advanced Excel users, users that want to gain familiarity with PowerPivot to build compelling reports.

Prerequisites

Before attending this course, students must have:

• General Excel and report building skills.

Objectives

• Explore every aspect of using Microsoft PowerPivot.
• Before attending this course, students must have:
• General Excel and Report building skills.

Outline

A simple introduction module.

After completing this module, students will be able to:

• Understand your course, classroom, classmates, facility and instructor.

• Lessons
  • PowerPivot Introduction
• Lab : Installing PowerPivot
  • Install PowerPivot for Excel
• After completing this module, students will be able to:
  • Install PowerPivot for Excel
  • Be able to navigate the PowerPivot windows
  • Understand the new features of Excel 2010

• Lessons
  • Supported Data Sources
• Lab : Loading Data Sources
  • Load Data From SQL Server
  • Load Data From Text Files
  • Load Data via Copy and Paste
  • Load Data via Data Feeds
  • Load Data via Reporting Services
• Lab : Cleaning Data
  • Cleaning data in PowerPivot
• Lab : Creating Relationships
  • Create Relationship between Data Sources
• After completing this module, students will be able to:
  • Import various data sources into PowerPivot
  • Understand how to clean imported data

• Lessons
  • PowerPivot Expressions
• Lab : Create a Time Table
  • Create a Time Table for future labs
• Lab : Using DATE Functions
  • Use DATE Function
  • Use DATEVALUE Function
  • Use the DAY, MONTH, YEAR, HOUR, MINUTE, SECOND Functions
  • Use EDATE Function
  • Use EOMONTH Function
  • Use NOW and TODAY Functions
  • Use TIME and TIMEVALUE Functions
  • Use TIME and TIMEVALUE Functions
• Lab : Using TIME INTELLIGENCE Functions
  • Use FIRST* and LAST* Functions
  • Use DATE* Functions
  • Use STARTOF* and ENDOF* Functions
  • Use CLOSING* and OPENING* Functions
  • Use LASTOF* and FIRST* Functions
  • Use PREVIOUS* and NEXT* Functions
• Lab : Using STATISTICAL Functions
  • Use AVERAGE* Functions
  • Use COUNT* Functions
  • Use MAX* and MIN* Functions
• Lab : Using VALUE Functions
  • Use ALL, ALLEXCEPT and ALLNOBLANKROW
  • Use CALCULATE, CALCULATETABLE
  • Use DISTINCT
  • Use EARLIER and EARLIEST
  • Use FILTER
  • Use REALTED, RELATEDTABLE
  • Use VALUES
• Lab : Using LOGICAL and INFORMATION Functions
  • Use Logical Functions (AND, FALSE, IF, IFERROR, NOT, OR, TRUE)
  • Use Information Functions (ISBLANK, ISERROR, ISLOGICAL, ISNONTEXT, ISNUMBER, ISTEXT)
• Lab : Using TEXT Functions
  • Use TEXT Functions
• After completing this module, students will be able to:
  • Be able to describe all the new PowerPivot Expressions
  • Use and apply many of the PowerPivot Expressions

Module 5: Building Reports using PowerPivot

In this module we take a look at the lessons of the module!

• Lessons
  • PowerPivot Reports
• Lab : Creating Reports
  • Use PivotCharts
  • Use Slicers
  • Use Sparklines
• After completing this module, students will be able to:
  • Describe the different Report types in PowerPivot
  • Be able to create Slicers and Sparklines for more engaging reports

• Lessons
  • Reports and Email
  • PowerPivot for SharePoint 2010
• Lab : Installing PowerPivot for SharePoint 2010
  • Install PowerPivot for SharePoint 2010
  • Configure PowerPivot for SharePoint
• Lab : Configuring PowerPivot For SharePoint 2010
  • Publish to SharePoint 2010
  • Configure PowerPivot for SharePoint 2010
• After completing this module, students will be able to:
  • Describe the integration points between PowerPivot and SharePoint 2010
  • Be able to publish and setup workbook data refresh in SharePoint 2010

Please note that this content is meant to be a guideline.

Class material is subject to change and may be presented in a slightly different format than listed.