Personal Finance & Money Management

Excel expert David H. Ringstrom, CPA, shows you how to identify and manage duplicate data within your spreadsheets in this live Microsoft Excel training. He covers a variety of topics, including identifying duplicate data visually by way of the Conditional Formatting feature, using a pivot table to determine how many duplicates are in a list, and applying worksheet functions like SUMIF or COUNTIF to sum or count instances of duplicates. In addition, David explains how to use the MATCH worksheet function to help you identify discrepancies in two different lists, how VLOOKUP will stop searching for duplicates after an initial match in found within a list, and how to use Excel’s Data Validation feature to create a rule that ensures users can’t enter the same data more than once in a given area of a spreadsheet.

Review of common investments used in corporate financial strategies. Review of definitions and uses of stocks, bonds, mutual funds, ETFs, options, direct participation vehicles, registered and non-registerd offerings

The objective of any report is to provide important information to management in the areas reviewed. It represents the end result of weeks of reviews, analyses, interviews and discussions. The quality of that report will have an impact on how well the report is understood and accepted.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://onlinecompliancepanel.com/webinar/QUALITY-AUDIT-REPORT-502009/FEBRUARY-2017-ES-TRAININGREGISTRY

This webinar will discuss the Truth In Lending Act and Real Estate Settlement Procedures Act Disclosures. Instructor will explain how to review the history of disclosures. Participants will understand the nature of the changes, the Loan Estimate form and calculations, closing disclosure and time considerations of the disclosures.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://onlinecompliancepanel.com/webinar/TILA-RESPA-INTEGRATED-DISCLOSURE-501836/DECEMBER-2016-ES-TRAININGREGISTRY

Learn best practices to protect accounts payable payment process from potential fraud and risk management techniques for handling ACH, Check, and Credit Card Fraud. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/Accounts-Payable-Payment-Fraud-Risk-and-Risk-Mitigation-ACH-Check-and-Card-505141/JULY-2018-ES-TRAININGREGISTRY

What needs to be considered for ACA compliance for 2016 and 2017? This webinar with Annette Nellen, CPA, GCMA, Esq. reviews the Premium Tax Credit (PTC) and the Individual Shared Responsibility Payment, as well as the new health reimbursement arrangement law enacted in December 2016. Ms. Nellen will address due diligence for preparers, and reminders for individuals and businesses, and resources to assist with compliance and planning.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://onlinecompliancepanel.com/webinar/AFFORDABLE-CARE-ACT-COMPLIANCE-2017-FILING-509437/MARCH-2017-ES-TRAININGREGISTRY

The webinar will provide an overview of the currency and monetary reporting requirements imposed by the Bank Secrecy Act. It will also discuss the updated CDD Rule which requires covered financial institutions to establish and maintain written procedures that are reasonably designed to identify and verify the beneficial owners of legal entity customers. Recognizing and investigating suspicious activities is the key in safeguarding an organization's financial system from illicit use and combating money laundering. Timely and accurate reporting will promote national security through the collection, analysis and dissemination of financial intelligence to the proper authorities.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://onlinecompliancepanel.com/webinar/AML-COMPLIANCE-FinCEN-UPDATES-502308/MAY-2017-ES-TRAININGREGISTRY

This training program will discuss the history and origin of a model validation. It will also discuss the requirements by the OCC for a model validation, and what exactly a model validation should include. The session will also cover the elements of a model validation in-depth to know what to look for in an RFP.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://onlinecompliancepanel.com/webinar/AML-MODEL-VALIDATION-501840/NOVEMBER-2016-ES-TRAININGREGISTRY

This training program will discuss the history and origin of a model validation. It will also discuss the requirements by the OCC for a model validation, and what exactly a model validation should include. The session will also cover the elements of a model validation in-depth to know what to look for in an RFP.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://onlinecompliancepanel.com/webinar/AML-MODEL-VALIDATION-505459/MAY-2017-ES-TRAININGREGISTRY

The webinar covers the newly released rule relating to the identification and validation of the control and beneficial ownership of legal entities. The new rule expands the requirements of existing AML program by adding the ongoing requirement of control/ownership oversight in the institutions Customer Id Program. From now until its full implementation, May 2018, covered financial institutions are required to develop risk based approaches to ongoing monitoring and implementation of the parties that hold sway over a legal entity that has an account established with it.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/ANALYZING-CDD-FINAL-RULE-508591/JULY-2017-ES-TRAININGREGISTRY

This webinar tells how to identify suspicious activity and what is the frontline approach to red flags of anti money laundering program or terrorist financing. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/Anti-money-Laundering-Detecting-Suspicious-Activity-and-Preventing-Terrorist-Financing-509970/MAY-2018-ES-TRAININGREGISTRY

Learn the importance of approved appraiser list stratification to enhance appraisal quality within the engagement process. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/Appraisal-List-and-the-Engagement-Process-504925/JUNE-2018-ES-TRAININGREGISTRY

This training program will classify common forms of ATM skimming fraud, POS skimmers, and POS malware, and also identify appropriate mitigation strategies. The course will further analyze why EMV will not stop ATM fraud and POS skimming fraud.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://onlinecompliancepanel.com/webinar/ATM-AND-POS-SKIMMING-FRAUD-501454/JUNE-2016-ES-TRAININGREGISTRY

The webinar will provide an overview of the currency and monetary reporting requirements imposed by the Bank Secrecy Act. It will also discuss Red Flags that pose present and future challenges for regulated businesses. Recognizing and investigating suspicious activities is the key in safeguarding an organization's financial system from illicit use and combating money laundering.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://onlinecompliancepanel.com/webinar/BANK-SECRECY-ACT-BEYOND-501800/OCTOBER-2016-ES-TRAININGREGISTRY

The Criminal Finances Bill was introduced to the UK House of Commons on 13 October 2016. It will significantly improve the government's ability to: tackle money laundering and corruption, recover the proceeds of crime and counter terrorist financing. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://onlinecompliancepanel.com/webinar/BANKERS-MONEY-LAUNDERING--504380/APRIL-2017-ES-TRAININGREGISTRY

A Blockchain is a transaction database shared by all nodes participating in a system based on the Bitcoin protocol. This course describes, what Blockchain is and its financial applications to creating secure KYC and payment data sets. This course also explains a Blockchain concept where the Blockchain itself is a shared single source of truth.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://onlinecompliancepanel.com/webinar/BLOCKCHAIN-RISK-MANAGEMENT-DATA-SECURITY-501662/SEPTEMBER-2016-ES-TRAININGREGISTRY

Real or perceived, over the last several years regulatory expectations have been heightened. As we enter 2017, and embark in a new year, what can we expect regarding Bank Secrecy Act (BSA) reporting expectations? The BSA requires that financial institutions have AML Programs that are “reasonably designed” to maintain appropriate records and file certain reports involving currency transactions and a financial institution's customer relationships. Currency Transaction Reports (CTRs) and Suspicious Activity Reports (SARs) are the primary means used by banks to satisfy the requirements of the BSA.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/BSA-BANK-SECRECY-ACT-502555/JUNE-2017-ES-TRAININGREGISTRY

This webinar will provide attendees a clear understanding of the compliance department of the future. Attendees will learn the best practices to ensure BSA and AML compliance and avoid failure and fines.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://onlinecompliancepanel.com/webinar/BSA-AML-501935/DECEMBER-2016-ES-TRAININGREGISTRY

This webinar will discuss the need for the validation process, the expectations of that process and how to address and identify areas of concern when validating the AML process, and the steps to follow and how to deal with it when it doesn't work. Government requirements continue to expand and those requirements continue to place increasing stresses on people and systems. Making sure it works is not only a top priority for compliance but to justify the costs and resources expended. Validation addresses much if not all of those concerns.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://onlinecompliancepanel.com/webinar/BSA-AML-AUTOMATED-SYSTEMS-VALIDATION-508766/MAY-2017-ES-TRAININGREGISTRY

This 3-part BSA/AML Bootcamp will cover the gamut of compliance, beginning with the four pillars of an AML Program, to how criminals and terrorists exploit systemic vulnerabilities of financial institutions in order to facilitate their illicit activity.Price:$600.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://www.onlinecompliancepanel.com/webinar/BSA-AML-BANK-UNION-CULTURE-ML-PART-3-501644/AUGUST-2016-ES-TRAININGREGISTRY