CPE Catalog & Events
Taking Advantage of Array Formulas in Excel
-
Virtual
2.00 Credits
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
CFO Solutions to IRS Problems
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:The authority of IRS in assessing and collecting taxes.The common misconceptions when dealing with IRS.Common questionable actions by business owners.How to prepare for an IRS audit.The seven options in IRS collections.Possible criminal tax violations by CFOs and small business owners.
The Ethic of Teamwork
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Virtue ethicsTeam dynamicsCharacteristics of highly effective teamsMeeting managementTeam communicationDecision making
Implementing an AI-Enabled Marketing Strategy for Your Firm
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Module 1: Introduction to AI in Marketing The Basics of AI – Concepts and TerminologyModule 2: Leveraging AI Tools and Technologies Overview of AI Tools for MarketingModule 3: Practical Strategies for AI Integration Integrating AI into Your Marketing WorkflowModule 4: Measuring AI-Driven Marketing Effectiveness Key Metrics for Assessing AI-Driven CampaignsModule 5: Real-Life Case Studies and Success Stories Case Studies of Firms Successfully Using AI in MarketingModule 6: Developing Your AI-Enabled Marketing Strategy Creating a Custom AI Marketing Strategy
Introduction to Ethics & Professional Skepticism
-
Online
2.00 Credits
Code of Ethics for Professional Accountants Yellowbook Auditing
Ethical AI Practices for CPAs: Ensuring Responsible Use
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Understanding ethical implications of AIData privacy and security considerationsCompliance with regulations and professional standardsDeveloping ethical AI policies and procedures
Taxation of Property Transactions - Tax Staff Essentials
-
Virtual
4.00 Credits
Sections 1231, 1245, and 1250 Depreciation recapture Capital gains and losses Nonrecognition transactions
Guide Strategy, Attract Investments with Financial Forecasts
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Financial Statement ForecastingOverview of the importance and benefits of forecasting for strategic planning and investment attraction.The Forecasting Process: Steps to project future income, expenses, and resources using historical data and market trends.Analyzing Historical Data: Methods for leveraging past financial data to inform future projections.Incorporating Market Trends: How to integrate market insights into financial forecasts.Forecasting Profitability: Techniques for predicting future earnings and their implications for budgeting, cash flow management, and investment planning.Forecasting the Balance Sheet: Approaches for predicting future financial positions, including growth potential, solvency, and capital structure
Private Company Simplified GAAP Alternatives
-
Online
2.00 Credits
Guidance, related to "plain vanilla" interest rate swaps that convert variable into fixed rate debt and other derivatives Guidance related to amortization and impairment of goodwill Guidance related to separately recognizing intangible assets from goodwill in a business combination Guidance related to lease accounting and revenue recognition options
Upholding Independence While Holding Your Client's Hand
-
Online
2.00 Credits
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
Navigating IRS Collections: Overview of Form 433 & OIC
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Overview of the IRS collection process and enforcement actions.Initial notices, taxpayer rights, and IRS timelines.When to use Forms 433-A or 433-B and required documentation.Offer in Compromise (OIC): criteria, process, and practical considerations.Payment options: installment agreements, partial payment plans, and OIC.Advising clients on IRS collections and avoiding penalties.Compliance strategies for minimizing tax liabilities.Real-world scenarios and examples for tax debt resolution.
Surgent's Exploring Business Valuation Fundamentals
-
Virtual
2.00 Credits
What does value mean? Technical vs. fundamental analysis Intrinsic value Other discounted cash flow models Assumptions in the Gordon Growth Model Valuations using free cash flows Residual income model Enterprise value Value in mergers and acquisitions Small business valuations and discounts Advanced valuation models
The Role of Internal Control in the Risk-Based Audit
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Specific matters auditors should consider when obtaining and documenting an understanding of the client's internal control systemDevelopment of a tailored audit approach that considers the potential reliance on internal controlsGuidance for establishing an adequate basis for reliance on internal controls of less formal, smaller clients
Will Your Ethics Be Burned by Burnout?
-
Virtual
2.00 Credits
The major topics covered in this class include:Explore the effects of crisis and burnout on ethical decision-makingDefine the stressors, pressures, and biases that can lead good people to make less than optimal choicesDiscuss ways to offset the pressures, ways to reduce stress on ourselves and on our team, and ways to support our teamsLearn how to recognize when an individual or an organization is heading in the wrong direction and how to stop sliding down the slippery slope
A Fox in the Henhouse/Courthouse
-
Online
1.00 Credits
Internal Controls Fraud Prevention Fraud Investigation
Introduction to Forensic Accounting
-
Online
1.80 Credits
Forensic Accounting Accounting Auditing Finance
The 10 Must Know Excel Features
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.
Ethics: IRS Criminal Investigations: Key Lessons for Accountants
-
Virtual
2.00 Credits
Snapshot of IRS Criminal InvestigationsGeneral tax fraudAbusive tax schemesRefund fraudEmployment tax fraudIdentity theftData compromisesMoney launderingPublic corruptionCorporate fraudGeneral fraudsCyber crimesGlobal tax and economic crimesNarcotics, counter-terrorism and transnational organized crimeSelected Field Office Case Files from Across USNew EnglandMiddle AtlanticEast NorthCentralWest North CentralSouth AtlanticEast South Central West South CentralMountainPacificHow accountants can add value to their operations by aiding law enforcement and fighting economic crime
Leases Accounting under Topic 842 - Answers to FAQ After Implementation
-
Online
2.00 Credits
Alternatives to adopting Topic 842 Short-term lease and related-party leasing arrangements Identifying lease agreements under the new rules Proper treatment of lease incentives, leasehold improvements, and lease modifications
IRS Penalties and Abatements
-
Virtual
2.00 Credits
The major topics covered in this class include:Various types of penalties: Accuracy related, fraud, understatement of valuation, reporting requirement, failure to pay, and pay or deposit penaltiesRules on waiver of penalties and interestsVarious forms and procedures for requesting reliefFirst Time Abatement: Requirements and proceduresHow an individual taxpayer qualifies for Reasonable Cause abatementProcedures for requesting refund of paid penaltiesAvailable administrative options
