You are here:Courses|Microsoft|MS Office Customised Courses|Excel Power Pivot and Power View

Excel Power Pivot and Power View

PowerPivot

PowerPivot is a powerful MS Excel tool for data exploration and mash up that analyzes billions of rows of data at great speed. PowerPivot tool can be downloaded as an add-in to the Excel 2010 version for free. Microsoft Excel 2013 has PowerPivot as a built-in functionality in the application package. It extends the PivotTable functionality of summarizing data and introduces the feature of importing data from several sources. PowerPivot function comes under the category of Microsoft BI (Business Intelligence), harmonizing with its in-memory, self-service abilities.

  1. PowerPivot DAX Measures & Functions
  2. PowerPivot for Creating Pivot Reports

Power View

Power View is an interactive tool in MS Excel for data exploration, presentation and visualization that allows business users to generate intuitive ad-hoc reports. The Power View feature is now built-in to Excel 2013. It is also an add-in feature of SharePoint 2010 and part of SQL Server 2012 Reporting.

  1. Introduction to Power View
  2. Basic Power View
  3. Working with Filters Pane
  4. Decorating reports
  5. Using tables, cards and Matrix
  6. Understanding Matrix Visualization
  7. Card Visualization
  8. Utilizing Table as a Slicer
  9. Working on Charts - line charts, pie charts, scatter charts
  10. Working with maps
  11. Using Titles
  12. Using Drill-Down
  13. Working with multipliers
  14. Effectively using Power View

 

Schedule for Excel Power Pivot and Power View
Course Contents Regular Track (days)
Excel Power Pivot and Power View 3
Balance Days for day of arrival, exam(s) and practice 1
Total duration 4

Prerequisites:

  • Basic computer skills, Basic knowledge of MS-Office

 

 

 

Our Location

Get In Touch

1st Floor of CHABAH House,

Chabah Bus Stop on the Odokor-Mallam HighWay

Opposite Total Filling Station

P. O. Box DS 2022

Accra, Ghana

Phone: +233 303 393 1256 / +233 302 325 815

Cell: +233 244036 522

Email: [email protected]