CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Excel for Accounting Professionals Session 6: List Comparisons and Indenting
-
Online
2.00 Credits
This session opens with how to use Excel's lookup functions to perform list comparisons. Also, this webcast covers how to perform multicolumn list comparisons without first combining several columns into a single lookup column. We discuss how a minor detail like how we indent can produce major efficiency gains. We end the webcast by comparing traditional lookup functions to Excel;'s multiple condition summing function. 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 webcast, 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 Handling Difficult People
-
Online
2.00 Credits
Learn to manage difficult colleagues with gloves - kid gloves, not boxing gloves. Having even one difficult person in your department can tax your restraint and deplete the time and energy you need to supervise your team. "Handling Difficult People" teaches you how to manage challenging colleagues without sacrificing everyone else to the process. This workshop is designed to help you learn to recognize difficult behavior before it gets out of hand and to understand why difficult people behave the way they do. You'll work with a three-part problem-solving model and study a five-step process for initiating the dialogue through to planned resolution. And you'll leave with an action plan to address specific situations in your workplace.
Why Cybersecurity Matters to CPAs
-
Online
2.00 Credits
CPA's are responsible for understanding (1) the presence of fraudulent activity, (2) that financial reports are complete and accurate, and (3) applying the going concern principle to a business. Appropriate cybersecurity controls, processes and oversight directly impact these three areas. Fraud Bad actors can exploit systems with weak security controls to perform fraud. The increasing prevalence of hacked systems reflect this. Bad actors are stealing data, intellectual property, financial assets, and other information. Digital fraud is becoming more prevalent and can be substantially more damaging than historical types of fraud. Not only can digital fraud result in financial loss, but it can subject companies to expensive lawsuits, damage reputations and can even put a company out of business. Complete & Accurate Financial Reports Having cybersecurity controls on systems and networks is critical to ensure information reported in financial statements is complete and accurate. Data residing in financial reports is processed, stored and transmitted using IT Systems. It is important for CPA's to understand the required cybersecurity controls to prevent or detect inaccurate data in financial reports. Going Concern With an increasing volume of system hacks (e.g. Target, Experian, Sony, and most recently the US Government), it is no longer "if" you're going to get hacked, it is "When." If organizations do not have appropriate cybersecurity controls in place to protect against an attack, then a malicious hack can put them out of business. An organization's cybersecurity posture should be a factor in evaluating the Principle of Going Concern. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Accounting & Auditing Update for Small Businesses
-
Online
4.00 Credits
For many small businesses, the standards issued by the FASB may have little to no effect as they impact topics that do not reflect the type of transactions that these entities most frequently experience. This class will focus on the Accounting Standards Updates (ASUs) that are most likely to impact small businesses with a focus on ASUs initiated by the Private Company Council (PCC). We'll then look at alternative reporting options to GAAP including FRF for SMEs and IFRS for SMEs for entities who don't necessarily need to prepare GAAP financial statements but want to use accrual accounting. Finally, we will transition to audit standards that small business auditors will need to implement.
2024 S Corporation Essentials: Review & Update
-
Online
4.00 Credits
This program addresses the critical issues and special opportunities facing S-corporations, with a focus on reporting shareholder basis and distributions. **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.
Comprehensive Accounting and Financial Reporting Update
-
Online
4.00 Credits
This course covers recently issued accounting and financial statement reporting standards from the Financial Accounting Standards Board. Key implementation challenges and experiences from public company filings will be identified. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Risk Assessment Under SAS No. 145: The Key to Audit Quality?
-
Online
2.00 Credits
The AICPA has identified risk assessment as an area of focus for its Enhancing Audit Quality Initiative as deficiencies in auditor's risk assessment procedures continue to be a common issue identified in peer review. SAS No. 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was written to improve the quality of risk-based audits. While key concepts do not fundamentally change, the standard works to clarify and enhance certain aspects of the identification and assessment of the risks of material misstatement to drive better risk assessments and hopefully overall enhance audit quality. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Clear. Confident. Compelling. - Communication Strategies for Women in Business
-
Online
1.00 Credits
When asked the question, “What would you like to improve about your leadership and communication style?” more than 65% of leaders say they want to be more confident and assertive in their communication. Confidence and clarity communicates leadership. If you are responsible for growing a profitable company or a productive team, you want team members who have the ability to reach goals, make sales, finish projects, and serve customers. Being a confident compelling leader helps to inspire better relationships, promotes trust and reduces stress in the workplace.
Audit 501: Personality Styles - Improving Your Interactions
-
Online
2.00 Credits
Personality Styles - Adapting to Different Types of Personalities for Improved Relationships and Interactions provides guidance for effectively adapting to various personality styles. Every individual has a dominant personality style, which includes relevant strengths and weaknesses. Effective interactions require individuals to adapt behaviors to complement, balance or counteract the traits of others. Note: This course is recommended as a part of a 8-hour audit skills curriculum for managers, while it is also appropriate for anyone who has responsibilities for interacting with others. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ChatGPT Bootcamp for CPAs with John Higgins
-
Online
4.00 Credits
ChatGPT is the fastest growing application in the history of technology with over 100 million users adopting it in within two months. It is a revolutionary technology that boosts the quality and efficiency of business processes in every industry. As "knowledge workers", CPAs and CFOs are positioned to be prime beneficiaries of this technology. This half day hands-on course will get you well on your way to becoming a ChatGPT expert. John Higgins, a nationally recognized advisor and educator on CPA technology, will guide you through the process of accessing ChatGPT and applying it to a variety of practical accounting, finance and tax scenarios. This course will catapult you to the top of the pyramid of CPAs who are knowledgeable in ChatGPT and you will be ready to put it to use in your day-to-day tasks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Common Deficiencies in EBP Audits
-
Online
2.00 Credits
During this presentation, the most common mistakes made by employee benefit plan auditors, as well as plan sponsors will be identified. Best practices for handling specific issues that arise during the course of the engagement will also be explored. This discussion will help auditors recognize potential pitfalls in audit procedures/documentation and assist plan sponsors with compliance issues. 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 2024 Effective Automation And Outsourcing
-
Online
1.00 Credits
Automation and outsourcing offer viable options for addressing today’s labor issues. In this session, you will learn about the potential benefits and risks associated with automation and outsourcing.
Communication Skills for Introverts
-
Online
2.00 Credits
In today's technology-driven world, success in business depends upon your ability to translate data into information, communicate with anyone, and present ideas powerfully, whether it's one-on-one or in the boardroom. This fast-paced and interactive session covers specific techniques in three critical areas: listening, writing, and presenting. Learn about the hard skills involved in the softer side of leadership. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Are You Up to the Challenge? Test Your Skills as a Quality Control Reviewer
-
Online
4.00 Credits
Have you ever wanted to reduce the number of financial statement review points you receive? Are you curious about a reviewer’s thought process? This hands-on session will answer these questions by helping you understand the role of an engagement quality control reviewer. Not only will you develop an appreciation for the role of an engagement quality control reviewer, but this interactive session will allow you to step into the reviewer’s shoes by performing a quality control review during the class session. You will leave with an understanding of best practices for minimizing your exposure to critique by reviewers.
Deep Dive Into Common Auditing Deficiencies
-
Online
4.00 Credits
This course will review common deficiencies identified by the AICPA and state boards of accountancy. It features discussion on a variety of topics, including analytical procedures, sampling, group audits and risk assessment. We will review the areas of concern and how you can overcome them by employing best practices. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Minimizing Workplace Warfare
-
Online
1.20 Credits
This course is designed to equip HR leaders, managers and business owners with the knowledge and skills needed to effectively minimize conflicts in the workplace. Participants will learn about the various sources of workplace conflict, how to identify and address conflicts before they escalate, and how to implement effective conflict resolution strategies. The course will also cover topics such as communication skills, active listening, and conflict management techniques. By the end of the course, leaders will be able to create a more positive and productive work environment, reduce turnover, and promote employee satisfaction.
Asset Misappropriation - Let Me Count the Ways
-
Online
2.00 Credits
As discussed in the Association of Certified Fraud Examiners’ Occupational Fraud 2022: A Report to the Nations, 86% of all frauds are misappropriation of assets. Why is the misappropriation of assets so large? Because there as so many of them it creates many, many opportunities. And the asset which is stolen the most? CASH! Because it’s easy to conceal and you don’t have to convert it. During this presentation, the many, many different ways to misappropriate (steal) assets and which assets (besides cash) are most subject to misappropriation are discussed as well as how to recognize such and more importantly, how easy it is to prevent it!
Excel for Staff Level 1 - What You Never Learned
-
Online
2.00 Credits
Most Staff Accountants learned Excel in college and many others learned Excel on their own, however most users never learned the important productivity tips that help them build spreadsheets more efficiently. This course will teach new and experienced users how to leverage the many productivity tools built within Excel in order to build spreadsheets with maximum effectiveness. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethics: How to Give and Receive Criticism the Right Way
-
Online
2.00 Credits
How well do you accept criticism? How might it enrich your business - and you - if you did a better job of it? This distinctive webinar will show you why it is in your best interest to accept criticism with gratitude. It's even better to welcome criticism. It's also a good idea to learn how to give criticism the right way. A related topic is the art of giving and receiving apologies, and we'll do a deep dive into this area as well. You'll leave with clear guidelines for how to criticize others, accept criticism from them, give meaningful apologies, and accept apologies with grace and ethical intelligence. The result will be a stronger CPA practice and a better you. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel for Staff Level 2 - Getting More Out of Excel
-
Online
2.00 Credits
Excel can do so many things but what are some of the features that can really help accountants take their Excel skills to the next level? This course is designed to do just that. To learn ALL the capabilities of Excel would take hundreds of hours of training, so this two-hour course is designed to give you a jump start on the most important features that you can immediately begin implementing in your spreadsheets. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.