CPE Catalog & Events
Surgent's Excel: Mastering PivotTables
-
TBD
2.0 Credits
Member Price: $99
Explore PivotTable capabilities and functionality Retrieve data from a database and feed it into the PivotTable Pull web tables from web pages into Excel
Fundamentals of Form 1040 -- Business
-
TBD
4.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Self-employment and business income taxation (Schedule C, self-employment tax, business deductions)Reporting income from pass-through entities (Schedule E, Schedule K-1, Shareholder stock and debt basis on Form 7203)Application of Form 7217 for capital construction fundsBest practices for self-employed clients and small business ownersKey deductions and credits for business ownersAvoiding common IRS audit triggers related to business income reportingLegislative updates impacting business income taxation in the current year
Mining Your Firm Client Database for Revenue
-
TBD
1.0 Credits
Member Price: $55
The major topics that will be covered in this course include:How accounting and tax professionals can transform dormant data into dynamic growth. When leveraged strategically, your client base becomes more than a list --it becomes a roadmap to higher-value services, expanded engagements, and greater long-term retention.How to audit client records, segment strategically, and surface needs that often go unmet --all without adding complexity or compromising relationships.Using the data you already own and relationships you have already built to drive smarter growth.
An Ethical Approach to Mental Health Issues at Work
-
TBD
2.0 Credits
Member Price: $89
The major topics covered in this class include:Virtue Ethics and Mental HealthDefinition, Myths and Bias of Mental HealthSuicide: Facts and ResourcesRecognizing signs of potential mental health challengesEmpathy and ListeningMental Health and Generational ExpectationsBecoming a Mental Health Ally
Coping With the Growth of Online Fraud
-
TBD
0.0 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
ACPEN: There is NO Such Thing as ‘Business Ethics’ featuring John Levy and Don Minges
-
TBD
1.0 Credits
Member Price: $39
Should ethical behavior be something that we always do? Is ethical behavior situational? Why being ethical will help you succeed personally and professionally. Consequences of not behaving ethically? Why trust matters? How we can make better ethical decisions in our professional lives.
ACPEN: Revenue Recognition - Topic 606 Overview
-
TBD
1.8 Credits
Member Price: $79
Revenue Recognition on Contracts with customers
ACPEN: From Numbers to Narrative: Effectively Presenting Your Budget and Reporting
-
TBD
2.0 Credits
Member Price: $89
Identifying the ‘Big Picture’ and your role in effective communication Communicating so others can understand us Understanding a presentation’s anatomy? Tips and tricks for budget presentations
ACPEN: Travel/Entertainment Expenses and Taxes: What You Need to Know for Compliance
-
TBD
2.0 Credits
Member Price: $89
Definition of what qualifies as an entertainment expense Strategies to deduct business entertainment expenses Deductibility of meals Situations not subject to the 50% meals and entertainment reduction How to handle automobile issues related to employer-provided parking Proper accounting for deductible vs. non-deductible expenditures The four steps to analyze business expenses The latest federal legislation, cases and rulings
ACPEN: K2’s Excel Tips – Today’s Best Features
-
TBD
2.0 Credits
Member Price: $89
New features and functions in Excel How to improve efficiency and effectiveness when working in Excel Taking advantage of Copilot integration with Excel Better ways of creating and working with formulas
ACPEN: Introverts Have Real Power, Why Quiet Leaders are So Successful
-
TBD
2.0 Credits
Member Price: $89
What are the signs of an Introvert? Why do we seek out extroverts? How do we communicate? Introvert characteristics Secrets of public speaking for Introverts How to help your Introverted child? Playing to an introvert’s strengths
ACPEN: Practical Excel Topics for Today’s Accountant
-
TBD
2.0 Credits
Member Price: $89
Data validation Underutilized, but powerful, formulas Formulas for manipulating, transforming, and cleansing data Formulas for data analysis Reference formulas such as =VLOOKUP Pivot tables Solver as a tool for performing multivariate analysis Mail merge Custom formatting
ACPEN: Cash Flow Clarity: Effectively Communicate Cash Flows for your Board and C-Suite
-
TBD
2.0 Credits
Member Price: $89
The importance and structure of the cash flow statement Understanding operating, investing, and financing activities Presenting the statement using the "Sources and Uses" approach How to tell the business story through cash flows and alternative reporting methods Identifying key drivers of cash and liquidity Bridging the gap between accrual accounting and understanding cash Communicating effectively with CEOs, boards, and non-financial stakeholders
ACPEN: Effective Manager - Traits and Skills
-
TBD
2.0 Credits
Member Price: $99
Management Leadership
S Corporations: Calculating Shareholder Basis
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Discuss the calculation of basis when the entity is formed including the impact of contributed propertyExplain the importance of shareholder loans to the entityUses a comprehensive example to illustrate the mechanics of the basis determination processSchedule K-1 Basis and Form 7203Discuss how basis is impacted by distributions of corporation propertyExplain how basis is impacted by sale/or liquidation of the S corporation interestDiscuss how S corporation losses impact Form 1040 Schedule E reportingShow how to get from the Schedule K-1 information to the basis calculations
ACPEN: How to Develop Your System of Quality Management Using the AICPA Practice Aids
-
TBD
3.0 Credits
Member Price: $109
Overview of Quality Management standards Scope of SQMS 1 Components of quality management Changes from prior standards AICPA practice aids Required documentation Risk assessment process Final documentation development
ACPEN: Estates & Trusts: Executor Duties and Tax Responsibilities in Estate Administration
-
TBD
4.0 Credits
Member Price: $149
Legal and fiduciary responsibilities of the executor or personal representative Overview of the estate administration process from appointment through final distribution Filing requirements for Form 1040, Form 1041, and Form 706 Income in respect of a decedent (IRD) and basis adjustments Estate asset identification, valuation, and management Creditor claims, debt settlement, and distribution procedures Obtaining an EIN for the estate and IRS notice procedures IRS audit risks related to estate administration Executor liability considerations and risk management Estate accounting records, documentation, and communication with beneficiaries
ACPEN: K2’s Implementing Internal Controls In QuickBooks Online Environments
-
TBD
4.0 Credits
Member Price: $149
Critical risks in QBO environments Internal control options that can mitigate risk to prudently acceptable levels Enabling alternative control measures to improve internal controls in QuickBooks environments
Create Measures in Power BI that Define Your Metrics
-
TBD
0.0 Credits
Member Price: $149
The major topics that will be covered in this class include:Introduction to DAX: Understanding the fundamentals of DAX and its role in Power BI.Advanced DAX Formulas: Delving into complex DAX functions and formulas for creating sophisticated measures.Time Intelligence in DAX: Exploring time-based functions to analyze data over different periods.Validating Measures with DAX: Techniques for ensuring accuracy and reliability in your DAX measures.Using PivotTables for Measure Validation: Employing PivotTables in Power BI to test and confirm the effectiveness of DAX measures.
How to Audit Inventory
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Auditing Inventory.Related Audit assertions, risks, and threats to inventory.Substantive auditing procedures that staff should perform.