Professional Development and Event Catalog
Excel for Accounting Professionals Session 2: Data Validation and Conditional Formatting
3:00pm - 5:00pm
Online
2.00 Credits
Member Price: $125
See more dates
Which Excel function is your go-to? This session invites you to actively engage and practice with the instructor, exploring exercises demonstrated. In doing so, you'll gain a firmer grasp of common Excel functionalities, including: Data validation Conditional formatting Enhanced summing options Skinny rows Achieving proficiency in Excel features Gaining proficiency in Excel means learning to design workbooks that are both functional and streamlined. The facilitator will lead you through an array of formatting skills, formula functions, and beyond as we expand upon foundational Excel knowledge with topics such as: Managing data input for individual cells Using conditional formatting to prevent errors Enhancing productivity via the Subtotal feature Ensuring total formulas refresh automatically *Session 2 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 3: Workbook Design Principles and Organization] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-3--workbook-design-principles-and-organization) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
The Ethic of Teamwork
3:00pm - 5:00pm
Online
2.00 Credits
Member Price: $89
See more dates
"No one cares how much you know until they know how much you care." To be a part of a team, a team that truly cares for its people, is to be granted an opportunity for growth and inclusion and a sense of belonging. It doesn't get better than that! This ethics-based webinar examines the essence of what constitutes teams that are high functioning and highly collaborative. One essential component is the balance between content (getting the job done!) and process (how we get things done...how we treat each other). This webinar will offer concrete practical suggestions for teams both for content and process effectiveness. It will also offer opportunities for self-reflection and actions to take to enhance team performance. 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
GPT Builder for Accountants
3:30pm - 5:30pm
Online
2.00 Credits
Member Price: $89
See more dates
This course provides a concise overview of using ChatGPT's GPT Builder to create custom GPTs specifically tailored for accounting professionals. Learn how to leverage this powerful tool to streamline accounting workflows, enhance client services, automate routine tasks, and improve financial analysis capabilities through customized AI solutions designed for accounting-specific applications. custom versions of ChatGPT with added skills and knowledge for specific tasks or industries. This course is designed to guide accountants on how to leverage these enhanced ChatGPT functionalities to streamline financial workflows, analyze data, and engage in more dynamic, multi-modal interactions. 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 Best Word, Outlook, And PowerPoint Features
3:30pm - 7:07pm
Online
4.00 Credits
Member Price: $129
See more dates
Most professionals routinely use Word, Outlook, and PowerPoint, but many are self-taught and, as a result, have not been exposed to the best features of these three applications. Consequently, they often use “brute force,” inefficient means when working with these three components of Microsoft Office. If that describes you, ensure you carve time out of your schedule to participate in this fourhour session. In it, you will learn how to work much more efficiently when using these tools to get better results in less time.
More Dates
K2's Understanding Your Ransomware Risk
4:00pm - 4:57pm
Online
1.00 Credits
Member Price: $39
See more dates
Protecting yourself from ransomware requires more than just anti-virus software. Additional technology protections are necessary. Further, business continuity, legal and regulatory, and cybersecurity insurance considerations should all be a part of your risk abatement strategy. Attend this session to determine if your current level of ransomware protection reduces your risk to an acceptable and identify ways to ensure that you are protected.
More Dates
Planning in an Uncertain World
4:00pm - 6:00pm
Online
2.00 Credits
Member Price: $79
See more dates
We all make predictions in our personal and professional lives. We base our decisions to marry, buy a house, launch a new product or hire staff on expectations about the future. In the past few years, research into improving predictions has advanced. We will look at this research and current best practices in forecasting to help us prepare better budgets and projections.
More Dates
Taking Advantage of Array Formulas in Excel
4:00pm - 6:00pm
Online
2.00 Credits
Member Price: $89
See more dates
This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in 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
Accounting of the Soul: Making the World a Better Place
5:00pm - 6:00pm
Online
1.00 Credits
Member Price: $55
See more dates
This workshop explores how each of us can play a part in helping to make the world a more fair and gentler place. This one-hour webinar includes an overview of Aristotle's virtue ethics and its application to present day life. We will focus on the virtue of compassion both individually and organizationally and its impact on individual, organizational and world wellbeing. 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
Change Management: Your Leadership Role for Aligning Profits & Culture
9:00am - 10:46am
Online
2.00 Credits
Member Price: $79
See more dates
This is a dynamic course tailored for seasoned accountants who are looking to elevate their skills in navigating and leading through organizational change. This advanced program focuses on enhancing agility by providing the tools and techniques necessary to manage and adapt to rapid shifts in the accounting landscape. Participants will explore theoretical frameworks alongside practical strategies that support effective change management for diverse business environments.
More Dates
Clean, Transform and Load Data in Power BI
9:00am - 11:00am
Online
2.00 Credits
Member Price: $89
See more dates
This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. 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 Role of Internal Audit in Enterprise-Wide Risk Management
9:00am - 12:37pm
Online
4.00 Credits
Member Price: $129
See more dates
Those charged with governance, with the assistance of internal audit, are responsible for overseeing the strategic direction of the organization, and ensuring value is delivered to the entity's stakeholders. This course will provide guidance on fulfilling the responsibility for challenging how much risk and uncertainty to accept through the application of COSO's Enterprise Risk Management Framework.
More Dates
2024 Revision to Government Auditing Standards Impact
9:00am - 1:00pm
Online
4.00 Credits
Member Price: $149
See more dates
This course will provide an update of Government Auditing Standards as a result of the GAO's issuance of the 2024 Revision to Government Auditing Standards. The course will focus on the Revisions impact on financial statement audits. The course will also focus on the impact of Quality Management Standards as well as clarify as to when the concept of reporting key audit matters might apply for financial audits. 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
Tax Season Update for Individuals with Steve Dilley
9:00am - 1:00pm
Online
4.00 Credits
Member Price: $149
See more dates
This program provides an update to the latest tax developments, rules and regulations impacting individual taxpayers, with a review and integration of the numerous 2024/25 legislation. 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
How Changes in Business Methods Affects Internal Control
9:00am - 5:00pm
Online
8.00 Credits
Member Price: $239
See more dates
New Technology, the move toward telecommuting, the widespread adoption of electronic documentation, and a wide range of other factors have significantly and forever changed the way business is conducted. It should go without saying that changes in tools and methods lead to upheaval in any organizations internal control system. In this session, we look at all the changes that are occurring and discuss what's coming in the not too distant future. The material then looks at how internal controls have been affected and what other updates are on the horizon. Anyone trying to use controls to keep their organization efficient and secure should consider this session because the rate of change to both operational methods and control processes has been and will continue to be incredible. 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 Annual Accounting and Auditing Update
9:00am - 5:00pm
Online
8.00 Credits
Member Price: $299
See more dates
Designed as an all-you-need-to-know update for accounting, auditing, and attestation practitioners at all levels in public accounting and industry, this course provides a comprehensive review of recent standard-setting and rulemaking activities of the Financial Accounting Standards Board (FASB), American Institute of Certified Public Accountants (AICPA), Public Company Accounting Oversight Board (PCAOB), and Securities and Exchange Commission (SEC). On the financial accounting front, we will cover the FASB's Post-Implementation Review (PIR) report for revenue recognition under ASC 606 and discuss the best practices in applying the standard and identifying any ongoing issues practitioners are experiencing with applying the standard. We will also discuss the more than a dozen ASUs the FASB has issued since the beginning of 2023 and into 2025 covering crypto assets, disaggregated expenses, business combinations, and leases for entities under common control. Our focus on AICPA standards includes a detailed discussion of revamped AICPA quality management standards. The AICPA updated and modernized the standards by issuing Statement on Quality Management Standards 1, 2, and 3 (SQMS 1, SQMS 2, and SQMS 3, respectively), SSARS No. 26, and SAS 146, Quality Management for an Engagement Conducted in Accordance with Generally Accepted Auditing Standards (SAS 146). These standards, effective December 15, 2025, modernize quality management standards to reflect an increased focus on risk assessment, technology use, and the presence of outside experts on engagements. We will also cover new rules impacting public company audits and present case studies on recent fraudulent accounting stories and best practices for detecting and preventing such frauds. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.
More Dates
Surgent's Predicting Future Financial Issues Facing the Financial Executive
9:00am - 5:00pm
Online
8.00 Credits
Member Price: $279
See more dates
Our financial and economic series is designed to take key topics for financial executives and explore them in detail such that the CFO/controller/financial executive can take away useful and practical recommendations dealing with the topic at hand. The program explores the current economic trends and analyze their impact on you as the financial executive in areas professional skepticism, medical care costs, social security viability, the dollar as a world currency, the national infrastructure and the "fate of the states" as well as the AICPA's top 10 trends and technologies. Specific recommendations and insights will be offered to you to deal with the challenges.
More Dates
S Corporations: Calculating Shareholder Basis
9:30am - 11:30am
Online
2.00 Credits
Member Price: $89
See more dates
A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans. How to use the Form 1120S, Schedule K-1 information for basis determination. An illustrative example demonstrates how the process works, as well as the many potential pitfalls. 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 Role of Internal Audit in SOX Compliance
10:00am - 11:48am
Online
2.00 Credits
Member Price: $79
See more dates
The Sarbanes Oxley Act (SOX) continues to pose challenges with compliance. Companies must continue to evaluate whether they have designed and implemented an adequate system of internal controls over financial reporting (ICFR). This course will address the best practices that ensure an effective and efficient approach to SOX compliance.
More Dates
Hold Your Horses! Could Tighter Reins Have Prevented a Landmark Fraud?
10:00am - 11:49am
Online
2.00 Credits
Member Price: $79
See more dates
What can we learn from one of the largest municipal frauds in U.S. history? Rita Crundwell stole nearly $54 million from the citizens of Dixon, Illinois over the course of two decades. This course examines circumstances that allowed this landmark fraud to occur. We will explore internal control deficiencies and other circumstances that hindered prevention or timely detection of Rita's scheme.
More Dates
S Corporations - Overview
10:00am - 12: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