Get data from Online to Excel

How to get data from website to Excel2013

Step 1: Open Your Excel sheet

Step 2: Click on Online Search  or FromWeb

If you know the exact address of a particular website then choose FromWeb

Step 3: In  search what data you want choose it by moving the cursor on tabs.
Then click on it.
At the end of page you can choose data where to load like Work sheet or data model

above and below images showing that while we drag cursor on searched items, the data should appear.
From this we can choose what data we want to analyze?

After double click, the data had loaded into work sheet or data model or both based on what option you checked.

Enable Power Query and PoerPivot in Excel 2013

How to enable Power Query and PowerPivot

Step1: Open Excel 2013

 if those are not available then

Step2: Click On file-->Select Options-->Click on Add-In

next 

next

If Microsoft Office PowerPivot or PowerQuery or PowerView not appear then download from microsoft website and install them

Again follow from step 2.