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
Last updated/reviewed: October 21, 2018

25 Reviews (50 ratings)Reviews

2
Anonymous Author
The graphics used in this presentation were not clear enough to see what the instructor was trying to demonstrate, or they were too small to read any of the text. The narration was very hard to follow along with and there were many missteps that had to be corrected. It was very difficult to continue to pay attention or get anything of value out of this course.
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
Anonymous Author
I wish I could have gotten more out of this course as the topic is certainly an important one if you plan to create models from many data sources. Perhaps clearer slides (they were hard to read) and a more energetic pace would have helped.
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.
3
Member's Profile
Poor screen quality was definitely a distraction even on large monitors. It was good to see what the end game was -- would have been better at the beginning rather than in the middle of the presentation.
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.
5
Member's Profile
Very nice - I like the course and the image of the flat file...as it is probably similar to what a lot of people are seeing.
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.
4
Member's Profile
good course except that the presenter's screen was blurry and I couldn't see clearly
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
5
Member's Profile
Great summary of PowerPivot can't wait to try this!
4
Anonymous Author
The active screens used are blurry and hard to see.
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