CPE Catalog & Events
Finding Errors in Excel Spreadsheets
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this class include:Understanding Common Excel Errors: Gain insights into the most common types of errors encountered in Excel, including formula errors, reference errors, and logic errors.Advanced Formulas and Functions: Learn to use advanced Excel functions and formulas that are crucial for error detection and data analysis.Data Validation Techniques: Master the art of data validation to prevent errors before they occur. This includes setting up data validation rules and using conditional formatting to highlight potential inaccuracies.Error Tracing and Auditing Tools: Delve into Excel's auditing tools to trace and fix errors. Learn to use Trace Precedents, Trace Dependents, and the Error Checking tool effectively.
ACPEN: Accommodation Requests - Substance Abuse - Contagious Infections
-
TBD
1.0 Credits
Member Price: $39
Accommodation requests - religious practices Accommodation requests - disabilities Substance Abuse - constructive confrontation Substance Abuse - duty to accommodate as a disability Disclosures of potentially contagious infections
ACPEN: Investment Scam Losses: How to Get Deductions
-
TBD
1.0 Credits
Member Price: $39
Categorization of various scams The keys to deductibility Review of the client's required actions to allow deductibility Disclosures and forms reporting required for deductibility “Tales from the Front” – practice issues CPAs are dealing with in these extraordinary situations
ACPEN: What Is Your Brand Reputation?
-
TBD
1.0 Credits
Member Price: $39
Presence
Internal Controls Over Compliance vs Compliance
-
TBD
0.0 Credits
Member Price: $55
The major topics that will be covered in this course include:Testing internal ControlsAlign internal controls with specific compliance requirementsThe misidentification of controls and the confusion between compliance and control processes
ACPEN: Digging Deep with Excel Pivot Tables
-
TBD
1.0 Credits
Member Price: $39
Data preparation and cleansing Pivot table creation Pivot table customization Navigating Excel’s PivotTable Analyze tab
ACPEN: 1065 – Understanding Partnerships Tax Returns
-
TBD
2.0 Credits
Member Price: $89
Partnership taxation Different types of partnerships Tax obligations of partners Role of the partnership agreement in tax reporting Filing deadlines of Form 1065
ACPEN: Global Internal Audit Standards (GIAS) Domain III - Part 2
-
TBD
1.0 Credits
Member Price: $89
Internal Audit Internal Controls GIAS Institute of Internal Auditors Standards Accounting
ACPEN: Ethics: Court Orders, Confidentiality, and Compliance
-
TBD
2.0 Credits
Member Price: $89
Overview of taxpayer confidentiality requirements under IRC §§7216 and 6713 Circular 230 standards related to disclosure of taxpayer information Gramm-Leach-Bliley Act (GLBA) privacy and safeguarding requirements Legal authority and limitations of court orders and summonses Disclosure considerations in divorce proceedings and mediation settings Dual representation and conflicts of interest Ethical decision-making frameworks for disclosure situations Documentation, informed consent, and scope limitations Best practices for protecting taxpayer confidentiality
Noble Leadership: An Ethical Approach
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Leadership DefinitionVirtue EthicsRelationship of Virtue Ethics to LeadershipCharacteristics of the Noble LeaderActions to create a culture of respect and dignity
Surgent's Leveraging AI for Data Analytics in Accounting
-
TBD
2.0 Credits
Member Price: $99
Transforming data analytics with AI Understanding the impact of AI on data analytics processes How AI enhances data accuracy, efficiency, and decision-making AI tools and techniques for data analysis Overview of AI-powered data analytics tools Techniques for improving data analysis accuracy and efficiency with AI Integrating AI into existing data analytics workflows Case studies on AI implementations for data analytics Success stories of AI-driven data analytics in accounting Challenges and lessons learned from AI integration Measuring the ROI of AI in data analytics Developing AI-powered data analytics skills Hands-on lab sessions using AI tools (e.g., ChatGPT, Excel) Practical exercises in filtering, sorting, summarizing, and visualizing data Applying AI insights to optimize data-driven decision making in accounting
Forensic Accounting: When The Office Is A Crime Scene
-
TBD
0.0 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
Take Command of your Time
-
TBD
2.0 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)
ACPEN: Leaders Eat Last. Why? 1 Hour Session
-
TBD
1.0 Credits
Member Price: $39
Why building trust is essential How trusting relationships makes us more effective Steps to build trust
ACPEN: Everyday Ethics: Ethics is Everywhere, All the Time! featuring Richard A. Karwic and Don Minges
-
TBD
1.0 Credits
Member Price: $39
Be careful of; Whom you trust, and What you easily dismiss. Beware of our internal biases. What are your biases? The need to consider situations from multiple perspectives.
ACPEN: AICPA Statements on Standards for Tax Services: Ethical Considerations
-
TBD
2.0 Credits
Member Price: $89
Review of the new AICPA Statement on Standards for Tax Services Reorganization of SSTS by type of work performed Discuss new standards on data protection, reliance on tools and representation of tax clients before taxing authorities
ACPEN: K2’s Expense Reporting Automation
-
TBD
2.0 Credits
Member Price: $89
Overview of selected expense and corporate credit card reporting and management platforms Major fraud schemes associated with expense reporting Extracting and importing transaction data from bank feeds and matching to receipts
ACPEN: Common Sense CFO: Decoding and Mitigating Internal and External Risks
-
TBD
2.0 Credits
Member Price: $89
Defining risk as it impacts organizations Understanding external and internal risks Examples of these risks How do we identify and assess? What can be done about the risks? Developing a risk mitigation strategy Monitoring and mitigating risk
ACPEN: Accounting for the Gig Economy
-
TBD
2.0 Credits
Member Price: $89
Characteristics unique to the gig economy Independent contractor and employee classification considerations Recordkeeping considerations for independent contractors Accounting and reporting issues for gig economy participants Audit and attestation for clients who participate in the gig economy Tax and regulatory considerations The CPA as a trusted advisor for independent contractors
Microsoft Teams for CPAs: Unlocking Its Full Potential
-
TBD
0.0 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