![]() These 2 video tutorials can be accessed at http://crc.sdcoe.net/resources/peoplesoft/tutorials. 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. 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. |
Announcements > PeopleSoft Announcements >