Benefits of Microsoft Excel add-ons, PowerPivot & PowerView

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 9 lectures (57m) | Size: 284.9 MB

This course teaches how to use Excel free add-ons PowerPivot and PowerView to provide data insights
What you'll learn:
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.

Requirements
Prerequisite: Proficiency with Excel.
Experience in Excel.
Excel 2013 installed on your PC or access to SharePoint 2013 or Office 365.
Advanced Pre

Description
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.

Who this course is for
Anyone interested in Accounting, Finance, Spreadsheet, or related fields