SOLVED - Power Query and Power Pivot option not showing

power query and power pivot tutorial, beginner guide to power query, power bi tutorial, how to use power pivot, advance excel

TONI trying to learn about POWER QUERY and POWER PIVOT, but he is unable to find this two option in the EXCEL 2013 in Ribbon and also the option not available in Excel Ribbon customization and add in.

He asked to excel experts TUTINA, how he can activate the POWER QUERY and POWER PIVOT.

TUTINA explained that if POWER QUERY and POWER PIVOT not available in your EXCEL menu bar like 

INSTALL POWER QUERY IN EXCEL 2010 and EXCEL 2013

STEP 1 - Click on FILE and then click on OPTION. 

STEP 2 - Click on CUSTOMIZE RIBBON and Select ALL TAB

STEP 3 - If you find POWER QUERY option, select and add POWER QUERY from LEFT side to RIGHT side and click OK.

STEP 4 - If you unable to find the option, need to download from MICROSOFT center. Visit below link

https://www.microsoft.com/en-in/download/details.aspx?id=39379

Check system requirement. Update Internet Explorer to latest version.

STEP 5 - Select appropriate software as per your windows 32 bit or 64 bit, then click on DOWNLOAD

STEP 6 - After download, install the package. Installation process same like other software installation. 

STEP 7 - After installation, RESTART your excel and you will find POWER QUERY in MENU BAR.

INSTALL or ADD POWER PIVOT IN EXCEL MENU BAR

STEP 1 - Go to FILE, then select OPTION (same step like before)

STEP 2 - Click on ADD-INS

STEP 3 - Select COM ADD-INS and then press GO (as shown in above image).

STEP 4 - Select option as shown below

FINISH 5 - POWER PIVOT option added in MENU BAR

GET POWER QUERY IN EXCEL 2016, EXCEL 2019 and OFFICE EXCEL 365

Due to High Demand and Requirement, Microsoft provide POWER QUERY option in inbuilt DATA menu