CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Enact Retaliation Abatement and Monitoring Measures
-
Online
1.00 Credits
Once an employee decides to report an issue, the risk for retaliation must be minimized. Metrics matter. As such, capturing and reviewing employee data for indicators of possible retaliation are key to protecting those who report. The more subtle forms of retaliation, though, require a focused communication plan to address. This course offers recommendations for implementing specific retaliation monitoring protocols.
Ethical Situations - What to do When?, featuring Allison McLeod and Don Minges
-
Online
1.00 Credits
What would you do when ___? Is would the same as should? Examples; Rashmi Airan-Pace and Yale Law School. What should you do when a vendor offers to give you tickets to the NCAA Final Four basketball tournament and your organization will permit it? Prepare for ‘situations’ before they happen to you.
Create Paginated Reports with Power BI Report Builder
-
Online
2.00 Credits
Elevate your data reporting skills to new heights with our cutting-edge course, "Create Paginated Reports with Power BI Report Builder." This two-hour, expertly crafted training is designed to transform the way you visualize and present data, leveraging the powerful capabilities of Microsoft Power BI Report Builder. Ideal for professionals who aspire to turn complex data into compelling, print-ready reports, this course is a game-changer in the realm of data visualization and business intelligence. Delve into the world of paginated reporting with a curriculum that balances theoretical knowledge with practical examples and demonstrations. You'll learn how to navigate the Power BI Report Builder interface with ease, design intricate report layouts, and connect to diverse data sources for comprehensive reporting. The course covers a spectrum of skills, from creating eye-catching visualizations to utilizing advanced features like sub-reports and drill-through capabilities. By the end of this session, you'll be adept at publishing and sharing professional-grade, paginated reports that can inform and persuade your audience. Enroll now and take the first step towards mastering the art of paginated reporting with Power BI Report Builder. 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 Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Online
2.00 Credits
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.
Business Consulting for CPAs
-
Online
4.00 Credits
Does your firm have interest in expanding its’ services beyond traditional CPA services? Do you have staff with the expertise to compete against non-CPA firms? Welcome to a course that will lead you through the maze of creating a successful Consulting Business Practice for your CPA firm. The course will help you understand: where consulting business opportunities exist, what are the firm’s professional responsibilities and most importantly how to recognize the needs of the client.
2024 Tax Season Update for Individuals with Steve Dilley
-
Online
4.00 Credits
This program provides an update to the latest tax developments, rules and regulations affecting individual taxpayers, including a review and integration of late 2023 -24 legislation. **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 Your Front-Row Ticket to the 2024 Accounting & Auditing Season
-
Online
4.00 Credits
This course highlights significant updates that affect financial reporting and related attestation services. We will explore novel FASB pronouncements while examining the enduring impact of lease accounting and revenue recognition standards. This course will provide reminders regarding both GAAP and non-GAAP financial reporting alternatives for closely held entities. We will also explore selected guidance regarding audit, review, and compilation engagements.
2024 Annual Update for Governments and Not-for-Profits
-
Online
8.00 Credits
We kick off this course with a look at the GASB standards that are effective this year including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We then move to the NFP side of the house with a look at the Accounting Standard Updates issued by the FASB that impacts nonprofit entities. Following that, we review the work of the Not-for-Profit Advisory Committee (NAC) and the projects they advise the FASB on. After the break, we will conduct a deeper dive into Yellow Book and Single Audit engagements. The course closes with a look at the significant changes in the 2024 Compliance Supplement, the changes to the Uniform Guidance and the common deficiencies identified by the federal agencies and peer reviewers.
K2's 2024 Paperless Office
-
Online
8.00 Credits
The Paperless Office is not a myth! With today’s technology, you have many fantastic options for “going paperless,” In this session, you will learn how to leverage these technologies for better document management and storage practices.
Cybersecurity Fundamentals for CPAs
-
Online
2.00 Credits
Modern technology solutions have enabled people to operate more effectively from home using cloud-based technologies and services. This course will cover cybersecurity best practices to help CPAs protect their data and devices while using internet-based cloud technologies. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Consulting Services Secrets
-
Online
1.00 Credits
Award winning discussion leader Mark Hugh discusses how to create and capture value with consulting services. Whether you want to consult a little or full time, this valuable course reviews identifying a specialty, growing a practice, capturing value, creating deliverables, and effective marketplace marketing strategies.
Awful Ethical Dilemmas - Bringing it to Life, featuring J. Michael Inzina and Don Minges
-
Online
1.00 Credits
Professional Codes of Conduct make Ethics seem easy and clear cut. However, this is not so in real life. This session discusses five cases where the ethics is not so clear cut. What should be considered? We will explain how you can be more diligent and maintain awareness of ethical issues to become more effective and enhance the reputation of the profession.
2024 Moving Beyond the Basics of Excel
-
Online
2.00 Credits
This course explores the increasingly complex features of Excel that facilitate efficient data analysis. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information.
2024 Real Estate Professionals: Passive Activity Rules
-
Online
2.00 Credits
When do they exist and how to report them? This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples, and integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction. **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.
Individual Tax Update: Recent Developments
-
Online
2.00 Credits
A discussion of the latest 2021/222 tax developments impacting individual taxpayers, with a focus on important provisions, rules and concepts. 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 2023 Excel Charting And Visualizations
-
Online
4.00 Credits
Charts and graphs are nothing new. However, many professionals struggle with building compelling visualizations. If that statement describes you, participate in this session to improve your skills in creating Excel charts and other visualizations. As a result, you will create visualizations to enhance your communication skills. This session is much more than just a seminar on fundamental charts. Instead, in this session, you will learn how to create advanced charts that are interactive, dynamic, and aesthetically pleasing – three qualities that will help to ensure that your readers and audience will understand the data you are presenting. This seminar is a must if you want to improve your communication skills.
Power BI - Analyze Your Data With Excel Pivot Tables
-
Online
4.00 Credits
* This course is #3 in the Microsoft Power BI series of webinars. Click button in Program Content section below to see 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 session is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make data analyzation an easy task for all accountants. Participants will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel. 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 2023 Case Studies in Fraud and Technology Controls - 8 Hrs
-
Online
8.00 Credits
Fraud continues to plague businesses at epidemic levels, and technology control failures are a significant reason fraud occurs. Using a case study approach, in this session, you will learn about the pervasiveness of fraud, the control failures that contribute to fraud, and what you can do to mitigate fraud risk. A specific focus of this course is the application of information technology general controls and information technology application controls. In this course, you will examine numerous reported fraud cases and identify the general control and application control failures that contributed to each of these frauds. By learning through these real-world case studies, you will be positioned better to reduce fraud risk.
Audit 503: Management - Being a Balanced Leader-Manager
-
Online
2.00 Credits
Management Skills - Exhibiting Traits of a Balanced Leader-Manager provides tips and techniques for striking the right balance between managing individuals and engagement teams and leading the overall strategic direction of a firm. Short-term profitability and long-term viability are important objectives of any successful organization. Note: This course is recommended as a part of a 16-hour audit skills curriculum for managers, while it is also appropriate for anyone who has responsibilities for leading or managing others. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Internal Controls Over Compliance vs Compliance
-
Online
1.00 Credits
Based on an AICPA Enhancing Audit Quality study, 23% of all single audits subject to enhanced oversight were materially non-conforming with professional standards due to failure to properly test controls over compliance. This course will provide an overview of internal controls over compliance specifically related to Single Audits. We will discuss how to apply the concept of internal controls to various compliance requirements. Additionally, a common finding in the audits of governmental entities receiving federal grants is misidentifying controls and mistaking compliance for a control. That's why this course will also focus on identifying compliance versus controls over compliance.