If you select the View data or edit query in Microsoft Query option you can now open the SQL Edit Query window by hitting the SQL button.
![how to add power query to excel 2016 how to add power query to excel 2016](https://i1.wp.com/radacad.com/wp-content/uploads/2018/02/2018-02-21_08h32_06.png)
Select the last option From Microsoft Query. Go to the DATA Ribbon Tab and click From Other Sources.
![how to add power query to excel 2016 how to add power query to excel 2016](https://cdn.wallstreetmojo.com/wp-content/uploads/2019/09/Power-Query-in-Excel.png)
Open the MS Query (from Other Sources) wizard I will want to create a simple query to calculate how many are Male and how many Female. In this file I have a list of Male/Female mock-up customers. I will extract data from an External Excel file called MOCK DATA.xlsx.
HOW TO ADD POWER QUERY TO EXCEL 2016 HOW TO
In this step by step tutorial I will show you how to create an Microsoft Query to extract data from either you current Workbook or an external Excel file. Want more SQL Capabilities in Excel? Check-out my Excel SQL AddIn Step by Step – Microsoft Query in Excel
![how to add power query to excel 2016 how to add power query to excel 2016](https://www.fm-magazine.com/content/fmm-home/news/2020/jun/transform-data-with-microsoft-excel-power-query/_jcr_content/article/articleparsys/image_846261879.img.png)
Using MS Query in Excel you can extract data from various sources such as: Its an incredible often untapped tool underestimated by many users! What can I do with MS Query?
HOW TO ADD POWER QUERY TO EXCEL 2016 WINDOWS
Excel as well as Access use Windows ACE.OLEDB or JET.OLEDB providers to run queries. A Microsoft Query (aka MS Query, aka Excel Query) is in fact an SQL SELECT Statement. Often Microsoft Query statements will be more efficient than Excel formulas or a VBA Macro. Microsoft Query allows you use SQL directly in Microsoft Excel, treating Sheets as tables against which you can run Select statements with JOINs, UNIONs and more. Excel Queries created this way can be refreshed and rerun making them a comfortable and efficient tool in Excel. You can use Microsoft Query in Excel to retrieve data from an Excel Workbook as well as External Data Sources using SQL SELECT Statements.