Home  |  Blogs  |  Courses  |  Schedule  |  Staff  |  Contact  |  Support  |  Tools  |  Customers  |  Login


Course Title: PowerPivot for End Users


What You Will Learn
How to use PowerPivot to access data sources, create relationships, use the PowerPivot DAX expressions and generate and format reports. You will also explore how PowerPivot workbooks can be integrated with SharePoint 2010.

Course Highlights
Explore every aspect of using Microsoft PowerPivot

Course Number
50433
Who Should Attend
Advanced Excel users, users that want to gain familiarity with PowerPivot to build compelling reports.

Prerequisites
General Excel and Report building skills

Course Author
Chris Givens

Includes
Course manual

Setup
N/A

SCORM
1.4 and 2004 Ready
Course Duration
2 Days

Course Hours
Begin @ 8:20 PM
End @ 8:20 PM

Meal Info:
N/A

Version:

Hardware:
N/A

MSRP:
$495.00

Book Cost:
$80.00


Register:
Schedule/Register
Course Outline
  • PowerPivot Introduction
    • Install PowerPivot for Excel
    • Explore new Excel 2010 Features
  • PowerPivot 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
    • Cleaning data in PowerPivot
    • Create Relationship between Data Sources
  • PowerPivot Functions
    • Create a Time Table for future labs
    • 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 WEEKDAY and WEEKNUM 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
    • Use AVERAGE* Functions
    • Use COUNT* Functions
    • Use MAX* and MIN* Functions
    • Use ALL, ALLEXCEPT and ALLNOBLANKROW
    • Use CALCULATE, CALCULATETABLE
    • Use DISTINCT and VALUES
    • Use EARLIER and EARLIEST
    • Use FILTER
    • Use RELATED
    • Use Logical Functions (AND, FALSE, IF, IFERROR, NOT, OR, TRUE)
    • Use Information Functions (ISBLANK, ISERROR, ISLOGICAL, ISNONTEXT, ISNUMBER, ISTEXT)
    • Use TEXT Functions
  • Building Reports using PowerPivot
    • Use PivotCharts
    • Use Slicers
    • Use Sparklines
    • PivotTable Models
  • PowerPivot for SharePoint 2010
    • Install PowerPivot for SharePoint 2010
    • Configure PowerPivot for SharePoint
    • Publish to SharePoint 2010
    • Configure PowerPivot for SharePoint 2010


About | Jobs | Privacy | Terms Of Use | Copyright Notices
Copyright 2011 Architecting Connected Systems
Seattle, WA 98115; San Diego, CA 92127

This site has been visited 401965 times! Unique Visitors: 32235