All Categories
    Filters
    Preferences
    Search

    Top Excel Functions & Formulas for Bankers

    $99.00
    *
    Excel has many built-in functions that help you deal with that data. It is very important that you know how to use some of these functions to get the most out of your data in a time efficient manner. This way, you can turn the data into meaningful information and then provide the answers that you need for yourself, your boss, your company or your organization.

    When you register for this webinar you will receive complimentary sample files that will help you get the most out of your Excel data. 

    Overview

    In the business world, or within your organization, you probably experience large amounts of data. Maybe the data is about your sales, customers, donations, orders, employees, vendors, expenses, or whatever it may be.

    Excel has many built-in functions that help you deal with that data. It is very important that you know how to use some of these functions to get the most out of your data in a time efficient manner. This way, you can turn the data into meaningful information and then provide the answers that you need for yourself, your boss, and/or your Financial Institution. 

    This webinar will tremendously benefit anyone who handles large amounts of data in Excel.

    Covered Topics

    •       Relative formulas
    •       Absolute Formuals
    •       IF
    •       And
    •       Or
    •       Vlookup
    •       Sumif
    •       Countif
    •       Averageif
    •       Sumifs
    •       Countifs
    •       Networkdays

    Who Should Attend? 

    This informative session is designed for:

    •        CEOs / CFOs / CTOs
    •        Branch Managers
    •        Tellers
    •        Supervisors 
    •        Senior Leadership
    •        Anyone who regularly uses Excel, & wants to be more         efficient and productive
    Write your own review
    • Only registered users can write reviews
    • Bad
    • Excellent

    When you register for this webinar you will receive complimentary sample files that will help you get the most out of your Excel data. 

    Overview

    In the business world, or within your organization, you probably experience large amounts of data. Maybe the data is about your sales, customers, donations, orders, employees, vendors, expenses, or whatever it may be.

    Excel has many built-in functions that help you deal with that data. It is very important that you know how to use some of these functions to get the most out of your data in a time efficient manner. This way, you can turn the data into meaningful information and then provide the answers that you need for yourself, your boss, and/or your Financial Institution. 

    This webinar will tremendously benefit anyone who handles large amounts of data in Excel.

    Covered Topics

    •       Relative formulas
    •       Absolute Formuals
    •       IF
    •       And
    •       Or
    •       Vlookup
    •       Sumif
    •       Countif
    •       Averageif
    •       Sumifs
    •       Countifs
    •       Networkdays

    Who Should Attend? 

    This informative session is designed for:

    •        CEOs / CFOs / CTOs
    •        Branch Managers
    •        Tellers
    •        Supervisors 
    •        Senior Leadership
    •        Anyone who regularly uses Excel, & wants to be more         efficient and productive
    Product tags
    Customers who bought this item also bought

    Crafting Effective Loan Policies and Procedures

    $99.00
    Participants will understand what constitutes a well planned institutional loan policy that is in accordance with sound practices as well as regulatory requirements. You will also discover how to devise clear, precise, and meaningful procedures to audit the loan function.

    3 Key Risk Assessments in Your ERM Program: ERM, IT, and Internal Controls

    $99.00
    This webinar will first take you through a step-by-step process to develop strong Risk Assessments to address key areas of your institution. Then the presenter will specifically focus on three key Risk Assessments you must have as critical components of your ERM Program: the Enterprise Risk Management Risk Assessment, Information Technology Risk Assessment, and the Internal Controls Risk Assessment. You will walk away with practical tools and examples you can implement in your organization immediately.

    2018 Collecting Past Due Accounts: CFPB, UDAAP, FCRA, FACTA, MLA, SCRA, & More

    $99.00
    In this session, we will examine the CFPB's broad application of its UDAAP authority. Taken together with an exploration of the CFPB's various informal guidance documents addressing debt collection issues, we will determine what constitutes a potential UDAAP violation according to the Bureau. We will also review the Federal Deposit Insurance Corporation's (FDIC) debt collection recommendations for 1st party collectors, as well as compliance points related to the Fair Credit Reporting Act (FCRA), the Fair and Accurate Credit Transaction Act (FACTA), and the Fair Debt Collection Practices Act (FDCPA). Finally, we will explore the recent verdicts and rulings that affect how you handle slow-paying accounts.

    Commercial Real Estate Lending in Today’s Economy

    $99.00
    The commercial real estate market has its “ups” and “downs.” Prior to the “Great Recession,” many banks were heavily concentrated in this market. But as the market has started to recover, it is important that banks “cautiously” expand their commercial real estate loan portfolio. This requires an understanding of “commercial real estate” and the “loan transaction” process. Attend this Webinar to review the basics of “commercial real estate” including types of properties, environmental issues, and demand/supply in the “current” market.
    Presenter:

    Tom Fragale

    Tom Fragale is a computer professional with over 30 years of professional experience. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.