Professional Development and Event Catalog
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
GASB 96 -SBITA, GASB 94 P3, and GASB 87 Leases (Year 2)
2:00pm - 3:46pm
Online
2.00 Credits
Member Price: $79


See more dates
This is a 2 hour webcast that will focus on the similarities between all three of these GASB accounting standards that deal with contractual arrangements such as leases, Subscription-Based Information Technology Arrangements (SBITA) and P3s. Compare and contrast these standards as you prepare for implementation this year of GASB 94 and GASB 96, and review the implementation efforts of Leases in Year 2.
More Dates
Drive Results with Metrics
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $79


See more dates
Many organizations struggle to keep budgets current in an ever-changing business climate. Twenty-first century performance metrics focus on determining what budgets should be rather than what they were in the past. Using performance metrics effectively reduces work, reduces politics, provides flexibility and substantially improves the performance management process. This session will show you powerful techniques to drive your organization’s performance.
More Dates
Mastering Partnership Basis: Inside and Outside Basis
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $89


See more dates
This course will provide a detailed analysis of how to determine a partner's tax basis for a partnership interest, with an explanation of the use of both "inside" and "outside" basis determination. An illustrated example with filled in forms will demonstrate how the process works and the 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
Mission-Critical Leadership: How Smart Managers Lead Well in All Directions
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $79


See more dates
Most leadership development focuses on a single direction within the organizational hierarchy: downstream to subordinates. While it is important to be a good boss, leadership is much more than that. The best leaders learn to lead well in all directions. They lead upward to superiors and across among peers throughout the organization. And it all starts with self-leadership. This often overlooked or misunderstood leadership principle is essential to build a thriving and productive culture. This topic is based on Jon’s book, Mission-Critical Leadership: How Smart Managers Lead Well in All Directions.
More Dates
How Fraud Can Affect Smaller Organizations
2:00pm - 6:00pm
Online
4.00 Credits
Member Price: $149


See more dates
Many small to medium sized companies do not properly address the risk that arises related to fraud because these organizations do not have the resources needed to mitigate this risk or because owners or those in top level management underestimate the scope of the issue. All organizations, regardless of size, must be aware of the risks associated with intentional fraudulent acts and know that a significant and effective fraud scheme could even create going concern issues for some entities. In this session, we delve into the reasons that fraud takes place. The material discusses the types of defalcations that are often executed against smaller entities and then explores measures that organizations can implement to help stop fraud activities and add security. 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
Creating an Ethical Work Environment
2:30pm - 4:30pm
Online
2.00 Credits
Member Price: $89


See more dates
This session introduces theories on human nature and organizational factors affecting ethical choices. Robbie examines the role of gossip in the workplace, provides tools for ethical decision making and offers concrete actions for creating and sustaining an ethical work environment. 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 OneDrive's Best Practices
3:00pm - 3:56pm
Online
1.00 Credits
Member Price: $39

See more dates
Although Windows incorporates the OneDrive app, you may not have configured it correctly for your specific needs. Using the OneDrive app and the related Cloud storage service to their fullest potential means you can access your files when and where you need them. Further, sharing your files and collaborating with others is easy when using OneDrive correctly. In this session, you will learn best practices for taking full advantage of OneDrive.
More Dates
Topic 842: FASB's Lease Accounting Standard Update
3:00pm - 4:54pm
Online
2.00 Credits
Member Price: $79


See more dates
It's a whole new world for lessees under ASC topic 842. Soon nearly all leases will need to be disclosed as a liability on the balance sheet - from buildings right down to autos and copiers. Although the greatest impact will be on large entities, this will affect the financial statements of small and mid-size entities as well. This program will dive into the new standard on leases, effective dates, and address what you need to know now.
More Dates
Improve Spreadsheets by Building Controls in Excel
3:00pm - 5:00pm
Online
2.00 Credits
Member Price: $89


See more dates
In today's data-driven world, spreadsheets serve as the backbone of business and personal productivity. However, creating complex and error-prone spreadsheets can lead to critical mistakes and inefficiencies. This course aims to equip you with the knowledge and tools to build robust spreadsheets, implementing a range of controls and safeguards to ensure data integrity, streamline processes, and maximize accuracy. 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
Federal Tax Update for Individuals with Doug Van Der Aa
3:00pm - 7:00pm
Online
4.00 Credits
Member Price: $129


