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. 

This webinar invites participants to explore the powerful intersection of ethics, spirituality, love, and belonging in the workplace. By shifting from transactional interactions to values-driven communities, organizations can cultivate cultures that honor human dignity while enhancing productivity. This is a heart centered and practical webinar emphasizing how love, belonging and spirituality shape ethical choices. Through a blend of practical strategies for personal and organizational growth and research- based insights, the session demonstrates that these elements are not optional "nice-to-haves." Instead, they are essential drivers of organizational success; shaping environments where people feel valued, connected, and inspired to contribute their best. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Stay current with this deep dive into accounting for and auditing nonprofit revenue streams. During this session, we'll review recent new standards. The case studies will include familiar and complex situations and audit techniques to identify potential misstatements.

This course provides a concise overview of how artificial intelligence, particularly ChatGPT and other AI tools, is transforming accounting research methodologies and practices. Students will explore the shift from traditional search engine-based research to AI-driven insights, learning how to leverage various AI platforms for enhanced financial analysis, regulatory compliance, and strategic decision-making. The course emphasizes practical applications of AI in accounting contexts while addressing critical considerations such as data verification, ethical usage, and professional judgment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.  

The budgeting process can be a mundane one for accountants. Let’s be realistic and agree that even the word “budget” does not bring excitement to you and your departmental colleagues.  The constraints and pressures can lead to poor decisions in both the technical and human components.  This session is the first part of a four part series and will cover the big picture of keeping the process fresh, pragmatic and useful. We discuss these keys in an engaging manner by discussing both our flaws and strengths, including how to build on these characteristics towards an enjoyable solutions-based method that should deliver effective results for your organization. 

This course provides a focused analysis of the individual and small business provisions in Pub. L. 119-21 (H.R.1), "One Big Beautiful Bill." Tailored for tax professionals working with Form 1040 filers, the course explores impactful updates, from the no-tax-on-tips provision to enhanced bonus depreciation. Designed to inform planning strategies and compliance for the 2025 tax year and beyond. Participants will gain actionable insight into newly proposed deductions and expanded credits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In a recent Gallup study, 50% of respondents quit because of their manager, which makes your managers and supervisors your company's first line of defense against costly turnover. This program looks at management from a broad perspective and then drills down into key skills needed to manage effectively.

This program provides an update on the latest tax developments, rules and regulations impacting individual and business taxpayers, including a review and integration of the most recent legislation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

How well do you understand your organization’s cash flow? Good cash management techniques can provide a competitive advantage! This session shows you how to effectively measure and manage your cash conversion cycle. With a more complete understanding of how cash flows through your organization, you can eliminate impediments. Better cash management lowers your borrowing costs, reduces financing needs, and creates financial flexibility in your organization.

What can you do to enhance your commitment to the highest ethical standards of the profession? How will doing so bring you more business? In this unique and engaging ethics course, the instructor, Dr. Bruce Weinstein, The Ethics Guy (R), reveals ten crucial qualities of CPAs. They are: 1. Honesty 2. Accountability 3. Care 4. Courage 5. Fairness 6. Gratitude 7. Humility 8. Loyalty 9. Patience 10. Presence (focus or mindfulness) You're already a good CPA and a good person. This course will show you how to be even better. The result will be greater satisfaction in your professional relationships, a deeper commitment to the profession of accounting, and much more business. Please note that this is a stand-alone course for 2 CPE credits in Behavioral Ethics, but you'll maximize your ROI by also taking "Ethics: How to Build and Keep Your A-Team". Together these courses are two of the surest pathways to sustained success in accounting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The purpose of this program is to discuss the ethical mandates that govern the conduct of tax practitioners. The program focuses on the ethical pronouncements of the IRS in Circular 230, as well as the preparer penalty provisions set forth in the Internal Revenue Code. Please note: This ethics course does not cover state-specific issues and so is not applicable in states that require ethics courses to include specific state laws and regulations. Please check with your state board prior to registering for this program if you are in doubt about whether this program satisfies your state's ethics requirements.

In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.

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.

The COVID pandemic changed the way many people worked, yet others have had remote teams for decades and little changed.  Many organizations trying to bring people back to the office have experienced significant turnover.  Some practices have changed forever while some principles will always remain the same.  Keeping your people happy equals keeping your best people.  Learn the changes you should make now and the things you should do forever!

This course provides tax and accounting professionals with a framework for serving as the lead advisor in a multidisciplinary planning environment. Participants will explore how to coordinate with attorneys, financial planners, insurance professionals, and bankers to deliver integrated planning strategies. The course emphasizes identifying opportunities across estate, financial, retirement, and tax planning while managing collaboration and delivering cohesive client solutions.

U.S. Department of Treasury's Financial Crimes Enforcement Network (FinCEN) imposed a new reporting requirement that went into effect on January 1, 2024. Millions of businesses may have to file a Beneficial Ownership Information (BOI) Report. In a surprise turn of events, the Federal District Court from the Northern District of Alabama ruled on March 1, 2024 in National Small Business United v. Yellen ("NSB") that the CTA is unconstitutional. This course will discuss the CTA's provisions and the court's decision in NSB. Also covered will be future implications for business entities and steps to consider given the recent ruling. We will also discuss recent proposed rulemaking by FinCen with respect to nonfinanced purchases of residential real estate and gratuitous transfers so that businesses can prepare for any additional reporting burdens that might arise. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The audit profession stands at a critical inflection point, facing unprecedented challenges from technological disruption, evolving regulatory landscapes, and workforce transformation. This comprehensive course, based on the Pennsylvania Institute of CPAs' groundbreaking research report "The Future of the Audit: Building Relevance and Sustaining Quality," provides auditors with essential insights and actionable strategies to navigate these seismic shifts. Through expert perspectives from industry leaders including PCAOB board members, Big Four executives, and audit committee chairs, participants will explore how artificial intelligence, blockchain, and data analytics are fundamentally reshaping audit practices while creating new opportunities for value creation and risk assessment. Beyond technology adoption, this course addresses the pressing talent crisis facing the profession and offers practical solutions for building a future-ready workforce. Participants will learn how to leverage emerging technologies to enhance audit quality, understand the implications of regulatory modernization including the concept of "regulatory sandboxes," and develop strategies for attracting and retaining top talent in an increasingly competitive market. Whether you're a partner in a small firm, a manager in a large organization, or an audit professional seeking to future-proof your career, this course provides the roadmap for maintaining relevance, ensuring quality, and thriving in the evolving audit landscape. You'll leave with concrete action steps for immediate implementation and a clear vision for transforming your audit practice to meet the demands of tomorrow's financial ecosystem. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Some companies are "born" great; others change and become great along the way. This seminar will discuss how both new and established companies become great. This seminar benchmarks world class companies to understand the underlying principles that made them great. The seminar begins with key lessons about business start-ups from Paul Hawken, author of Growing a Business, and Guy Kawasaki, author of Art of the Start and Enchantment. Next, the seminar looks at research on existing businesses, beginning with the management classic In Search of Excellence and then focusing on Jim Collins" research presented in Built to Last, Good to Great, How the Mighty Fall and Great by Choice.

ChatGPT has grown its user base to over 800 million active users per week. As a leader in the generative market, it is a tool that every CPA should have a basic understanding of how to use it and apply it in business. This course will provide a comprehensive review and demonstration of how to put ChatGPT to work for you and your clients. It is designed as a "hands-on" course that facilitates your following along with the presenter while applying the features of ChatGPT on your computer. Practice files will be provided so that you don't have to expose your confidential data.