1 CPE Not currently accepting new students
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: August 12, 2023
28 Reviews (64 ratings)
Reviews
Anonymous
(Senior Accountant)
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.
Anonymous
(Accountant)
Unreadable, unstructed and chaotic Course!
Seem to be that the Publisher never have reviewed his Video: Low Video Quality that you cannot read anything and double records (in creating tables and Import into PowerPivot). As Beginner you cannot follow his steps. After the Import step - he Shows the final results but did not Show exactly the way to it.
Vineet Sharma
(Associate at Cians Analytics)
• 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.
Anonymous
(CFO)
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.
William Lathrop
(- at Artful Home, LLC)
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.
Bruce Reed
(Chief Financial Officer at PracticeLink)
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.
Kyle Degruttola
(Accounting Manager at Park Avenue Securities)
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.
Edward Thill
(Consultant at None)
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.
Gregg Gillaspy
(Owner at Gregg Gillaspy, CPA, CFP)
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.
Margaret Winn
(Accounting Professional at .)
Obsolete and should no longer be an active course. PowerView has been replaced by Power BI. Power query is necessary to do the day to clean up before you load it into Power Pivot.
Anonymous
(Independent Financial Consultant)
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.
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.
David Horvath
(Operations Director at Hubbell Incorporated)
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.
Anonymous
(Controller)
Good introduction. I would like some of the things that were shown in Excel and Powerpivot to be in the slides as well.
Anonymous
(Founder)
Power View has apparently changed by MSFT to focus on Microsoft BI...may want to update this course?
Gina Alexander
(CFO at Non-hospital based healthcare company)
PowerPivot looks like a great tool. The presentation was helpful and was easy to follow.
Andrew Anderson, CPA
(Principal Financial Analyst at Rio Tinto)
good course except that the presenter's screen was blurry and I couldn't see clearly
Anonymous
(VP, Finance)
I had never heard of this powerful Excel function. I'm going to try this out.
Anonymous
(Vice President / Technology and Planning)
Good course - would have preferred more working examples in Excel
Rahman Ullah
(Senior Accountant at Cardtronics)
Great summary of PowerPivot can't wait to try this!
Anonymous
(Senior Analyst)
The active screens used are blurry and hard to see.
Neal Cezat
(Financial Analyst at Arnott)
I have Excel 2010 so much of it was N/A for me.
Anonymous
(VP Finance)
Very good course about a very powerful tool
Good presentation of technical material.
Very useful course for excel users
Courtney Sanen
(CFO at Elevation Labs)
Excellent coverage of the topic.
brian bleifeld
(Partner at Bleifeld CPA LLC)
Good content
Anonymous
(Consultant)
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
.
James MyersDirector, FP&A Strategy
About Illumeo
Platform
Resources
Contact Us
- Email: info@illumeo.com
- Phone: 408-400-3993
- Adress: 1608 W Campbell
- Av #221, Campbell, CA 95008
© 2024 Illumeo, Inc.