![excel query table templates excel query table templates](https://miro.medium.com/max/1400/1*cn1guaUtuQbxnky1by_RiQ.png)
The image below displays the results that appear if you select Run to HTML. To limit the search, enter a course subject such as ACG or BSC.ĥ.Click View Results to run the query and see your data.Ħ. Enter subject or % for all-The % is a wildcard value in this system.To filter other campuses from the search, enter one of the three campuses (i.e., MAIN, Panama City, or Republic of Panama). Entering % returns courses for all campuses. Enter campus or % for all-The % is a wildcard value in this system.Always provide a value here to limit your results. Click the Look Up button (magnifying glass) to search for the necessary academic organization/s. Acad Org-The academic organization value limits the search to only those units you specify.Institution-The institution value is always FSU01.Term-The term value is equivalent to the term value used in scheduling.The FSU_SR_CLASS_RSRV_CAP_LIST selection provides an example of the class reserve-capacity query's search criteria: NOTE: Search-criteria field options vary depending on the specific query.
![excel query table templates excel query table templates](https://d13ot9o61jdzpp.cloudfront.net/images/pq_consolidate_sheets_diagram.png)
When you select Run to HTML or Run to Excel, an interface appears displaying fields for entering search criteria. NOTE: You can add a query to your favorites list for quick navigation to the queries you run frequently.Ĥ. Do not select the Run to Excel option if Excel is not installed on your computer.
#EXCEL QUERY TABLE TEMPLATES DOWNLOAD#
Approve this action for the download to complete. If your computer blocks pop-ups, you may be prompted by the browser to approve the download. NOTE: If you select Run to Excel, the resulting data is exported directly to Excel. Prompt fields appear in which to enter criteria. Choose a query to run: Run to HTML, Run to Excel, or Run to XML. NOTE: The FSU_SR_CLASS category includes data elements that return reports related to scheduling data.ģ. In the Search By field, type FSU_SR_CLASS.Ģ. Go to Main Menu>Reporting Tools>Query>Query Viewerġ.
![excel query table templates excel query table templates](https://trumpexcel.com/wp-content/uploads/2017/12/Select-table-in-power-Query-Editor.png)
#EXCEL QUERY TABLE TEMPLATES HOW TO#
Further down the page, some examples of how to format results in Excel are shown. The example below is an FSU_SR_CLASS query that uses reserve capacity data to generate report results. Queries allow you to generate reports based on whatever data elements you choose to include.