Training Viewlets

A Viewlet is an online multimedia training presentation. Select the training that you would like to do from the links below.

---

Time Approval

• Time Approval - Supervisors 1of 2 (Basic Approval)

• Time Approval - Supervisors 2 of 2 (Printing and Sending Information)

• Time Approval - Kronos Managers

• Time Approval - Controllers

---

Budget Adjustment

• Electronic Budget Adjustment Training Module

---

Business Objects (BOb)

Introduction

• How to Use the Tutorials

Basic Training

• 1. What is BOb?

• 2. Logging into BOb

• 3. Layout and User Options

• 4. Running a Query

• 5. Downloading a Query to Excel

• 6. Using the Drill Function

Advanced Training

• 1. Editing a Query

• 2. Saving a Query

• 3. Sending a Query

---

CashNet

• 1. CashNet Login

• 2. Department Deposit

• 3. Full Cashiering

---

Delegation of Security Rights

• 1. Logging In

• 2. Reactiviating

---

Excel

• Subtotals - Apply subtotals in a block of data without inserting rows one-by-one and summing.

• Concatenation - Combine two or more cells together in one cell.

• VLOOKUP Function - Retrieve data from one worksheet to a second worksheet based on a matching field from both sheets.

• Pivot Table - Useful tool for data analysis.

• Left, Right, and Mid Functions - Extract needed characters from a field.

• Absolute Reference -

• Absolute Values -

• Charts and Graphs -

• Copy and Paste in one click

• Find -

• Sorting -

• Paste Special -

• File Name Formula -

• Excel Training Handout

• Excel Training Files

 

---

Extensity

• Create a Travel Plan

• Expenses: JP Morgan Card

• Expenses: Entertainment

• Expenses: Meals

• Expenses: Meals on JP Morgan Card

• Expenses: Attach A Travel Plan

• Using A Filter

• Check Document Status

---

Kronos

• Kronos Training

---

QuikPay

• 1. QuikPay Basics

• 2. Paying Tuition

• 3. Paying with a Credit Card

• 4. Creating Scheduled Payments