The Get And Transform tool is designed around accessing external datasets; however, you can use Excel Data Tables to connect your queries to data within your workbook. Learn how with this lesson!