CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Power BI - Analyze Your Data With Excel Pivot Tables
-
Online
4.00 Credits
This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order. Excel is a popular tool for data analysis, yet most users have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis. This webcast is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make data analysis an easy task for all accountants. You will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features. This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel. Explore the other webcasts in the Power BI Series: Power BI - Introduction to MS Power BI Tools Power BI - Prepare Your Data Efficiently for Excel Analysis Power BI - Create Excel Dashboards for Maximum Impact Power BI - Use Power Query to Transform Your Data Power BI - Go Beyond PivotTables with Power Pivot Power BI - Use Advanced Calculations with DAX Formulas Power BI - Use PBI Desktop to Create Reports and Dashboards Power BI - Share Your Data Analysis using PowerBI.com
Tax Season Update for Business with Steve Dilley
-
Online
4.00 Credits
This program provides an update to the latest tax developments, rules and regulations impacting business taxpayers, with a review and integration of the numerous 2021/22 legislation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Annual Update for Governmental Accountants & Auditors
-
Online
8.00 Credits
This course begins with a look at the GASB standards effective this year, including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We'll include practical application of the topics in the form of case studies. We'll then switch gears to review the GASB standards coming down the pike, including major projects of the GASB. When considering the audit side of the house, Yellow Book and Single Audit engagements are considered must-select engagements for Peer Review. This course will cover the Yellow Book independence requirements which are required any time an auditor performs a Yellow Book or Single Audit even when the engagement is for a for-profit entity. The session will also cover the changes to the Uniform Guidance. We'll close with a look at the key changes in the 2024 Compliance Supplement and the common deficiencies identified by the federal agencies and peer reviewers. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Best Federal Tax Update Course by Surgent
-
Online
8.00 Credits
In this continually revised course, tax advisors will be fully updated on the most recent enacted legislation and IRS guidance, as well as major trends on the horizon with a view toward planning considerations. This update course is designed for all practitioners, both those working in public accounting as well as those in private industry, who need the latest information on tax changes. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BITU.This course qualifies for CFP credit.This course qualifies for IRS credit.
The Ethics of Care in the Workplace
-
Online
2.00 Credits
Ethics involve relationship to self, others, and the world in which we live. In the busyness of our world we often act out of habit without realizing that what we do truly matters. We matter! This session explores ethical values and principles as they apply to creating an Ethic of Care in the workplace with specific emphasis on compassion, accountability and respect. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Responding To Retaliation Concerns and Capturing Key Retaliation Case Metrics
-
Online
1.00 Credits
Individuals may cite retaliatory concerns when weighing their decision to report an issue; during an investigation; or, after an investigation’s conclusion. No matter the timing, when an individual raises a retaliation concern, their claims should be taken seriously and fully reviewed. Does your organization analyze retaliation allegations and investigate outcomes as part of their cultural assessment? Most organizations track retaliation matters at a general, non-specific level. The type of retaliation and the perceived cause of the retaliatory act are not delineated. When a retaliation matter requires investigation, an organization should gather key data points for trending purposes and to fine tune future training and policy initiatives. This course offers recommendations for (1) framing responses to retaliation allegations (2) capturing key data points (3) developing specific metrics for retaliation matters
The Controllership Series - The Controllers Role in Financial Forecasting
-
Online
1.50 Credits
Financial forecasting is an important part of any successful business. It enables businesses to plan for the future and anticipate scenarios based on strategy. The controller helps forecast financials by calculating future revenue and income streams. In recent years, corporate finance has undergone many dramatic changes due to the growth of a number of high-tech tools. The responsibilities/competencies of the Financial Controller position (FC) has changed in recent years To maximize performance, Controllers must be aware of how the FC position is changing, and how they must adjust to these changes. There are many types and methods of financial forecasting. This course will review the most prevalent forecasts and relative methods being used.
2024 Independence Requirements for Auditors
-
Online
2.00 Credits
CPAs in public practice are required to maintain independence. In this course, we will discuss concepts associated with independence and review the rules from the AICPA Code of Professional Conduct with a focus on their practical application. We will also review the recently issued ethics interpretations from the Professional Ethics Executive Committee (PEEC), which impact independence, and discuss practical methods of implementation.
Improve Design and Productivity with Excel Tables
-
Online
2.00 Credits
Excel tables are a fundamental feature that streamlines data organization, analysis, and visualization in Excel. Throughout this course, you will discover how to transform raw data into elegant, efficient, and visually appealing tables. By harnessing the full potential of Excel tables, you will be able to make better data-driven decisions and collaborate more effectively in various professional settings. Join us in "Improve Design and Productivity with Excel Tables" and unlock the full potential of Excel tables to revolutionize the way you manage, analyze, and present data, leading to improved efficiency and better decision-making in your personal and professional endeavors. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2's 2024 Excel Best Practices And Features
-
Online
2.00 Credits
Excel remains a staple tool for virtually all accounting and financial professionals. In this session learn about many of the newer features in Excel, along with some you may have overlooked in the past…truly “must-see CPE!”
Let's End Business Ethics
-
Online
2.00 Credits
Most ethics courses focus on unethical individuals and their terrible misdeeds. We don’t need another course on lessons from Enron or individuals committing fraud. Most unethical failures result from unethical individuals. Instead, this session will focus on how good people can do better, why there is no such thing as business ethics and why we only need one rule to lead ethical lives.
Surgent's Skills to Enhance Personal and Professional Networks
-
Online
2.00 Credits
Managing a strong network is one of the most important things you can do to grow professionally. Yet despite its importance, maintaining an effective network is often not taught in undergraduate and graduate schools. The good news is that managing and growing a network is easier than it sounds. In fact, most professionals have some level of basic networking skills simply from helping someone find a job, attending an industry conference, or seeking professional connections through social media. Effective networking involves more than simply collecting contacts. Strong networks should be relevant to your career and consist of people you trust. Personal networks are just as important as professional networks and the two often overlap. In this course, we explore ways to strengthen and grow networks by examining proven strategies that have helped individuals meet their personal and professional goals.
Surgent's What Tax Practitioners Need to Know About Medicare
-
Online
2.00 Credits
Tax advisors often receive questions concerning all facets of Medicare. How does Medicare work? How do I apply? How much does it cost? Is Medicare optional or required? This program provides a basic introduction to the Medicare program and covers many of the areas of the Medicare program that clients are most interested in. If you, or some of your clients, have questions relating to Medicare, this program is a must for you.
2024 Financial & Tax Accounting for S Corporations
-
Online
4.00 Credits
This program addresses the many complex financial and tax accounting issues that are common in S corporation transactions, with discussion of common pitfalls and the new AICPA "small" GAAP accounting standards.
2024 Fiduciary Accounting for Estates and Trusts
-
Online
4.00 Credits
Financial accounting for trusts and estates is one of the least understood branches of accounting. It is not particularly concerned with recording income and expenses but is obsessed with determining whether receipts and expenditures are assigned to income or principal/corpus. This course will dive into this tricky area and provide a reporting guide for fiduciary accounting.
Hands-On Tax Return Workshop - Partnerships & LLCs (Form 1065)
-
Online
8.00 Credits
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
2024 Annual Update for Accountants & Auditors
-
Online
8.00 Credits
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.
Combating Internal Fraud
-
Online
2.00 Credits
Fraud in the workplace is not new, however, statistics show that the number of instances of internally actuated fraud schemes is increasing. Additionally, because of all the changes that have come about due to recent upheaval, fraud risk is at an all-time high. This session starts by reviewing the many reasons that fraud occurs; it then looks at ways to detect internal fraud and finally explores control measures that can help to reduce fraud risk. Those that take the class will learn just how invasive and damaging internal fraud can be. They will also know ways to detect and thwart fraudulent activity. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Why Auditors Fail To Detect Fraud
-
Online
2.00 Credits
Prior to the original SAS No. 82 on Consideration of Fraud In A Financial Statement Audit (now codified as SAS No. 122, AU 240), the word fraud never appeared in a single SAS, nor was it described anywhere. SAS No. 82 stated that auditors failed to detect fraud for two reasons: 1) They did not know what it looked like and 2) They had not been trained to look for it. Although the SASs did not provide any guidance, auditors have always been responsible for the detection of anything that would cause a material misstatement of the financial statements whether caused by error or irregularities. (They would not even say the word fraud until it appeared in SAS No. 82) The standards were replete with guidance on the detection of an error but silent on how to detect irregularities. Now auditors are required to document in every financial statement audit their process of determining the risk of financial misstatement due to fraud. This presentation is designed to focus on frauds that were missed by the auditors and, in some cases, why it was missed. There will also be discussion as to what the auditor must do in order to improve their track record on detecting fraud. As reported on the Association of Certified Fraud Examiners Occupational Fraud 2022: A Report to the Nations, only 4% of frauds were initially discovered by the external auditor. It was reported that more frauds were discovered by accident, (5%) then was discovered by the external auditor.
2024 Accounting Update in a Post COVID-19 World
-
Online
2.00 Credits
The COVID-19 pandemic has altered corporate and public accounting in ways we could never have imagined. This broad-based course will discuss accounting and auditing implications that have arisen as a result of the pandemic.