Microsoft Office 2010 – Excel and Word
Microsoft Excel
- In order to work with PeopleSoft Query output, you will generally run the query to Excel.
- To make the best use of Excel’s features once the information has been downloaded, it is recommended that you have a good general understanding of how Excel 2010 works.
- One helpful tool is the Pivot Table which enables you to summarize and analyze data in lists and tables. With pivot tables you can quickly rearrange the position of fields to give you a different view of the table.
- Click on this link to learn about the Excel 2010 Shortcut and Function Keys
- Excel 2010 is a topic that is covered in Lynda.com which you you can reach by clicking on the link under Campus Applications in Wes Portal. There are a number of lessons and related videos available.
Microsoft Word
- Microsoft Word Mail Merge is an effective tool if your office needs a method to produce basic mass mailings, envelopes, and labels, etc. *
- This is another subject area that requires a thorough understanding to get the most benefit from this component.
- Click here to read about the Keyboard Shortcuts for Microsoft Office Word
- Word 2010 is also a topic that is covered in Lynda.com which you you can reach by clicking on the link under Administrative Applications in your Portfolio. There are a number of lessons and related videos available.
*NOTE: If you are thinking about using PeopleSoft Query to aid in producing reports and/or mass communications, you may want to consider the features of these PeopleSoft Tools: BI PUBLISHER (formerly XML Publisher) and COMMUNICATION GENERATION (COMM GEN).