Related Links
 QueryLink Overview
 Menu: Data Warehouse
 Departments
 Administrative Computing and Telecommunications

 Blink Home > Technology > QueryLink and Excel PivotTables
Make Blink yours!
 · Activate personalization
 · Learn about MyBlink
Get what you wanted?
yes no Comments

EmployeeLink This system is working normally. If you experience any problems, please report them to the ACT Help Desk at (858)534-1853
FinancialLink This system is working normally. If you experience any problems, please report them to the ACT Help Desk at (858)534-1853
TritonLink This system is working normally. If you experience any problems, please report them to the ACT Help Desk at (858)534-1853
TravelLink This system is working normally. If you experience any problems, please report them to the ACT Help Desk at (858)534-1853   |  More...

At Your Service Online
    Via Single Sign-On
    Via AYSO password
MyApprovals
MyBlink
MyDashboard
MyDirectory
MyEffort
MyFunds
MyLeaveBalances
MyTime
MyTraining
MyTravel    |   Info ...
News and events
UCSD News
This Week @ UCSD
Calendar of Events
Staff Ed classes
Find What's New
Find the most recent articles by topic.
UCSD News & Information
UCSD Events Calendar
Blink online glossaryOnline glossary
Stumped by a word on Blink? Look it up!
Blink e-mail reminders Reminder Service
Blink can remind you of important events.
Department Index
QueryLink and Excel PivotTables  
 
Summary: 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.

If you have questions about QueryLink contact the Data Warehouse Team.

  Print
Print this page		   Email
Share this page		   Add to MyBlink
Save this link		   Get notified when this page is updated
Notify on change		   Add a sticky note to this page
Add a note		  
Last reviewed/updated on Aug. 22, 2007 (see more info)
Blink A-Z Index:   0-9  A B C D E F G H  I  J K L M N O P Q R S T U V W X Y Z 


Blink Home  Site Map  Help  Accessibility Tips  Privacy Statement  Content Manager  RSS Feed 


Copyright ©2008 Regents of the University of California. All rights reserved.
Official Web Page of the University of California, San Diego

Blink version 1.7 12-17/2007 Blink Usability Group