Financial Analysis & Modeling

Attend this webinar if you use Microsoft Excel on a regular basis and want to take your knowledge to the next level. In this webinar, you will learn how to take all of your raw data and quickly turn that data into easy to use flexible summary reports using Pivot Tables and Charts. We will start with the basics and build up to more complex Pivot Tables. AREAS COVERED • 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 Use Promo Code LBRD20 and get flat 20% discount on all purchases. To Register (or) for more details please click on this below link: https://bit.ly/3kHpXTG Email: support@trainingdoyens.com Toll Free: +1-888-300-8494 Tel: +1-720-996-1616 Fax: +1-888-909-1882

As an intermediate to advanced level user of Excel, not only do you want to take your knowledge and skills to the next level, you want to produce meaningful, impactful and insightful reports in the shortest time possible. These features of the application will help you to do just that. WHO WILL BENEFIT This session is aimed at Excel users who have intermediate to advanced level knowledge and who wish to take their knowledge and understanding of the application to the next level. • Business Owners • CEO's / CFO's / CTO's • Managers • Accountants • CPA's • Financial Consultants • IT Professionals • Auditors • Human Resource Personnel • Bookkeepers • Marketers Use Promo Code MDTD20 and get flat 20% discount on all purchases. To Register (or) for more details please click on this below link: https://bit.ly/2z3r7Wj Email: support@trainingdoyens.com Toll Free: +1-888-300-8494 Tel: +1-720-996-1616 Fax: +1-888-909-1882

Get practical instructions and guidance on how to apply Excel's sensitivity tools in advanced financial modeling and design efficient forecasting models. Price:$199.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/Financial-Modeling-with-Excel-s-Advanced-Sensitivity-Tools-508281/JULY-2019-ES-TRAININGREGISTRY

Learn how to represent data visually using different excel charts and tools. Register to learn more. 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/Excel-Data-Visualization-Charts-and-Infographics-505910/JULY-2019-ES-TRAININGREGISTRY

Learn best practices to create dynamic, interactive charts. Understand how to use INDEX and MATCH to retrieve data and chart with multiple criteria. 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/Advanced-Excel-Charting-Skills-Using-Spinners-Sliders-Check-Boxes-Other-ActiveX-Tools-That-Turn-You-Into-a-Guru-504477/FEBRUARY-2019-ES-TRAININGREGISTRY

It is imperative that practices and facilities know the "audit risks" and what the Office of Inspector is looking for in regard to safeguarding federal dollars and protecting the Medicare trust fund. Discussion of what the audits have uncovered so far in 2018 and how you can protect your practice in the future. Easy to understand guidance and layout of the items that the OIG is watching. 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/2018-OIG-Work-Plan-for-Coding-Billing-Reimbursement-505323/AUGUST-2018-ES-TRAININGREGISTRY

This training program will explore the vital world of advanced financial statement analysis. This session will include a review of the four financial statements and a five-step analysis model including liquidity, activity, leverage, operating performance, and cash flow. It will also review the Z-score (bankruptcy predictor) and the sustainable growth models. The webinar is a must for all commercial lenders and credit administrators.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/Advanced-Financial-Statement-Analysis-Liquidity-Activity-Leverage-Operating-Performance-Cash-Flow-Z-Score-and-Case-Studies-506503/AUGUST-2018-ES-TRAININGREGISTRY

Learn when and how you must compensate employees for travel time. Ensure you comply with the requirements under the Portal Act. Get an update on IRS travel expense documentation requirements. Clearly define when employee meals are 100% deductible and when they are only 50% deductible. Learn about the impact of the Tax Credits and Jobs Act on deductibility of meal, entertainment and gift expenses. Understand the limitations when personal and business travel and entertainment are mixed. Ensure your records will stand the scrutiny of a compensation or tax audit. Learn about employer liability for accidents of traveling employees.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/Travel-Pay-T-E-Reimbursements-Vicarious-Liability-504280/AUGUST-2018-ES-TRAININGREGISTRY

This webinar provides introductory information for banks and credit unions to work toward meeting the regulator's appraisal program requirements. 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/Commercial-Appraisal-Review-Focus-on-the-Tough-Ones-507165/AUGUST-2018-ES-TRAININGREGISTRY

