I've switch from Office 2010 to Office 2016 (360 subscriber) and surprisingly have found the unique Warehouse tab is missing. Then I've asked to go back to Office 2013 and still to no avail. Checked out a YouTube video and saw Office 2013 DOES have the Warehouse tab.


What's going on?
Anybody has a clue?

Whats the Warehouse Tab!

This snipped one was taken from Youtube.
(
Video Name: Basic Excel Business Analytics #31: Power Query: Import Multiple Excel Files with 1 Sheet Each
Video URL: https://www.youtube.com/watch?v=XPLVkLSagIY
Time: 10:17

)


file:///C:/Users/mrspi/Desktop/_TEMP/Capture.PNG

As you can see, the Tabs goes like this:
File, Home, Insert, ...., PowerPivot (11ht item).
How do I get that?

https://www.youtube.com/watch?v=XPLVkLSagIY
Time: 10:17
11th Tab (POWERPIVOT)

If you have a version of 2016/2013 which includes Power Pivot, you need to enable it in the COM add-ins dialog.