CPE Catalog & Events

Excel is the accountant’s tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Regardless of your level of experience, if you use Excel, you need this course to learn more efficient and effective ways to work with Excel. In this course, you will discover countless tips, tricks, and techniques to improve your general level of productivity, reduce the amount of time you spend on mundane tasks, such as formatting, and customize Excel for greater accuracy and efficiency. You will also learn valuable formula-building skills, best practices for linking Excel data from other worksheets and workbooks, and how to streamline report generation and printing processes. Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples that will improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience in delivering spreadsheet training to accounting and financial professionals, which assures you of the relevance and usefulness of the information and guidance provided during the program.

This course will start with the Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. We'll 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. We'll also review year 2 considerations for leases including modification accounting. Then we will switch gears, switching to the audit side of the house. We'll review the impact of the changes to auditing group audits as well as the status of the AICPA's quality management project management. This course will keep auditors up to date on the work of the ASB. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Performing a single audit Exploring various topics related to single audits will give you the knowledge you need to perform these engagements skillfully. You can learn about: Major program determination Pass-through entity responsibilities SEFA requirements The Compliance Supplement requirements The administrative requirements and cost principles found in the Uniform Guidance Uniform Guidance compliance audit basics Gaining an understanding of the Uniform Guidance basics will prepare you for compliance audit engagements. You can examine various topics, such as: Requirements overview Applying GAAS and the Yellow Book to compliance audits Entities that must undergo this type of engagement Federal awards decoded You can also learn the different types of federal awards, along with audit implications for a recipient or subrecipient. Federal award topics covered include: Becoming aware of the SEFA Major program determination Testing and reporting responsibilities You will acquire a fundamental understanding of your responsibilities related to testing and reporting by examining topics, such as: Testing internal control over compliance Testing compliance Writing an audit finding

If there is a potential error, the IRS will assess a tax and add a hefty penalty, without even knowing the facts. As a tax professional, you will be exposed to the IRS and their methods of penalizing taxpayers for the smallest of violations. This presentation will focus on the rules and regulations that create the penalty, and the reasons that exist that the IRS will consider to remove those penalties. 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 provides essential knowledge for Client Advisory Services (CAS) professionals navigating multistate taxation and managing tax deadlines. We'll start by exploring the implications of the Wayfair decision, focusing on general rules for sales and income tax nexus across states. You'll learn what to look for in state statutes and gain a solid foundation for filing requirements. Additionally, we'll cover key tax due dates, how to handle missed deadlines, and potential relief options. Whether you're new to the field or running your own practice, this course will equip you with the tools to succeed.

This course uses the lives of the rich and famous as a template to better understand the realm of estate planning. With stories ripped from the headlines, we will examine pitfalls and best practices. Did you know that Prince died without a will, opening the door for 45 people claiming to be his beneficiaries? Or that Michael Jackson was not careful in properly funding his trust, leading to delays and legal battles in the administration of his estate? Even Abraham Lincoln, it turns out, did not have a will. In discussing an array of celebrities, from Jackie Kennedy, Joan Rivers, Jimi Hendrix, and Whitney Houston to Aretha Franklin, Barry White, Leona Helmsley, and Florence Griffith Joyner, the course is designed as an enjoyable learning experience with tips for all levels of expertise. We may not have their fame or fortune, but we can certainly walk the red carpet when it comes to estate planning.

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.  **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.

Isn’t it time you learned about PivotTables – Excel’s best feature? If so, participate in this session to learn PivotTables from A to Z to take full advantage of this terrific tool's many benefits.

This session explores the importance of internal controls with an emphasis on best practices for small- and medium-sized entities.  We will examine the roles of both preventive and detective controls and practical, cost-effective suggestions for implementing effective internal controls will be addressed.

This program will examine the key provisions of the Inflation Reduction Act of 2022 that was enacted to not only curb inflation, but reduce the deficit, promote clean energy solutions, and much more.  Learn how this new legislation can provide tax savings for both your individual and business clients.  **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.

Many don't realize it, but one's health is one's greatest wealth. Health-related decisions can have a major impact on personal happiness and financial success. Acquire a better understanding of medical insurance options, including government exchanges, workplace plans, and health savings accounts. Managing the risk of a financially catastrophic illness requires thoughtful analysis of personal, tax, and financial factors.

You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, “One day, I’ll learn how to write macros.” Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel’s Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don’t miss this unique opportunity to learn how to begin working with macros – one of Excel’s most powerful tools.

Microsoft 365/Office 365 continues to grow and evolve, yet most utilize only a fraction of the tools available in their subscription. For example, powerful resources such as SharePoint Online and audio and video conferencing can change how your organization communicates and collaborates. In contrast, more personal apps such as Teams, Planner, Flow, and Sway allow individuals to work more efficiently and effectively in virtually all facets of their jobs. Further, security enhancements to Office 365 mean that your organization can take advantage of all these features in a highly secure environment. Isn't it time you learned how to move beyond the traditional Microsoft 365/Office 365 applications such as Excel, Word, and Outlook and unleash all your subscription offers? Join us in this fast-paced and highly interactive seminar where you will learn what you need to know to succeed with Microsoft 365/Office 365.

Ready to elevate your practice? This series is designed for professionals who have yet to explore outsourcing in their audit, tax, or CAS practice. Part 3 will dive into the aspects of your internal and external teams, taking KPIs and workflows into consideration. Companion courses: Unlocking the Potentials of Outsourcing Part 1 - The Basics Unlocking the Potentials of Outsourcing Part 2 - Starting The Process Unlocking the Potentials of Outsourcing Part 4 - The Intersection of Outsourcing and AI

This program will address recent legislation, rulings and developments affecting individual taxpayers and provide practitioners with a comprehensive update for the upcoming tax season. **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.

Isn’t it time you learned how to take advantage of critical features available in your Microsoft 365/Office 365 subscription? In this session, you will learn to use tools such as Teams, Planner, Power Automate, and others to enhance productivity and efficiency.

Business intelligence efforts continue to grow, and Microsoft’s Power BI platform is central to many of these efforts. Participate in this session to learn more about business intelligence and how to create dashboards using Power BI.

Ready to elevate your practice? This series is designed for professionals who have yet to explore outsourcing in their audit, tax, or CAS practice. Part 4 is for those who already have an outsourcing team and want to understand how Artificial Intelligence can be incorporated with their outsourced team to maximize the benefits of an outsourcing strategy. Companion courses: Unlocking the Potentials of Outsourcing Part 1 - The Basics Unlocking the Potentials of Outsourcing Part 2 - Starting The Process Unlocking the Potentials of Outsourcing Part 3 - The Next Level

This program provides in-depth coverage of SAS 145, a major standard that helps auditors enhance risk assessment procedures through improved techniques for identifying and assessing risks of material misstatement. This session is essential for CPAs that perform audits. The discussion will also be insightful for auditees and other professionals who want to maintain awareness of current auditing guidance.

This course addresses the most recent legislative developments impacting individual taxpayers, with a focus on important provisions, rules and concepts to apply when preparing client returns.    **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.