CPE + Events Catalog

How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.

Performance Management is about getting the best out of everyone. It's about setting the stage so staff can excel as an individual and as a team member. It's about knowing what to say, how to say it, and when to say it to inspire and elevate staff performance. For staff to hear, understand, and act on performance feedback they have to trust the person delivering the feedback. The feedback must be constructive, useful, and implementable. And surprisingly, the performance management process is as much about listening as it is about delivering feedback. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course is designed for firm partners and managers to explore ways to incorporate data analytics and related technologies in their audit practices. Participants explore how small and mid-size firms are using these tools to improve engagement efficiency and quality while providing opportunities for value-added services to clients.All of AHI's courses rely heavily on participant interaction and these virtual programs have co-opted many of Zoom's features to preserve the same strengths of the in-person training: visual interaction between the instructor and all participants (plan to be "on screen" throughout the program); breakout rooms to ensure small group engagement; and instructor interaction screen share for small group presentations easy delivery of video presentations fillable PDF for online note-taking in the course materials.

Casey Crowther did not have a college education, but he had an outstanding work ethic. With little more than a pickup truck and some hand tools, he built a roofing company that grew. Over time, Casey's company employed more than 100 people and generated more than $20 million in annual revenues. With a company of that size, Casey relied upon advice from his bookkeeper when filling out financial documents. As a result of representations he made on bank statements and loan documents, authorities charged Casey with criminal behavior related to PPP loan fraud. What should an accounting professional learn from Casey's story? Stay tuned to find out! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Taxation of long-term contracts has evolved into a myriad of compliance requirements and reporting considerations. Understanding complex and sometimes illogical rules is a specialty in itself. Learn the essentials to address both tax and compliance. Based on many years of real estate and construction industry service, this course will efficiently plow through the many issues and provide precise approaches to obtain the most beneficial tax result while meeting compliance requirements.

Master the critical tax accounting method rules and concepts. Timing rules are crucial knowledge for computing taxable income, tax planning and accounting for income tax. Discover favorable methods for small businesses. Learn how to select and adopt a method of accounting. Plus, review method versus error, timing rules for income and expenses, and inventory accounting. Examples and exercises are used throughout the course to illustrate relevant Internal Revenue Code, regulations, IRS rulings and court cases. Tax planning ideas and the relevance of tax timing rules to the income tax provision for financial accounting are covered. Formerly titled: Tax Accounting Methods. Be sure to register for both courses in this series: Timing Rules for Income Tax Compliance and Planning-Part 1 Timing Rules for Income Tax Compliance and Planning-Part 2

In recent history, even the most prestigious CPA firms have had ethical lapses and oversights that have cost them both financially and, at that moment, clouded their brand. This course will review the AICPA code of ethics for both accounting and tax practitioners and encourage you to examine your firm's policies and choices relative to those standards and common sense through thought-provoking and sometimes humorous Q&A and case studies. This course fulfills the four-hour ethics education requirement.

Strategic Planning for SMEs

The course will start with the Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. We will also review year 2 implications of the leases standard including modification accounting. We will then switch our attention to the items coming down the pike, including a look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Though many clients see Social Security as a government benefit, it is a covered worker's investment asset to be managed like any other asset. Examine issues like how Social Security benefits are calculated, identifying benefit-claiming strategies, and what spouses can do now to maximize benefits at retirement. You'll learn how Social Security works and explore common planning situations-including workers with and without spouses, sandwich-generation families with dependent parents and minor children, and surviving and/or divorced spouses-and techniques to maximize your clients' benefits.

Auditing Contingencies and Going Concern Uncertainty - Testing for Completeness and Proper Disclosure will provide tips and techniques for obtaining sufficient appropriate audit evidence to support conclusions related to contingencies and going concern uncertainty. Financial statements may contain significant uncertainties requiring special audit consideration for evaluating proper accounting and financial reporting treatment. Note: This course is recommended as a part of a 16-hour audit skills curriculum for supervisory or managerial auditors, while it is also appropriate for anyone who has responsibilities for evaluating loss contingencies and substantial doubt about going concern. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

What exactly is cryptocurrency and its cousin named blockchain? Are they here to stay? This session will provide a big picture examination of the technologies and currencies by explaining how we got here. We discuss the systems and technical aspects of cryptocurrencies and blockchain. What is the broad view of the technologies that currently do, and will continue to, impact our workplace and lives?

Team development and performance are critical to leadership success. In this session, participants will examine team formation, learn about the balance between team performance and team health, develop team agreements, and understand the latest tips from Google's Perfect Team research to strengthen team experience. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.

Many tax clients with losses from their S corporations, partnerships, and multiple-member LLCs treated as partnerships will want to use these losses to offset their other income from other sources. This program explains when, why, and how the at-risk rules apply to allow or to prevent the owner of a pass-through entity from taking a loss from a pass-through entity and using it to offset other income. This program is extremely helpful for anyone with pass-through entity clients.

Conflict is as natural as breathing air. For many, the thought of dealing with conflict is difficult and horrifying, and yet unresolved conflict can damage relationships, cause pain and suffering as well as hinder workplace productivity. When addressed, however, conflict has the power to be transformative in strengthening workplace relationships, shared understanding, and increased productivity. This workshop will provide an intimate understanding of how to deal with conflict in collaborative and constructive ways. Using ethical values and principles, we will explore how to move conflict from an obstacle to an opportunity. This workshop is geared toward individuals who are wanting to improve their conflict management skills and create more harmonious and positive working environments. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In this session, participants will delve into a comprehensive exploration of what Diversity, Equity, and Inclusion (DEI) truly entails. Often met with resistance due to its perceived condemnatory nature, this session aims to provide a more nuanced definition of DEI, fostering a better understanding among attendees. By demystifying the language surrounding DEI, participants will be equipped with straightforward approaches to seamlessly integrate these principles into their perspectives. This session will spotlight the distinctive features of our DEI model in comparison to other systems. Attendees will gain valuable insights into the model, understanding its unique perspective on achieving DEI success. At its core, our approach is grounded in the simple premise that we are all human beings sharing the common human experience. The goal is to convey to participants the importance of embracing DEI through this paradigm, effectively humanizing the DEI experience. One of the most remarkable DEI experiences unfolded during my son's 18th birthday celebration in our backyard. The event brought together individuals from diverse backgrounds, spanning various walks of life and races, who interacted in a profoundly humanistic manner— an encounter unlike any I had witnessed before. In this session, we will deconstruct this experience and draw parallels to its relevance in workplace dynamics.

Security is not optional, and yesterday's security techniques do not minimize today's threats. Therefore, now is the time to tune up what you know about protecting sensitive data. This program will teach you the latest tools and techniques for securing your data, including encryption, virus protection, safe communications, electronic signatures, secure authentication, and more. You will also learn how to implement a practical, five-step approach to securing your PC and the questions you should ask your staff to ensure server-based information remains protected. Security failures, such as client or customer data breaches, are costly - they can even drive your company out of business. So, what security tools do you need, and how should you use them to secure your sensitive data and systems? Can you risk attempting to manage today's threats using yesterday's techniques? Participate in this program to learn how to identify viable and practical solutions to mitigating today's security threats.

Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Based on real life experiences! This program addresses the many issues impacting CPA practice with a world in crisis. The unique challenges facing practitioners are related through actual practice situations - and then analyzed for their ethical implications. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.