There are a number of COM Add-ins available for Excel including those for BI; Power Pivot, Power View, Power Query and Power Map. To activate these:

  1. Go to the Excel File Menu   ExcelRibbon
  2. Select Options from the left menu
  3. An Excel Options window should now appear
  4. Select Add-ins from the Excel Options left menu
  5. Select COM Add-ins from the drop down menu at the bottom of the Excel Options window and click the GO button
  6. Ensure that the required Add-ins are ticked – as per the image at the top of the page
  7. Click the OK button
  8. You Excel ribbon should now reflect the selection you made. Power Pivot and Power Query have their own ribbons, whilst Power View and Power Map can be found as icons on the Insert Ribbon
We hope you found this useful and/or interesting. If so please like, share or comment.