In this webinar, attendees will learn the risks and responsibilities for maintaining a correspondent banking relationship in 2018. 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/AML-Risks-in-Correspondent-Banking-What-You-Need-to-Know-for-2018-508270/JUNE-2018-ES-TRAININGREGISTRY

Get a thorough knowledge on Loan Documentation Process for Loan Administration. 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/Loan-Documentation-for-Loan-Administration-507726/JUNE-2018-ES-TRAININGREGISTRY

Attend this webcast and learn how the CPA should calculate and interpret the Cash Conversion Cycle formula and how it directly impacts a company's liquidity. 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-the-Company-s-Liquidity-Using-the-Cash-Conversion-Cycle-507465/JUNE-2018-ES-TRAININGREGISTRY

In this training session any user of Excel who wants to learn how to create form-driven applications and spreadsheets can attend this webinar at discounted price. 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/Building-and-Designing-Data-Input-Forms-in-Excel-504850/MAY-2018-ES-TRAININGREGISTRY

Get trained on the various laws affecting travel expense reimbursements and learn how to comply with federal regulations. 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/Travel-Pay-Best-Practices-to-Comply-with-Federal-Regulations-506090/MAY-2018-ES-TRAININGREGISTRY

This Excel training program will illustrate how best to use Excel's special tools and functions to spot fraud red flags. It will also review SAS No. 56 Analytics and related dashboard KPIs and offer insight into Benford's law and limitations. Attendees will learn how to set up a worksheet to help automate Benford's law analysis. 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/How-to-Use-Excel-to-Detect-Fraud-509892/MARCH-2018-ES-TRAININGREGISTRY

This Excel training program will help attendees create interactive, dynamic Excel Charts helpful for financial modeling and dashboards. It will also help build Excel Charts to save time and eliminate manual input. Attendees will learn Excel Lookup functions, understand how to use INDEX and MATCH to retrieve data and chart with multiple criteria, learn how to use Excel dynamic named ranges with tables for chart automation, and more. 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/Advanced-Excel-Charting-Skills-Using-Spinners-Sliders-Check-Boxes-Other-ActiveX-Tools-That-Turn-You-Into-a-Guru-508950/MARCH-2018-ES-TRAININGREGISTRY

The course provides a concise overview of leading Internet security resources and strategies that can be used by accountants to step up their security posture from an individual front-line perspective and enterprise standpoint. While perfect security is not possible in a world where threat actors are always finding new and creative ways to exploit users and technology, attendees will walk away knowing how to better manage digital risks, prioritize security issues, and develop controls that improve protection of corporate data and networks. Find out how to encrypt smartphone communications, boost your Wi-Fi security, protect your mobile devices, avoid social engineering scams and more. 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/Internet-Security-Tools-for-Accountants-504916/FEBRUARY-2018-ES-TRAININGREGISTRY

Forms come in many varieties. The forms we will build are created within Word and are intended for online use. We will create forms used for collecting data built with legacy fields. We will demonstrate collecting that data and importing it into Excel for analysis. We will also examine Content Control fields and how a user can benefit by including them in a "form type" document. An overview of general Word fields will be presented to help with further automating any Word file. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://onlinecompliancepanel.com/webinar/MASTERING-FORMS-IN-MICROSOFT-WORD-505509/NOVEMBER-2017-ES-TRAININGREGISTRY

In many organizations, operationally responsible managers have been made accountable for the financial performance of their divisions. This means that these managers need to have a firm grip on using a wide range of financial reports and information - making understanding finance, accounts and budgets extremely important for them. In the webinar, the speaker will aim to make non-financial managers comfortable will using the information provided by their accounting departments to make the correct management decisions.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://onlinecompliancepanel.com/webinar/FINANCE-FOR-NON-FINANCIAL-MANAGERS-504635/OCTOBER-2017-ES-TRAININGREGISTRY

This webinar will help attendees understand the way accounting "rules" are made by the FASB in the private sector, focus on the general principles underlining GAAP "rules," appreciate unique peculiarities of bank accounting, comprehend the intricacies of bank financial statements and master the complete set of financial statements and related schedules and reports. The webinar also focuses on the recent accounting trends that emphasize: Balance sheet over income statement, current values over historical costs and full disclosure over detailed schedules.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/UNIQUE-BANK-ACCOUNTING-GAAP-ISSUES-504283/OCTOBER-2017-ES-TRAININGREGISTRY