CPE & Event Calendar

Wow! So many new Excel features and so little time! Microsoft continues to add tremendous functionality to Excel - the business professional's tool of choice. Yet most Excel users have not discovered these new tools and remain mired in yesterday's practices for working in Excel. In this session, you will learn how to use many of Excel's latest features to work more efficiently and effectively with your spreadsheets. Participate in this session to learn about recently released features such as PIVOTBY, GROUPBY, Office Scripts, integration with Copilot, new ways to share and collaborate in Excel, and data entry and formula improvements. If you work with Excel - and who doesn't - this session is necessary to help you improve your efficiency and effectiveness when using Excel.

Ethics and professional skepticism are a cornerstone of public accounting. This course will review the Code of Ethics for Professional Accountants that practitioners must adhere to. This course will outline the pressures, opportunities, and rationalizations that lead to instances of fraud. In addition, this class will walk through some interactive examples to illustrate various scenarios of noncompliance during engagements. 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 introduces accounting, auditing, and finance professionals to the emerging field of agentic AI: autonomous, goal-driven systems capable of planning, acting, and learning with minimal human intervention. Participants will explore how agentic AI differs from traditional automation (RPA) and generative AI, and how these agents are being deployed in finance and accounting. The course emphasizes foundational concepts such as the Perceive-Reason-Act-Learn (PRAL) loop and ethical decision-making frameworks. To ground abstract ideas in practice, participants will experience a brief agent simulation using basic ChatGPT, showcasing how natural language prompts can emulate agentic behavior, such as goal setting, clarification loops, and structured task execution. The course also highlights real-world agent platforms (e.g., Microsoft Copilot, IBM watsonx, and UiPath) to provide context on enterprise adoption trends and discusses emerging global regulations such as the EU AI Act and the U.S. Executive Order on Safe AI.

Whether you're heading across town or across the globe, traveling with electronic devices carries real risks to the sensitive client and firm data stored on them. In this session, we'll explore the ethical obligations CPAs have to protect confidential information, including guidance from the AICPA Code of Professional Conduct and applicable laws. We'll examine how data can be accessed — legitimately or maliciously — by third parties during travel, and offer practical strategies to minimize risk, from using loaner devices and mobile device management to coordinating with IT before departure. The session includes current border search rules, international considerations, and actionable tips for staying secure in transit.

Individual tax planning strategies for 2026 and beyond will take their cue from the many tax advantageous tax law changes enacted in the One Big Beautiful Bill Act (OBBBA). Many of the OBBBA changes are very favorable to individual taxpayers. Taxpayers and their clients now have the opportunity to utilize these new planning strategies. Tax practitioners must know about these new changes and the planning strategies associated with them to maximize the advantages to their clients. This program will cover tax changes from 2025 that impact individuals and provide individuals with significant tax reduction opportunities for 2026.

This course builds on the foundational knowledge from Part 1, Fundamentals of the 1040 - Core Concepts. It expands into business income taxation and additional reporting requirements. Participants will learn how to accurately report self-employment income, income from pass-through entities on Form 1040. This course covers Schedule C, Schedule E, and essential forms such as Form 7203 and Form 7217 to ensure accurate tax preparation for clients with business activities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Gerald Ford once said that "[n]othing in life is more important that the ability to communicate effectively." Public speaking remains a centuries-old skill that allows individuals to effectively communicate both at a personal and professional level. The benefits of good public speaking run long, whether it be the ability to persuade others, lead a team, or encourage critical thinking. This course is designed to refresh and refine speaking skills for professionals. Through this webinar, participants will gain a better understanding of the core skills of how to communicate effectively in groups — big or small. The webinar is intended to help those who already speak in public better improve their skills, while at the same time teaching more novice speakers how to approach a task that so many professionals dread — speaking in front of others.

Explore the intricacies of federal income taxation as it intertwines with rental real estate activities. This course delves into the calculation of rental income, understanding the nuances of deductions, and unraveling the complexities of passive activity loss rules. Whether it's mastering Schedule E or understanding Congress' intent behind tax laws, professionals will leave with an enriched understanding.

Globalization continues to make it easier for taxpayers to live abroad, do business in other countries, or invest in foreign enterprises. This creates significant complications and tax planning opportunities when it comes to filing U.S. tax returns. This course provides an overview of the unique tax challenges and solutions presented to U.S. expats or investors living or investing abroad. It examines how foreign-source income is taxed in the U.S. and how the tax consequences could be mitigated by applying the tax treaties, claiming credit for foreign taxes paid, or excluding foreign-earned income. Additionally, the course discusses the numerous foreign informational form reporting requirements and the significant penalties that could be imposed by the IRS. Examples from real-life client scenarios are included.

