All Categories
    Filters
    Preferences
    Search

    Excel for Bankers: Pivot Tables, Pivot Charts, Slicers, & Timelines

    $219.00
    *
    Upon completion of this webinar, participants will be able to: • Create a Pivot Table • Create a Pivot Chart • Sort and Filter a Pivot Table • Manipulate a Pivot Table • Add Slicers and Timelines to a Pivot Table

    When you register for this webinar you will receive complimentary Pivot Table Toolkit, which will help you convert your raw data into useful Pivot Tables and Charts.  

    Overview 

    Many people struggle with making sense of raw data. Maybe you're unsure of what can be done with the data in the first place. Or, maybe you've heard about putting data into Pivot Tables, but think they are too difficult to bother. Or, perhaps, you are confused by the actual process of creating Pivot Tables. 

    Regardless of why Pivot Tables give you pause, after attending this webinar, you will be able to take all of your raw data and quickly turn that data into easy to use flexible summary reports using Pivot Tables and Charts. You and your staff will be instantly more productive in Excel. These techniques will work with any type of data. You will find these methods to be clear and concise and right to the point, and you will be able to apply these techniques to your own data immediately after the session.

    Excel Expert Tom Fragile will show you what Pivot Tables are, how to use them, and prove to you not only that Pivot Tables are user-friendly, but also that they can provide tremendous results for your Financial Institution. We will start with the basics and build up to more complex pivot tables. We will then create several Pivot Charts together, and you will see the benefits of graphically examining data.

    We will then add sorts, filters, slicers, and timelines to create an extraordinarily easy-to-use, highly powerful dashboard that will give you instant results, and allow you to slice and dice your data any which way. 

    Covered Topics

    •        Creating and managing Pivot Tables.
    •        Changing the calculation type
    •        Adding additional calculations
    •        Creating custom calculations
    •        Multilayer reports
    •        Creating Daily, Monthly, quarterly and yearly summaries
    •        Adding A pivot chart
    •        Adding Slicers
    •        Adding timelines

    Who Should Attend?

    This informative session is designed for:

    •        CEOs
    •        CFOs
    •        CTOs
    •        Branch Managers
    •        Bank Tellers
    •        Management of all levels
    •        Anybody who uses Excel on a regular basis, and want 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 Pivot Table Toolkit, which will help you convert your raw data into useful Pivot Tables and Charts.  

    Overview 

    Many people struggle with making sense of raw data. Maybe you're unsure of what can be done with the data in the first place. Or, maybe you've heard about putting data into Pivot Tables, but think they are too difficult to bother. Or, perhaps, you are confused by the actual process of creating Pivot Tables. 

    Regardless of why Pivot Tables give you pause, after attending this webinar, you will be able to take all of your raw data and quickly turn that data into easy to use flexible summary reports using Pivot Tables and Charts. You and your staff will be instantly more productive in Excel. These techniques will work with any type of data. You will find these methods to be clear and concise and right to the point, and you will be able to apply these techniques to your own data immediately after the session.

    Excel Expert Tom Fragile will show you what Pivot Tables are, how to use them, and prove to you not only that Pivot Tables are user-friendly, but also that they can provide tremendous results for your Financial Institution. We will start with the basics and build up to more complex pivot tables. We will then create several Pivot Charts together, and you will see the benefits of graphically examining data.

    We will then add sorts, filters, slicers, and timelines to create an extraordinarily easy-to-use, highly powerful dashboard that will give you instant results, and allow you to slice and dice your data any which way. 

    Covered Topics

    •        Creating and managing Pivot Tables.
    •        Changing the calculation type
    •        Adding additional calculations
    •        Creating custom calculations
    •        Multilayer reports
    •        Creating Daily, Monthly, quarterly and yearly summaries
    •        Adding A pivot chart
    •        Adding Slicers
    •        Adding timelines

    Who Should Attend?

    This informative session is designed for:

    •        CEOs
    •        CFOs
    •        CTOs
    •        Branch Managers
    •        Bank Tellers
    •        Management of all levels
    •        Anybody who uses Excel on a regular basis, and want to be more efficient and productive
    Customers who bought this item also bought

    Final Regulation CC Changes & Compliance: The Elements of an Effective Funds Availability Program

    $219.00
    This session will explore what steps need to be taken to implement an effective Regulation CC compliance program; will breakdown the new rule section-by-section and explain the effects these changes have on your check clearing procedures; and, will outline the procedures your institution must have in place for a sound and compliant effective funds availability program.

    Commercial Loan Structure, Documentation, & Compliance Training

    $219.00
    This proactive webinar provides a thorough overview of commercial lending requirements from a loan structure, documentation, and compliance perspective. Basic business structure will be presented along with loan structure and loan support. Additionally, commercial lending issues relative to loan documentation will be reviewed. Loan pricing and monitoring will also be covered along with a review of current compliance issues. The webinar will be summarized through a comprehensive case study.

    New CECL Approach to Determine Allowance for Loan & Leases

    $219.00
    This webinar summarizes the new accounting standard (ASU 2016-13, Financial Instruments – Credit Losses) for the determination of the Allowance for Loan & Leases (ALLL) – the new standard that replaces the incurred-loss model currently in use. This carefully presented overview should take away the mystique and in some cases the fear of the estimation (forecasting) requirements now required under CECL.

    ADA Website Compliance: Best Practices to Avoid High-Speed Claims

    $219.00
    Claims under Title III of the Americans with Disabilities Act (ADA) are rising. The DOJ received 6,391 accessibility complaints in 2015—a 40% increase over 2014. Moreover, 240 businesses across the United States have been sued by plaintiffs who claim these organizations' websites fail to accommodate certain disabilities. Even more Financial Institutions and businesses have received demand letters from law firms. Targets have been strong-armed into settlement agreements due to plaintiffs' citation of favorable arguments in previous cases which held that the ADA applies to websites.
    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.