Business Systems & Processes

Provides training to teach and expose employees on how to do business using various business systems and processes at Georgia State University.

Sample Courses:

This course covers the basic functions and features of Access 2010. After an introduction to database concepts and the Access environment and Help systems, students learn how to design databases. Then they work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students then learn about queries, forms, and reports. Prerequisite: Must know Windows.

Learn the fundamentals of Access as you work with tables, queries, and the important importing! After this course, you will be able to: create your own database from scratch; design and optimize tables for storing information; create text, numeric and other types of data fields; relate tables using referential integrity for effective data structures; and import and export data from Access. Prerequisite: Access Level I.

This course provides hiring managers and internal employees the necessary knowledge on how to post vacancies, manage applications and submit qualified candidates for recommendation. Individuals learn about system functions and methods to decrease hiring turnaround time, including techniques and strategies for identifying the most qualified candidates.
Do you or others use your personal vehicle for GSU business? Find out what the State covers.
For users who build PowerPoint presentations, this course shows the tips and tricks to build superior presentations. Wow your audience with interesting animations and engaging custom graphics. Course goals create customized presentations with templates. Add special effects. Use the slide, notes, and handout masters. Create, edit, and import charts. Manage hyperlinks. Create custom shows.
Learn how to create beautiful professional looking forms for Georgia State University and beyond! Learn about the form creation tools found in Word 2010 and how to produce electronic forms that are visually pleasing and easy to navigate. The course covers designing a form; capturing data effectively with drop down lists, date pickers, and check boxes; and adding controls for repeating data using the Word Content Control Toolkit. The course also includes protecting and distributing forms. This course includes five real-world projects. Exercise files accompany the course.
Attendance at both courses required. No multiple registrations or late admissions.
Informational level only. Review of first aid basics. Not a certification course.
Mandatory training for GSU drivers. Recommended training for personal use.
Learn how to have a safer holiday – on and off the job.
This course provides training on the basic navigation of the PeopleSoft Financials and Panther Mart tools and basic concepts of Financials operations.
This course provides training on the general ledger module. A journal is the vehicle used to correct/adjust previously recorded transactions, process interdepartmental invoices, transfer expenditures, record departmental sales & service revenues, agency expenses and continuing education revenue and expenses. Participants will be taught how to create, modify, delete, print, and approve a journal, inquire on a journal and troubleshoot errors.
Managers have the dual tasks of evaluating performance of supervisors as well as reviewing evaluations prepared by supervisors. In both situations, managers must ensure that performance evaluations are fair, job-related, and absent discriminatory content and impact. Even more challenging, managers must ensure that performance appraisals meet legal guidelines, as well as maintaining employee morale and productivity. This course reviews such topics as avoiding discrimination in performance evaluations and in the evaluation process, evaluating a diverse workforce, setting goals and objectives, improving performance appraisals and the role of managers in the review process.
So you want to be more efficient with Excel but you don’t know where to start? This outstanding workshop taught by Microsoft Certified trainer Deborah Dunbar is the place to start! It’s your ticket to a faster, more productive way to master the beginner’s level of Excel. From worksheet shortcuts to getting beyond just typing numbers into a spreadsheet. If you are a beginner to Excel or rarely use it- this course is perfect for you! Most jobs requires basic Excel skills. You will learn the 6 areas that form the core of basic Excel skills.
Prerequisite: Must know Windows
Wouldn’t it be great if there were a way to expand your skills without having to go back to square one? Once you have finished this course you will know more than most people who are using Excel each day. So, can you multi-task? Learn how to work with large worksheets efficiently using 3-D formulas in multiple worksheets and workbooks at the same time. Calculate data with a variety of formulas including COUNT, COUNTA, and SUMIF. Powerful formulas you will also learn are: IF, AND, OR, NOT & VLOOKUP’s. A good use of these, especially with the logical formulas, can really enhance your analysis of your department’s data. Learn from Microsoft Certified trainer Deborah Dunbar.
Prerequisite: MS Excel LI
You've got the Power. Can you Pivot? In this course, you will learn about PivotTables and Pivot Charts. You will password protect your beloved spreadsheet or just a portion of your spreadsheet. You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications by importing and exporting data. Learn all this and more from a successful Microsoft Certified Trainer Deborah Dunbar.
Prerequisite: Must have taken Excel Level II
This course provides training for those people who will be requesting payments for less than $5,000 and generally these transactions include processing invoices, reimbursements, payments to independent contractors/consultants, food purchases, non-employee travel reimbursements, relocation and moving expenses, scholarships/fellowships and stipends. This course also provides training for those people who process travel for their departments and/or units. Only Employee and Student travel will be processed using the Panther Mart Travel Authorization form.
This course provides training for those people who will be procuring goods and services, equipment purchases and consultant agreements. This course will cover shopping using catalog, non-catalog and punch-out catalog; assigning carts; reviewing carts and assigning accounting and workflow information; submitting the purchase requisition into workflow, approving transactions and receipting goods.
This course details strategies to promote positive employee relations and Georgia State’s progressive disciplinary process. It identifies ways to motivate employees. It provides modeling and practice in how to hold discussions with staff members about unacceptable performance when coaching and feedback have failed to correct performance. The group will also discuss procedures for documentation and handling emotions under pressure.
This course provides training on the basic concepts of the PeopleSoft Financials Web query tool. A Query is an inquiry tool that allows users to easily retrieve specific data from the PeopleSoft system by specifying the records, fields and criteria to be applied to the search. Participants will be taught how to view existing queries, create a basic query, use the selection criteria and aggregate functions, download query results to an excel spreadsheet and find data in the PeopleSoft system.
Part 2 of the Query Basics course held on 12.10.13. Attendance at Part 1 is mandatory.
This course provides training on the various reports that are available to users and tells what the reports are used for (i.e., expenditure review). The course covers how to find financial information quickly, view detailed information using drill down features for purchase orders, vouchers, payments, journals and your budget. Participants will also learn how to run reports, print reports and monitor their budgets.
If you want to leave the office on time, then attend this class that teaches you how to use features in Microsoft Outlook to get more done in less time. You’ll learn how to use the new and improved Outlook ribbon, maneuver efficiently through the Outlook folders with easy click and drag techniques, use the Inbox and the Calendar as pseudo “to-do” lists and work with the Calendar as a planning tool. To complete the training, you’ll learn how to use Voting Buttons and how to survive the avalanche of email that dumps into your Inbox on a regular basis. Use the techniques taught in the class and you’ll be more productive – guaranteed.
Don’t let your productivity dip while you try to learn how to use the new features in Microsoft Outlook 2010. Attend this course and immediately you’ll be proficient. You’ll learn the differences between the To-Do List, To-Do Bar and the Tasks folder and how to use the Tasks folder to drive project productivity. You’ll be introduced to amazing new features such as Quick Steps and “View as Conversation” and learn why these new features can help you rapidly process email. The added bonus is learning how to be more productive using the Calendar as a tool for managing daily work flow.

Back to OLP Page