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
Forensic Accounting: When The Office Is A Crime Scene
-
Webinar
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
Surgent's Fraud In Single Audits
-
Webinar
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
-
Webinar
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
Making Culture A Competitive Advantage
-
Webinar
1.00 Credits
Member Price: $39
Talent Strategy Culture Employee Engagement Employee Retention Leadership Leadership Strategy
Excelling at Excel: The Magic of Power Query
-
Webinar
2.00 Credits
Member Price: $79
Intro to Power Query & how to get started Examples of data clean up using Power Query Combining workbooks and files with Power Query
Surgent's Bankruptcy Basics: Understanding the Reorganization and Liquidation Process in These Uncertain Economic Times
-
Webinar
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
-
Webinar
2.00 Credits
Member Price: $99
Form W-4 Form I-9 Form W-9 End-of-year compliance Payroll tax returns Unemployment insurance
Taxation of the Cannabis Industry
-
Webinar
2.00 Credits
Member Price: $79
Historical context of U.S. taxation Industrial hemp vs. marijuana Income definitions under I.R.C. §61 Tax code restrictions: §280E and §471 State-specific marijuana laws Cash management in cannabis businesses Federal court case analysis
Managerial Accounting: Your Prescription for Better Decision Making
-
Webinar
4.00 Credits
Member Price: $129
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
-
Webinar
1.00 Credits
Member Price: $39
Research Analysis Interviewing Documenting Reporting Results
Performance Auditing Made Easy
-
Webinar
1.50 Credits
Member Price: $59
Performance audit standards Performance audit types Performance audit objectives
Navigating IRS Collections: The Collection Process
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of the IRS collection process.Taxpayer rights and the Taxpayer Bill of Rights.Collection due process and appeals.Installment agreements and offers in compromise.Wage garnishments, levies, and liens.Penalties and interest.
Surgent's Current Issues in Accounting and Auditing: An Annual Update
-
Webinar
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
-
Webinar
4.00 Credits
Member Price: $129
Tools for FSA The 3 P's. The QST trifecta The integrated planning model Performance based management The value chain The balanced scorecard
K2's Effective Automation And Outsourcing
-
Webinar
1.00 Credits
Member Price: $39
Overview of how firms and businesses currently use automation and outsourcing Discussion of the management and regulatory compliance issues with offshore and onshore outsourcing use in small and mid-size organizations Review of which tasks are best suited for offshoring, which solutions are best for onshore outsourcing, and which solutions can be solved with technology Discussion of specific solution providers which provide solutions for tax and accounting firms as well as internal accounting departments
The Untold LinkedIn Hyper-Growth Story
-
Webinar
1.00 Credits
Member Price: $39
Talent Business Growth People Strategy Culture Communication Trust Strategy
The Controllership Series: The Controllers Role in Internal Controls
-
Webinar
1.50 Credits
Member Price: $59
Accounting Finance Internal Controls
IRS Cybersecurity Checklist
-
Webinar
2.00 Credits
Member Price: $79
Defining Cybersecurity and Cyber Risks Implications of Cybercrime Cyber Attack Trends Landscape of Cyberattacks Laws and Regulations Security Standards and Frameworks Cybersecurity Roadmap
Develop Your Emotional Intelligence to Be More Successful in Life and Leadership
-
Webinar
2.00 Credits
Member Price: $79
Emotional Intelligence (EQ) in Leadership Building Stronger Workplace Relationships Creating and Leading High-Performing Teams Navigating Change with Emotional Intelligence