CPE Catalog & Events
Mastering the Excel Lookup Functions
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:A review of the various lookup functions, beyond VLOOKUPLearn which lookup works best for your situationHow to apply the many lookup functionsDiscover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectivelyAn in-depth review of the following functions:VLOOKUP / HLOOKUPXLOOKUPMATCH / INDEXXMATCHINDIRECTFILTERSORT / SORTBYUNIQUEAn overview of some newer functions
Exercise Your Ethics: Techniques to Improve Ethical Response
-
Virtual
2.00 Credits
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.
Profiles in Fraud
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Real life fraudsters: what they did, how they got away with it, how they finally were caughtProfiles: the characteristics the fraud perpetrators have in commonTechniques to prevent and deter these common schemes
ACPEN: Eliminating Busy Season: Transforming Your Practice to Year- Round Advisory Services
-
Online
2.00 Credits
Limitations of the traditional busy season model Building a year-round advisory practice Transitioning existing clients Attracting higher-value clients Integrating tax, financial, and estate planning Workflow restructuring and operations Pricing and value communication Implementation challenges
Self-Rental Real Estate: Passive Activity & Section 199A
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Definition of self-rental property - both for Sections 199A and 469Self-rental income from directly owned properties and reporting on Form 1040, Schedule E, page 1Self-rental income from indirectly owned (partnerships, S corporations) and reporting on Form 1040, Schedule E, page 2Form 8582 (passive activity)The flow-through entity grouping electionIllustrative examples and consequences of failing to comply with the reporting standardsSelf-rental property and "former passive activities" rules
Workforce Transformation and Talent Management in 2025
-
Virtual
1.00 Credits
To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: Understanding why the traditional pyramid structure is failing firms The inverted pentagon framework and its talent retention advantages Impact of technology and AI on entry-level accounting roles The 6 Ps of Business Model Transformation implementation Accelerating specialized skills acquisition in your workforce Effective knowledge transfer through mentorship and job rotation Technology-driven training and development strategies Best practices from other industries for workforce transformation Building and retaining specialized middle layers of expertise Strategic pricing models to support the pentagon structure
ACPEN: Group Audits: Who is Responsible for What?
-
Online
2.00 Credits
Responsibilities of the group audit engagement team, including the group engagement partner Clarifying roles and responsibilities of component auditors and reference auditors in audits of group financial statements Special considerations on audit planning and audit reporting in a group audit
Public Procurement Basics: Protecting the People's Money
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Guidelines and requirements that will help lead you to public procurement success.Guidance on how governments can meet complicated procurement needs.Best practices to protect public and Federal funds.
Surgent's Introduction to Charitable Gifting for Individual Taxpayers
-
Virtual
2.00 Credits
Fundamentals of charitable gifting Income and estate tax considerations for charitable giving Charitable deduction rules and limitations Structuring charitable contributions for maximum tax efficiency Advanced charitable gifting techniques Compliance and documentation requirements
Surgent's More Money at the End of the Month: Strategic Ways to Improve Cash Flow
-
Virtual
2.00 Credits
How to optimize cash flow Qualitative evaluations: core earnings and sustainable growth Quantitative evaluations: liquidity ratios Increasing customer base vs. payment terms Business cycle and cash Behavioral finance biases Managing head count Other potential areas of excess cost
Surgent's Starting a Small Business: What Every Trusted Advisor and Entrepreneur Needs To Know
-
Virtual
0.00 Credits
Understanding the time commitment required to start and run a business Selecting a corporate structure to protect your personal assets Building your product or service Sales and marketing in your business Establishing your owners, investors, managers, and employees Accounting, recording-keeping, and other software programs Leases, contracts, and employee agreements Protecting intellectual property Insurance Business plans Financing Market position
Surgent's Integrated Planning, Forecasting, and Budgeting for Organizational Success
-
Virtual
4.00 Credits
The keys that develop a plan into an actionable document The major difference between planning and budgeting Strategic planning The business plan The people plan The marketing plan Capital and technology plans
Surgent's Update on Recent AICPA Standard Setting: Staying Current in a Changing Environment
-
Virtual
4.00 Credits
AICPA hot topics and standard-setting initiatives AICPA Quality Management Standards: SQMS No. 1, SQMS No. 2, and SQMS No. 3 Consideration of fraud in a financial statement audit Discussion of the standard on audit evidence effective for years ended December 31, 2022 Discussion of the standard on auditing accounting estimates and disclosures effective as of December 31, 2023 Discussion of the two standards on use of specialists and information from a pricing service, and the newly updated risk assessment standard effective for years ended December 31, 2023 Discussion of standards that are effective as of 2025, including those dealing with client acceptance and questions asked of the predecessor auditor, the partner’s responsibility for engagement quality, group audits, conforming changes to compliance auditing, and more
Yellow Book Independence and Single Audit Fundamentals
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:The conceptual framework approach to independenceIndependence threats related to preparing financial statements and accounting recordsConsideration of specific non-audit services that would and would not impair independenceDocumentation necessary to support adequate consideration of auditor considerationFundamentals of a compliance audit performed under the Uniform GuidanceSchedule of expenditure of federal awardsDetermination of major programsUsing the Compliance Supplement Uniform Guidance administrative requirements and cost principles Testing internal control over complianceTesting complianceWriting an audit findingReporting requirements of a single audit
ACPEN: Performance Management
-
Online
1.00 Credits
Setting and resetting performance expectations On-the-spot counseling Addressing erratic performance Drafting and presenting performance appraisals
ACPEN: Viewing A&A Through the Eyes of a Tax Practitioner
-
Online
2.00 Credits
The role of financial reporting for a myriad of users Fundamentals concepts Special Purpose Frameworks Financial statement analysis Cross-functional collaboration
ACPEN: Section 25F Scholarship Granting Tax Credit: Planning and Compliance Strategies
-
Online
2.00 Credits
Overview of Section 25F and legislative intent Eligibility requirements and qualifying contributions Credit calculation and limitations State-by-state conformity and eligibility considerations Interaction with other federal and state tax provisions Compliance, documentation, and reporting considerations Common pitfalls and audit risks
ChatGPT Deep-Dive Hands-on Bootcamp for CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Getting started with ChatGPTTour of the ChatGPT app and how to use itVariety of hands-on case study examples for accounting, finance, and taxProtecting your data privacy in ChatGPTAdvanced ChatGPT features reviewSubscription plan options
Analyzing IFRS Financial Statements
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Financial Analysis fundamentals: Overview of financial statements, their interconnections, and the foundation of advanced analysisLoblaw Companies Case Study: Introduction to our example company and its financial performanceAdvanced Analysis Techniques: Common size analysis, Dupont framework, financial leverage, and operational metricsOperational Focus: Separating core business performance from financing activitiesApplied analysis and managerial ratios: Segment analysis, cash flow analysis, and managerial ratiosManagement Commentary: Overview of the corporate narrative as presented from IFRS lens.
AI & Accounting in Manufacturing
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Intelligent automation and dark factoriesPredictive maintenance and real-time cost trackingAI-enabled financial reporting and dashboardsContinuous auditing and anomaly detectionTax compliance automation and transfer pricing AIData governance and cybersecurity in financial systemsWorkforce reskilling and AI-augmented financial roles