With approximately 500 functions now available in Excel, some newer and more powerful tools are easily overlooked. But if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel's more advanced features-some new and some legacy-to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel's FORECAST.ETS function. Regardless of your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel. 

Financial statements are a window into what is going on in the day-to-day operations of the company. They help us see what the company's strengths and weaknesses are. However, financial statements can often have different messages depending on the user. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many self-employed or sole proprietors find themselves having to navigate Schedule C in reporting business income.  While this attachment to Form 1040 seems straightforward on the surface, there are many traps for the unwary. This course is ideal for CPAs, EAs, or other tax professionals. **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.

This course explores how autonomous agents are transforming internal and external audit functions. Agentic AI is redefining how auditors perform risk assessments, gather evidence, test controls, and issue reports. Participants will examine real-world examples, including audit bots from Big Four firms, and consider the impact on assurance quality, auditor judgment, and documentation standards. Key frameworks from the PCAOB, ISA, and AICPA will be discussed, along with governance strategies to ensure audit agents operate reliably, securely, and ethically. This redefines the CPA's role in ensuring the integrity and reliability of audit evidence when leveraging AI agents, impacting audit quality and professional skepticism.

This session takes a unique review of the fundamental budget issues faced by all and walks through a detailed modeling process intended to generate discussion and best practices to improve your organization’s financial modeling.  From the beginning of the accounting process – ‘the chart of accounts’ to the end of the process – ‘the valuation of the company’, the budgeting cycle via a live case model to learn best practices common to successful companies.   This course stands on its own but is part two of a four part budget mastery series.

Some customers are unprofitable from an economic or time perspective – but many organizations do not differentiate or know the difference. When an organization has a unique, well-differentiated service or product, understanding value from the customer’s perspective becomes a crucial factor in profitable pricing. We must take the time to fully understand what our customers value - from the customer’s point of view. What is value? Why do brand, value, and customer focus matter? Developing a deep understanding of our customers is vital. Our most important customer might be someone we have not yet recognized. Understanding both external clients and internal stakeholders - including the evolving role of the finance department, is critical to long-term success. Using humorous video clips, memes, and vetted research, your understanding of customer bases will improve.

Yellow Book and Single Audit engagements are routinely selected for peer review and continue to be areas of heightened scrutiny by peer reviewers and federal oversight agencies. This course examines common deficiencies identified in governmental and Single Audit engagements, with a focus on understanding why these issues arise and how they can be avoided. Participants will review frequent deficiencies related to Yellow Book requirements issued by the U.S. Government Accountability Office, including independence, CPE, and reporting considerations. The course also addresses common Single Audit deficiencies, including internal controls over compliance, compliance testing, and major program determination. Designed for auditors performing governmental and Single Audit engagements, this course helps participants recognize recurring problem areas and better understand the requirements that continue to drive peer review findings.  

Join Us for Our Next Roundtable Open to NECPAs members, roundtables offer a small-group setting to exchange ideas, discuss shared challenges and learn from peers through open, candid conversation. CPE Credit Information To receive CPE credit, you must: Be in attendance for at least 50 minutes Respond to required attendance check polling questions Please note: We recommend using the email address linked to your NECPAs profile when logging into Zoom. Questions? Contact Melissa Nystedt at mnystedt@necpas.org.

While many financial services professionals advise their clients on tax, investment, and life insurance issues, far fewer venture to help in the area of property and casualty insurance. Auto and homeowners policies are mandatory products that everyone generally needs - yet they are also complex products. This complexity raises questions in clients' minds: Are all my belongings covered under my policy? Do I have to adjust my policy if I want to let my neighbor borrow my car? Do I need an additional policy if I want to work as a rideshare driver? And will my premium go up when I move? In this course, we will cover the fundamentals of auto and homeowners' policies. We will touch on these questions, explore basic coverages, and offer some guidance on what practitioners should cover with their clients in this area, so you can offer guidance and give them the peace of mind they need. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

We mostly focus on the income statement, but what about other financial statements and countless other accounting concerns?  This seminar is dedicated to breaking down common balance sheet issues, both on-the-books and off, that have an impact on our stakeholders and the value of the organization.  Using practical analysis, we highlight several key tools in understanding and communicating the importance of the forgotten cornerstone of accounting: the balance sheet. Most notably, we dedicate time to the pressing issue of “unrecorded assets”.  This session is designed to also be fun and entertaining. This seminar stands on its own but is also part of the Common Sense CFO series.

This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel.  Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level.