CPE Catalog & Events
Advanced Excel: Hidden Secrets and Gems
-
Online
2.00 Credits
Member Price: $89
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. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: AdvancedThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Unlock the Power of AI with Copilot in Excel
-
Online
2.00 Credits
Member Price: $89
In the ever-evolving world of data analytics and business intelligence, Microsoft Excel continues to be an indispensable tool for professionals across industries. With the introduction of Copilot, Microsoft has integrated the power of artificial intelligence directly into Excel, revolutionizing how users work with data. This 2-hour interactive course, Unlock the Power of AI with Copilot in Excel, provides a comprehensive overview of how Copilot transforms traditional Excel workflows into dynamic, AI-driven processes, enabling users to accomplish tasks faster, more accurately, and with less manual effort. During this course, you'll discover how Copilot leverages AI to enhance productivity and streamline operations. Whether you're a seasoned Excel user or just beginning your journey, this course will guide you through practical applications and best practices to make the most of Copilot's capabilities. Through hands-on demonstrations and real-world examples, you'll see how Copilot can save time, improve decision-making, and elevate your analytical skills to new heights. This course not only focuses on the technical aspects of Copilot but also highlights its potential to transform your day-to-day work, from automating repetitive tasks to uncovering trends and insights you might otherwise overlook. By the end of the session, you'll be equipped with the knowledge and confidence to integrate Copilot into your workflows and unlock its full potential in Microsoft Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
2025 Annual Update for Accountants & Auditors
-
Online
8.00 Credits
Member Price: $239
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.Delivery Method: Individual webcastCPE Credit: Accounting, AuditingProgram Level: UpdateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Relationship Networking: The Art Of Conversation
-
Online
1.00 Credits
Member Price: $39
In the fast moving world where everyone is communicating through email, text and instant messaging we have forgotten the power of face-to-face conversation. Communication and connection is the foundation for building a thriving network and business. During this talk, The Connector’s Advantage author, Michelle Tillis Lederman will inspire you to leverage the power of personal connection in the digital age while still incorporating the efficiency of virtual communication. Delivery Method: Individual webcastCPE Credit: Personnel / human resourcesProgram Level: Basic
Aligning Analytics to COSO's Fraud Risk Management Principles
-
Online
1.00 Credits
Member Price: $39
In this course, participants will learn about the five principals of COSO's Fraud Risk Management Guide and the linkages each principal has to the use of forensic data analytics to measurably demonstrate effectiveness and ROI. We will also explore key elements to a successful program that is sustainable as well as pitfalls to avoid. Finally, we will cover several case studies that demonstrate the key concepts discussed. Delivery Method: Individual webcastCPE Credit: Specialized knowledgeProgram Level: Basic
K2's Accounting Solutions And Add-Ons For Small Businesses
-
Online
2.00 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. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Update
K2's Optimizing Your Tech Stack For Efficiency And Cost-Effectiveness
-
Online
2.00 Credits
Member Price: $79
In the ever-evolving landscape of business technology, it is about having the right tools and optimizing for efficiency and cost- effectiveness. K2's Optimizing Your Tech Stack for Efficiency and Cost-Effectiveness is designed for professionals seeking to balance functionality with financial prudence. This session delves into strategies for streamlining your technology stack without sacrificing performance. We will guide you through assessing your current tech tools, identifying redundancies, and exploring less expensive yet effective alternatives. You will learn techniques to evaluate the total cost of ownership of tech tools and make informed decisions to avoid overspending. This course is necessary for professionals seeking the most value from their technology investments. Delivery Method: Individual webcastCPE Credit: Information technologyProgram Level: Intermediate
Employees Today and Tomorrow : Are Employees Assets?
-
Online
2.00 Credits
Member Price: $79
As the managers' role continue to evolve, it is crucial for us to understand the strategic aspects of managing a diverse workforce, beginning with understanding the big trends in employee demographics. We begin with a rhetorical question - asking if employees are assets? GAAP tells us they are not, so discussion will revolve around whether this treatment delivers an unhealthy bias on our view of the people in our organization. What do the most successful organizations believe and why? If you have an opinion as to whether employees are an asset or not, this is a fun session intended to be interactive with participation either live, virtual or both. Delivery Method: Individual webcastCPE Credit: Business management & organizationProgram Level: Intermediate
K2's Office Scripts - The New Macros
-
Online
2.00 Credits
Member Price: $79
Office Scripts is a new feature that allows you to automate tasks in Excel and other Office applications. Unlike VBA, a legacy language that runs only on Windows, Office Scripts can run on any platform and device that supports Office on the web. Further, Office Scripts has a modern and intuitive interface that lets you easily create, edit, and share your scripts. Office Scripts are stored in the Cloud, and they work with Office Online apps and integrate with Power Automate for process automation. Save time and improve productivity using Office Scripts in Excel and other Office applications. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Intermediate
Taxation of Non-fungible Tokens (NFTs)
-
Online
2.00 Credits
Member Price: $79
Non-fungible Tokens (NFTs), unique, identifiable digital assets based on blockchain technologies, have become a fast-growing industry. This course will provide a background on how NFTs came into the mainstream marketplace. These materials will assist the practitioner to understand the tax implications of the creation, purchase and sale of these assets. **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. Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Basic
Clean, Transform & Load Data in Power BI
-
Online
2.00 Credits
Member Price: $89
This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Communicate Financial Concepts to Non-Accountants
-
Online
2.00 Credits
Member Price: $79
Do you ever get blank looks when you present your company's financial statements? Does your board nod knowingly, during your presentation, but never seem to have any meaningful questions? It could be that they have no idea what you are talking about and are just pretending to understand! Learn how to connect with your CEO, board, fellow managers, and ordinary employees so they understand your message. Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Intermediate
Key Tax Issues for Business Taxpayers
-
Online
2.00 Credits
Member Price: $79
This course will address the most recent tax legislation, IRS guidance and developments occurring in 2024-25 that will impact business taxpayers. Designed to prepare the practitioner for the upcoming filing season, this course will provide useful strategies to assist in the tax preparation process. **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. Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Intermediate
Mergers & Acquisitions: Tips and Speed Bumps to Avoid
-
Online
2.00 Credits
Member Price: $79
Mergers, acquisitions and alliances have been and continue to be major avenues to organizational growth and increased competitive advantage. Despite the great initial promise of many mergers and alliances, few seem to yield the anticipated results. Numerous studies indicate that between 55% and 77% of mergers fail to accomplish their intended purpose. This course helps financial professionals, and their advisors identify, execute, and consummate mergers and acquisitions that create shareholder value while avoiding the many traps that can cause post-acquisition failure. Delivery Method: Individual webcastCPE Credit: Business management & organizationProgram Level: Intermediate
Surgent's Comparing and Contrasting Retirement Plans for Small- and Medium-Sized Businesses
-
Online
2.00 Credits
Member Price: $99
Clients often ask their tax advisors whether they have the "best" pension plan and whether they are using it to its maximum advantage. This program explains how various pension plans work and analyzes why a small or medium-sized business owner would choose one plan over another.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Understanding Partnership Taxation: Debt Allocations
-
Online
2.00 Credits
Member Price: $99
How debt is allocated to the partners in a partnership is important. It dictates how much money may be taken tax-free as a distribution, the losses that flow down to the partners, and the gain or loss on the sale of a partnership interest. However, the allocation of debt can differ depending on the type of debt it is and the type of partner we are talking about. Furthermore, 704(c) can complicate things. And what in the world is a constructive liquidation scenario? In this course, we will tackle the concept of debt allocations - how you do it, what it means, and why you do it.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Critical "Soft" Skills for CFOs and Controllers
-
Online
4.00 Credits
Member Price: $129
Accounting and finance managers and executives must demonstrate sound soft skills necessary for personal growth and organizational success. This course will provide insights into the most crtical personal skills critical for CFOs and Controllers - or those that want to be! Delivery Method: Individual webcastCPE Credit: Business management & organizationProgram Level: Intermediate
ACPEN Signature 2025-2026: Business Fraud Update and Managing the Risk of Fraud
-
Online
8.00 Credits
Member Price: $250
Fraud has not been conquered. Although most organizations like to think, “it can’t happen to us,” the fact of the matter is that fraud can happen to any organization and its impact can be catastrophic. Accountability professionals are the first line of defense against fraud. When fraud happens, management always turns to the accountability professional and either says (a) “this must be your fault,” or (b) “you were right; you warned us; help us make sure this cannot happen again.” Consequently, accountants, internal auditors, external auditors, fraud examiners, and risk management professionals need to develop the skills needed to prevent, detect, and deter fraud and need to be proactive in promoting and effecting organizational change. According to the Association of Certified Fraud Examiners’ (ACFE) 2024 Report to the Nations: The median loss per fraud case is $145,000; the average loss per fraud case is $1.7 million. 43% of frauds are discovered by tips, usually from employees. Asset misappropriation schemes are the most common (89%) but least costly ($120,000 median loss). Financial statement fraud schemes are the least common (5%) but most costly ($766,000 median loss). Corruption is the most common scheme in all global regions. Median losses for frauds by owners/executives ($459,000) were more than 7X GREATER than those carried out by employees ($60,000). 84% of fraudsters exhibited at least one behavioral red flag. Organizations that have implemented anti-fraud measures suffer significantly lower losses and find fraud much more quickly. These conclusions are alarming and should be a wake-up call for all business and government professionals. The impact of fraud is always devastating and can be catastrophic. The 2025 Business Fraud Update is another fast-moving seminar that will provide a comprehensive look at the latest developments about fraud from the technical, legal, and operational perspectives and update participants on the most recent legal and regulatory developments in this important area of professional responsibility. In addition, our panel of legal, accountability, and forensic experts will explain key steps and methods in conducting a successful fraud investigation: Establishing predicate for an investigation Gathering and preserving evidence Conducting interviews and obtaining confessions When to involve law enforcement professionals and regulators The CPA's Role Preparing an expert report Providing expert testimony Implementing corrective action plans Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: Update
S Corporations: Tax Compliance, Elections, and Best Practices
-
Online
8.00 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 Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Basic
The Best S Corporation, Limited Liability, and Partnership Update Course by Surgent
-
Online
8.00 Credits
Member Price: $299
This year practitioners need to keep abreast of tax changes affecting pass-through entities used by their business clients and employers, and this enlightening course delivers that information. You will learn invaluable strategies, techniques, innovative tax-planning concepts, income-generating ideas, and other planning opportunities available to S corporations, partnerships, LLCs, and LLPs. In addition, this course will discuss current trends and emerging issues, helping practitioners stay informed about relevant and significant topics that may impact their clients. Continually updated to reflect enacted legislation.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: UpdateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent.