Drilling URLs and Querying from Excel

Have you ever wanted to: Run PeopleSoft queries from Excel? Onboard new users by simply handing them a workbook so they can use as a front end to run the most common queries? Wanted to have, in Excel, 15 versions of your favorite query pre-populated for the 15 cost centers you repeatedly research every month? This session will show you how- and with no VBA knowledge or additional software required! With basic Excel functions and some creative thinking Awith PeopleSoft’s delivered Drilling URL functionality, you too can have a tool that will make even the most inexperienced user comfortable researching with queries. You will learn how to build Drilling URLs and how to leverage these to create a front end for Query Manager within an Excel workbook. Complete with examples, demos, step-by-step instructions, and tips and tricks. For the past five years, over three hundred users have found this tool to be a staple of their daily interactions with PeopleSoft. Attend this session to see how!

Presented by Chris Sides, Alliance Data