CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Excel for Accounting Professionals Session 1: Tables and Named References
-
Online
2.00 Credits
The first session in the series covers one of the most significant enhancements rolled out with Excel 2007, Tables. Tables are used to store data and can absolutely revolutionize our workbooks because they solve one of the biggest pitfalls Excel users have faced for over 20 years. The webcast also covers named references, which will be used throughout the series. In addition, the five most important shortcuts are explored, so that you can improve your personal productivity. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel, since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the session, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook, and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.
Surgent's Internal Controls, COSO, and COVID-19
-
Online
4.00 Credits
Companies that fall victim to fraud schemes need to reassess internal controls in order to prevent future fraudulent activity. In this course, we will review the 18 most prevalent internal controls that should be present (as well as designed and operating effectively) in order to prevent future frauds. These controls are taken from Association of Certified Fraud Examiners' Report to the Nations: 2020 Global Study on Occupational Fraud and Abuse. Then we will tie these controls to the 17 internal control principles offered by the Committee of Sponsoring Organizations of the Treadway Commission (COSO), the framework used by virtually all entities and auditors to assess the design and operational effectiveness of internal controls. Lastly, we will consider the impact of the 2020 pandemic on internal controls in the coming era.
Leadershift: Drive Results Through Ethical Performance Mgmnt
-
Online
4.00 Credits
Do you find yourself challenged to achieve the results you want? While leading employees can be one of the most challenging activities, it is also one of the most impactful leadership skills few seem to master. Inspirational leadership looks like lifelong employees reaching their full potential AND impactful business results that are repeated year after year. Striking the balance between these two critical aspects does not have to be rocket science. In this power-packed course, the formula to be an Inspirational leader has been masterfully developed and covers the soft skills of Inspirational leadership and the Results Model: Goal Setting + Coaching + Follow Up with proven results from dozens of both large and small companies. These cornerstones are simple but can be hard to execute because it is HOW you do it first, then WHAT you do second. This exciting course is designed to ignite your leadership skills by putting theory into practice; drilling into real live examples and experiencing first-hand what excellence sounds like through role-playing and building your action plan. Get ready to become an inspirational leader and learn the steps required to get the results you really want. 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 Tips, Tricks, and Techniques for Accountants
-
Online
8.00 Credits
Excel is the accountant’s tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Regardless of your level of experience, if you use Excel, you need this course to learn more efficient and effective ways to work with Excel. In this course, you will discover countless tips, tricks, and techniques to improve your general level of productivity, reduce the amount of time you spend on mundane tasks, such as formatting, and customize Excel for greater accuracy and efficiency. You will also learn valuable formula-building skills, best practices for linking Excel data from other worksheets and workbooks, and how to streamline report generation and printing processes. Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples that will improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience in delivering spreadsheet training to accounting and financial professionals, which assures you of the relevance and usefulness of the information and guidance provided during the program.
A Practical Guide to Trusts
-
Online
8.00 Credits
This course provides in-depth information to enable the practitioner to make a well-informed decision as to whether a trust is the appropriate vehicle for a client’s financial, estate, and/or asset protection plan, and, if so, how the trust can best be implemented and operated. Participants will learn about the many different types of trusts that can be harnessed to save clients income, estate, generation-skipping, and other taxes, at both the federal and state level.
Finance Business Partnering: The Essentials
-
Online
8.00 Credits
Critical Competencies This webcast builds on your current knowledge and experience to help you successfully navigate and drive value for your business during a time of disruptive, technology-led change. You will learn how to stay relevant and future-focused while building your competencies in critical areas including communication, influencing, and business acumen. This webcast also delivers strategies and best practices to support your ability to enable strategic decisions to drive business forward.
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.
Surgent's Audits of 401(k) Plans: New Developments and Critical Issues
-
Online
8.00 Credits
One of the most favored employee benefit plans, the 401(k) plan, provides unique challenges for auditors. Also, as many 401(k) plan administrators opt for ERISA Section 103(a)(3)(C) audits, audits of 401(k) plans will be significantly impacted by the now-effective SAS 136, the AICPA's new employee benefit plan auditing standard. Through this course, auditors will obtain an understanding of the rules and regulations unique to employee benefit plans and obtain practical guidance on applying them. Auditors will enhance their knowledge of the performance and reporting requirements of SAS 136 through real-world examples, best practices, and efficient audit techniques that can be utilized in various audit engagements. Make sure your audits don't trigger a DOL inspection by conforming to all applicable rules and regulations.
Consideration of Fraud in a Financial Statement Audit
-
Online
2.00 Credits
One of the most significant challenges facing auditors is the prevalence of fraud that exists in today's business environment. All auditors should have a working knowledge of the requirements in professional literature regarding fraud. We will cover the issues that all auditors need to know about fraud and the people who commit fraud. This course will provide horror stories about frauds that have occurred and how they were detected. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Ethics Hour: Thinking Through Decisions and Recognizing the Consequences
-
Online
1.00 Credits
We all are busy, pressed for time and we strive to do as much as we can – as fast as we can. This is our world. However, there are times when we should stop and think. When we do not analyze (one of our many talents) this inaction causes problems. We will review the penalties of moving too fast. Let’s learn from the mistakes of others.
Business Valuation Fundamentals
-
Online
1.00 Credits
In this course we will look at the highlights of what valuation is doing, how to go about it and what to look for in business valuation reports. Areas such as types of reports, the standards by which they are prepared and process that is used to go from data to report. We will also discuss the purposes of reports and how that purpose may impact the value. Finally, we discuss how to determine the value of minority interests.
2024 Deep Dive into Quality Management
-
Online
2.00 Credits
Quality management will have a big impact on CPA firms. This course will cover both SQMS 1 and 2 as well as the related engagement level standards (SAS 146 and SSARS 26). The new standards will require a risk-based approach to quality management as well as the documentation of an information & communication process. This two hour class will provide a deep dive into what you need to know to start your implementation process!
2024 Single Audit Update
-
Online
2.00 Credits
This course will start with a review of the impact of the 2024 Compliance Supplement on Single Audits as well as the changes to the Uniform Guidance. We will also review common audit deficiencies found in Single Audits.
Drive Results with Metrics
-
Online
2.00 Credits
Many organizations struggle to keep budgets current in an ever-changing business climate. Twenty-first century performance metrics focus on determining what budgets should be rather than what they were in the past. Using performance metrics effectively reduces work, reduces politics, provides flexibility and substantially improves the performance management process. This session will show you powerful techniques to drive your organization’s performance.
Supervision/Management Competencies: An Ethical Approach
-
Online
2.00 Credits
Job titles for individuals can vary in different organizations even though the work is the same. This webinar is designed for the individual whose role is to oversee the work of others. This webinar includes an overview of Aristotle's virtue ethics and its application to the responsibility and privilege of developing employees to be their best and for the success of the organization. We will also address issues such as going from "buddy to boss", how to manage if you are newly assigned to an existing employee that was previously supervised by someone else, and critical skill sets necessary for supervisory/managerial positions. 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 Auto and Energy-Related Tax Credits
-
Online
2.00 Credits
The Inflation Reduction Act (IRA) contains many changes to auto and energy-related credits. Many if not most of these credits reduce the cost of individual- and business-related expenses. As a result of the changes brought about by the IRA, tax advisors have new and reformed credits to understand and explain to their clients. The IRS has issued extensive guidance regarding these credits in the form of Frequently Asked Questions that elaborate on and explain these new credits. This program covers the new and revised energy-related credits clients will be asking about, such as credits related to personal autos, energy-efficient commercial vehicles, and household-related utilities and improvements. This program will cover the IRA changes related to electric car credits in detail so that those attending can properly advise their individual and business clients regarding them.This course qualifies for IRS credit.
Surgent's Guide to the Corporate Transparency Act for Accounting and Finance Professionals
-
Online
2.00 Credits
Effective January 1, 2024, an estimated 32.6 million entities will be required to report information about their beneficial owners to FinCEN as part of the Corporate Transparency Act (CTA). In an effort to combat money laundering and other illegal activities, the law provides harsh penalties for the failure to report the required information. This reporting specifically targets small businesses and holding entities, creating opportunities for accountants, tax practitioners, and other business advisors to expand their service offerings. The reports require the listing of all "beneficial owners," and they are imprecisely defined, possibly requiring an exercise of judgement. Therefore, proper education of professionals and business owners is paramount for accurate reporting. The course includes an overview of the CTA and a detailed discussion of what information needs to be reported to FinCEN.
Surgent's Key Roth IRA and Roth 401(k) Rules for Funding and Tax-free Distributions
-
Online
2.00 Credits
How much can you contribute to a Roth IRA, Roth 401(k), SEP Roth IRA, or SIMPLE Roth IRA? How will a Roth distribution qualify to be tax-free? How did SECURE Act 1.0 and SECURE Act 2.0 change the Roth rules? These are only some of the key Roth questions advisors must know the answers to. Plus, as Roth accounts have increasingly become an essential component of retirement savings portfolios, with one-third of IRA owners owning Roth IRAs, advisors have even more reasons to be Roth-proficient. To that end, the instructor will simplify critical rules that govern Roth funding and Roth distributions for Roth IRAs, Roth 401(k)s, and sister plans.This course qualifies for IRS credit.
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Online
2.00 Credits
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.
SAS No. 122, AU 240, Consideration of Fraud in a Financial Statement Audit
-
Online
3.00 Credits
When performing a financial statement audit, auditors have always been responsible for the detection of anything that would cause a material misstatement of the financial statements whether caused by error of fraud. However, in the past the audit profession focused on material misstatements due to errors and more or less ignored the possibility of misstatements due to fraud. Now, SAS No. 122, AU 240 requires significant documentation as to what the auditor did in order to determine if there any material risk of a misstatement of the financial statements. This presentation is an overview of what the auditor is to document in there working papers on every financial audit as to the procedures they performed in order to determine the risk of a material misstatement. If a material risk is discovered, they are then required to document what they did in order to determine if the financial statements were misstated.