CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
The Role of Internal Control in the Risk-Based Audit
-
Online
4.00 Credits
This program explores the role of client internal controls for balancing efficiency and effectiveness in a risk-based audit. We offer practical insights regarding an auditor's assessment of the risk of material misstatement when auditing financial statements of non-issuers, with particular emphasis on internal controls of small-to-medium clients.
Build a Data Model for Analysis in Power BI
-
Online
4.00 Credits
This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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.
Estate and Financial Planning for the Older Client
-
Online
8.00 Credits
Enter the complex world of elder planning with this comprehensive course tailored for financial professionals. Gain invaluable insights into estate and financial strategies designed specifically for older clients, equipping you with the knowledge and skills to address their unique needs and challenges. Throughout the course, participants will explore a wide range of topics, from understanding the complexities of Medicare and various life insurance types to navigating Social Security considerations and exploring Medicaid planning details. With a focus on practical application, attendees will learn to customize estate planning strategies, explore housing and care alternatives, and address gifting complexities relevant to older clients. By the end of the program, you'll develop expertise in executing specialized planning requirements for mature clients, ensuring you're well-prepared to provide informed counsel and support in this important aspect of financial practice. Join us and enhance your knowledge in estate and financial planning for the older client 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 Handouts Tab and submit to kori.herrera@acpen.com
Ethical Considerations in Working with Cannabis
-
Online
1.00 Credits
This session will explore the ethical considerations CPAs and CPA firms should be cognizant of when considering services to the state legal, regulated cannabis industry. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Microsoft Outlook "Must Know" Email Tips
-
Online
2.00 Credits
If you use Outlook on a daily basis to process your email, chances are pretty good that you are missing out on a lot of opportunities to improve your efficiency in composing, processing and organizing your messages. There are many different features in Outlook that often get overlooked, even though we are working in the app all day, every day. John Higgins, a strategic advisor to the profession on Microsoft 365 deployment, will review numerous tips and features to improve your productivity in Outlook. You will learn many time-saving, practical ways to improve the quality of your email message. 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 The Complete Guide to Payroll Taxes and 1099 Issues
-
Online
8.00 Credits
Employment taxes are often overlooked as an area where more planning may be effective. Payroll taxes have become an increasing burden for the average business, and IRS penalties for noncompliance have risen dramatically in recent years. They have also been subject to employer incentives. The Service has announced that uncovering noncompliance by employers ranks high on its audit list. This course presents a comprehensive overview of federal payroll taxes, Form 1099, and related compliance issues.
Building Your Own Library of Anti-fraud & Continuous Monitoring Tests
-
Online
1.00 Credits
In this course, participants will gain a broad understanding of the various anti-fraud preventive and detective tests available to practitioners and take initial steps in building their own library of tests unique to their business or industry risks. Specific discussions and examples will include vendor analysis to look for potentially improper payments around conflicts of interests, fake vendor schemes, bribery & corruption, sanctions and trade compliance, anomalous payments, segregation of duties, among other risk categories. Participants will also explore tests around customers or distributors that include margin analysis, free goods, discounts and revenue recognition. Further, we will explore employee related test to mitigate travel & entertainment expense abuses. We will also point out various online and public resources for participants to start building their own library of tests to support both reactive investigations as well as proactive prevention and detection.
Working Through Grief and Loss - How to Build a Supportive Workplace
-
Online
1.00 Credits
Now more than ever, navigating loss, grief and crisis in the workplace is a skillset that leaders must possess. Keeping the heart in human resources is so important, especially in this post-pandemic state we are living in. We will explore ways that you can show empathy to your employees while also balancing your business needs.
Maintaining a Harmonious Working Environment
-
Online
1.00 Credits
A harmonious working environment is one in which people feel safe, seen, heard, and respected. Critical to maintaining it are that employees have high self-esteem, are treated with respect, and work in a safe, non-violent setting. This course provides practical knowledge and scripts on how to take appropriate action and deal effectively with discriminatory comments, sexual harassment, and threats and acts of violence, such that personal and employer liability is avoided.
Creating A Culture of Trust
-
Online
1.00 Credits
It is the role of a leader to build and maintain a great culture in the organization. The culture is the driving force that shapes the attitudes and behaviors of everyone in the organization. A relationship driven organization is built on trust and is the most effective way to improve productivity, engagement, and the bottom line. Understand the components that enable trust to be created and maintained throughout teams and organizations.
Yellow Book Ethics
-
Online
2.00 Credits
The Yellow Book outlines essential ethical principles for governmental auditors, including serving the public interest, maintaining integrity, objectivity, and professional behavior. This course provides a focused review of these key concepts and their practical application in governmental auditing. Participants will also explore the independence standards, gaining insights on maintaining objectivity and avoiding conflicts of interest to ensure unbiased and professional audits.
Creating an Ethical Work Environment
-
Online
2.00 Credits
This session introduces theories on human nature and organizational factors affecting ethical choices. Robbie examines the role of gossip in the workplace, provides tools for ethical decision making and offers concrete actions for creating and sustaining an ethical work environment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2025 A&A Update With Technology Implementation
-
Online
4.00 Credits
Stay informed and prepared with this comprehensive annual update on the latest developments in accounting and auditing. We'll begin with a deep dive into the Accounting Standards Updates (ASUs) effective in 2025, followed by insights from the FAF's 2024 PCC Review and an overview of FASB's Invitation to Comment - Agenda Consultation, which will shape the future of accounting standards. On the auditing side, we'll tackle the essential changes in quality management standards that firms must implement by the end of 2025. The session will also highlight common deficiencies identified by the DOL in EBP (Employee Benefit Plan) engagements and provide a peek at upcoming projects from the Auditing Standards Board (ASB). Join us to gain practical insights and actionable takeaways to navigate these updates with confidence. Finally, we will close the course by exploring the audit technology adoption process to help transform resistance into resilience as the industry embraces new technologies. We will learn how to overcome common barriers to deliver a successful implementation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Estate Planning Strategies: Advanced Techniques and Tools
-
Online
8.00 Credits
As the new administration proposes changes to tax policies, estate planning strategies must adapt to evolving laws and regulations. This course equips financial professionals with advanced tools and techniques to address complex estate planning issues, including the latest legislative and regulatory updates. Participants will gain insights into tax-efficient wealth transfer strategies, charitable giving techniques, and the impact of recent tax law changes on estate and gift taxation. With a focus on real-world application, this course provides practical strategies for leveraging closely held stock, split-interest trusts, and life insurance in estate planning. Attendees will explore how to maximize tax benefits while ensuring compliance with changing regulations, ultimately helping clients achieve their financial and legacy goals. *Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Handouts Tab and submit to kori.herrera@acpen.com
K2's Excel Essentials For Staff Accountants
-
Online
8.00 Credits
Staff accountants have specific needs when working with Excel – needs that are often not met by their existing Excel knowledge. Chief among these are the needs to quickly summarize data, prepare accurate and aesthetically pleasing reports, and create accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills they need to maximize their efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a “laptop-friendly” environment, and participants will have access to all the demonstration files used in the session. In sum, this seminar is a “must” for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.
K2's Excel PivotTables for Accountants
-
Online
8.00 Credits
Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge of PivotTables, then plan to participate in this course. You will learn how to build PivotTables, group data inside PivotTables – including grouping options for fiscal periods – and create user-defined calculations in your PivotTables. You will also learn advanced PivotTable techniques, including building PivotTables that consolidate data from multiple data ranges and PivotTables that connect dynamically to external databases and financial accounting systems. Additionally, you will learn to take advantage of other Excel features associated with PivotTables, including Slicers, Power Query, and Power Pivot. You will be a master of Excel PivotTables at the end of the day! This course is for you if you have been leery of working with PivotTables or have struggled to realize their many benefits. With some information, guidance, and coaching from your K2 instructor, you will be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.
Leadershift Ethics: Things Must Change!
-
Online
2.00 Credits
With the rapid pace of change, change now happens daily in business and our personal lives. It can be difficult to navigate change when right and wrong get a bit fuzzy. New processes, new technology, new circumstances and new impacts to people must be measured and decisions made as the change evolves. Change always becomes something different than what was originally planned or imagined. In this session, learn how to measure your ethics through change. You will learn how to filter everything you do during change through a simple litmus test. Through the power of story, you will learn from the lessons of other organizations and their ethical mistakes. Lastly, you will take away what is required to manage yourself so that when ethical decisions arise, you have the mental capacity to manage through it well. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Shortcuts that Excel Users Love
-
Online
2.00 Credits
Many people that use Microsoft Excel know a great deal about the functionality of the application. There are, however, a tremendous number of hidden tools that a high percentage of users overlook. Additionally, there are newer features that some have not had the opportunity to explore. This session shows some of the numerous time-saving tools and features that often go unused by spreadsheet creators. People that wish to become more efficient when using Excel should take this session! 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 Saving Time With Electronic Forms
-
Online
1.00 Credits
Web portals, "low-code/no-code" data collection, and survey tools have changed how we collect data. Modern solutions like Microsoft 365 Forms, Zoho Survey, SurveyMonkey, Microsoft PowerApps, and legacy tools like Adobe Acrobat Forms allow users to create web forms and integrate the resulting data into business process workflows. This session introduces the range of available tools, demonstrates standard features, and shows how tools permit users to expose or conceal questions based on answers given earlier in the survey. Attend this session to learn how to use tools you already own to efficiently collect data from your team, customers, and vendors.