CPE Catalog & Events
Accounting and Reporting Long-Term Debt
-
Online
2.00 Credits
Member Price: $79
Debt is typically a critical component of the financial statements, impacting the economic decisions of financial statement users. This course will address common issues that may impact the proper presentation and disclosure of debt, including debt covenant compliance and other issues that impact classification of the liability between current vs. noncurrent. Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Basic
Excelling at Excel: The Magic of Power Query
-
Online
2.00 Credits
Member Price: $79
Elevate your data analysis capabilities with our focused course on Power Query. Tailored for financial professionals, this training will show you how to get started using Power Query and teach you some of the ways to take advantage of its ability to handle messy data and automate repetitive tasks. Harness the efficiency of Power Query to revolutionize the way you work with data. Learn how to "program" your tasks once and set them on repeat, eliminating the need for repetitive, robotic work. This automation not only saves time but also ensures consistency and accuracy in your data processes. Whether you're dealing with complex datasets or simply looking to streamline your reporting processes, this course will equip you with the tools and knowledge to make Excel work for you like never before. Delivery Method: Individual webcastCPE Credit: Business management & organizationProgram Level: Intermediate
Predictive Accounting: Driver-Based Budgeting & Rolling Financial Forecasts
-
Online
2.00 Credits
Member Price: $79
The annual budgeting process is often criticized as an accounting exercise that is obsolete soon after it is published, prone to gamesmanship, cumbersome, not volume sensitive, and disconnected from the organization's strategy and risk management processes. You can resolve these deficiencies using capacity-sensitive driver-based projections. Driver-based budgeting allows for quick scenario planning and far easier analysis of a growing organization whose future may look nothing like today. The driver-based budgets can be periodically refreshed to create rolling financial forecasts extending well beyond the fiscal year end. Learn how managerial accounting can become managerial economics. Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Intermediate
HR Investigations - Episode 2 - Interview Techniques
-
Online
2.00 Credits
Member Price: $79
Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session provides best practices for interviewing to gather accurate information, such as creating and asking open ended questions, effective listening, and understanding verbal and non-verbal communication. Attendees will end the session with takeaways to immediately implement in future HR investigations. Two of three Episodes in the series. Delivery Method: Individual webcastCPE Credit: Personnel / human resourcesProgram Level: Intermediate
K2'S Eight Awesome PivotTable Features
-
Online
2.00 Credits
Member Price: $79
Are you looking to take your PivotTables to the next level? Many experts consider PivotTables to be Excel’s most powerful feature. Yet, most who create and work with them barely scratch the surface of all that PivotTables can do. In this session, you’ll learn eight powerful features you may have missed. From user-defined calculations to consolidating reports and adding KPIs, we’ll show you how to get the most out of your PivotTables. These are just some examples of the great things you can do with PivotTables, and in this session, you will learn these and other techniques to make your PivotTables even more powerful. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Intermediate
Surgent's Marijuana: A Generalized Business Viewpoint
-
Online
2.00 Credits
Member Price: $99
Each year, more states legalize cannabis (i.e., marijuana) for medical or recreational purposes. As legalization grows, so too does the cannabis industry. While some financial professionals have stayed away from this growing sector of the economy, others have embraced the opportunities the cannabis industry has to offer. The legalization of cannabis brings with it a complex regulatory landscape, which includes strict compliance with federal and state regulations. However, the complexity of this emerging market provides opportunities for accountants and other financial professionals. Behind the cannabis dispensaries are scores of related business sectors including food production, retail, farming, and chemical production, as well as facilities, design, and construction. Simply stated, the commercialization of marijuana offers financial professionals an opportunity to participate in an industry expected to reach $73 billion worldwide within six years.Delivery Method: Individual webcastCPE Credit: Specialized knowledge, TaxesProgram Level: OverviewThis 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.
Emerging Issues in Financial Accounting 25-26
-
Online
3.00 Credits
Member Price: $139
Recognize the impact of emerging issues, including the increasing divergence of private company accounting standards, the pace and complexity of new standards being issued, and the usefulness of non-GAAP reporting. We'll discuss current issues, including accounting for crypto assets, the controversy over ESG reporting, going concern disclosures and impairment testing, and accounting for internally developed intangibles, including research and development. The course also includes an update on the FASB and PCC agendas.Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Advanced
Take Command of your Time
-
Online
2.00 Credits
Member Price: $89
Manage distractions, decrease stress and improve productivity. This training is designed to help business professionals improve their productivity and work performance by learning how to prioritize time, decrease distractions and lower stress. 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: Personal developmentProgram 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.
K2's Taking Another Look At PDFs
-
Online
2.00 Credits
Member Price: $79
We’re all familiar with PDF documents. However, it’s safe to say that most professionals use only a tiny fraction of their features. This circumstance is unfortunate, considering all you can do with PDF documents. Therefore, isn’t it time to take another look at PDF K2’s Taking Another Look At PDFs documents and all you can do with them? Participate in this session to learn more about PDFs and how and why they should be a cornerstone technology in most organizations. Collaboration options, long-term storage and archival, and fillable forms are just a few features you will learn about in this session. If you’re ready to elevate your PDF productivity, this session is for you! Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Intermediate
Controller Series: Technology - Must Have Excel Competencies
-
Online
1.00 Credits
Member Price: $75
Excel has long been included in the accountant's toolbox. Even though Microsoft Power BI and other big data tools such as Qlik and Tableau are becoming more important, Excel is still a "must have" tool. We cover what the accountants of today should know about Excel to improve their efficiency, access data, and gain insights into the company, industry, and economy.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 AICPA.
Global Internal Audit Standards (GIAS) Domain V - Part 2
-
Online
2.00 Credits
Member Price: $79
The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service Delivery Method: Individual webcastCPE Credit: Accounting, AuditingProgram Level: Update
PowerPoint: Tips & Tricks for Today's Accountant
-
Online
2.00 Credits
Member Price: $79
PowerPoint is a widely available resource that is potentially underutilized by accountants because many accountants do not stray beyond Excel and Word in the Microsoft Office suite. You will learn how to create and edit a professional PowerPoint slide deck. This session places particular emphasis on efficiency tips and tricks that will allow you to develop creative, professional visual aids while minimizing time and effort. The course’s author will share personal insights he has cultivated throughout more than two decades of public speaking. Although the session will focus on creating and editing slides, we will illustrate best practices for presentation delivery. We will also explain how PowerPoint can be used for purposes other than delivering presentations. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Basic
Criminal Tax: How CPAs Bring Value to Defense Attorneys
-
Online
2.00 Credits
Member Price: $89
CPAs can be requested to assist attorneys in litigation support in criminal proceedings. For criminal tax cases, the IRS has recommended prosecution. However, the rules and stakes are different than a simple civil audit. This presentation will focus on how to assist defense attorneys in calculating tax loss, asking the right questions, and probe possible weaknesses in criminal tax investigations. 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: TaxesProgram 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.
Generative AI in Practice-Boost Efficiency and Profitability
-
Online
2.00 Credits
Member Price: $89
Unlock the potential of generative AI to streamline accounting, auditing, tax , and advisory services. This course focuses on practical applications that can save you time and enhance profitability. Learn how to integrate AI tools into your workflows to automate tasks, improve accuracy, and deliver higher-value services. 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: Information technologyProgram 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.
Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Online
2.00 Credits
Member Price: $99
Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram 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.
Nonprofit Internal Control - Practical Insights into Mitigating Financial Reporting, Compliance and Other Risks
-
Online
4.00 Credits
Member Price: $129
There is simply no denying that a sufficiently designed and effectively operating system of internal controls over reliable financial reporting is more important than ever. The primary objective of this course is to give participants "hands-on" practice in designing, evaluating, and communicating conclusions related to design and operating effectiveness of internal controls over reliable financial reporting and other risks for nonprofit environments. Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: Basic
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.
The Radar Phenomenon
-
Online
1.00 Credits
Member Price: $39
This session reviews the three elements of fraud, how fraudsters think, how proper internal controls can prevent and detect fraud, and the red flags to look for to identify fraud. It looks at Radar O'Reilly, one of the most beloved characters of the TV show M*A*S*H. He was trusted by his boss to run the administrative side of the US Army medical unit. Were there red flags all around Radar? Did he have the opportunity to steal? Was he a fraudster? We'll find out? Attendees learn to recognize the traits of this type fraudster that are present in many organization. Case studies of various Radars are included. Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: Basic
Performance Management
-
Online
1.00 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. Delivery Method: Individual webcastCPE Credit: Personnel / human resourcesProgram Level: Intermediate
HR Investigations - Episode 3 - Gathering-Analyzing-Reporting
-
Online
1.00 Credits
Member Price: $39
Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session provides best practices for gathering and analyzing evidence and reporting the investigation results. Attendees will end the session with takeaways to immediately implement in future HR investigations. Three of three Episodes in the series. Delivery Method: Individual webcastCPE Credit: Personnel / human resourcesProgram Level: Intermediate