CPE + Events Catalog
Excel for Accounting Professionals Session 8: Dynamic Headers, Mapping Tables and Error Check (3.5 hours)
-
Online
3.5 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
Strategic Foresight (1 hour)
-
Online
1.0 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 hours)
-
Online
2.0 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 hours)
-
Online
2.0 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
Surgent's Navigating AI Compliance: The EU AI Act for U.S. Finance and Accounting Leaders (2 hours)
-
Online
2.0 Credits
Member Price: $119
See more dates
This course provides U.S.-based accounting and finance professionals with an in-depth understanding of the EU Artificial Intelligence (AI) Act, the first comprehensive AI regulation in the world. It explores the Act's key provisions, including its risk classification framework, compliance requirements for high-risk systems, and transparency obligations. Participants will gain insight into how the Act affects organizations operating internationally and how to prepare for compliance challenges. Interactive activities are integrated throughout the course to reinforce key concepts.
More Dates
Taxation of the Cannabis Industry (2 hours)
-
Online
2.0 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
More Dates
Create Measures in Power BI that Define Your Metrics (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
Unlock the full potential of your data with our specialized course, "Create Measures in Power BI that Define Your Metrics". Designed for professionals who aspire to excel in the dynamic world of data analysis, this 4-hour intensive training delves deep into the advanced functionalities of Microsoft Power BI. You'll embark on a journey to master the art of Data Analysis Expressions (DAX), a powerful tool in the Power BI suite to create metrics. This course is meticulously crafted to transform you into a proficient user, capable of harnessing complex DAX calculations to bring your data to life. The course content is thoughtfully structured to ensure a comprehensive learning experience. Starting with the foundational elements of DAX, you'll rapidly progress to tackle advanced formulas and time-intelligent functions, essential for nuanced data analysis. The highlight of the course is the emphasis on the DAX calculation process, a crucial aspect for validating measures in Power BI. Additionally, the practical application of PivotTables for measure validation will equip you with the skills to confirm the accuracy and effectiveness of your data measures. These advanced techniques are not just theoretical concepts but are presented through engaging, real-world scenarios, enabling you to apply your learning immediately to your daily tasks. This course is an invaluable step towards mastering Power BI and making data-driven decisions with confidence. 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
Exploring the New Lease Accounting Standard (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
It's a whole new world for lessees under ASC topic 842. This program will dive into the new standard on leases and its impact on every size entity, review effective dates, and address what you need to know now. 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
Internal Controls for Small and Medium-Sized Entities (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
This session explores the importance of internal controls with an emphasis on best practices for small- and medium-sized entities. We will examine the roles of both preventive and detective controls and practical, cost-effective suggestions for implementing effective internal controls will be addressed.
More Dates
The Controller Function - Elevating the Role (1.5 hours)
-
Online
1.5 Credits
Member Price: $59
See more dates
This is the beginning of a series that will cover major aspects of the Controllership function. Controllers are essential to the day-to-day accounting for organizations. Yet, the role is not often readily understood. In today’s world of acronyms such as CFO, CEO, COO, CAO, etc., the Controller function may get lost in the shuffle. However, they are a critical group of professionals who ensure the adequacy and transparency of accounting and financial reporting information. A Controller is an individual who has responsibility for all accounting-related activities including high-level accounting, managerial counting, and finance activities within a company. The duties of a Controller include assisting with the preparation of the operating budgets, overseeing financial reporting, and performing essential duties relating to payroll. However, in today’s evolving world, the Controller function can provide much more in-depth value to their organizations. This series is dedicated to exploring the traditional Controller role and stepping out of the box to identify areas where the Controller can add strategic value to their organizations. In this first course we focus on the typical Controller function and begin to identify ways to elevate the function.
More Dates
IRS Cybersecurity Checklist (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
This course is designed to provide learners with an understanding of the Internal Revenue Service (IRS) Cybersecurity Checklist and how it can be used to protect taxpayer data. The course will cover the basics of cybersecurity, including threats, risks, and vulnerabilities. Learners will be introduced to the IRS Cybersecurity Checklist, which provides a framework for organizations to assess and enhance their cybersecurity practices. The course will cover the various elements of the IRS Cybersecurity Checklist, including access control, data protection, and employee training. Learners will gain an understanding of the importance of each element and how it contributes to the overall security of taxpayer data. The course will also cover best practices for implementing each element of the IRS Cybersecurity Checklist. Throughout the course, learners will be presented with real-world examples of cybersecurity threats and breaches, highlighting the importance of effective cybersecurity practices. Learners will also be given practical exercises and assessments to reinforce their understanding of the IRS Cybersecurity Checklist. *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
ChatGPT and Advanced Accounting Research (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a concise overview of how artificial intelligence, particularly ChatGPT and other AI tools, is transforming accounting research methodologies and practices. Students will explore the shift from traditional search engine-based research to AI-driven insights, learning how to leverage various AI platforms for enhanced financial analysis, regulatory compliance, and strategic decision-making. The course emphasizes practical applications of AI in accounting contexts while addressing critical considerations such as data verification, ethical usage, and professional judgment. 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
Navigating IRS Authorizations: Understanding Power of Attorney, Form 2848, and Form 8821 (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
This two-hour course provides a comprehensive overview of the IRS collection process, guiding tax professionals through each stage, from the initial notice to enforced collection actions. Participants will gain insights into taxpayer expectations during the collection process, as well as strategies for resolving tax debts. The course highlights when to use Form 433-A or 433-B, the documentation needed, and the criteria for submitting an Offer in Compromise (OIC) to settle tax debts for less than the full amount owed. Attendees will also learn about the various payment options available and practical approaches to advising clients. *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
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
Lessons on Fraud Prevention from Sam Bankman-Fried's Crypto (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This course chronicles the decisions that led to the arrest of Sam Bankman-Fried (SBF), and helps participants understand the consequences that will follow for people charged with business-related crimes. Authorities arrested SBF pursuant to a grand jury indictment that charged him with wire fraud, securities fraud, money laundering, and related conspiracy charges. This lesson chronicles how the former billionaire's business decisions exposed him to criminal charges that include potential penalties of more than 100 years in federal prison for his alleged role in defrauding investors who trusted in his ability to make ethical decisions. Participants will learn about the criminal justice process, including indictments, arrest, extradition, judicial proceedings, mitigation, sentencing, prison, and collateral consequences. 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
Employment Law 101 (1 hour)
-
Online
1.0 Credits
Member Price: $39
See more dates
Review of the major employment laws governing the workplace, when they are triggered, and key compliance aspects under each law. This presentation is designed to give viewers enough information to issue spot when matters arise in the workplace.
More Dates
Self-Rental Real Estate: Passive Activity & Section 199A (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This program presents a detailed analysis of the self-rental passive activity rules, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. 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
Tech It to the Next Level: Slim Your Team for Max Efficiency (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $55
See more dates
Ready to slim down your team and maximize efficiency without sacrificing quality? This session breaks down how to leverage tech and automation to fill workflow gaps, build a strong tech stack, and connect tools seamlessly. Learn how one proven tech stack replaced more than half a traditional team while improving client satisfaction and reducing overhead. Walk away with practical steps to streamline operations, automate repetitive tasks, and focus your resources on what really matters. Attendees will gain practical insights into streamlining operations, automating repetitive tasks, and focusing resources on high-value activities. The session also includes an exclusive look at a proven tech stack used to replace over half a traditional team, offering actionable steps to create a leaner, tech-driven, scalable firm. Perfect for firm owners ready to rethink staffing, reduce overhead, and embrace the future of accounting efficiency. 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 Controller Function - Strategic and Annual Planning (1.2 hours)
-
Online
1.2 Credits
Member Price: $39
See more dates
This course corresponds to our Controllership series. Within this course, we specifically address the Controllers role and pro-active potentials in organization Strategic and Annual Planning. This series of courses is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the Controller can add strategic value to their organizations. Controllers are essential to the day-to-day accounting for organizations. Yet, the role is not often readily understood. In today’s world of acronyms such as CFO, CEO, COO, CAO, etc. the Controller function may get lost in the shuffle. However, they are a critical group of professionals who ensure the adequacy and transparency of accounting and financial reporting information. When it comes to the task of strategic planning, many feel this role is primarily the responsibility of the executive team and board. However, in this course, we delve into the various steps of the strategic plan and explore where the Controller can add strategic value through providing functional input and insight. Strategic planning is a process used to identify goals, the strategies necessary to accomplish those goals, and the internal performance management system that will be used to monitor and evaluate progress.
More Dates
Navigating IRS Collections: Overview of Form 433 & OIC (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course highlights when to use Form 433-A or 433-B, along with documents needed to effectively submit an Offer in Compromise (OIC) or Installments Agreement. Settling tax debts is an important part of the IRS collection process, this course helps guide taxpayer representatives through the process so they may efficiently complete these necessary forms. 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
