Microsoft Excel - Intermediate
01 - Intro
02 - Charts
03 - Headers, Footers & Layout Options
04 - What If
05 - Basic Tables in Excel
06 - Pivot Tables
07 - Manipulating Data Within the Pivot Tables
08 - Pivot Table Charts
09 - Data Validation
10 - Conclusion
Microsoft Excel - Basic
01 - Intro
02 - Interface & Functions
03 - Cells
04 - Entering Data into Cells
05 - Basic Formatting in Excel
06 - Creating a Worksheet
07 - The Intelligence of Excel
08 - Customizing Rows & Columns
09 - Creating Formulas
10 - Summary Pages and Moving Workbook to Workbook
11 - The Function Builder
12 - Conditional Formatting
13 - Sorting & Filtering Data
14 - Printing with Excel
15 - Conclusion
Microsoft Excel - Advanced
01 - Intro
02 - Customizing the Ribbon & Cells
03 - Creating & Managing Ranges
04 - More Formulas
05 - Data Analysis
06 - Data from an Outside Source
07 - Spark Lines
08 - Macros
09 - Conclusion
Seat Time: 2hrs - Desc:
This course will introduce the learner to the code of conduct by which all employees must abide at the institution. The course will familiarize the learner with various aspects of the code, including policies on insider trading, outside activities, and conflicts of interest. After completing this course, the learner will understand:
Seat Time: 2.75hrs - Desc:
This course will help the learner to understand risk, and how to apply Enterprise Risk Management (ERM). The learner will be provided with an overview of ERM objectives and requirements, and will address risk assessment and response. After completing this program, the learner will be able to:
Seat Time: 2.25hrs - Desc:
This course presents the concept of emotional intelligence, the emotions that create the base of emotional intelligence, and how to stimulate it for success on the job. Upon successful completion of this course, the learner will be able to understand:
This course will introduce the learner to the increasing problem of elder financial abuse and the measures that are being taken to detect and prevent it. The course will familiarize the learner with federal and state laws that address elder financial abuse, in addition to providing advice for protecting elderly customers and how to report suspicions of elder financial abuse. After completing this program, the learner will understand:
Seat Time: 2hrs - Desc:
This course will examine the attributes of good presenters, including making eye contact and projecting voice. The learner will become acquainted with presenter delivery sequence and other strategies for presenting. After completing this program, the learner will be able to: