Home / Educational Content / PeopleSoft / Drilling URLs and Querying from Excel

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

Watch the full-length video

Premium Content: access is limited to Quest Corporate and Professional members.

Membership has its perks. Get unlimited access to the latest Oracle updates, event session replays, strategic content centers and special members-only programming, plus big discounts on conference registration, with a Quest Corporate or Professional membership. Quest is where you learn.

Drilling URLs and Querying from Excel