Logo: Wesleyan University
  • Tools
    • WesPortal
    • Directory
    • Library
    • OneStop
    • WesConnect
    • Calendar
    • WesMaps
    • WFS
    • Moodle
    • EMS
    • GApps
  • About
  • Admission & Financial Aid
  • Academics
  • Campus
  • Athletics
  • Give
  • Students
  • Alumni
  • Parents

Student Faculty Information System

PeopleSoft Campus Solutions

Feed on
Posts
Comments
« Welcome to the SFIS Blog!
Highlighting the SFIS FAQs Page »

Query Tip Sheet and Working with Microsoft Excel and Word

May. 12, 2010 by Carolyn Pike

Since the introduction of the SFIS Blog last week, there have been three additions to the Query section that you should know about:

 

 First, there is a Query Tip Sheet that has hints, suggestions, and ideas.  Among the topics discussed are joins, table ordering and criteria.  This page will be added to as needed. 

 

 Second, there is a page entitled Using Microsoft Excel and Word with Query which gives you some information about instructional resources for these tools that are used with data derived from Query.  

 

 Third – related to the previous item – is Query to Excel (Pivot Table Intro) which is a brief demonstration of the utility of Excel Pivot Table with typical SFIS data. 

Tags: Criteria, Microsoft Excel, Microsoft Word, Query - Advanced, Query Joins, Summarizing, Table Ordering, Translate Values

Posted in Blog Tips, Query - Advanced, Query - Getting Started

Comments are closed.