David Ringstrom demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly Office 365) version of Excel. He draws your attention to any differences in the older versions of Excel (2021, 2019, 2016, and earlier) during the presentation as well as in his detailed handouts. Ringstrom also provides an Excel workbook that includes most of the examples he uses during the webcast.
Microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2021, Excel 2019, and so on.
What You’ll Learn
- Adding a percentage column to a pivot table with just a couple of mouse actions
- Adding rows to a blank pivot table to create instant reports
- Applying a consistent look and feel to your charts by way of chart templates
- Combining the VLOOKUP and MATCH functions to summarize income statement data for use in a waterfall chart
- Enlivening staid lists of numbers with the Data Bars conditional formatting
- Filling blanks and removing unwanted rows from a general ledger report with Power Query
- Filtering data within pivot tables in Excel 2010 and later by way of the Slicer feature
- Filtering pivot tables to show fewer columns and/or rows of data
- Illustrating numbers within a list by using the Icon Sets conditional formatting
- Improving the integrity of Excel pivot tables with the Table feature
- Jump-starting data visualization with the Quick Analysis feature
- Managing data security prompts that may appear when you link external data into Excel spreadsheets
Who Should Attend
Practitioners who create and work with monthly financial statements will learn to work in a more efficient and effective manner.
Presenter Bio
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. Ringstrom’s mantra is “Either you work Excel, or it works you”, so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. To learn more about Ringstrom, you can view his LinkedIn profile and follow him on Facebook or Twitter (@excelwriter).
Registration Options
Live Access, 30 Days OnDemand Playback, Presenter Materials and Handouts $279
- Available Upgrades:
- 12 Months OnDemand Playback + $110
- 12 Months OnDemand Playback + Digital Download + $140
- Additional Live Access + $85 per person
Controlling a Borrower’s Business Without Taking Control Through the Loan Agreement
Often times, a commercial banker may want to control their commercial borrowers’ business without taking control in an effort to protect the bank’s investment. It is never advisable for any bank to dictate the day-to-day decisions of any organization otherwise; the bank may face lender liability if the borrower follows the banks instructions but fails during the process. So, how can you control a commercial borrower without taking control of their business?
All loans have loan agreements. However, some loan agreements are more tangible than others. At one end of the spectrum are lengthy agreements that have been formally drafted by legal counsel. In the middle are pre-printed loan agreements, usually containing a security agreement that banks may use for nearly any type of credit extended. At the other extreme are completely informal oral agreements, which have little significance.
Many financial institutions take the position that loan agreements are simply too complicated and often attempt to avoid using them in loan transactions. However, loan agreements can benefit both the lender and the borrower. While the borrower must have sufficient latitude to operate the company, certain limitations must be placed on the business due to the financial institution’s credit exposure. Provisions in the loan agreement must be drafted to guarantee adequate cash is conserved by the borrower to ensure continued financial viability and to repay the financial institution’s loan.
In this webinar, we will discuss formal loan agreements that are generally used for commercial borrowers. In general, loan agreements are used for the following reasons:
- Sets forth the agreement between the financial institution and the borrower by clearly and concisely defining the duties and responsibilities of both parties during the term of the loan
- Establishes restrictions and qualifications on the borrower’s activities and financial condition, which are set out by affirmative and negative covenants
- Causes the borrower and lender to work through various contingencies thus preparing an alternative plan of action that both parties can agree to abide by should the original plan become inoperable
- Serves as a communication tool and monitoring device by requiring the borrower to submit certain documents at specified times and to require notification of the lender about certain plans of the borrower (Example: periodic financial statements and financial projections).
What You’ll Learn:
- Define the loan agreement
- Know When a loan agreement is required to monitor your borrowers’ activities
- Understand the rights afforded by the loan agreement
- Know the key covenants to insert to monitor your borrowers’ financial condition
- Understand the relationship of the loan agreements with other loan documents
Who Should Attend?
This informative session is designed for Chief Risk Officers, Senior Credit Officers, Senior Loan Officers, Credit Administration Officers, Loan Review Personnel, Commercial Loan Officers, Consumer Loan Officers, Branch Managers, Credit Analysts, and Special Assets Officers.
Presenter Bio
Jeffery W. Johnson, MBA – Bankers Insight Group
Jeffery Johnson has been in financial services more than 40 years. He has been VP and senior lender for a large regional bank and SVP and commercial banking division manager for a community financial institution. Most of his career has been spent in credit administration, lending, business development, loan review, management, and training and development. Over the last 17 years, Johnson has provided training for several banking associations and individual financial institutions nationwide.
Johnson holds a bachelors in accounting from Morehouse College in Atlanta, an MBA in finance from John Carroll University in Cleveland, a Diploma of Graduation from the Prochnow School of Banking at the University of Wisconsin-Madison, and a Graduate Certificate in Bank Management from the First American Management Institute at the University of Pennsylvania’s Wharton School of Business.
Registration Options
- Live Access, 30 Days OnDemand Playback, Presenter Materials and Handouts – $279
- Available Upgrades:
- 12 Months OnDemand Playback + $110
- 12 Months OnDemand Playback + CD + $140
- Additional Live Access + $75 per person
This webinar will teach you how to create a supportive learning culture and boost motivation, engagement, and success. Discover expert strategies for mastering the art of facilitation, and learn how to become a role model in your organization.
Being an inspirational facilitator has a positive impact on employee motivation, engagement, and overall success. Learning to create a supportive learning culture leads to better and more efficient performance, and a greater likelihood of successful careers within your organization. Trainers who master the skill of facilitation tend to become role models and have a lasting impact on the employees’ professional lives.
What You’ll Learn
- Understanding the materials and tools
- Understanding the room Virtual or Face-to-Face
- What Facilitators should and should not do
- Create trust-building skills
- Encourage open communication skills
- Handling difficult conversation skills within the classroom
Who Should Attend
Anyone new to bank training, seasoned trainers wanting to refresh their skills, or anyone needing to become a Training Ambassador for their company.
Presenter
As a Certified Professional in Training Management (CPTM™), Bobbi McVey-Blath works with an array of banking staff to ensure the training is aligned with the company’s initiatives. Having worked in the banking field for over 25 years, McVey-Blath has had the opportunity to create curricula and facilitate to all levels, from onboarding to supervisor workshops & executive leadership. She is passionate about helping other trainers in her field and enjoys mentoring and coaching them.
Registration Options
- Live Access, 30 Days OnDemand Playback, Presenter Materials and Handouts – $279
- Available Upgrades:
- 12 Months OnDemand Playback + $110
- 12 Months OnDemand Playback + CD + $140
- Additional Live Access + $75 per person
Are you ready to achieve remarkable results and take your bank team from good to great? Imagine the incredible impact you could make with just a 5–10% improvement in performance. In this webinar, we will provide you with a proven 3-step approach to help your producers focus their efforts and develop their expertise for their targeted markets. You’ll gain invaluable insights and practical strategies to help you cultivate a motivational mindset that will drive your team’s success.
Imagine the impact if you could improve the performance of your middle producers by just 5–10%. This webinar will help bank leaders and managers with the motivational mindset with a 3-step approach to help your producers focus their efforts and develop their expertise for their targeted markets. Using huddles and a coaching approach called “Where’s Walter,” bank managers will learn how to help your middle producers’ sales activities improve. This focus on improving the middle majority can make a huge impact on your group’s bottom line.
What You’ll Learn
- How to sustain your bank business objectives of pursuing profit as well as volume
- How to identify the Sales DNA needed to effectively position value and support negotiation skills
- A consultative approach that will help lenders begin to “negotiate” the potential sale early in the process
- How mastering these consultative strategies will eliminate prospect “think it overs” and bloated pipelines
Who Should Attend
Line of business leaders, managers, area leaders, trainers, and sales execs will benefit from this training.
Instructor Bio
Dan Fischer, sales development expert, has 28 years of financial sales and sales management experience working in the banking and insurance industries. During that time, he has developed a life-long passion for coaching along with an understanding of how to motivate salespeople. Using all the many tools and techniques from his past experience, Fischer is focused on helping salespeople and sales leaders become top quartile in their efforts. When he is not at work, Fischer can usually be found with his wife of 33 years and family. Fischer’s “Why” gets him up every morning… “to inspire, motivate and have a positive impact on people through my passion to help them achieve beyond what they imagined.”
For 27 years, Anthony Cole Training Group has been helping banks and other financial service organizations close their sales opportunity gap by helping them sell better, coach better and hire better. Our Mission: Grow People, Grow Organizations.
Registration Options
Live Access, 30 Days OnDemand Playback, Presenter Materials and Handouts $179
- Available Upgrades:
- 12 Months OnDemand Playback + $70
- 12 Months OnDemand Playback + CD + $100
- Additional Live Access + $50 per person
What You’ll Learn:
- Federal reserve banking system
- How money moves — checks, cash, ACH, wires, and debit cards
- Jobs and roles in our banks
- Regulators and regulations
- Products and Services
Who Should Attend?
New bankers employees, training, and compliance.
Presenter
Deborah Crawford is the President of Gettechnical Inc., a Florida based training company. She specializes in the deposit side of the financial institution and is an instructor on IRAs, BSA, Deposit Regulations and opening account procedures. She was formerly with Hibernia National Bank (now Capital One) and has bachelor’s and master’s degrees from Louisiana State University. She has 35+ years of combined teaching and banking experience.
Registration Options
- Live Access, 30 Days OnDemand Playback, Presenter Materials and Handouts – $279
- Available Upgrades:
- 12 Months OnDemand Playback + $110
- 12 Months OnDemand Playback + CD + $140
- Additional Live Access + $85 per person
In this webinar, we’ll explore the crucial difference between an average leader and an excellent leader: good communication. We won’t just focus on the how – we dive into the what as well.
When describing what makes the difference between an excellent leader and an average leader, the number one answer is good communication.
Good communication is much more than how you communicate, it’s what you communicate. This webinar will take the mystery out of becoming a good communicator and give you the skills you need to get better results; make a bigger impact; and motivate others to do their best.
What You’ll Learn
- Get people excited about coming to work each day
- Set high standards for excellence
- Give conflict-free feedback
- Develop high performers
- Motivate others to give their best
Who Should Attend?
New, emerging, and seasoned supervisors and managers with direct reports need this course.
Presenter
Liz Uram is a nationally-recognized speaker and corporate trainer who works with leaders to develop the skills they need to make a bigger impact, get better results, and influence others to do their best.
Uram has been practicing, studying, and teaching leadership skills for more than 20 years. She has worked with companies like Wells Fargo, Transamerica, American Family Insurance, Allina Health, United Health, State of Minnesota, Jennie-O, and International Dairy Queen, among many others.
Whether she’s training onsite at a client location or speaking at a conference, audiences get practical solutions to everyday leadership challenges they can apply in the real-world. Her stories and examples drive home the lessons and make them stick, earning her an average rating of 4.8 out of 5 stars.
Uram has written four books packed full of tools to help leaders get real results, real fast and she holds a degree in Organizational Leadership. She enjoys spending her free time on the 3G network — golfing, gardening, and being a grandma.
Registration Options
Live Access, 30 Days OnDemand Playback, Presenter Materials and Handouts $279
Available Upgrades:
- 12 Months OnDemand Playback + $110
- 12 Months OnDemand Playback + CD + $140
- Additional Live Access + $75 per person
The business case for Diversity, Equity, and Inclusion (DEI) is stronger than ever. This webinar will provide bankers a comprehensive review of the moral, economic, and financial rationale for strategic investments in DEI policies, practices, and programs.
If the financial services industry is to truly earn the full trust and respect of all segments of our society, banks must be as diverse as the communities in which they operate and serve. In this session, participants will learn why Diversity, Equity, and Inclusion (DEI) initiatives are critical to their institution’s long-term success and profitability. An extensive body of research suggests that organizations that excel at DEI are higher-performing companies measured by business, financial, brand, and talent outcomes. It is more important than ever for banks to implement policies and practices that welcome and engage talent across a diverse range of identities inclusive of race, ethnicity, gender identity, and sexual orientation. For younger job seekers and Gen Z employees especially, diversity and inclusion in the workplace are not a preference. They are a requirement.
What You’ll Learn
- The state of inequality in America
- The state of DEI in financial services
- The economic cost of Black inequality
- How DEI drives employee engagement
- How diverse teams drives business performance
- Understand how a culture of inclusion underpins all DEI efforts
Who Should Attend
Executive leadership, management, supervisors, human resources, corporate trainers and anyone responsible for advancing a culture of belonging and psychological well-being will benefit from this course.
Instructor Bio
Francis Janes serves as the Industry Relations and Partnerships Director for Beneficial State Foundation. In this role, Janes supports financial institutions with their Corporate Social Responsibility strategies and ESG initiatives. Prior to joining Beneficial State, he was an Associate Director at the International Living Future Institute. At the Institute, Janes led the development of a social equity in the workplace organizational assessment framework branded as the JUST Program. Prior to his work at the Institute leading the JUST Program, Janes worked in the financial services sector in a variety of management roles including five years as vice president relationship manager at Beneficial State Bank. Prior to his work in the financial services industry, Janes was a senior account executive with SHL Systemhouse and delivered Information Technology consulting and solutions to Fortune 500 companies.
Registration Options
Live Access, 30 Days OnDemand Playback, Presenter Materials and Handouts $279
Available Upgrades:
- 12 Months OnDemand Playback + $110
- 12 Months OnDemand Playback + CD + $140
- Additional Live Access + $75 per person
It is widely perceived that companies face a reality gap. More and more business leaders are seeing that cultivating equality is not just the right thing to do, but also the smart thing to do. Diversity alone doesn’t move your entire business forward — inclusion is an integral part. All people need to feel a sense of belonging. Inclusion is when every person is valued, heard, respected, empowered, and feels a true sense of belonging.
Senior management needs to commit to education and discussions surrounding D&I. You will want your entire staff onboard with your company’s mission to embrace this topic.
What You’ll Learn
- Generational Differences and providing all of them inclusion
- Where you are with diversity awareness
- Understand what it is and is not
- The value of diversity in The organization
- Tools and resources that will aid you in taking D&I to a new level
- How focusing on inclusion is directly related to employee engagement
Who Should Attend
Human resources, leadership, management, supervisors, trainers, and anyone responsible for leading and engaging.
Presenter Bio
Vicki Kraai is CEO of InterAction Training. A company passionate about professional development training and education.
Kraai’s 25+ years of Community Bank experience started at the family bank in rural Nebraska, serving as a bank teller and eventually becoming CEO. Kraai’s many years of banking include credit card lending experience where she was a member of the management team that launched the Cabela’s credit card program. She has a passion for developing people for success in the financial services industry. Banker’s value Kraai’s highly engaging “been there, done that” approach to all facets of her training and speaking engagements.
Kraai shares her expertise and experience as a faculty member for State Bank Association Schools and the Graduate School of Banking in Madison, WI.
Registration Options
Live Access, 30 Days OnDemand Playback, Presenter Materials and Handouts $279
- Available Upgrades:
- 12 Months OnDemand Playback + $110
- 12 Months OnDemand Playback + CD + $140
- Additional Live Access + $85 per person
Are you and your training presentations in harmony? Do you feel like you’re in a constant battle for audience attention? These techniques will help you create a remarkable increase in learner engagement.
Five of our best practices will enhance your technical skills. They are surprisingly easy and will help you synergize your presentation with what you say and teach. The other five best practices will complete your toolbox with attention-grabbing techniques and skills by setting the right tone, focusing on the right objectives, and embracing adult learning principles.
Register now! These techniques can be applied to webinars, e-courses, or classroom training and are easy to implement in both new and existing training programs. Plus, you’ll receive an InterAction Training Toolkit to help you amplify your training effectiveness.
What You’ll Learn
- Prepare learners for a great and inviting experience
- Apply key adult learning principles
- Zero in on learning objectives by organizing content strategically
- Rewording techniques for better audience engagement
- Alternatives to the dreaded bullet-point list
- PowerPoint tips
- Best practices for using photographs
- And more!
Who Should Attend
Anyone who is expected to train others, develops training programs, leads meetings, or represents your brand.
Instructor Bio
Heather Legge is a training specialist and certified executive coach, founder of Envision Success Inc, and author of Lead With Moxie. She is a senior training consultant for InterAction Training and is known for her presentation and delivery expertise.
Previously, she earned her master’s in business administration and spent over 15 years in multiple industries transforming organizational performance through business analysis, project management, training and employee development.
Legge is passionate about making a positive impact in her local community and far beyond. She is always engaged in several networking, professional, and philanthropic groups.
Registration Options
Live Access, 30 Days OnDemand Playback, Presenter Materials and Handouts $279
- Available Upgrades:
- 12 Months OnDemand Playback + $110
- 12 Months OnDemand Playback + CD + $140
- Additional Live Access + $75 per person