CPE + Events Catalog

Excel's named reference capability allows us to create a friendly name and then use that name in a variety of places, including formulas. This session covers the basics of setting up named references with the Name Box, and then how to add, edit and delete names with the Name Manager. After naming a cell, a range and a constant, you'll dig into the details and name a few formulas. You'll then use the named formulas to create a clean and modular formula. Presented in Excel for Windows. Note: Items presented may not be available in all Excel versions, including Excel for Mac, iPad or web. The webcast was originally broadcast on June 1, 2016. Note: There is a minimum passing rate of 70% for this course.

The conditional formatting feature of Excel allows you to format a cell based on its value. In this session, we'll quickly get warmed up by covering the basics and then look in-depth at its more useful capabilities, including using a formula to define the formatting rule, using icon sets to create alerts and filtering for duplicates. Presented in Excel for Windows. (Please note: Items presented may not be available in all Excel versions, including Excel for Mac, iPad or web.) The webcast was originally broadcast on June 1, 2016. Note: There is a minimum passing rate of 70% for this course.

With a solid industry analysis,the business can better decide whether to enter, stay in, or leave an industry. The tools you will gain from this course will help you define where an industry is in its lifecycle, which can be used for applications such as determining the risk and reward ratio of a potential investment, or the making of strategic choices like diversification, market exit, market stimulation, and so on.

Inherited retirement accounts have changed'and smart planning matters more than ever. In this course, Mike Harris, associate professor in charge of retirement studies at the College for Financial Planning, breaks down inherited retirement account planning under the SECURE Act and SECURE 2.0. Participants will gain clarity on complex distribution rules and learn actionable strategies to protect retirement savings while navigating taxes with confidence and compliance.

Go beyond the standards and see how private company GAAP is really shaped. This course offers an inside look at the Private Company Council and its work with the FASB to address the unique needs of private companies. Hear directly from PCC Chair Jere Shawver on agenda priorities, stakeholder outreach, and why practitioner input matters. Gain practical insight to help you interpret guidance, anticipate change, and better support clients and stakeholders.

Internal Control is designed to provide reasonable assurance to achieve the entity's objectives related to financial reporting, effectiveness and efficiency of operations and compliance with applicable laws and regulations. It safeguards assets against unauthorized acquisition, use, or disposition and may include controls relating to financial reporting and operating objectives. Auditors should understand internal control relevant to the audit and the application of professional judgment. Most audit-related controls relate to financial reporting. However, not all controls related to financial reporting are appropriate for audits. Therefore, the auditor should evaluate the design of controls and determine whether they have been implemented by performing procedures and the inquiry of the entity's personnel.

Valuation is probably the most fundamental concept in finance and is a necessary skill to become a world-class financial analyst. Due to the nature of a bank's operations, as well as banking regulations, we have to modify the most common valuation approaches. In this course, we will build a dividend discount model, a residual income model, mark a bank's balance sheet to market value and discuss comparable valuation.

This self-paced business intelligence online training introduces you to the fundamentals of business intelligence (BI). You'll learn how data, tools, and team roles work together to drive smarter business decision-making. Unlike traditional data analysis training, this business intelligence course focuses on equipping you with practical, real-world BI knowledge you can apply immediately.

The following course will introduce the user to fraud theory as applied to financial reporting. The course will seek to define fraud and provide examples of how fraud can occur by or against a company. Finally, the course will introduce the user to key causes of fraud and the characteristics of those causes. Please note that this product will expire either on 06/30/2026 or one year from the date of purchase (whichever occurs first). Educator discounts do not apply to this product.

This course will introduce the Sustainability Accounting Standards Board's framework and the Fundamentals of Sustainability Accounting (FSA) credential and its relevance to management and financial services industries. The course will discuss the relevance of reporting and monitoring SASB metrics for private companies to manage risk, improve operational results and increase enterprise value.

Clients increasingly rely on your expertise to mitigate risks and secure their financial futures. This course will equip you with essential knowledge about the latest developments in virtual currency, including an in-depth exploration of Bitcoin, its underlying technology, and the evolving regulatory landscape. You will gain insights into investment strategies that can enhance your ability to advise clients effectively, ensuring they are well-prepared to navigate the complexities of this dynamic market. By the end of the course, you will be empowered to leverage various tools and techniques that will not only enhance your professional skill set but also significantly benefit your clients' investment decisions in the realm of virtual currency.

In this unprecedented time, conventional investment wisdom won't work. This past year has demonstrated some of the most significant market movements and fears we have seen in years and our clients are becoming more skeptical than ever. Join Jeffrey H. Rattiner as he leads a comprehensive discussion on developing an investment plan in these unchartered times to weather the many storms that are pounding individuals and businesses. You'll learn how to understand the marketplace, prioritize your objectives, determine which investments work best in a volatile market, and then how to combine investments for the best results. This dynamic program will help you increase your client base and fees by incorporating a proven and practical approach to creating client investment portfolios into your practice and how to keep score to help you measure success. You'll leave with a clear understanding of how to build, sustain and evaluate investment portfolios for clients in these turbulent times.

Calvin Harris, CEO of the New York State Society of CPAs, speaks with Joel Black, Chair of the Governmental Accounting Standards Board (GASB), about current priorities in governmental accounting and financial reporting. Black discusses how GASB is responding to stakeholder needs while considering resource constraints, and shares insights on the Board's ongoing efforts to improve standards, transparency, and engagement with governments, auditors, and financial statement users.

Entities participating in federal programs must understand significant changes in the 2024 Single Audit Compliance Supplement to ensure compliance, optimize funding utilization, and maintain eligibility for future awards. Phil Marciano, Partner at Citrin Cooperman, explains key strategies for adapting to these updates, focusing on increased thresholds for audits, enhancements to internal controls'including cybersecurity measures'and adjustments to program income usage. He also addresses the adjusted de minimis indirect cost rate and the importance of timely audit submissions to maintain low-risk auditee status.

- Today's competitive environment requires you to lead your company or team through diverse and often complex scenarios. This course will help attendees determine importance of sound leadership skills, differentiating between a leader and a manager, and learn how to identify and eliminate roadblocks to successful leadership. Also, using leadership scenarios, address common workforce issues and learn techniques to best handle workforce diversity.

Discover the transformative potential of ChatGPT and other large language models within forensic accounting during our upcoming session. This comprehensive introduction to ChatGPT and similar models is meticulously designed to enhance your understanding and application of these cutting-edge technologies in forensic accounting practices, litigation services, and financial analysis. By delving into real-world applications and case studies, you will gain valuable insights into how these tools can streamline processes, improve accuracy, and provide innovative solutions to complex financial challenges. Join us to explore the future of forensic accounting and unlock new opportunities for professional growth and efficiency. This session was recorded on March 19, 2024 at the 2024 Fraud & Forensic Accounting Virtual Conference.

With recent high-profile cybersecurity breaches and increased practitioner and regulatory attention, organizations are under pressure to consider the accounting implications of these attacks and develop appropriate responses. Specifically, cybersecurity events may affect organizations - operations, financial and non-financial performance, and ultimately its stakeholders. To address how cybersecurity issues may affect accounting, this paper presents an Event, Impact, Response Framework to discuss current research and consider implications for both practitioners and researchers. The Framework highlights how practitioners may rely on research findings to better assess cybersecurity threats, understand their impact, and develop response strategies. Results encourage additional research examining how (1) organizations identify cybersecurity threats, incidents, and breaches, (2) cybersecurity affects different risks, and (3) management responses to cybersecurity risks and events. The Framework also suggests the need for cybersecurity research to extend beyond the Accounting Information Systems (AIS) community to areas such as financial accounting, managerial accounting, and auditing.

An analyst must understand mergers and acquisition accounting, as it's crucial when properly building an M&A model and evaluating whether the deal makes financial sense. In this course, we cover the M&A accounting process, including fair value adjustments, calculating goodwill, deferred taxes, and various related fees and expenses. We also cover how a deal can be structured as either a stock purchase or an asset purchase and the resulting accounting implications. We will practice adding transaction adjustments to calculate a pro forma balance sheet, but we will also look at the impact of a transaction on the income statement and cash flow statement.

This workshop will help employees and managers understand the emotional stages everyone goes through during a change process. While learning to manage their own response to change, leaders will also discover the best way to help their employees become change-resilient. Research shows that the average business has undertaken five major organizational changes in the past three years, and 75% of those companies expect to pursue additional change initiatives in the next three years. These numbers present a significant challenge for companies, as most employees are resistant to change and are the primary reason change fails. Please note that this product will expire either on 06/30/2026 or one year from the date of purchase (whichever occurs first). Educator discounts do not apply to this product.

The offshoring of external audit work to so-called low-cost countries is prevalent among the Big 4 professional services firms. Despite this, our understanding of how this form of offshoring influences audit practitioners and the audit process is limited. This course examines how and why offshoring emerged as an organizational matter that changed the way audit work is organized in a Big 4 firm context. Study findings demonstrate how changes in the design of offshoring processes influence interactions between onshore and offshore auditors. We'll: Uncover how individual - "boundary spanners" - struggle to coordinate audit work across the multiple boundaries that separate onshore and offshore auditors. Show how the institutionalization of - "boundary spanning" - functions in organizational structures and processes can have the unintended consequence of widening the boundaries between onshore and offshore auditors. Offer evidence of the effect of offshoring on the learning process of onshore and offshore auditors.