CPE Catalog & Events
Mastering the Excel Lookup Functions
-
Webinar
2.00 Credits
Member Price: $89
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
AI & Accounting in Construction
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of AI adoption in constructionPredictive analytics and risk managementAI-integrated Building Information Modeling (BIM)Real-time compliance and financial reportingTaxation challenges in AI-driven constructionAI in project scheduling, supply chains, and quality controlRegulatory frameworks and ethical AI use in audits
Navigating IRS Authorizations: Form 2848 & Form 8821
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of IRS Power of Attorney (POA) rules.Form 2848: Authority to Represent Clients before the IRS.Form 8821: Accessing Tax Information Without Representation.Identifying errors and compliance risks in POA filings.Rules for revoking or updating POA authorizations.Managing authorizations through the CAF system.Electronic submissions and the IRS online authorization process.Ethical responsibilities when holding a POA.
Risk Assessment Under SAS No. 145
-
Webinar
2.00 Credits
Member Price: $89
Risk assessment under SAS No. 145 Overview of the steps to perform during risk assessment Testing the design, implementation, and operating effectiveness of controls New concepts due to the issuance of SAS No. 145
Surgent's Top 10 Celebrity Estate Mistakes and How to Avoid Them
-
Webinar
2.00 Credits
Member Price: $99
Overview of estate planning The dangers of a Power of Attorney The most important aspect of a will Role, scope, rights, and responsibilities of an executor Benefits of incorporating a trust Bequests Caring for a pet Claims against the estate Insurance Consequences of poor estate planning
Microsoft Outlook "Must Know" Email Tips
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Using Quick Parts to streamline message composition.Eliminating inefficient back and forth appointment scheduling with the Bookings app.Using category codes and contacts to send bulk emails.Sending emails to Teams and OneNote.Organizing your inbox with custom views, rules and folders.Mastering the search tools to find emails quickly.Review of key option settings to maximize email productivity.
Accounting & Attestation for ESG
-
Webinar
1.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Current ESG-related initiatives and projects underway at the Financial Accounting Standards Board, Governmental Accounting Standards Board, and the AICPA. Types of services CPAs may provide in connection with ESG reporting, including advisory and attestation engagements.
Workforce Transformation and Talent Management in 2025
-
Webinar
1.00 Credits
Member Price: $55
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
Microsoft 365 Application Lightning Round Review-Updated
-
Webinar
1.00 Credits
Member Price: $55
The major topics covered in this course include:Lightning round review of the following apps, with an explanation and demonstration of what each of them offersTeams - the foundation of all that you do in Microsoft 365SharePoint / OneDrive - secure cloud storagePower BI - the new financial reporting modelStream - the YouTube for your organizationBookings - streamline your appointment scheduling OneNote - get your content organized for quick retrieval Lists - create custom list tracking reportsTo Do - consolidate all your Outlook, Planner and general "to do's" in one appPlanner - manage simple and complex engagements and projects in an intuitive appA quick look at many of the remaining apps
Take Command of your Time
-
Webinar
2.00 Credits
Member Price: $89
The major subjects that will be covered in this course include:Identify time wasters and adopt strategies for eliminating themRecognize the variety of causes of procrastination and apply techniques to overcome themUse practical techniques for prioritizing workDelegation strategiesIncorporate wellness and stress management into your day in short incrementsUnderstand their energy cycles and use it to manage your scheduleLearn techniques to decrease stress in the moment (based on neuroscience)
Tax Depreciation: Review and Update
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Recent tax legislation and developments related to capitalizationEligible property for Section 179 and Section 168(k)Discussion of the Section 179 deduction and its use to depreciate real propertyThe Section 168(k) deduction and its use to depreciate real propertyDisposition of segments of real propertyExchanges of tangible personal property after repeal of the like-kind exchange rulesOther related topics
Common Deficiencies in SSARS Engagements
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:Frequent problem areas in preparation, compilation, and review engagementsThe root causes of noncompliancePractical approaches firms can use to improve consistency, documentation, and overall engagement performance
Preparation, Compilation, and Review Engagements: Update and Review
-
Webinar
4.00 Credits
Member Price: $139
Overview of preparation, compilation, and review guidance Accounting and reporting issues Current practice issues Common deficiencies in peer reviews Current and future standard-setting projects
An Exhaustive Look At Fraud and Ways To Control It
-
Webinar
8.00 Credits
Member Price: $239
The major topics covered in this course include:Fraudulent acts initiated from outside organizationsWhy internal fraud occursThe importance of fighting cyber-fraudSteps that verify anti-fraud activities are working
Fraud Busters: Controls to Prevent & Detect Fraud
-
Webinar
1.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Fraud motivators - the fraud triangle, typical profiles of fraud perpetratorsRevisiting the basics of controls - design vs effectiveness, preventative vs. detectiveEntity-wide controls and how they can assist in fraud deterrenceSpecific fraud types and the controls that could prevent and detect them
How Fraud Can Affect Smaller Organizations
-
Webinar
4.00 Credits
Member Price: $149
The major topics included in this course include:The reasons for fraudFraudulent acts that are initiated against smaller organizationsMethods to stop fraud attempts against small businesses
Get started with Power BI
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Overview of the Power BI Tools: Introduction to the Power BI ecosystem, including Excel’s Power BI features (Power Pivot and Power Query) and standalone tools (Power BI Desktop, Power BI Service, Power BI Report Builder and Power BI Report Server).Tour of the Tools: Introduction to the interfaces of Power Pivot, Power Query, Power BI Desktop and Power BI Services.Comparative Analysis: Understand the strengths and limitations of Excel’s Power BI features versus standalone Power BI tools.Strategic decision-making on when to use each tool for optimal efficiency and accuracy in data analysis tasks.
Federal Tax Updates for Individuals
-
Webinar
8.00 Credits
Member Price: $239
The major topics that will be covered in this course include:Current tax issues affecting individual taxpayersReview of recent tax legislationOther issues affecting the profession, including IRS procedure, current cases, and other federal tax issues
Microsoft Teams for CPAs: Unlocking Its Full Potential
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Best practices for organizing your teams and channelsUnderstanding the role of Teams and SharePoint integrationUsing Teams to communicate and collaborate externally with clientsTips and tricks for managing conversations in TeamsLeveraging Microsoft Copilot AI in Teams
Beyond the Basics: Financial Ratios You Might Be Overlooking
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Understanding Cost Behavior and Its Impact on Decision-MakingContribution Margin and Break-Even AnalysisMargin of Safety and Its Role in Risk ManagementOperating Leverage and Financial SensitivityAnalyzing Asset Turnover for Operational EfficiencyCash Conversion Cycle and Working Capital InsightsFree Cash Flow Yield as a Valuation Tool