CPE Catalog & Events
K2's Accessing Your Company's Data With Power Query And Power BI
-
Online
2.0 Credits
Member Price: $79

Power Query and Power BI offer great opportunities for accessing your data and making it more useful in reporting scenarios. Learn how to benefit from these tools in this session.
Taking Advantage of Array Formulas in Excel
-
Online
2.0 Credits
Member Price: $89

This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Communication Miracles At Work and In Life - Part 1
-
Online
4.0 Credits
Member Price: $129

Communication is the glue that connects people, but it doesn’t come easy for many of us. If you want to quickly and effectively handle problems with co-workers or clients, and you want people to do what you want without a lot of hassle, this seminar is for you. The bottom line will be better client and co-worker relationships, leading to increased enjoyment and productivity at work.
K2's Business Intelligence, Featuring Microsoft's Power BI Tools
-
Online
8.0 Credits
Member Price: $225

Business Intelligence (BI) is perhaps the hottest topic in most professional circles in today’s business climate. Increasingly, organizations of all sizes seek to take advantage of the data available to them to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools – from Excel add-ins to dedicated solutions such as Power BI – now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyzes unthinkable until recently. This program will teach you to implement “do-it-yourself business intelligence” using various techniques and tools. First, you will learn to use advanced Excel data query and summarization features to create Excel-based dashboards. You will then learn how to leverage that knowledge to build even more powerful BI objects using Microsoft’s Power BI tools. If gaining better insights into your data to make better decisions interests you, then join us for a fast-paced look at how you can take advantage of these fantastic tools.
K2's Harnessing ChatGPT - Unlocking Professional Efficiency
-
Online
1.0 Credits
Member Price: $39

Enhance your productivity and streamline your accounting practices with ideas learned in this course. This dynamic program, designed specifically for accountants seeking a competitive edge, delves into the practical applications of ChatGPT in your daily workflow. From conducting comprehensive research and crafting compelling correspondence to swiftly addressing technical inquiries and optimizing Excel formulas, you will gain invaluable skills to expedite your tasks and improve overall efficiency. Furthermore, we will delve into the power of ChatGPT plugins, equipping you with the knowledge to process PDF documents seamlessly and efficiently navigate the vast expanse of the web. Join us on this transformative journey and unlock your potential as a proficient and empowered accountant.
K2'S Supercharging Your Spreadsheet Collaboration
-
Online
1.0 Credits
Member Price: $39

Collaboration is a key to productivity and success. But remote work can make collaboration more challenging, including collaborating on spreadsheets. Fortunately, tools such as portals with check-in/check-out capabilities, version control, comment tracking, and co-authoring can enable online spreadsheet collaboration. Further, Excel’s Inquire tool can facilitate spreadsheet collaboration in offline environments. Don’t let remote work hamper your spreadsheet collaboration needs! Participate in this session to learn how to collaborate on spreadsheets effectively from anywhere using tools you already own or license.
Performance Management
-
Online
1.0 Credits
Member Price: $39

The tools for managing performance and addressing misconduct are not identical. The failure to point this out to leaders has often resulted in the use of the wrong tool. Reinforcing good performance and securing improvements in performance requires skill in coaching employees, making effective requests, and providing effective feedback. This course provides practical knowledge and scripts for setting, communicating, and enforcing performance expectations, such that personal and employer liability is avoided.
K2's Accounting Solutions And Add-Ons For Small Businesses
-
Online
2.0 Credits
Member Price: $79

Working with a small business, you know that keeping the company's finances in order is critical to success. While numerous software programs and tools are available to help you do this, they vary substantially in many significant aspects. In addition to conventional options like QuickBooks and Sage 50, you can choose from Cloud-based tools such as Zoho Books, QuickBooks Online, Spire Systems, Xero, Accounting Suite, Accounting Power, and many more. In this session, we'll look at the best accounting tools for small businesses and discuss the benefits of each one. This session covers accounting solutions that should work for startups and companies with up to $10 million in annual revenue. We also cover various add-on solutions that can enhance the overall functionality of your accounting platform. Join us to learn your options for achieving your small business management financial goals.
Liquidity & Uncertainty Disclosures for Nonprofits
-
Online
2.0 Credits
Member Price: $79

The current environment could be having an enormous impact on accounting and financial reporting for all entities, including nonprofits. This course will provide insights into the most critical disclosures related to liquidity, accounting uncertainty, and going concern for nonprofits.
Considerations of Fraud
-
Online
2.0 Credits
Member Price: $79

This course provides an in-depth exploration of AU-C 240, Consideration of Fraud in a Financial Statements Audit. Participants will gain practical insights into identifying, assessing, and responding to fraud risks within the context of financial statement audits. Through engaging lectures, real-world examples, and case studies, the course examines the nature and characteristics of fraud, including fraudulent financial reporting and misappropriation of assets. It also delves into the auditor's responsibilities under AU-C 240 for planning and performing audits with fraud considerations, techniques for identifying fraud risk factors and assessing risks of material misstatement, and methods for designing and implementing effective audit procedures. Additionally, participants will explore best practices for communicating and documenting findings related to potential or identified fraud. Ideal for auditors at all experience levels, this course equips attendees with the knowledge and tools necessary to navigate fraud-related complexities and maintain audit integrity.
AI Privacy, Security, and Compliance Masterclass
-
Online
2.0 Credits
Member Price: $89

