How to Perform Multiple Queries on an Excel Spreadsheet. Using the External Data Connection feature in Excel, you can acquire information from external sources, such as Access and SQL Server.