![]() ![]() Next we need to specify the Data Source for our Microsoft Query. Select the last option From Microsoft Query. Go to the DATA Ribbon Tab and click From Other Sources. 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. 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
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |