Professional Development and Event Catalog

In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

Financial professionals are expected to do more than report numbers-they must explain them in ways others understand and trust. This session focuses on improving financial communication by addressing financial literacy gaps, simplifying complex accounting concepts, and building compelling narratives around data. Participants will learn how to use stories, visuals, and language effectively to communicate strategy, performance, and risk. Through examples and interactive discussion, this session helps CPAs and CFOs become clearer, more confident communicators in both live and virtual environments. Also, some video clips will be used to add to the learning materials and research. Don't worry, they are pretty entertaining.

More Dates

The cost of fraud, dearly paid by governments and nonprofits, is too severe to not learn from past experiences. This course examines real-world fraud cases to uncover the lessons they provide and translate them into practical, preventive controls. Using a highly illustrative and innovative format, the course engages participants with over 15 focused exercises designed to build a strong working knowledge of fraud risks and effective anti-fraud controls. Whether you are an auditor or an industry professional, you'll gain actionable strategies to strengthen oversight, reduce vulnerabilities, and safeguard your organization.

More Dates

Auditing for today's world Remoting auditing is happening everywhere you turn. Understanding the considerations for a remote audit and the specific techniques for performing the engagement will help you integrate remote auditing into your practice. You will learn how to: Leverage the benefits of remote auditing Manage the team, client, and audit process remotely Identify engagement-wide procedures from client acceptance through report issuance when remote auditing Identify and obtain audit evidence for generally material accounts

More Dates

This program compares and contrasts the financial and tax accounting differences of partnerships, LLCs, and S corporations, as well as discuss the tax accounting for these entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

Basic, but not boring Newcomers to tax return preparation are exposed to the many topics that encompass individual taxation. Topics, discussed in an approachable format, include: Filing requirements and dependents Gross income inclusions and exclusions Adjustments to income Standard and itemized deductions Refundable and nonrefundable tax credits Tax computations Penalties Taking advantage of present opportunities for your clients' futures Tax planning involves understanding a client's current situation to anticipate areas of future tax savings. You'll review common individual tax planning topics to help clients prepare for their futures. Decoding recent legislative changes for individual taxpayers H.R. 1, commonly referred to as OBBBA, has created new tax planning opportunities for individual clients across the income and activity spectrums. You'll be able to provide your clients with the most current tax planning and tax-saving strategies for their tax plans. Course materials include discussions of the major H.R. 1 provisions affecting individual taxpayers, further informed by IRS guidance. This course has also been updated for IRS guidance related to other recent legislation, including SECURE (1.0 and 2.0) and the Inflation Reduction Act. Part of Tax Staff Essentials Level 1 This self-study online course is part of Tax Staff Essentials Level 1, a comprehensive learning program that provides tax staff with the technical training required to support their teams.

More Dates

One of the most favored employee benefit plans, the 401(k) plan, provides unique challenges for auditors. Through this course, auditors will obtain an understanding of the rules and regulations unique to employee benefit plans and obtain practical guidance on applying them. Auditors will enhance their knowledge of the performance and reporting requirements through real-world examples, best practices, and efficient audit techniques that can be utilized in various audit engagements. Make sure your audits don't trigger a DOL inspection by conforming to all applicable rules and regulations.

More Dates

The most difficult concepts to master when dealing with flow-through business entities are the basis and distribution concepts. Major error and malpractice issues occur if the CPA does not fully understand the impact of these rules. This course is designed to focus on the practical applications of these rules.

More Dates

This course provides a concise overview of Claude and its growing role as an AI-powered productivity, analysis, and workflow platform for accounting professionals. Participants will learn how Claude differs from traditional search engines, spreadsheets, and chatbots, and how it can be used to accelerate drafting, research, document review, data analysis, and client communications while maintaining professional skepticism and accountability. The course explores practical prompting techniques, document and spreadsheet analysis, projects, artifacts, connectors, Microsoft 365 integrations, automation capabilities, and emerging AI workflows. Special emphasis is placed on confidentiality, privacy, ethics, verification, and professional judgment. By the end of the course, participants will understand how to integrate Claude into their daily accounting workflows to improve efficiency, strengthen decision-making, and support higher-value advisory services. The course is based on the Claude platform ecosystem, including Chat, Projects, Artifacts, Connectors, Microsoft Office integrations, Voice Mode, Design, Code, and Cowork capabilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

Explore the transformative impact of technology on the audit profession in this forward-looking course. Gain practical insights into cutting-edge tools and trends, including data analytics, artificial intelligence (AI), and automation, and discover how these advancements are revolutionizing audit methodologies and improving audit quality. Through engaging demos, case studies, and actionable tips, you'll learn how to navigate the evolving audit landscape with confidence and adaptability. This session is designed to equip CPAs with the knowledge to embrace innovation and stay ahead in a rapidly changing profession. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

The tax landscape is constantly changing, challenging tax practitioner to stay abreast of these developments. This eight hour program will cover issues unique to business entities, including new court decisions, recent IRS publications, and the latest tax legislation that will impact businesses and individuals. The remaining time will be spent on IRS procedure and other issues. This course will provide a concise look at the hottest topics affecting every tax practitioner. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

It is the role of a leader to build and maintain a great culture in the organization. The culture is the driving force that shapes the attitudes and behaviors of everyone in the organization. A relationship driven organization is built on trust and is the most effective way to improve productivity, engagement, and the bottom line. Understand the components that enable trust to be created and maintained throughout teams and organizations.

More Dates

This segment is designed to evaluate Step Five of the new model dealing with recognizing revenue which is the final step in applying the new revenue recognition standard. For performance obligations that are fulfilled at a point in time, revenue is recognized at the fulfillment of the performance obligation. For performance obligations to be satisfied over time, an entity must decide how to appropriately measure the progress and completion of the performance obligation. A performance obligation is satisfied when or as control of the good or service is transferred to the customer. There are several issues companies should consider in applying step 5 of the standard: •   Determining if a Performance Obligation is satisfied over time •   Identifying indicators of transfer of control of good/services •   Utilizing input and output methods to measure progress of revenue recognition •   Understanding stand-ready obligations and how to apply discounts

More Dates

Both IFRS and IFRS for SMEs are self-contained standards designed to meet the needs of specific financial statement users. This course is designed to explain the differences between the two standards, including disclosure requirements and recognition and measurement principles.

More Dates

Non-fungible Tokens (NFTs), unique, identifiable digital assets based on blockchain technologies, have become a fast-growing industry. This course will provide a background on how NFTs came into the mainstream marketplace.  These materials will assist the practitioner to understand the tax implications of the creation, purchase and sale of these assets.  **Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.

More Dates

Every business professional today needs to know how to work with data. We are all generating more and more data every day. However, only some of us know how it can be effectively leveraged. There are many new opportunities for people who can effectively work with data. From helping their organizations make better decisions to working more effectively on projects to creating integration between applications and automating workflows. This course will take a longer and more in-depth look at how to use databases, structure data for optimum workflow, and share data between applications. This course teaches you how to effectively use Excel, Power BI, SQL, and other data-related technologies. You'll also discover how to integrate and share data between different applications. By the end of this course, you'll be able to utilize databases more effectively and make better decisions based on data analytics. We will go beyond the basics to give you the knowledge you need to start.

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.

More Dates

Answering clients' tax questions accurately and on time is a key challenge for tax practitioners. Through simple, plain language explanations and examples, this course will help practitioners perform tax research more efficiently by describing the structure of the primary sources, highlighting the difference between primary and secondary sources, and describing the steps in the tax research process.

More Dates

This course provides a focused update on major recent pronouncements issued by the Governmental Accounting Standards Board. Coverage includes GASB Statement No. 103 (financial reporting model improvements), GASB Statement No. 104 (enhanced disclosures for capital assets), and GASB Statement No. 105 (subsequent events). Participants will also receive a high-level overview of active GASB exposure drafts and ongoing projects. The course is designed to help auditors, preparers, and financial leaders understand how these developments affect audits, financial statement preparation, and board reporting.

More Dates

Valuation techniques and cash management activities are two other tool categories that can round out your analytical toolbox. In this course we will initially discuss how to turn your financial plan into a powerful valuation engine.  We then will discuss the formation of an efficient cash management program based on solid banker relationships.  Finally, we will review Ten Steps for keeping your financial toolbox full.

More Dates