CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Instant Audit? Just Add Risk Assessment
-
Online
1.00 Credits
What would you do if you only had one workday to complete a financial statement audit? How would you optimize just a handful of hours? What would you test? More importantly, what would you minimize or eliminate? Although one day is unrealistically short, it illustrates how risk-based auditing can help auditors optimize professional effort. This course emphasizes the importance of risk assessment for enhancing both the effectiveness and efficiency of audit procedures.
The Radar Phenomenon
-
Online
1.00 Credits
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.
I want the TRUTH: Preparing to be an Expert Witness
-
Online
2.00 Credits
Many practitioners dealing with government and not-for-profit issues are asked to serve as expert witnesses in courts of law or other adjudicatory venues. This session will discuss key issues you need to know when you are asked to serve in this capacity, including: Applicable standards and other engagement acceptance considerations. Preparation requirements and techniques. Dos and don'ts of testifying. Avoiding commons traps and tricks designed to undermine your effectiveness. The session will conclude with a “mock cross-examination” with participants serving as the jury to identify what our witness does right and what he does wrong.
Introduction to Not-for-Profit Accounting
-
Online
2.00 Credits
Not-for-profit organizations encounter distinct accounting complexities. This course provides an introduction to the financial statements and specialized accounting principles relevant to nonprofits. Attendees will explore key topics such as net assets, agency transactions, contributions, and endowments, focusing on the unique transactions and account balances that define not-for-profit accounting.
K2's Office Scripts - The New Macros
-
Online
2.00 Credits
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.
Become a Data Analysis Expert
-
Online
2.00 Credits
In today's rapidly evolving business landscape, accounting professionals are expected to be more than just number crunchers, they are expected to be insightful interpreters of data. In an era where data is king, this course is your gateway to becoming a savvy data analyst, giving you a competitive edge in your field. We will guide you through the intricacies of making complex data analysis approachable and engaging. You will learn the all important Data Analysis Process Flow that will take you from collecting data all the way to making insightful decisions based upon your data. We will explore the basics of data modeling that will allow you to access data from multiple sources and use sophisticated calculations to create our data metrics. You will learn how to create interactive dashboards, perform sophisticated reporting, and uncover deep insights from your data. Whether you're looking to streamline your reporting process, enhance your data visualization skills, or make more data-driven decisions, this course is tailored to meet those needs. It's not just about learning a tool; it's about enhancing your professional identity as a forward-thinking accounting professional. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Mastering Charitable Remainder Trusts and Form 5227 ComplianceCompliance
-
Online
2.00 Credits
Join us for an in-depth webcast on Charitable Remainder Trusts (CRTs) and the essential aspects of preparing Form 5227. This course will provide a comprehensive overview of CRTs, including their purpose, benefits, and practical considerations. Moreover, we will delve into the intricacies of Form 5227, the informational return for charitable remainder trusts, ensuring you have the necessary knowledge to accurately complete and file this crucial document. During this webcast, Art Werner will guide you through the fundamental concepts of Charitable Remainder Trusts, illustrating how they can be utilized as a strategic tool for tax planning. We will explore various types of CRTs, their formation, and the different scenarios in which they are most beneficial. A significant portion of the webcast will be dedicated to Form 5227, the reporting requirement for charitable remainder trusts. We will provide an in-depth analysis of the form's components, line by line, ensuring you gain a comprehensive understanding of the information it requires. From trust assets and income to distributions and charitable beneficiaries, we will cover each section, discussing common pitfalls and best practices for accurate reporting. Mr. Werner will address the recent updates and changes to Form 5227, enabling you to stay up to date with the latest compliance requirements. **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.
Surgent's Taking Advantage of Like-Kind Exchanges
-
Online
2.00 Credits
When real property is sold for a gain, we always try to find ways to defer recognizing income so that it won't be necessary to send a check to Uncle Sam. There is a provision within the Internal Revenue Code that allows the taxpayer to defer recognition of immediate taxable gain in the year of sale known as a "like-kind exchange." Knowing how and when to utilize this provision makes the Accounting and Finance Professionals very valuable to either their client or the entity they work for. We will also discuss recent proposals that could impact the future of this provision.This course qualifies for IRS credit.
Surgent's Working Remotely: Best Practices, Challenges, and Opportunities
-
Online
2.00 Credits
Working from home presents both benefits and challenges for professionals. For employees, working from home provides opportunities to be more productive and gain time that would otherwise be spent commuting to and from the office. Employers who utilize remote work enjoy fewer fixed costs, more efficiency, and greater employee satisfaction. Without proper planning, professionals who work remotely may experience increased anxiety and disorganization. They may also jeopardize data privacy. However, when executed properly, working remotely can help organizations become more efficient and profitable, while at the same time improving employee morale. This course looks at how firms and companies have successfully implemented work from home programs and discusses mistakes that can be avoided through proper planning.
The Power of a Good Story!
-
Online
4.00 Credits
Storytelling makes wisdom stick.
Achieving Balance in Work and Life - Part 1
-
Online
4.00 Credits
Due to the constant stress of a fast paced life, overwork, and family demands, it’s easy to feel one’s life is out of balance. When this happens, all areas of your life can suffer. By learning key methods for setting priorities and goals, overcoming stress, and deciding what’s most important to you, you can achieve new levels of balance and greater results. Having more balance in your life will allow you to do less of what you don’t want and more of what is truly important to you.
Triple Your Memory, Prevent Dementia and Halve Your Stress - Part 1
-
Online
4.00 Credits
This is not your average CPE course! In this fun and practical course, you'll learn how to remember names, where you put things, what you read, or anything else 300% (or more) effectively than before. You will also learn how to prevent dementia, and halve your stress by using exercises that take under two minutes a day to do. Additionally, you'll receive information on ways to improve your memory by improving your overall health and wellness. This course will give you an overview of natural supplements to enhance your memory as well as share tips to improve your sleep. This course will change your life both now and in the future by making sure you know the best ways to remember information, handle stress and keep your mind sharp until the day you die. The information in this course to help increase your professional efficiency and improve your overall quality of life.
The Competent Accountant - Mastering the Role of the Controller/ CFO
-
Online
4.00 Credits
How do you raise your skills to the next level to master the Controller or CFO role? Welcome to a course that provides insights that align the CGMA Competency Framework. The course will examine each of the areas: Technical, Business, Leadership and People to increase your competency. How are your technical skills? Are you a traditional accountant or have you learned to expand your technical skills to go beyond “what are the financial numbers?” to “why did these financial results occur?” Are you able to use ratios to understand the business dynamics and the implications to change course or take corrective action? Are the systems that you implement and operate best practices or merely stop-gap solutions? How are your business skills? Can you set a vision? Can you develop a strategy? Do you understand the macroeconomic environment of your organization? Can you lead a major project to a successful conclusion? This session will explore the role of business as opposed to tracking the results of the business. How are your people skills? How good is your ability to influence others? How are successful are your negotiation skills? How well can you communicate? Are you a collaborator or a partner? This section will help accountants understand that it is people skills that drive the overall success of the accounting operations. Finally, how are your Leadership skills? Do you inspire staff or make them angry? Do you know why your staff work for your company and you? Do you understand what employees want from their position? Do you know how to deal with a difficult staff person? Can you lead difficult change? This session will help you recognize what leadership truly is as opposed to what passes for day to day management.
New Mergers & Acquisitions: Tricks, Traps, & Terrors
-
Online
4.20 Credits
Welcome to a course that makes the process of M&A easy to understand and easy to implement within your organization or your clients' organization. The course will provide an intensive overview of the M&A process. Focus will be on practical techniques to guide you through the M&A jungle and avoid the traps that have befallen many organizations.
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.
Preparation, Compilation, and Review Engagements: Update and Review
-
Online
4.00 Credits
By reviewing the latest developments and issues relevant to preparation, compilation and review engagements, you'll be able to adhere to professional standards while performing these types of engagements.
K2's Technology For CPAs - Don't Get Left Behind
-
Online
8.00 Credits
How good are you with the technology you use daily? What new technology tools are available that could save you time and make you more effective? Technology continues to accelerate rapidly, and the need to keep pace is essential. If you are not an information technology (IT) expert but need a technology update to maintain and improve your skills to serve your companies or clients more efficiently and effectively, this course is for you! In this fast-paced, update-style course, you will survey today’s IT environment, learning about computer hardware, software (including Microsoft Office), operating systems (including Windows 10), and what they mean for you, and peripheral devices. You will also learn about significant trends in information technology and how to take advantage of the opportunities presented by these trends. Examples include the latest Excel features, working with PDF files, and security and privacy issues. Additionally, you will learn how to improve the overall performance of your IT investment, thereby increasing your return on investment. Throughout this program, you will learn from real-time demonstrations of practical applications of the latest tools, which can provide you with the knowledge you need to harness the power of technology, both now and in the future. Register now for this “don’t miss” opportunity to get the skills required to enhance the value of your IT investment.
How to Get a Better Return on Financial Statement Audits - Avoiding the Most Misapplied Risk-Based Audit Conce
-
Online
8.00 Credits
By far, the biggest contributing factor that leads to a profitable, yet high quality, financial statement audit is the proper identification, evaluation, and response to assessed risk of material misstatement. When designing your detailed audit plan, how and where you decide to spend your time is largely a matter of professional judgment. The proven tips and techniques for critically rethinking how you plan and design your audit taught in this course will help auditors enhance audit quality and manage profitability in all engagements.
Surgent's Audit Skills Training Level 2: Preparing for Increasing Responsibilities in Public Accounting
-
Online
8.00 Credits
As you rapidly gain experience in the auditing profession, the responsibilities of the staff accountant grow exponentially. Progressing from the base-line audit skills covered in Level 1 training that allow a new auditor to perform their roles, Level 2 training covers those skills that are required for experienced staff accountants who need to audit more complex and subjective areas, such as accounts receivable and investments, and to plan and appropriately perform sampling and analytical procedures. Redesigned to provide the relevant content to staff accountants when they need it, the Level 2 reviews the underlying accounting concepts of these often-complex areas and, through examples and exercises, discusses the relevant audit procedures required by professional standards. The course is designed to allow the staff auditor to capitalize on their prior experiences and apply them in new areas, as they continue their career advancement. IMPORTANT NOTE: This course takes place over two consecutive days. Registration for both days is required.
Fraud & Embezzlement: Case Studies from the Trenches
-
Online
2.00 Credits
Governmental entities are the second largest victims of embezzlement. This seminar examines recent events involving theft of public money and circumstances that allowed the fraud to occur. Case studies we examine include the 2012 $54 million embezzlement from the City of Dixon by Rita Crundwell. The events that impacted the small Illinois town of 16,000 residents was the largest governmental fraud case to date, and spanned an astonishing 20 years. This remarkable story inspired an award-winning documentary, "All the Queen's Horses." We will also examine factors that led to scandals involving the Baptist Foundation of Arizona, World Com, Collin Street Bakery and the Ohio American Cancer Society, among others. This course is ideal for CPAs, government finance personnel, all Internal Auditors, lawyers, governance professionals, accountants and human resource personnel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.