ND HEUG Conference 2006
ND HEUG Conference 2006Finance
Campus
Access Control — Finance and HRMS:
PowerPoint in PDF
An overview of duties of campus access control officers. Includes revision of
forms, terminations of users; verification of FERPA and/or Employee Data Privacy
Training; additional roles; new menus and navigations; and Q & A.
Barb Rask, HECN
Query Writing for
Finance and HRMS Tracks:
PowerPoint in PDF
What are query writers trained to do? What can they accomplish with query writing?
What happens if your query writer writes a great query?
Sue Rosha, UND
General Ledger and Purchase
Order Issues :
PowerPoint in PDF
(Combo edits, use of projects, balancing POs to KK)
This session will review combo edits and budget definitions relating to projects
within a chartfield when used on purchase orders and PO vouchers.
Pam Hurdelbrink, NDUS
Linda Romuld, NDUS
Vendors and Withholding:
PowerPoint in PDF
Review of vendor set up for 1099 reporting and 1099 reporting maintenance throughout
the calendar year.
Linda Romuld, NDUS
Payroll Vouchers:
PowerPoint in PDF
Payroll Vouchers paid quarterly or annually. come see a work around to record
the cash and accounts payable entries for the payment on payday.
Pat Hanson, UIND
Allison Peyton, UND
Reconciling
Financial Aid Awards/Distributions to the General Ledger:
PowerPoint in PDF
Users will learn how to retrieve data from Student Administration and what was
disbursed with what has actually hit the General Ledger.
Angela Uhlenkamp, NDUS-SIS, HECN
Pam Hurdelbrink, NDUS
Analyzing Your Data
Using Excel:
PowerPoint in PDF
XP Version: Excel in a Nutshell
Using PeopleSoft Data:MS
Word in PDF
ConnectND NDUS Training and
Documentation Using MS Excel:
Web page link
In this session the user will learn to use features in Excel such as
Sorts, Subtotals, Filters, Vlookup Function and Pivot Tables to analyze
the data from queries and
data dumps. The PowerPoint slide above is a broad outline of the presentation
while the real essence
existed in using Excel live during the seesion. Excel training is summarized
in the XP Version: Excel in a Nutshell Using PeopleSoft Data document with embedded
links to other documents. For additional training please check the
ConnectND NDUS Training and Documentation Using MS Excel
web page for MS Excel documents and companion WebEx recordings
(an audio and video walk-through on how to actually do it) on all of the above MS Excel features.
wMaria Saucedo, NDUS-SIS, HECN
Dan Johnson, LRSC
05/02/2006