In today's rapidly evolving digital landscape, understanding the interplay between generative AI and data protection is not just an asset, but a necessity. This transformative course is designed to delve deep into the crucial privacy, security, and compliance aspects of working with Generative AI (GenAI) technologies. As accountants increasingly integrate AI tools into their workflows, the stakes for safeguarding sensitive information and ensuring ethical AI practices have never been higher. Our masterclass is tailored to meet the unique needs of modern accountants, providing a thorough and practical exploration of how to navigate the complexities of secure data sharing with GPT models, implement robust AI policies, and master the intricacies of AI copyright compliance. With a focus on real-world applications and emerging threats, such as deepfakes and their implications for fraud and misinformation, this course is your gateway to becoming a trusted expert in the field. Join us to future-proof your career and lead with confidence in the digital age. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Understanding Partnership Taxation: PTE Elections, 754 Elections, and Selling a Partnership Interest
-
Online
2.0 Credits
Member Price: $99

Partnership tax law is always difficult. However, when certain transactions come up, not knowing how to handle them can be costly to clients and practitioners. In this course, we discuss several of these types of situations. We will explore the tax impacts of a PTE election and how a 754 election affects the inside basis of partnership assets. We will then examine those tricky look-through provisions on the sale of a partnership interest in order to properly calculate the tax implications.
Taxation of Business Entities
-
Online
2.5 Credits
Member Price: $79

This course will introduce you the different types of business entities and the tax implications of contributions, distributions and earnings, among other topics. **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
Financial Statement Presentation and Disclosure
-
Online
4.0 Credits
Member Price: $129

This comprehensive session is a must-attend event for any professional accountant who prepares financial statements for either a private enterprise or a firm client. We illustrate best practices for presentation and disclosure by revisiting fundamentals of financial reporting for various industries. This workshop explores best practices for United States GAAP in addition to considerations for special purpose frameworks. Experienced accountants will benefit from a refresher whereas other accountants will appreciate formative skill-building insights.
The Art of Marketing for CPAs
-
Online
4.0 Credits
Member Price: $129

To make more money in less time, all accountants need to learn to market themselves effectively to their clients or their firm. For better or worse, promotions and more money go to those who are the best marketers, rather than the most competent accountants. In this fascinating and fun workshop, participants will learn seven key ways to get more clients and/or promotions through the art of marketing.
Hands-On Tax Return Workshop - Partnerships & LLCs (Form 1065)
-
Online
8.0 Credits
Member Price: $300

This case-driven training is designed to get the inexperienced accountant up to speed quickly in the most common areas of partnership, limited liability company (LLC) and limited liability partnership (LLP) taxation. A cornerstone of this course is the preparation of the Form 1065 using a fairly complex trial balance common to most partnership, LLP and LLC income tax 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
2025 Business Federal Tax Update - Navigating the Current Tax Landscape
-
Online
8.0 Credits
Member Price: $225

Get ready to elevate your tax game with the Business Tax Update, designed exclusively for tax practitioners looking to sharpen their skills in business income taxation. This course doesn't just scratch the surface – it thoroughly explores the complexities of the tax code, ensuring you're equipped to navigate the ever-evolving tax landscape with confidence. From recent legislative updates to complex tax considerations like COVID-19-related subsidies, this course covers it all. Gain practical strategies and insights that you can immediately apply to assist your clients in optimizing their business income tax planning. Don't miss this opportunity to stay ahead in business taxation and enhance your expertise in a rapidly changing regulatory environment. With a focus on real-world application and comprehensive exploration of essential topics, the Business Tax Update promises to be a game-changer for your tax practice. Whether you're dealing with partnership, corporation, or LLC taxation issues, this course provides precise guidance tailored to diverse business clients. Plus, you'll gain invaluable insights into recent legislative changes, including their implications on tax code sections like Section 199A. Stay at the forefront of business taxation and ensure you're delivering top-notch advice to your clients by enrolling in this essential course today. **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.
S Corporations: Tax Compliance, Elections, and Best Practices
-
Online
8.0 Credits
Member Price: $225

This comprehensive course covers the most common aspects and tax implications of S Corporations, providing a deep dive into their structure, tax treatment, and compliance requirements. Participants will learn the mechanics of electing Subchapter S status, with discussions on Form 2553 and relief options for late filings. The course also explores the application of Rev. Proc. 2022-19 and Rev. Proc. 2023-3, analyzing their differences and implications under I.R.C. §1361 and §1362. Key topics include corporate formalities, shareholder stock and debt basis, and highlights of Form 1120S and its schedules (K-1, K-2, and K-3). Additionally, participants will gain insights into officer reasonable compensation requirements, audit strategies, and corrective measures for eligibility errors. *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
Surgent's Compilations, Reviews, and Preparations: Engagement Performance and Annual Update
-
Online
8.0 Credits
Member Price: $299

Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-26 by the ARSC. In addition to SSARS 26, the entire suite of quality management standards is discussed. However, knowing the standards is not enough. You need to be able to effectively apply them. To support this, the course will review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARS requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform these types of engagements. This course is intended to be your go-to reference for training your staff and managing your SSARS No. 21-26 services in compliance with professional, ethical, and technical requirements.
The SECURE Act 2.0 - Planning Opportunities for Individuals
-
Online
1.0 Credits
Member Price: $39

The Secure Act 2.0 was passed in a flurry of year-end legislation. This one hour program will cover the important changes that individuals need to know about contributions to accounts and new ways of accessing these funds. This course will provide a concise look at these hot topics. **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.