See more dates
This program will address recent legislation, rulings and developments affecting individual taxpayers and provide practitioners with a comprehensive update for the upcoming tax season. **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 Build a Custom AI Chatbot and GPT in Plain English
3:30pm - 5:30pm
Online
2.00 Credits
Member Price: $89


See more dates
Participants will learn to create customized AI chatbots that can enhance client interaction and internal operations-all without coding experience. This course provides a concise overview of specialized, task-oriented AI chatbots and GPT builders, focusing on how these technologies are revolutionizing professional workflows. Through hands-on exploration of platforms like AgentGPT, Claude Projects, Gemini Gems, and NotebookLM, participants will learn to design, deploy, and manage custom AI assistants tailored to their specific needs. The course emphasizes creating advanced AI apps that can understand context and solve complex problems autonomously. 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 to Audit Inventory
4:00pm - 6:00pm
Online
2.00 Credits
Member Price: $89


See more dates
Inventory observations are often a right of passage for audit staff. This course will cover the basics of auditing inventory, including the related audit assertions, risks, & threats to inventory. During this course, we will also highlight the various substantive auditing procedures that staff should perform, and also walk through how to conduct a physical inventory observation. 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 The Best Kept Secrets Of Microsoft 365
4:30pm - 6:16pm
Online
2.00 Credits
Member Price: $79


See more dates
Many organizations have implemented Microsoft 365/Office 365 at a basic level, but few have truly explored the breadth and depth of tools included with their subscriptions. Some less commonly known apps help you manage shared email boxes, create and use web forms, schedule appointments, trade shifts, create real-time closed captions, and translate presentations. Attend this session and learn more about the hidden features in Microsoft 365 that you can use to level up your productivity.
More Dates
K2's The ABCs of Automation With Microsoft's Power Platform
5:00pm - 6:45pm
Online
2.00 Credits
Member Price: $79


See more dates
Automation and standardization are two of the keys to productivity, but most people who are not programmers are unsure where to start. Microsoft’s Power Platform is a comprehensive platform for creating automated workflows, integrations, and data-driven reports. Components include Power BI, Power Apps, Power Automate, Power Pages, and Power Virtual Agents. Attend this session to learn about this platform and how everyone can use its low-code, no-code environment to solve process challenges.
More Dates
SAS 145: Modern Risk-Based Auditing
9:00am - 10:48am
Online
2.00 Credits
Member Price: $79


See more dates
This program provides in-depth coverage of SAS 145, a major standard that helps auditors enhance risk assessment procedures through improved techniques for identifying and assessing risks of material misstatement. This session is essential for CPAs that perform audits. The discussion will also be insightful for auditees and other professionals who want to maintain awareness of current auditing guidance.
More Dates
CPAs and Addictions: Finding Hope and Healing
9:00am - 11:00am
Online
2.00 Credits
Member Price: $79


See more dates
Substance abuse and mental health issues among CPAs has become of great concern among many state boards and the AICPA in recent years. This program will cover the factors that push CPAs to unhealthy behaviors, the prevalence of drug and alcohol abuse, and possible options in addressing the situation. We will also discuss steps that friends and family can take to support their struggling CPA find hope and healing.
More Dates
Understanding the New Forms K-2 and K-3
9:00am - 11:00am
Online
2.00 Credits
Member Price: $89


See more dates
Schedules K-2 and K-3 are promulgated by the IRS in order to standardize the reporting of foreign-related tax information for pass-through entities. Even pass-through entities that have no foreign activities, investments, or partners may have a reporting requirement. Schedules K-2 and K-3 for reporting partners' income, deductions, and credits from foreign activity are now required for passthrough returns (Form 1065, 1120-S and 8858). This requirement starts with returns with a tax year that ends in 2021. This course discusses each part of these schedules and explain these new reporting obligations in detail. 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
Avoiding Peer Review Deficiencies and Professional Liability in Public Accounting
9:00am - 1:00pm
Online
4.00 Credits
Member Price: $129


See more dates
Peer review deficiencies and professional liability claims result from both audit and nonaudit services. This course will provide best practices for avoiding legal liability and quality control concerns for a wide variety of professional services offered by public accountants.
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.