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
ACPEN: Doing Debt Differently - Your Roadmap to Changes & Choices for Success
-
Webinar
4.00 Credits
Member Price: $149
Education that is also transformation Key Learning Objectives A word collage to clarify your starting point with debt Practical and emotional aspects of debt Your current story about debt 3 myths and 3 truths about debt that will help you start over A new philosophy on Doing Debt Differently Key concepts that lead to success in becoming debt free A petition for debt freedom Facing your debt problem and creating relief The six ways to find relief – awareness, letting go, identifying debt patterns, creating your new relationship, the alchemy process, inspired actions Creating your personal plan for debt freedom Review and tips for continued success The secret to success is support How to build your success team
Viewing A&A Through the Eyes of a Tax Practitioner
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:The role of financial reporting for a myriad of usersFundamentals conceptsSpecial Purpose FrameworksFinancial statement analysisCross-functional collaboration
ACPEN: Preparing to be a Forensic Accountant - Focus on Network Forensics
-
Webinar
1.50 Credits
Member Price: $79
Forensic Accounting Accounting Auditing Finance
ACPEN: The Controllership Series - Sales, Collections and Customer Credit
-
Webinar
1.50 Credits
Member Price: $79
Accounting Sales Collections
ACPEN: K2’s Taking Another Look At PDFs
-
Webinar
2.00 Credits
Member Price: $89
Understanding the Portable Document Format Identifying tools you can use to work with PDFs Collaborating using PDFs Creating, distributing, and collecting fillable PDF forms Using PDFs to enhance security
ACPEN: Common Sense CFO: Balance Sheet Issues Walk through to Understand and Build Value
-
Webinar
2.00 Credits
Member Price: $89
Typical accounting issues that impact the balance sheet Where are the hidden issues in unrecorded liabilities? What are unrecorded assets and why they matter? Identification of and resolution of balance sheet challenges and changes Communicating to your audience and stakeholders
ACPEN: Nonprofit Tax Rules After OBBA: From Regulation to Reporting
-
Webinar
2.00 Credits
Member Price: $89
Recent tax legislation and developments related to non-profit entities Special sections of Form 990 and various form related changes Nonprofit tax exemption applications “Intermediate sanctions” excise tax Excess compensation excise tax Excess parachute payment excise tax Unrelated business income tax Required profit motive The Mayo case Entertainment expenses Taxable fringe benefits (including employer-provided parking)
ACPEN: Forensic and Fraud Interviewing Techniques and Skills
-
Webinar
2.20 Credits
Member Price: $89
Forensic Accounting Accounting Auditing Finance
Ethics, Tax Practice & Understanding Circular 230
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Importance of ethics in tax practiceOverview of Circular 230 and its application to tax practitionersCommon ethical violations and penaltiesProcedures to promote compliance with ethical standardsReal-life scenarios illustrating ethical decision-making in tax preparationCircular 230 provisions related to tax return preparation and representationBest practices for maintaining professional integrity and compliance
Ethics: 10 Crucial Qualities of High Character CPAs
-
Webinar
2.00 Credits
Member Price: $89
The major topics covered in this class include:Discover why the ten crucial qualities of high-character CPAs are essential to your successLearn how to evaluate these qualities in job candidates and why you must do so
ACPEN: Are You Up For the Challenge? Test Your Skills as a Quality Control Reviewer
-
Webinar
4.00 Credits
Member Price: $149
AICPA professional standards EQCR expectations Firm-specific considerations Best practices for reducing the frequency of review points Best practices for mitigating the severity of review points Examples of common EQCR deficiencies The impending influence of SQMS No. 1, SQMS No. 2, SAS 146, and SSARS 26 An interactive, hands-on EQCR simulation
ChatGPT for Accountants: 50+ Use Cases
-
Webinar
2.00 Credits
Member Price: $89
Major topics covered in this course include:Introduction to ChatGPT and artificial intelligence chatbot technologiesAutomating frequently asked questions and the onboarding processVerifying and reviewing financial recordsProviding real-time support to clientsGenerating financial reportsAutomating tax return preparation and financial planningProviding guidance on financial decision making
ACPEN: Accommodation Requests - Substance Abuse - Contagious Infections
-
Webinar
1.00 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: The Controllership Series – The Controller’s Skillset
-
Webinar
1.00 Credits
Member Price: $39
Accounting Finance Skills
ACPEN: What Is Your Brand Reputation?
-
Webinar
1.00 Credits
Member Price: $39
Presence
ACPEN: Preparing to be a Forensic Accountant - Focus on Computer Forensics - Part 3 (Steganography)
-
Webinar
1.60 Credits
Member Price: $79
Forensic Accounting Accounting Auditing Finance
ACPEN: 1065 – Understanding Partnerships Tax Returns
-
Webinar
2.00 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
-
Webinar
2.00 Credits
Member Price: $89
Internal Audit Internal Controls GIAS Institute of Internal Auditors Standards Accounting
ACPEN: Ethics: Court Orders, Confidentiality, and Compliance
-
Webinar
2.00 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