New video tutorials available: “Excel & PeopleSoft Queries”

posted Oct 26, 2017, 12:40 PM by Peyri Herrera
New

These 2 video tutorials can be accessed at http://crc.sdcoe.net/resources/peoplesoft/tutorials

PeopleSoft Conference - Excel and PeopleSoft Queries HCM Video
This 12-minute video demonstrates several Excel functions: pivot table, freeze panes, filters, subtotaling, remove duplicates, vlookup, and concatenate. Data from two HCM queries are used: M_TL_PAYABLE_TIME_AUDIT and M_PY_PAYCHECKS_BY_DIST.
Excel and PeopleSoft Queries HCM Video


PeopleSoft Conference - Excel and PeopleSoft Queries FIN Video
This 12-minute video shows some ways to analyze the M_GL_DETAILS_PO query in Excel using filters, pivot tables, If and Left formulas. This query includes all details in Finance including AP payment information. Learn how to summarize the data very quickly with a few formulas and a pivot table. At about 7 min, 41 sec, see how to configure a pivot table to mimic a Trial Balance by Restricted and Unrestricted.
Excel and PeopleSoft Queries FIN Video