CPE & Event Calendar

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.

Getting ready for busy season involves not only knowing what's new for the current year but also understanding how the changing limits, phaseouts, and other rules apply to current-year returns. With OBBBA enactment over the past few years, the present course will constitute a one-stop "shop" that brings you the essential individual tax information. In addition, this course provides an up-to-date review of important tax form changes, new tax forms, new limitations, key developments as they are reflected in the IRS forms, IRS filing issues, and deadlines that will be invaluable to attendees who prepare tax returns during busy season.

This course is a 'deep dive' into many aspects involving the taxation of real estate for the mid-level practitioner moving into this complex area. You will deepen your understanding of the complex considerations and strategies that individuals must navigate in acquiring, operating, and selling real estate. You will leave the course able to navigate critical issues associated with the relevant returns and plan strategically for your company or clients. We will discuss in detail the impact that recent tax changes have had on the real estate industry, as well as new credits that are available after the Inflation Reduction Act of 2022.

This course will elevate your individual income tax preparation skills and knowledge. It will help you go beyond the basics and will help you provide superior service to your clients. We will cover topics including taxation of investments, reporting of partnership and S-corporation income, net investment income tax, calculation of self-employment taxes, household employer taxes, social security taxation, basic retirement planning opportunities and Alternative Minimum Tax (AMT). In addition, we will also do a review of loss limitations and much more.

This webinar gives CPAs a practical look at designing, implementing, and maintaining effective internal controls. While many organizations are able to build a solid control framework, too often, the execution falls short'especially when it comes to testing, monitoring, and keeping controls up to date. That weakens the entire structure. We'll walk through proven strategies to ensure controls aren't just created, but successfully embedded into day-to-day operations. You'll receive a set of customizable checklists to help maintain and improve your organization's policies and procedures. Most importantly, you'll develop a deeper understanding of why internal controls must evolve alongside changes in business tools and processes'and how to keep yours responsive, relevant, and effective.

Participants will go over the changes on preparation, compilation and review engagements using SSARS rules, followed by a general overview of how to perform these services. This interactive workshop is designed for practitioners in small and medium-sized CPA firms and will include a lecture with generous time for questions and case studies.

Fraud activities can be executed from within an organization, by parties outside an entity, or by both. Importantly, as the business world becomes more technological, the way fraud is carried out is changing. There must be an increased focus on understanding where new fraud vulnerabilities exist. In this session, we delve into the reasons that both internal and external intentional defalcations take place. The material discusses the new ways fraud is being actuated and looks at the factors driving those that undertake fraud. We spend time examining measures that can be implemented in order to stop fraud via the deployment of added security across the enterprise. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Good writing is good business. Studies show that the average business worker receives 121 emails per day. That's a lot of emails. Are your emails effective? Are they being read? Are they professional and tone-smart? In this course, you will learn techniques and skills to get your emails to stand out and improve their effectiveness and professionalism.

Thanks to the One Big Beautiful Bill Act (OBBBA) passed in 2025, 100% bonus depreciation is now permanently available for new and used assets. OBBBA has restored 100% bonus depreciation and increased the depreciation that can be taken under Section 179. OBBBA also provided a new, important depreciation topic — qualified production property. These topics, covered extensively in the program, are vital for tax practitioners advising business taxpayers.

The phrase "time management" is misleading. No one manages time. Instead, we manage events in our lives which consume time. Like money, time is both finite and valuable; it should be budgeted and used wisely. Those individuals who "manage" or budget their time wisely often are more productive, less stressed, and able to achieve their goals more effectively than others. Professionals by nature place a high value on their time. Still, successful time management strategies vary based upon the personality, motivation, and discipline of each individual. This course provides simple, practical, and powerful techniques that help professionals work efficiently and achieve better balance in their lives. Successful time management skills also reduce the risk of burnout, which in turn improves the likelihood of achieving success in any endeavor.