Data Analytics with Excel by Punit Prabhu

Data Analytics with Excel by Punit Prabhu

Author:Punit Prabhu [Prabhu, Punit]
Language: eng
Format: azw3, epub
Published: 2021-04-03T16:00:00+00:00


Image showing the transformation commands under the Transform, Home, and Add Column tabs of the Power Query Editor

Get & Transform

Click on Data Tab→ Inn Get and Transform → From Table

For 2013 its under Power Query Tab

After clicking on From Table Power Query Editor will open as shown in Image

In Power Query Editor you can clean and transform the data.

After Importing Sales Data. Go to Home tab in Power query Editor and click on Close and Load To

Load to window will appear. Click on Only create connection and click on Load.



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.