Add a question to an Excel worksheet (Energy Question)

Add a question to an Excel worksheet (Energy Question)

Observe: Energy Question is named Get & Remodel in Excel 2016. Info supplied right here applies to each. To be taught extra, see Get & Remodel in Excel 2016.

Observe: For a really fast video on show Question Editor, see the top of this text.

Energy Question presents a number of choices for loading queries into your workbook. You set default question load settings within the Choices dialog popup.

I have to:

Load queries into your workbook

Wonderful-tune my load choices

Load a question to the Excel Information Mannequin

Set default question load settings

Load queries into your workbook

There are a number of choices to load queries into your workbook:

  1. From Search outcomes:

    Search results

  2. From the Navigator pane:

    Navigator

  3. From the Question Editor:

    Query Editor

  4. From the Workbook Queries pane and the Question context menu:

    Workbook Queries

Observe: If you click on Load To from the Workbook Queries pane, you may solely Load to worksheet or Load to Information Mannequin. Different load-to choices let you fine-tune the way you load a question. To be taught in regards to the full set of load choices, see The right way to fine-tune your load choices.

Wonderful-tune your load choices

With Energy Question Load-To choices, you may:

  • Choose the way you wish to view your knowledge.

  • Choose the place the info is loaded.

  • Add knowledge to the info mannequin.

Load a question to the Excel Information Mannequin

Observe: The steps on this part require Excel 2013.

An Excel Information Mannequin is a relational knowledge supply composed from a number of tables inside an Excel workbook. Inside Excel, a Information Mannequin is used transparently, offering tabular knowledge utilized in PivotTables, PivotCharts, and Energy View studies.

With Energy Question, knowledge and annotations on the Information Mannequin are preserved when modifying the Load to Worksheet setting of a question. Energy Question doesn’t reset the question ends in each the worksheet and the Information Mannequin when modifying both one of many two load settings.

Load a question into the Excel Information Mannequin

To load a question to the Excel Information Mannequin, within the Load To popup window, test the Add the info to the Information Mannequin field. To learn to show the Load To popup window, see the Load queries into your workbook part above.

Set default question load settings

Comply with these steps to set your default question load settings:

  1. Within the Energy Question ribbon tab, click on Choices.

  2. Within the Choices popup window, select a Default Question Load Setting.

Options

Observe: The Question Editor solely seems if you load, edit, or create a brand new question utilizing Energy Question. The video under reveals the Question Editor window showing after modifying a question from an Excel workbook. To view the Question Editor with out loading or modifying an present workbook question: From the Get Exterior Information part within the Energy Question ribbon tab, choose From Different Sources > Clean Question.

How to see Query Editor in Excel

Leave a Reply