Faculty and Staff

QueryLink and Excel PivotTables

Last updated August 19, 2009 1:42:33 PM PDT
Give more feedback

With QueryLink you can download data directly into an Excel PivotTable.

Features

  • Creating: QueryLink automatically defines and creates a PivotTable when you choose the data you want.
  • Downloading: To download the data, select "Excel 2000/XP PivotTable" from the drop down list at the bottom of Query pages.


Sample PivotTable


Need more information? Learn about using Excel PivotTables with Microsoft's tutorial or attend the Microsoft Excel XP class offered through Enrollment Central.

For more information about QueryLink contact the Data Warehouse Team.

Technology

Creating an SQL Statement

Departments

Administrative Computing and Telecommunications