CPE Catalog & Events
Taking Advantage of Array Formulas in Excel
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Introduction to Array Formulas: This segment establishes the foundation by differentiating array formulas from regular Excel formulas and explaining their significance.Using Array Formulas: This section focuses on the practical application of array formulas, teaching participants how to effectively implement and utilize these formulas in a variety of common Excel tasks and scenarios.Dynamic Arrays and Spill Functions: This part covers the utilization of dynamic arrays and spill functions, highlighting their role in modern Excel data handling.Advanced Array Functions: Participants will delve into complex functions such as SUMPRODUCT, UNIQUE, SORT, and FILTER, focusing on multi-condition summing and data management.Using Array Constants: This section teaches how simplify the use of static values called Array Constants
SSARS Practice Issues and Standards Update 25-26
-
Webinar
4.00 Credits
Member Price: $175
Review of applicable SSARS standards, including standards updates Review of AICPA professional ethics requirements In-depth discussion of non-attest services Review of independence issues for SSARS services Overview of SSARS #21 performance, documentation and other requirements Detailed analysis of preparation vs. compilation engagements Detailed analysis of review engagements
Advanced Cybersecurity - Beyond the Basics
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:Understanding Cyber Threats and Risks in FinanceCybersecurity Frameworks and Best Practices for Financial ProfessionalsFinancial Data Security and Encryption TechniquesCybersecurity Auditing and Forensic InvestigationsEmerging Technologies and Trends in Financial CybersecurityLeadership and Governance in Cybersecurity for Financial Executives
Leading and Managing the Accounting Department
-
Webinar
4.00 Credits
Member Price: $129
Accounting Leadership Management
Behind the Curtain: Exploring IRS Audit Technique Guides
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of ATGsBest practices for utilizing ATGsSalient provisions of selected ATGsInsights auditors may obtain from analytical proceduresNuances associated with selected industries
Emotional Intelligence for Professionals: Mastering the Human Side of Success
-
Webinar
1.00 Credits
Member Price: $39
Emotions Relationships Emotional Intelligence Communication
Upholding Independence While Holding Your Client's Hand
-
Webinar
2.00 Credits
Member Price: $79
Circumstances that may cause recent FASB pronouncements to introduce threats to independence AICP's Code of Professional Conduct Best practice tips and practical strategies for preserving independence when assisting clients with technical matters
Tax Procedure
-
Webinar
2.00 Credits
Member Price: $79
Filing a tax return IRS audit RS Appeals Collections and litigation at courts of original jurisdiction
The ABCs of Advisory Services
-
Webinar
2.00 Credits
Member Price: $79
Understanding the concept of “Integrated Planning” (financial, estate, asset protection, and tax planning) Changes in the landscape of a tax practitioner’s practice The bridging of services Getting started – Where do your clients fail? Understanding the primary planning issues for all clients Estate and Gift issues Traps, pitfalls, and tips in planning Practical steps in establishing a tax advisory and wealth management services practice Domicile issues
Effectively Responding to IRS Letters
-
Webinar
2.00 Credits
Member Price: $79
Types of IRS letters: General notices, audits, collections, return requests, and errors Deadlines for responding to IRS correspondence Communication best practices for dealing with the IRS Avoiding escalation and penalties through proactive responses Ensuring compliance when addressing IRS correspondence Real-world examples of successful IRS communications Common pitfalls in handling IRS letters and how to avoid them
Exercise Your Ethics: Techniques to Improve Ethical Response
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Explore research for common answers to "what does ethics mean to you?" and examine whether those are valid.Identify common ethical barriers - reflecting the latest from the ACFE Report to the Nations.Discover ways to improve ethical response.Practice, using practical advice from leading thinkers in ethics.
S Corporations - Overview
-
Webinar
2.00 Credits
Member Price: $79
Overview of S Corporation election and compliance requirements Comparison of S Corporations with other business entities Preparing Form 2553 and addressing late filing relief Shareholder stock and debt basis considerations Form 1120S and Schedule K-1: key aspects and reporting requirements Officer reasonable compensation requirements and IRS audit strategies Introduction to Schedules K-2 and K-3 Compliance with corporate formalities and taxable fringe benefits
Everything You Need to Know About the Pass-Through Entity Rules: IRC 199A The Code and Regulations
-
Webinar
4.00 Credits
Member Price: $129
Understanding the term “QBI” (qualified business income) Understanding the terms “SSTB” (specified service trade or business) Understanding the term “QTB” (qualified traded or business) Calculate the 199A deduction Understanding the phaseouts Understanding “aggregation” Rental property as a trade or business Identify how your clients can maximize the deduction Planning ideas Understand the Section 199A Regulations
Data & Predictive Analytics & Business Intelligence for Controllers/CFOs
-
Webinar
1.00 Credits
Member Price: $129
DA and BI relationship to accountant value. Current trends in BI and DA, including the emergence of AI tools like ChatGPT. The changing accountant roles: data analyst, data scientist, and data storyteller, with an emphasis on how ChatGPT can be utilized in these capacities. Obtaining datasets to compare and contrast with their organization's data, and how ChatGPT can assist in analyzing and interpreting this data. BI tools and the inclusion of AI technologies such as ChatGPT to streamline processes and improve analytical capabilities.
Comprehensive Audit & SSARS Update
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:AICPA Accounting and Review Services Committee standards update and new practice aidAICPA Auditing Standards Board standards update including recent changes to the audit and attestation standardsAICPA’s new Quality Management Standards - Overview, implementation considerations, timeline, and AICPA implementation resourcesPCAOB, IAASB standard-setting agenda and potential future AICPA ASB standards changesUpdate on AICPA’s Enhancing Audit Quality InitiativeTrends in audit quality including the DOL’s audit quality studyFrequent peer review findings and practice tips for achieving high practice qualityLatest on the DOL’s audit quality study
Generative AI Strategy for Accountants
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Evolution and current state of AI technologies in accountingDevelopment of comprehensive AI usage policies and guidelinesImplementation frameworks for integrating AI into accounting workflowsStrategic approaches to AI-driven process automation and optimizationMethods for identifying and capitalizing on AI opportunitiesBest practices for human-AI collaboration in accountingRisk management and ethical considerations for AI implementation
Ethical Considerations in Working with Cannabis
-
Webinar
1.00 Credits
Member Price: $55
The major topics covered in this class include:Framework for assessing the propriety of offering services within the state legal, regulated cannabis industryAssist in identifying key stakeholders to be considered in conjunction to providing cannabis industry services, including:partnersstaffclientsBanking relationshipsMalpractice insurance
Resistance to Resiliency: Striving for Technology Change Acceptance
-
Webinar
1.00 Credits
Member Price: $39
Yellowbook Accounting and Auditing Strategic Alignment Model
Preparing to be a Forensic Accountant - Cloud Forensics
-
Webinar
1.40 Credits
Member Price: $59
Forensic Accounting Accounting Auditing Finance
The Controllership Series - The Controllers Role in Financial Forecasting
-
Webinar
1.50 Credits
Member Price: $59
Accounting Finance