Professional Development and Event Catalog
Excel for Accounting Professionals Session 7: Date-Driven Workbooks and Concatenation
11:00am - 1:00pm
Online
2.00 Credits
Member Price: $125
See more dates
Realistic Excel training for skill development Shifting from manual inputs to automated formulas in Excel can help enhance data efficiency. Understanding that Excel can handle date and text values broadens the potential to improve efficiency when managing data in Excel. This webcast will focus on the following essential functions: EOMONTH MONTH and YEAR DATE CONCAT SUMIFS with CONCAT Practical hands-on Excel learning exercises taught by a highly engaging expert In this webcast, you'll develop your skills and implement Excel techniques that will boost the effectiveness of conditional summing functions using comparison operators. Additionally, you'll gain in-depth knowledge of the following: Adding helper columns Distinguishing key function differences Combining values *Session 7 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 8: Dynamic headers, mapping tables and error check] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-8--dynamic-headers-mapping-tables-and-error-check) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Risk Assessment Under SAS No. 145: The Key to Audit Quality?
11:30am - 1:30pm
Online
2.00 Credits
Member Price: $89
See more dates
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.
More Dates
Mergers and Acquisitions: Complete Guide to Relevant Issues
12:00pm - 2:00pm
Online
2.00 Credits
Member Price: $79
See more dates
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. *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
Reviewing Individual Tax Returns
12:00pm - 2:00pm
Online
2.00 Credits
Member Price: $125
See more dates
The volume of individual tax returns requiring preparation can create an environment that leads to errors or omissions. Identify common errors practitioners make on individual tax returns for single filers.
More Dates
S Corporations - Overview
12:00pm - 2:00pm
Online
2.00 Credits
Member Price: $79
See more dates
This course provides an overview of the key aspects and tax implications of S Corporations. Participants will learn the mechanics of electing Subchapter S status, compare S Corporations to other entity structures, and explore compliance requirements such as corporate formalities. Highlights include a detailed discussion of Form 1120S, accountable plans, taxable fringe benefits, officer reasonable compensation, and IRS audit strategies. The course also covers Schedules K-1, K-2, and K-3, as well as the concept of effectively connected income. Practitioners will gain practical insights into advisory services and strategies for representing clients before the IRS. *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
The Ethic of Recruitment and Selection
12:00pm - 2:00pm
Online
2.00 Credits
Member Price: $89
See more dates
Today, more than ever, it is essential that employers have an ethical and effective recruiting strategy and selection process that fosters an environment of diversity and inclusion. This webinar focuses on identifying recruiting strategies that help to increase talent pools and employment interviewing that maximizes hiring success. 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
Comprehensive Accounting and Financial Reporting Update
12:00pm - 4:00pm
Online
4.00 Credits
Member Price: $149
See more dates
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.
More Dates
The Original Secure Act and Secure Act 2.0 Retirement Planning Strategies
12:00pm - 4:00pm
Online
4.00 Credits
Member Price: $129
See more dates
Congress was EXTREMELY busy. There are over 50 tax-related provisions within SECURE 2.0 which an advisor needs to be able to master. This course will provide the participants with everything that they need to know about SECURE 2.0 so that they will be able to better serve their clients’ retirement planning needs. **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 it to kori.herrera@acpen.com.
More Dates
Navigating IRS Collections: The Collection Process
12:30pm - 2:30pm
Online
2.00 Credits
Member Price: $89
See more dates
This course is designed for tax professionals seeking to understand and navigate the IRS collection process effectively. Participants will gain indepth knowledge of the various collection methods employed by the IRS, including liens, levies and wage garnishments. Additionall, participants will leand strategies to avoid or halt collection actions and the implications of the statute of limitations on tax collection. 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
K2's Office Scripts - The New Macros
1:00pm - 2:49pm
Online
2.00 Credits
Member Price: $79
See more dates
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.
More Dates
Taking a Global View of Professional Ethics
1:00pm - 2:50pm
Online
2.00 Credits
Member Price: $79
See more dates
Just as there is some convergence of U.S. accounting standards (GAAP) with international standards (IFRS), a convergence of U.S. professional ethics standards (AICPA Code of Professional Conduct) with the international Code of Ethics for Professional Accountants is continuing to emerge. This workshop compares these two sets of ethics standards, emphasizing both the theoretical aspects and practical implications for today's accounting professionals.
More Dates
Bytes, Bias, and Balance: Data Ethics for Tech-Savvy Accountants
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $79
See more dates
This course explores the transformative role of artificial intelligence (AI) in accounting and auditing, highlighting its vast potential while addressing the associated risks and ethical considerations. Participants will discover how to harness AI tools to enhance efficiency and innovation, while mitigating challenges such as overreliance, data security vulnerabilities, and ethical dilemmas. Through case studies and interactive discussions, you'll gain practical skills to navigate AI complexities, ensure trustworthy outputs, and uphold ethical standards in today's fast-paced digital environment.
More Dates
Determining Reasonable Compensation for Owner Employees
1:00pm - 3:00pm
Online
1.00 Credits
Member Price: $55
See more dates
This session will expand on methodologies to employ when owner-employee compensation is at issue. The session will focus on determinations of reasonable replacement compensation for individuals who both provide services to a closely held business or professional practice and also have an ownership stake in the enterprise. Executive Compensation in the form of options and restricted stock will also be covered in the context of marital dissolution proceedings. 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
Leadershift Ethics: Things Must Change!
1:30pm - 3:30pm
Online
2.00 Credits
Member Price: $89
See more dates
With the rapid pace of change, change now happens daily in business and our personal lives. It can be difficult to navigate change when right and wrong get a bit fuzzy. New processes, new technology, new circumstances and new impacts to people must be measured and decisions made as the change evolves. Change always becomes something different than what was originally planned or imagined. In this session, learn how to measure your ethics through change. You will learn how to filter everything you do during change through a simple litmus test. Through the power of story, you will learn from the lessons of other organizations and their ethical mistakes. Lastly, you will take away what is required to manage yourself so that when ethical decisions arise, you have the mental capacity to manage through it well. 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
Excel for Accounting Professionals Session 8: Dynamic Headers, Mapping Tables and Error Check
1:30pm - 5:00pm
Online
3.50 Credits
Member Price: $175
See more dates
Relevant Excel methods for accounting experts In Excel, there are several opportunities to apply features, functions and methods to build a dynamic workbook. In this hands-on demonstration of several Excel skills, you'll review the following topics through engaging expert-led instruction: Dynamic headers Horizontal reports Mapping Tables Data Validation Excel error checking skill development Designed with time for you to work along with the facilitator, this webcast examines the importance of automating reporting workbooks in Excel. You will review various topics, including: Horizontal or crosstab reports Mapping tables and how they are the key to unlocking major efficiency gains. Data validation in digital reports Error Check *Session 8 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 other parts of the bundle. [Excel for Accounting Professionals Webcast Series] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-webcast-series-bundle) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Are Those Independent Contractors Really Independent Contractors?
2:00pm - 3:06pm
Online
1.00 Credits
Member Price: $39
See more dates
Various legal tests are used to evaluate whether a worker should be classified as an employee or an independent contractor. There is no uniform standard or bright-line rule for determining whether an individual is properly classified as an independent contractor. Instead, the inquiry is always fact-intensive, and the analysis can vary based what body is performing it, i.e. the Internal Revenue Service (“IRS”), Department of Labor (“DOL”), various state agencies, or the courts. This presentation will review the various tests and highlight some of the common, most important factors for consideration.
More Dates
Strategic Foresight
2:00pm - 3:10pm
Online
1.00 Credits
Member Price: $75
See more dates
In this FutureReady course, Tom Hood explains how Strategic Foresight is crucial to preparing your organization for a future of exponential change. First, he defines Strategic Foresight and shares different ways of applying it. Then, he demonstrates how to prepare for a future that you can't yet see. And finally, Tom covers different types of innovation and how to apply them to your career and organization.
More Dates
Form 7203 - How to Calculate Shareholder Basis
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $79
See more dates
Starting with tax year 2021, Form 7203, S Corporation Shareholder Stock and Debt Basis Limitation, may be required to accompany shareholders’ Individual Income Tax Returns (Form 1040). This form is essential for reporting a shareholder's outside basis and debt basis to properly apply loss limitations under I.R.C. §461 and at-risk limitations. This course will provide a detailed overview of Form 7203, including its mechanics and strategies for completing it accurately. Additionally, strategies for reconstructing shareholder basis when it has not been maintained in the past will be discussed, helping practitioners handle these scenarios effectively. *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 AI Fits into the Accounting World
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $89
See more dates
This session is designed as a primer to introduce artificial intelligence (AI) and to discuss how it will impact accountants as they work. The material will briefly explain what AI is and then focus on ways that it is already serving those in the accounting realm. It will close with a look at future AI-centric developments that will have great potential to positively impact the accounting profession. Those wishing to gain an understanding of what artificial intelligence is and how it will be used by accountants should consider attending this session. 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
Taxation of the Cannabis Industry
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $79
See more dates
This course provides a comprehensive analysis of the taxation issues affecting the cannabis industry. It covers the historical context of U.S. taxation, the distinctions between industrial hemp and marijuana, and the specific tax codes and regulations that apply to the cannabis business. Participants will gain insights into state marijuana laws, the unique challenges of a cash-intensive industry, and pertinent federal court cases. *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