PowerPivot for End Users Course

After the last two weeks of finishing this course, it is about to be published!  Here's the 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

Chris