Instructor for this course
more

This course provides hands-on instruction in leveraging the benefits of free Microsoft Excel add-ons, PowerPivot and PowerView. Both are free with Excel 2013, and dramatically extend the powers of Excel through interactive data exploration, and intuitive ad-hoc reporting. With these valuable tools, finance teams can add true value to their organization through insight generation and data visualization.

Learning Objectives

  • Identify how to set up Power Pivot & PowerView in Excel 2013
  • Recognize how to create a data table and link into PowerPivot
  • Identify basic calculations in PowerPivot
  • Discover how to build PowerView tables and graphs

18 Reviews (33 ratings)Reviews

4
Member's Profile
• The course provides a good insights on how to use PowerPivot and PowerView for making interactive dashboards and management reports • However, I think that the course should also cover the PowerView report in bit detail. As it is the ultimate outcome of the whole exercise.
3
Member's Profile
First, am not sold on the merits of PowerPivot over traditional pivot tables and related charts. I'm sure there's value (like large data sets) - but this didn't really delve into that. Video could have been edited better.
5
Member's Profile
I've wanted to get started using the Power Tools that Excel has added over the last few generations of Excel. This lesson has provided a good starting point. Just in depth enough to provide value. But not too much to follow.
4
Member's Profile
I work with this stuff all the time. I would like to see more courses on this subject, such as pulling data from databases. I like doing so with a few data sources and editing the SQL is pretty easy in Powerpivot.
4
Member's Profile
Wow!!! I didn't know this existed. Even though much of this is over my head at this point, I now know the upper boundaries of where I can go with Excel on BI, analysis and reporting.
4
Anonymous Author
I had never heard of Microsoft PowerPivot & PowerView before taking this course. I look forward to trying out the topics covered in the class using my company's data.
4
Member's Profile
Thought was a great intro, simplified by not detailing period or date table structures. Would. Have like to touch on the other ways to get data into the power pivot.
4
Anonymous Author
Good introduction. I would like some of the things that were shown in Excel and Powerpivot to be in the slides as well.
4
Member's Profile
PowerPivot looks like a great tool. The presentation was helpful and was easy to follow.
5
Anonymous Author
I had never heard of this powerful Excel function. I'm going to try this out.
4
Anonymous Author
Good course - would have preferred more working examples in Excel
3
Member's Profile
I have Excel 2010 so much of it was N/A for me.
5
Anonymous Author
Very good course about a very powerful tool
5
Member's Profile
Good presentation of technical material.
4
Member's Profile
Very useful course for excel users
4
Member's Profile
Excellent coverage of the topic.
5
Member's Profile
Good content
4
Anonymous Author
Good

Prerequisites

Course Complexity: Advanced

Prerequisite: Proficiency with Excel

  • Experience in Excel
  • Excel 2013 installed on your PC or access to SharePoint 2013 or Office 365

    Advanced Preparation: None

     

 

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
INTRODUCTION AND OVERVIEW
Discovering PowerPivot & PowerView
  7:45Overview and Setup
  14:49Creating Tables and Import into PowerPivot
  19:17Enriching The Data Model Design
  9:15Produce Reports Based on The Data Model
Conclusion
  4:17Publish the Workbook to SharePoint
SUPPORTING MATERIALS
  PDFSlides: FP&A Strategy
  PDFFP&A Strategy Glossary/Index
  xlsx4 Sales Data
REVIEW & TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM