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