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:
- What constitutes a violation of the code of conduct.
- Why excellence is important to the institution and how the learner can contribute to the success of the organization.
- What constitutes prohibited financial interests and how they can be avoided.
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:
- Utilize specific evaluation activities and processes and methodologies.
- Communicate effectively while addressing, assessing, and responding to risk.
- Understand the importance of objective settings, internal environments, and the application of ERM.
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:
- Different classifications of emotion.
- The correlation between emotional intelligence and success in the workplace.
- How to respond appropriately to the emotions of others.
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:
- The financial institution’s responsibilities and role in preventing and detecting elder financial abuse.
- How to empower elderly customers to better protect them from abuse.
- The role of Adult Protective Services.
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:
- Develop, plan, and practice a presentation professionally.
- ;Use visual aids, scripts, and podiums to augment presentations.
- Make eye contact and use good posture and vocal projection.
Seat Time: 2.5hrs - Desc:
This course will introduce the learner to the process of credit analysis. This course will familiarize learners with macroeconomics, in addition to economic, general business, and micros cycles and industry, business and product life cycles. After completing this program the learner will understand:
- The five competitive forces in industry.
- How to develop a company overview.
- The accounting cycle.
Seat Time: 1.5hrs - Desc:
This course will introduce the learner to diversity in the workplace. The course will familiarize the learner with the importance of maintaining a diverse workplace by highlighting the benefits working in a diverse organization. After completing this course, the learner will understand:
- How promoting diversity enables the organization to retain talent, increase productivity and profitability, and instill a sense of loyalty in employee.
- How stereotyping, discrimination and prejudice can serious problems at the organization.
- Why encouraging cultural awareness among employees is important to the organization.