How to Activate Power Query in Excel 2016

Beginner 15 min 9 steps 34517 views Rating: 3.5/5 Published: 2026-06-12

Open Excel.. Open a new document.. Click the Data tab.

Start Playback
S
Author

Steps

1

Open Excel.

Step 1

Open Excel.

2

Open a new document.

Step 2

Open a new document.

3

Click the Data tab.

Step 3

Click the Data tab.

4

Click Get Data.

Step 4

Click Get Data.

5

Select a data source.

Step 5

Select a data source.

6

Select the data you want to import.

Step 6

Select the data you want to import.

7

Double-click a query to edit it.

Step 7

Double-click a query to edit it.

8

Edit and transform your data.

Step 8

Edit and transform your data.

9

In the Query Editor, click Close and Load.

Step 9

In the Query Editor, click Close and Load.

View as Slideshow

Rate This Guide

★ ★ ★ ☆ ☆ 3.5/5
3

Comments (0)

No comments yet. Be the first to share your thoughts!