i am trying to activate power pivot add-in but it s not showing in the list. i have a office 365 .
please help me in activating it as i knew that it s included in 365 .
You don't have to do anything to activate PowerPivot in 365. Although some documentation still refers to PowerPivot as an addin, that is only for versions prior to 2016
Office 365, the Excel app on Windows for PCs offers the full Get & Transform and Power Pivot features that further enhance your analytics and modeling capabilities
Here are links to some MS documentation about PowerPivot.
! Welcome to PowerPivot
2011 05 22
Welcome to PowerPivot for Excel. This section includes an introduction to PowerPivot, how to install PowerPivot, and where to find sample data and videos.
. * Introducing PowerPivot for Excel
. * Learn About PowerPivot Capabilities
. * PowerPivot Capacity Specification
. * Install PowerPivot for Excel
. * Get Sample Data for PowerPivot
. * Watch Videos About PowerPivot Tasks
. * PowerPivot Overview for IT Administrators
! PowerPivot Help Topics
This link is the home page for links to A LOT of articles and tutorials. Well worth digging through
Power Pivot provides advanced data modeling features in Microsoft Excel. Use the resources below to learn about how you can use Power Pivot to help you gain new insights into your data.
. * Learn more about data analysis tools in Excel
. * Power Pivot: Powerful data analysis and
data modeling in Excel
. * Start Power Pivot in Microsoft Excel
. * Power Pivot keyboard shortcuts and accessibility
. * Power Query
. * Power View
. * Power Map
Data Modeling and Visualization Tutorials
. * Tutorial: Import Data into Excel, and Create a
. * Tutorial: Optimize your Data Model for Power
. * Get sample data for DAX and Data Model tutorials
. * Tutorial: Extend Data Model relationships
using Excel, Power Pivot, and DAX
. * Tutorial: Create Map-based Power View Reports
. * Tutorial: Incorporate Internet Data,
and Set Power View Report Defaults
. * Power Pivot Help
. * Tutorial: Create Amazing Power View Reports - Part 2
. * Understanding the Excel Data Model (Office 15-Minute Webinar)
. * Understanding Power Pivot for Excel (Office 15-Minute Webinar)
. * Video: Set default fields in Power Pivot
. * Video: Hide columns and tables in Power Pivot
. * Video: Set the Power View default aggregation
using Summarize By
Understand the Power Pivot Data Model
. * Create a Data Model in Excel
. * Create a memory-efficient
Data Model using Excel and Power Pivot
. * When to use Calculated Columns and Calculated Fields
. * Lookups in Power Pivot Formulas
. * VLOOKUP Functionality in Power Pivot
. * Version compatibility
between Power Pivot Data Models in Excel 2010 and Excel 2013 and Excel 2016
. * Upgrade Power Pivot Data Models to Excel 2013
or Excel 2016
. * Data Model specification and limits
. * Data types in Data Models
. * Freeze columns
. * Get data using the Power Pivot add-in
. * Get data from a data feed in Power Pivot
. * Get data from Analysis
. * Import Data from a Reporting Services
. * Make changes to an existing
data source in Power Pivot
. * Find out which data sources are used in
a workbook data model
. * Filter the data you import into Power Pivot
. * Create a blank table in Power Pivot
. * Refresh imported data in Power Pivot
. * Troubleshoot linked tables
Tip: Power Query for Excel is a new add-in you can use to import data from many different source into your Excel workbooks and data models. Learn more at
Microsoft Power Query for Excel Help.
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
Thanks for your feedback.