CPE Catalog & Events
Taking Advantage of Array Formulas in Excel
-
Online
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
Forensic Accounting: When The Office Is A Crime Scene
-
Online
4.00 Credits
Member Price: $149
The major topics covered in this class include:A step-by-step process from the initial client phone call to you writing a report of your findings for any civil or criminal actions that may be pursuedHow to advise your client in approaching an allegation of embezzlementWhat pitfalls may arise in finding the truthThe best practices to ensure that the evidence is preserved properly for potential civil or criminal actions
Practical Tools and Tips to Help CPAs Manage Risk (Audit & Attest Services Focus)
-
Online
4.00 Credits
Member Price: $159
AICPA Professional Liability Insurance Program's claims data Client and engagement acceptance Engagement letters and fee management Client continuance and termination Team management and firmwide quality control Causes of loss Risk management tips to assist claim defense Data security
Surgent's Fraud In Single Audits
-
Online
4.00 Credits
Member Price: $159
Study real-life misappropriations involving federal awards and how they were carried out The backgrounds, motivations and methodologies of the fraudsters Brainstorm where things went wrong that allowed the frauds to occur without prevention or detection
Coping With the Growth of Online Fraud
-
Online
4.00 Credits
Member Price: $149
The major topics covered in this course include:The actuation of online and other cyber fraudsFraudulent acts that are initiated electronicallyAutomated and employee driven methods that can reduce cyber-fraud risk
Surgent's Bankruptcy Basics: Understanding the Reorganization and Liquidation Process in These Uncertain Economic Times
-
Online
2.00 Credits
Member Price: $99
Commencement of a bankruptcy proceeding Protections provided to debtors under the Bankruptcy Code Key procedural aspects of bankruptcy The automatic stay Differences between Chapters 7, 11, and 13 bankruptcy cases The bankruptcy discharge Proofs of claim Plans of reorganization Litigation that can arise during bankruptcy Creditor committees Bankruptcy trustees Avoidable preferences and fraudulent transfers Special rights afforded to landlords and secured creditors
Surgent's Hiring New Workers and Payroll Taxes
-
Online
2.00 Credits
Member Price: $99
Form W-4 Form I-9 Form W-9 End-of-year compliance Payroll tax returns Unemployment insurance
Managerial Accounting: Your Prescription for Better Decision Making
-
Online
4.00 Credits
Member Price: $159
Target profit and Break-even analysis Relevant costs and decision-making Standard costs and variances Activity-based costing Segment reporting and analysis Budgeting
Conducting Human Resource Investigations
-
Online
1.00 Credits
Member Price: $59
Research Analysis Interviewing Documenting Reporting Results
Performance Auditing Made Easy
-
Online
1.50 Credits
Member Price: $79
Performance audit standards Performance audit types Performance audit objectives
Surgent's Current Issues in Accounting and Auditing: An Annual Update
-
Online
4.00 Credits
Member Price: $159
Recently issued but newly implemented Accounting Standards Updates (ASUs), the PCC Update, and items on the FASB’s Technical Agenda New ASUs covering disaggregated expenses, crypto assets (e.g., cryptocurrency), and business combinations Results and findings of the FASB’s Final (Stage 3) Post-Implementation Review (PIR) Report on Topic 606 Recently issued SASs and other AICPA activity through SAS No. 149 Detailed review of the three new Statement on Quality Management Standards (SQMS 1, SQMS 2, and SQMS 3) Other important A&A practice matters
Achieve Competency in Three Basic Tool Categories - Master the Fundamentals
-
Online
4.00 Credits
Member Price: $159
Tools for FSA The 3 P's. The QST trifecta The integrated planning model Performance based management The value chain The balanced scorecard
The Controllership Series: The Controllers Role in Internal Controls
-
Online
1.50 Credits
Member Price: $79
Accounting Finance Internal Controls
Resolving Ethical Dilemmas-You Make the Call
-
Online
1.50 Credits
Member Price: $79
Ethical frameworks Threats and safeguards to objectivity and independence
IRS Cybersecurity Checklist
-
Online
2.00 Credits
Member Price: $109
Defining Cybersecurity and Cyber Risks Implications of Cybercrime Cyber Attack Trends Landscape of Cyberattacks Laws and Regulations Security Standards and Frameworks Cybersecurity Roadmap
Grading Your Auditors - Are You Getting the Most Value?
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Limitations in roles and responsibilities an auditor can accept without impairing independenceAssessing the strength of your auditor's ability to think critically, strategically, and creatively in appropriate circumstancesEvaluating your auditor's time and project management stillsGrading your auditor's communication and interpersonal skills, in exceeding your expectations on an audit
Planning for Small Business Success
-
Online
4.00 Credits
Member Price: $159
The integrated planning model The strategic plan Linkage with Performance Based Management Tracking success Real world examples
Fraud Busters: Controls to Prevent & Detect Fraud
-
Online
2.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
The Controllership Series - The Controller's Skillset
-
Online
1.00 Credits
Member Price: $79
Accounting Finance Skills
SECURE Act 2.0: What You Need to Know
-
Online
1.00 Credits
Member Price: $59
Expanding Automatic Enrollment in Retirement Plans Increased Age for RMDs Higher Catch-up Contribution Limit Emergency Expense Penalty-Free Withdrawals “Starter” 401(k)s for Certain Employers Part-time Worker Improved Coverage