CPE Catalog & Events
Excel for Accounting Professionals Session 6: List Comparisons and Indenting
-
Online
2.00 Credits
Member Price: $125
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.*Delivery Method: Individual webcastCPE Credit: Specialized knowledgeProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by AICPA.
Inventory Observation - Cretaceous Conservatory Simulation
-
Online
3.00 Credits
Member Price: $99
Step into the heart of the Cretaceous Conservatory for an unforgettable inventory observation adventure! In this immersive simulation, you'll travel to a remote island where the inventory isn't just vast, it's alive. As an auditor responsible for ensuring accuracy in the company's dinosaur-development operations, you'll face wild risks, navigate complex inventory procedures, and confront the unexpected. Through hands-on scenarios, you'll learn to identify misstatements, evaluate unique inventory challenges, and apply standard observation techniques all while staying one step ahead of potential disaster. Can you survive the wilds of the Cretaceous and emerge as the ultimate inventory explorer, or will the risks prove too much to handle? Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: Basic
Surgent's Representing a Client in an IRS Audit
-
Online
3.00 Credits
Member Price: $149
Recent legislation in Congress has provided the IRS with substantially increased funding to bolster its human staff and purchase software that will allow the IRS to audit many more taxpayers in a more effective way. The IRS believes it can target the right kinds of taxpayers for audits so that it will not waste its time on audits that produce little, if any, revenue. The purpose of this program is to discuss the current state of IRS audits and the anticipated increases in the IRS's ability to audit wealthier taxpayers in an efficient way. The course will discuss the state of the IRS's current audits and where the IRS is headed with audits in the coming years. Tax practitioners should also be aware of the state of the IRS's efforts to target efficiencies so as to produce the most revenue.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Accounting Fraud 25-26
-
Online
8.00 Credits
Member Price: $329
Gain an understanding of the concept of fraud, the Fraud Triangle theory, fraud risk, fraud detection and prevention. Learn about best practices in fraud detection and fraud deterrence. This course includes real-world cases of fraud, how they were perpetrated, and how they were detected.Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Basic
Advanced Personal Financial Planning Update 25-26
-
Online
8.00 Credits
Member Price: $329
New personal financial planning strategies are emerging due to evolving personal goals in rough economic and legal environments. Drawn from recent publications and government directives, this course reviews the latest financial strategies and planning changes from the past year in insurance, investments, tax, estate and retirement, including Social Security and Medicare. Additionally, Randy covers estate and tax planning strategies that enable practitioners to better serve clients by allowing them to take advantage of new opportunities.Delivery Method: Individual webcastCPE Credit: FinanceProgram Level: Update
Not-for-Profit Organizations: Treasury Utilizing QuickBooks 25-26
-
Online
8.00 Credits
Member Price: $329
Not-for-profit organizations always need volunteers as treasurers or members of the financial oversight committee! CPAs are often asked to fulfill these roles. This course highlights the accounting needs of such organizations. Along with covering the status of the not-for-profit organizations, an update on recent ASC updates affecting nonprofit entities is covered. QuickBooks 2024 Desktop will be used to demonstrate how its tools provide more efficient and effective financial management for your not-for-profit entity. This course is geared toward hands-on, or future hands-on, treasurers of service clubs and similar not-for-profit organizations.Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Overview
Strategies for Guiding Clients Through Challenging Situations: Tax Insights
-
Online
8.00 Credits
Member Price: $225
In this comprehensive course, practitioners gain a deep understanding of strategic planning considerations and potential hurdles encountered when clients face difficult circumstances. Delving into an array of scenarios often classified as "challenging," the course offers tax insights. From divorce and personal bankruptcy to intricate personal relationship matters, participants will equip themselves to adeptly guide clients through these challenging scenarios by understanding the tax implications. **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. Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Basic
S Corporations: Calculating Shareholder Basis
-
Online
2.00 Credits
Member Price: $89
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.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Comprehensive Audit & SSARS Update
-
Online
4.00 Credits
Member Price: $149
This course covers recently issued standards from the AICPA Auditing Standards Board and AICPA Accounting and Review Services Committee including the new Quality Management Standards. The session will highlight projects in progress at the Public Company Accounting Oversight Board, and International Auditing and Assurance Standards Board. The course will also recap recent changes and present common peer review findings and best practices to improve practice quality. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: Accounting, AuditingProgram Level: OverviewThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Internal Controls Over Compliance vs Compliance
-
Online
1.00 Credits
Member Price: $39
Accurately identifying and testing controls over compliance is critical, yet it remains a common deficiency highlighted in peer reviews. This course offers a comprehensive overview of internal controls over compliance, with a focus on their application to Single Audits. Participants will learn how to effectively align internal controls with specific compliance requirements. Additionally, we will address one of the most frequent findings in audits of governmental entities receiving federal grants: the misidentification of controls and the confusion between compliance and control processes. This course will help clarify the distinction, equipping you with the tools to enhance audit quality and ensure compliance effectiveness. Delivery Method: Individual webcastCPE Credit: Accounting (governmental)Program Level: Basic
Learning to Teach "Tax" as a Second Language
-
Online
1.00 Credits
Member Price: $39
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. Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Intermediate
K2's Time To Advance Automation - Strategies And Tools For Efficiency
-
Online
2.00 Credits
Member Price: $79
Increasingly, automating business processes is a necessity. In this session, you will learn about real-world examples of automating business processes. Remember, the survival of your business might depend upon successful automation! Delivery Method: Individual webcastCPE Credit: Information technologyProgram Level: Intermediate
AI & Accounting in Construction
-
Online
2.00 Credits
Member Price: $89
This course provides a concise overview of how artificial intelligence (AI) is revolutionizing the construction industry and reshaping financial oversight, accounting practices, and regulatory compliance. From autonomous equipment to predictive risk analytics, construction firms are increasingly adopting AI to enhance safety, efficiency, and profitability. As this transformation unfolds, accountants and financial professionals must evolve their roles-leveraging AI for smarter budgeting, automated compliance, and real-time auditing. The course highlights the top 20 macro-level AI trends in construction and explores how accounting professionals can align financial systems with operational AI, uphold audit integrity, and prepare for emerging tax and compliance challenges. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: Information technologyProgram Level: OverviewThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Dashboard and Report Design Principles Using Excel
-
Online
4.00 Credits
Member Price: $129
Transform your data presentation skills with our comprehensive course on creating impactful dashboards and reports using Excel. This workshop is tailored for professionals who: Regularly produce or update dashboards and reports Struggle with confusing or overly complex reporting tools Seek to streamline varied reporting styles across their organization Aim to establish a consistent, replicable "house style" for reporting Want to impress stakeholders with clear, user-friendly data presentations Through a combination of theory and hands-on practice, you'll learn the fundamental principles that make reports and dashboards easy to understand. We'll distill these concepts into a set of practical rules and guide you through their application in Excel. Delivery Method: Individual webcastCPE Credit: Personal developmentProgram Level: Basic
K2's Excel Essentials For Staff Accountants
-
Online
8.00 Credits
Member Price: $225
Staff accountants have specific needs when working with Excel – needs that are often not met by their existing Excel knowledge. Chief among these are the needs to quickly summarize data, prepare accurate and aesthetically pleasing reports, and create accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills they need to maximize their efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a “laptop-friendly” environment, and participants will have access to all the demonstration files used in the session. In sum, this seminar is a “must” for all staff accountants seeking to improve their efficiency and accuracy when working with Excel. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Intermediate
Fraud Busters: Controls to Prevent & Detect Fraud
-
Online
2.00 Credits
Member Price: $89
This course investigates actual real-world fraud schemes and discusses what controls could have prevented the fraud from occurring, and what controls could detect and curtail the fraud scheme. The instructor speaks from experience, finding multiple frauds very early in her career leading to a career-long focus on fraud prevention and detection. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: Auditing, AccountingProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
K2's Harnessing ChatGPT - Unlocking Professional Efficiency
-
Online
1.00 Credits
Member Price: $39
Enhance your productivity and streamline your accounting practices with ideas learned in this course. This dynamic program, designed specifically for accountants seeking a competitive edge, delves into the practical applications of ChatGPT in your daily workflow. From conducting comprehensive research and crafting compelling correspondence to swiftly addressing technical inquiries and optimizing Excel formulas, you will gain invaluable skills to expedite your tasks and improve overall efficiency. Furthermore, we will delve into the power of ChatGPT plugins, equipping you with the knowledge to process PDF documents seamlessly and efficiently navigate the vast expanse of the web. Join us on this transformative journey and unlock your potential as a proficient and empowered accountant. Delivery Method: Individual webcastCPE Credit: Information technologyProgram Level: Basic
Professional Skepticism for the Public Accountant
-
Online
1.00 Credits
Member Price: $39
Accountants are expected to demonstrate a questioning mindset. While such professional skepticism is an obvious requirement for assurance engagements, it is applicable elsewhere in the practice of public accounting. In fact, a skeptical mindset offers benefits to both public accountants and those who work in industry. This course provides specific examples of professional skepticism while suggesting best practices. Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: Basic
The Controllers Role in Data Analytics and Big Data
-
Online
1.50 Credits
Member Price: $59
Today’s economy and all of the digital enhancements have impacted the way companies engage with their customers as well as how the company manages their internal practices. The business control function needs to keep pace. The rising importance of analytical capability is critical when defining the role of the modern controller. Execution of analytics can vary but there are still key questions that must be asked. What are the options and what we need to understand to decide the best way forward? This course focuses on the value that can be brought by the Controller when becoming involved with data analytics powered by technology and also Big Data. The digitized world we live in has made it important for the Controller function to evolve and take on this advanced task. Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: Basic
ChatGPT and Advanced Policy Manual Development for ACCTs
-
Online
2.00 Credits
Member Price: $89
This course provides a concise overview of how to leverage ChatGPT and other AI tools to develop comprehensive, efficient, and compliant policy manuals for accounting firms. The revolutionary PRIME Method (Policy Refinement and Integration through AI-Managed Elaboration) empowers accounting professionals to create sophisticated policy documentation while maintaining human oversight and expertise. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: Information technologyProgram Level: OverviewThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.