CPE + Events Catalog
Excel for Accounting Professionals Session 6: List Comparisons and Indenting (2 hours)
-
Online
2.0 Credits
Member Price: $125
See more dates
Major benefits of detailed Excel workbooks Understanding list comparisons in Excel is vital for improved workbook efficiency. In this webcast, the facilitator will walk you through comprehensive learning exercises that provide an overview of the following topics: Performing list comparisons Building multicolumn list comparisons Using lookups Indenting commands In-depth training for Excel upskilling This webcast is crafted to enable active participation as you follow the demonstrations. It will navigate you through the intricacies associated with working Excel columns, helping you to apply key functions effectively for significant improvements through the following: ISERROR COUNTIFS SUMIFS *Session 6 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 7: Data- Driven Workbooks and Concatenation] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-7--date-driven-workbooks-and-concatenation) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Surgent's Anatomy of a Ransomware Event and Incident Response (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
The past two years have ushered in an explosion of ransomware attacks affecting businesses and individuals. Many of us read or hear about these attacks, but there is little understanding of how they occur, how a response is undertaken, and how the chances of experiencing one can be reduced. Join us to learn about these topics so you can be prepared with the best response and the knowledge to avoid common mistakes in a ransomware event.
More Dates
Surgent's Working Remotely: Best Practices, Challenges, and Opportunities (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
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.
More Dates
Unlock the Power of AI with Copilot in Excel (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
In the ever-evolving world of data analytics and business intelligence, Microsoft Excel continues to be an indispensable tool for professionals across industries. With the introduction of Copilot, Microsoft has integrated the power of artificial intelligence directly into Excel, revolutionizing how users work with data. This 2-hour interactive course, Unlock the Power of AI with Copilot in Excel, provides a comprehensive overview of how Copilot transforms traditional Excel workflows into dynamic, AI-driven processes, enabling users to accomplish tasks faster, more accurately, and with less manual effort. During this course, you'll discover how Copilot leverages AI to enhance productivity and streamline operations. Whether you're a seasoned Excel user or just beginning your journey, this course will guide you through practical applications and best practices to make the most of Copilot's capabilities. Through hands-on demonstrations and real-world examples, you'll see how Copilot can save time, improve decision-making, and elevate your analytical skills to new heights. This course not only focuses on the technical aspects of Copilot but also highlights its potential to transform your day-to-day work, from automating repetitive tasks to uncovering trends and insights you might otherwise overlook. By the end of the session, you'll be equipped with the knowledge and confidence to integrate Copilot into your workflows and unlock its full potential in Microsoft Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Common Yellow Book & Single Audit Deficiencies (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
Yellow Book and Single Audit engagements are considered must-select engagements for peer review. This course will review the common deficiencies noted by peer reviewers and federal agencies. We'll focus on the requirements of Yellow Book independence, CPE, and reporting. We will also review deficiencies related to internal controls over compliance, compliance testing, and major program determination for Single Audits. We'll close the course with a look at the deficiencies often identified in COVID-related funds.
More Dates
ChatGPT for Accountants: 50+ Use Cases (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course will explore the use of ChatGPT and artificial intelligence chatbot technologies in the accounting profession. Participants will learn how to utilize ChatGPT to automate tasks, improve efficiency and accuracy, and provide real-time support to clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Audit Risk Assessment in Plain English (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
Audit Risk Assessment in Plain English, is a 2 hour webcast highlighting the AICPA’s clarified risk assessment standards, along with a new Statement on Auditing Standard (SAS 145) related to understanding the entity, the entity’s environment, the entity’s internal controls, and assessing the risks of material misstatement. This session will attempt to simplify the requirements using common sense examples and language.
More Dates
Recruit. Retain. Engage. Mastering LinkedIn for HR Success (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Today's savvy executives use LinkedIn to accelerate hiring, as well as, to promote employee retention and engagement. This interactive session is for the financial executive who is actively growing and nurturing a team or company and wants to leverage LinkedIn, which is the best digital resource available. Join us for this powerful webinar and unlock the full potential of LinkedIn as your HR secret weapon for recruiting top talent, retaining your best employees, and elevating overall team engagement. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Bumper Sticker Ethics v. Professional Ethics (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
Ethics is simple: Do no harm, just tell the truth, keep your word, and when in Rome do as the Romans do. For most people in most circumstances, these "bumper sticker" sayings provide helpful ethical guidelines. For accountants, however, ethics -- and especially, professional ethics -- can quickly turn into a tangle of ethical conflicts and competing rules. This workshop untangles some of these situations by working from ethical theory and practice. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
The Controllership Series - The Treasury Function Part 1 - Cash and Investing (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
This course corresponds to our Controllership series. This course is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we discuss the area of cash and investments and explore how the controller can move these responsibilities into more of a strategic role. In today’s world, the role of cash management is often a pivotal role in the organization. In economically difficult times, controllers may find that they spend a great deal of their time on understanding and managing the organizations' cash position. This is certainly important and, in some areas, can be seen as a staple of the lifeblood of the organization’s ongoing viability. This course takes a look at some of the typical objectives involved in Cash management and then evaluates how those objectives can be further stretched into strategic pillars of the organization.
More Dates
Preparation, Compilation and Review Engagements (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
This course is an introduction to preparation, compilation, & review engagements. During this course, we will compare and contrast these different engagements by reviewing the procedures that should be performed, different reports, as well as the level of assurance specific to each type of engagement.
More Dates
The Controllership Series - Overhead, Direct and Indirect Costs and Allocation Methods (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
Managing expenses is a key for business success, and overhead costs play a pivotal role in realizing favorable profit margins. Almost all companies have some form of overhead consisting of specific categories of indirect expenses. The better organizations are able to manage overhead costs, the more competitive they are in the marketplace. It is incumbent in the Controller’s role to effectively manage, monitor and perform ongoing assessment of overhead costs, allocations and rates. Overhead refers to the ongoing business expenses not directly attributed to creating a product or service. A company must pay overhead on an ongoing basis, regardless of how much or how little the company sells. It is important for budgeting purposes but also for determining how much a company must charge for its products or services to make a profit. Overhead can be fixed, variable, or a hybrid of both. There are different categories of overhead, such as administrative overhead, which includes costs related to managing a business. In short, overhead is any expense incurred to support the business while not being directly related to a specific product or service.
More Dates
How Culture Affects Risks (1 hour)
-
Online
1.0 Credits
Member Price: $75
See more dates
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.
More Dates
Learning to Teach "Tax" as a Second Language (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
Sometimes the vernacular of accounting seems more challenging than technical aspects. This session offers suggestions for translating the foreign language of taxation into tangible terms for non-accountants. We explore techniques for simplifying the complexity of taxation terminology. This course will equip you with tools for demystifying tax technicalities so you can help clients and other non-tax professionals grasp fundamental concepts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Revenue Recognition - Allocate the Transaction Price (1.8 hours)
-
Online
1.8 Credits
Member Price: $59
See more dates
The updated revenue recognition standard outlines five steps for proper compliance. At the surface, these steps seem simplistic. However, there are many considerations that should be considered within each step based on your process and industry.
More Dates
Travel Expenses and Taxes: How to Maximize Deductions and Stay Compliant (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
This program reviews the statutory and regulatory guidance as they relate to fringe benefits. There will be an emphasis on entertainment, meals and business transportation expenses, including qualified employer-provided parking, with a focus on planning opportunities. Recent federal tax legislation, cases and rulings will also be addressed. *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
More Dates
Like-Kind Exchanges (2.2 hours)
-
Online
2.2 Credits
Member Price: $79
See more dates
Please join us for a discussion on like-kind exchanges (LKE), known as one of the last great tax legal “shelters” available to those buying and selling real property. We will be covering the basic structure of a LKE, and ways a taxpayer can utilize qualified third party intermediaries (QI), tenancy-in-common structures including Delaware Statutory Trusts (DST). We will also explore creative solutions to sticky situations a taxpayer may find itself in obtaining replacement property. **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
More Dates
How to Audit Expenses & Payables (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
It is imperative that audit staff understand the fundamentals of expenses & payables. This course will cover the basics of auditing expenses, accrued liabilities, and other payables, including the related audit assertions, risks, & threats to the expenses & payables balances. During this course, we will also highlight the various substantive auditing procedures that staff should perform, and also walk through some real-world examples. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Surgent's Fraud In Single Audits (4 hours)
-
Online
4.0 Credits
Member Price: $159
See more dates
With all the planning, procedures, and reporting involved in a single audit, sometimes things can slip through the cracks. But what if the thing that slips through is fraud? Compiled from news releases, court records, and the thrilling annals of the Federal Audit Clearinghouse, this course tells the tale of six real-world frauds which seemingly dodged detection in the single audit process. Leveraging the incredible gift of hindsight, this course is designed to raise your awareness and sharpen your focus on the potential for fraud in single audits!
More Dates
Business Consulting for CPAs (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
Does your firm have interest in expanding its’ services beyond traditional CPA services? Do you have staff with the expertise to compete against non-CPA firms? Welcome to a course that will lead you through the maze of creating a successful Consulting Business Practice for your CPA firm. The course will help you understand: where consulting business opportunities exist, what are the firm’s professional responsibilities and most importantly how to recognize the needs of the client.
More Dates
