CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Surgent's Controller/CFO Update: Hot Topics Facing Today's Financial Professional
-
Online
4.00 Credits
In today's rapidly changing world, finance professionals are required to wear many hats and are often the keys to the success of the organization. On one hand, they need to be abreast of the latest proven financial skills for making the best decisions, and on the other hand they need the best skills to motivate, manage, and lead people. Being pigeon-holed into one area or another is neither good for career building nor good for the organization. This reality has proven to be even more true with the advent of COVID-19. We'll cover the latest issues that all CFOs and controllers need to know about and provide how-to guidance to allow for immediate use in their organizations. The program is focused on organizational success and will concentrate on ways to manage risk and achieve greater productivity.
Power BI - Advanced Data Analytics with Power Pivot
-
Online
8.00 Credits
This fast-paced course focuses on using Excel Power Pivot features to enhance data analysis. One of the strengths of Power Pivot is the formula language DAX (Data Analysis eXpressions). We will spend considerable time using the power of DAX to create meaningful calculations that add new dimensions to our data. We will also review the use of a date or calendar table that allows us to perform date analysis that was never possible before. This will allow us to use the new time-intelligent functions to perform complex calculations on our data such as: month-to-date, quarter-to-date, year-to-date, last year same period, last year-to-date, etc. We will also demonstrate the hottest tips and tricks that will take your data analysis to the next level. Although our focus will be on using Power Pivot, we will review some of the other Power BI Tools including: Power Query (Get & Transform), Power BI Desktop and Power BI Services (PowerBI.com). NOTE: If you want to apply the concepts presented, you will need Excel 2013, 2016 or 2019/Office 365 AND the Power Pivot add-in pre-installed. To see our full prerequisite recommendations, see PROGRAM CONTENT section below. 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.
Excel - Advanced Spreadsheet Troubleshooting Techniques
-
Online
2.00 Credits
Do you dread that annoying ERROR! message popping up on your spreadsheets? Tired of using the same long, elaborate formulas when you could be using the ones that are already built into Excel? Then this class is for you! In this webinar, we will focus on Debugging and Troubleshooting complex formulas. You will learn various techniques that will assist you in creating complex compound formulas. You will also learn techniques to resolve issues when you receive errors. This session will also discuss the 9 built-in error checking options and demonstrate resolution techniques. We will also review techniques to resolve rounding errors. This session is presented using Excel 2013. Regardless of the version you are using, ALL 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.
Internal Control Frameworks for Single Audit
-
Online
1.00 Credits
The Uniform Guidance identifies COSO and Green Book as best practices in internal control. This course will cover the background on COSO and its 2013 update. We’ll also review the application of COSO to Green Book. Attendees will learn how to leverage Part 6 of the Compliance Supplement for documentation of internal controls.
6 Practical Strategies To Promote Diversity & Inclusion In Your Workplace
-
Online
1.00 Credits
Although organizations are trying to create and manage diverse and inclusive workplaces, many are not aware of some of the best practices and simple strategies they can incorporate to promote such an environment. We are currently living in unprecedented times. Division, bias, and exclusion, based on factors associated with social injustice and a general lack of appreciation for diversity, seems to have become our current societal norm. With the high stress and anxiety created by these current trends in society, it is even more important for organizations to provide a safe space for their employees where there is a genuine sense of belonging and fair access to opportunity. The goal of this course is to outline the relationship between diversity and inclusion, while providing very practical strategies for HR Professionals in their role to promote a culture of diversity and inclusion in the workplace.
Surgent's Artificial Intelligence for Accounting and Finance Professionals
-
Online
2.00 Credits
Accounting and finance professionals have used different forms of automation over the years to improve the efficiency and accuracy of their work. So far, technology has not been able to replace the knowledge, experience, and decision-making of seasoned professionals. Times are rapidly changing. Today, systems easily exceed humans in accuracy and consistency. Artificial intelligence (AI) brings opportunities for accountants and finance professionals in the short term to improve efficiency and accuracy, while providing more value for businesses and customers alike. In the long term, AI will offer profound changes to how professionals work and process data. This course is designed to review where we are and where we are headed in the world of AI.
Surgent's Ethics for Tax Professionals
-
Online
2.00 Credits
The purpose of this program is to discuss the ethical mandates that govern the conduct of tax practitioners. The program focuses on the ethical pronouncements of the IRS in Circular 230, as well as the preparer penalty provisions set forth in the Internal Revenue Code. Please note: This ethics course does not cover state-specific issues and so is not applicable in states that require ethics courses to include specific state laws and regulations. Please check with your state board prior to registering for this program if you are in doubt about whether this program satisfies your state's ethics requirements.This course qualifies for IRS credit.
Surgent's Improving Your Profits: Identifying Cost Cutting Opportunities
-
Online
2.00 Credits
Part of one's duty as a CPA working in industry is to safeguard the assets of the organization. Cost cutting is one way to preserve assets and maintain a company's competitive position in the industry. However, what keeps us from ridding our organizations of unnecessary costs? In this course, we will look at the factors that prevent our companies from being as streamlined as they could be. By using statistics and survey data, we will attempt to show how to better negotiate and navigate budgeting and contracting decisions. We will also discuss financial statement analysis techniques, benchmarking, and cash flow management in an effort to better cut costs and maintain the long-run viability of an organization.
Surgent's Top 10 Celebrity Estate Mistakes and How to Avoid Them
-
Online
2.00 Credits
This course uses the lives of the rich and famous as a template to better understand the realm of estate planning. With stories ripped from the headlines, we will examine pitfalls and best practices. Did you know that Prince died without a will, opening the door for 45 people claiming to be his beneficiaries? Or that Michael Jackson was not careful in properly funding his trust, leading to delays and legal battles in the administration of his estate? Even Abraham Lincoln, it turns out, did not have a will. In discussing an array of celebrities, from Jackie Kennedy, Joan Rivers, Jimi Hendrix, and Whitney Houston to Aretha Franklin, Barry White, Leona Helmsley, and Florence Griffith Joyner, the course is designed as an enjoyable learning experience with tips for all levels of expertise. We may not have their fame or fortune, but we can certainly walk the red carpet when it comes to estate planning.
Nonprofit Accounting and Financial Reporting Explained
-
Online
8.00 Credits
This course provides a high-level overview of the most important issues facing nonprofit entities and their auditors. The focus of this course is on explaining the theory behind major issues and trends, enabling professionals to understand the most important aspects of relevant professional and regulatory standards related to reliable financial reporting for nonprofit entities.
Mail Fraud and Wire Fraud: Why Business Owners go to Prison
-
Online
2.00 Credits
When federal prosecutors contemplate charges against business owners, two of their most potent and readily available tools include charges for mail fraud and wire fraud. The elements to convict for these crimes are clear: 1) The defendant devised or intended to devise a scheme or artifice to defraud, and, 2) in executing or attempting to execute the scheme, the defendant used or caused the use of mail or an interstate wire or wireless transmission. Mail, emails, cell phone calls, text messages, Internet transmissions, and even tweets could form the basis for charges of wire fraud or mail fraud. The crime of wire fraud is a reason that many business owners go to prison. In this course, we'll learn about a few people who've experienced a conviction for wire fraud. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Professional Skepticism for the Public Accountant
-
Online
1.00 Credits
Accountants are expected to demonstrate a questioning mindset. While such professional skepticism is an obvious requirement for assurance engagements, it is applicable elsewhere in the practice of public accounting. In fact, a skeptical mindset offers benefits to both public accountants and those who work in industry. This course provides specific examples of professional skepticism while suggesting best practices.
How Culture Affects Risks
-
Online
1.00 Credits
Creating Culture Benefits Your Organization It's important to dedicate time and resources in: Evaluating the company's current culture Communicating the company's values Creating processes and risk avoidance activities for a healthy corporate culture Prioritizing and monitoring risks This course will help you evaluate your organization's current culture, and teach you strategies for building a thriving corporate culture.
2024 How to Choose the Right Business Entity for Your Client
-
Online
2.00 Credits
Tax rates, personal liability, operations – these are all factors to be weighed when advising clients about their choice of entity decision. This session provides a comparison of the multiple entity choices to start the discussion with clients and selecting the best tax efficient option for them. **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.
Crucial Tax Topics 2021-2022 with Art Werner - Mergers and Acquisitions: Complete Guide to Relevant Issues
-
Online
2.00 Credits
Arthur Werner will provide financial professionals with the information their teams will need to successfully plan and execute mergers and acquisitions. For major topics covered, see below. This course may be customized or tailored based on the needs of your organization.
Everyday Ethics at Work: Don't be the Next News Story!
-
Online
2.00 Credits
When asked, most people would say they are an ethical person. So why is it that every month there are reports of ethical breaches at major companies? The concept of ethics is easy to understand, easy to talk about, but incredibly hard to implement on a consistent basis. In this course, we will discuss current ethical issues, and walk-through a nine-step ethical decision-making model. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Retaining Talent in a Competitive Marketplace
-
Online
4.00 Credits
Retaining Talent in a Competitive Marketplace -Creating a Benefits Program Employees Care About In today's competitive marketplace, retaining talented employees is becoming increasingly difficult. A solid benefits program can make a difference in the fight for talent - but only if those benefits matter to the employees you are trying to hire! Through statistics and case studies, this course will explore what benefits are most valuable to employees. We will also explore the basic types of retirement and health insurance plans and discuss what financial leaders should consider before adopting a benefits package. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Estate Planning for Today and Beyond
-
Online
8.00 Credits
Estate planning continues to evolve, and staying informed about the latest trends and strategies is crucial for professionals in the field. This forward-looking course delves into the intricacies of estate planning, with a specific focus on current issues. Participants will explore cutting-edge techniques, emerging legal considerations, and industry developments to ensure they are equipped with the knowledge and skills to create effective estate plans that withstand the test of time and safeguard their clients' legacies.
Audit 203: Auditing Accounts Receivable - Common Risks
-
Online
2.00 Credits
Auditing Accounts Receivable - Focusing Procedures for Testing Existence and Valuation will explain tips and best practice techniques for auditing common accounts receivable risks, primarily focusing on existence and valuation. Accounts receivable tends to carry higher risk of material misstatement due to the complexity and subjectivity involved with initial recognition, subsequent measurement, and valuation. In addition, revenue recognition is presumed to be a significant fraud risk. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has responsibilities for auditing accounts receivable. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
SAS 145 - Risk Assessment
-
Online
1.00 Credits
SAS 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was issued in October 2021. This audit standard amends AU-C 315, making many changes to address common audit deficiencies. This course will provide an overview of SAS 145 and its changes to AU-C 315.