CPE Catalog & Events
The 10 Must Know Excel Features
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.
ACPEN: Interviewing, Onboarding and Training 101
-
TBD
1.0 Credits
Member Price: $39
Best practices on interviewing Best practices for onboarding Best practices with training
Tax Implications of Retirement Plan Distributions
-
TBD
1.0 Credits
Member Price: $55
The major topics that will be covered in this course include:Required minimum distributions for a deceased’s heirs2025 retirement plan contribution limitsRequired minimum distributions and contributions to charityKey provisions of Secure Act 2.0
ACPEN: Ethics in Communicating & Reporting
-
TBD
1.0 Credits
Member Price: $39
Fundamentals of ethical communication 4 must-have communication skills How to improve your ethical communication skills Problems related to unethical behavior in reporting & communication
ACPEN: White-Collar Crime: What Every CPA Should Know
-
TBD
1.0 Credits
Member Price: $89
Definitions of white-collar crime White-collar crime characteristics and statistics The CPA’s role in combating white-collar crime
ACPEN: Thinking Like an Auditor When Preparing Your Financial Statements
-
TBD
2.0 Credits
Member Price: $89
Determining an appropriate sense of quantitative and qualitative materiality Identifying the critical components of the financial statements that matter most to financial statement users Evaluating where the financial statements are most likely to contain material fraud and error, and ensuring adequate internal control and monitoring to mitigate those risks
ACPEN: New Client Ethical Challenges: The CPAs Guide
-
TBD
2.0 Credits
Member Price: $89
How the CPA can meet the challenges presented by a new client AICPA Code of Professional Conduct AICPA Statements on Standards for Tax Services IRS Circular 230 Case study illustration of how to bring the new client into ethical, proper financial and tax compliance
ACPEN: Best-in-Class Internal Controls: Best Practices for Finance Professionals
-
TBD
2.0 Credits
Member Price: $85
Define and explore the basic concepts, myths and facts of internal controls Examine typical control types Identify why controls fail Identify a framework to develop the right balance of internal controls Discuss Internal Controls in the Digital Age Examine the variances and considerations of automated vs. manual controls Evaluate the concept of IT controls
Tax Depreciation: Review and Update
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this class include:Recent tax legislation and developments related to capitalizationEligible property for Section 179 and Section 168(k)Discussion of the Section 179 deduction and its use to depreciate real propertyThe Section 168(k) deduction and its use to depreciate real propertyDisposition of segments of real propertyExchanges of tangible personal property after repeal of the like-kind exchange rulesOther related topics
ACPEN: Financial Statement Analysis
-
TBD
4.0 Credits
Member Price: $149
Purposes of financial statement analysis Trend analysis and vertical & horizontal analysis Simple and multivariate regression; Analysis of metrics Assessment of liquidity, solvency, and profitability Using data visualizations The role of qualitative factors
ACPEN: Building Personal Leadership Skills
-
TBD
4.0 Credits
Member Price: $149
Leadership Personality Types Communication Uses of AI in the work place
ACPEN: Maximizing Fringe Benefits: Strategies for Business and Personal Needs for Today and Beyond
-
TBD
8.0 Credits
Member Price: $250
Legislative and regulatory updates affecting fringe benefit planning Employer-sponsored fringe benefits and tax compliance under evolving regulations IRC §132 fringe benefit options and applications Cafeteria plans: benefits, limitations, and tax considerations Tax treatment of dependent care and educational assistance programs Flexible spending accounts and health savings accounts Group term life insurance: design features and tax treatment Financing strategies for retiree medical benefits Comparing health care benefits: insured plans vs. HMOs ERISA reporting and disclosure requirements Common control rules and nondiscrimination regulations
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.
ACPEN: K2’s Better Reporting With QuickBooks Online
-
TBD
1.0 Credits
Member Price: $39
The types of reports available in QuickBooks Online, by subscription level Customizing reports to meet your needs Spreadsheet Sync in QuickBooks Online Advanced
ACPEN: K2's Ten Questions To Ask Your IT Team
-
TBD
1.0 Credits
Member Price: $39
Ten Strategic Question Frameworks for Technology Assessment Cybersecurity and Infrastructure Oversight Through Targeted Dialogue Cloud Governance and Remote Work Technology Evaluation
AICPA's New SSTS #4 - New Ethics Standard for Tax Resolution
-
TBD
1.0 Credits
Member Price: $55
The major topics that will be covered in this course include:This session will provide a comprehensive overview of the ethical guidelines outlined in Circular 230 and the newly updated Statements on Standards for Tax Services (SSTS) #4. Gain insights into how these standards apply to real-world tax resolution scenarios, ensuring compliance and integrity in your practice.
ACPEN: A Guide to Sampling - Part 1
-
TBD
2.0 Credits
Member Price: $89
Auditing Yellowbook
ACPEN: Recognizing Lies: How to Detect and Prevent
-
TBD
2.0 Credits
Member Price: $89
Lies abound Why is it so difficult to call out a liar? How lies devastate Why do we despise lies? What sets liars apart? Deciphering the signals that indicate dishonesty How short-term thinking leads to lies and leads to uncovering lies Analyzing the cues Differentiating concerns and guilt The deception paradox What makes a great lie so great? Proven processes to uncover lies
Becoming a Fractional CFO: What to Do and How?
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Do you have what it takes to be a successful fractional CFO?Should you be a solo practitioner or join a larger firm? 1099 versus W2?What skills are needed to be successful?Sales, marketing, etc.What are some of the ‘red flags’?Typical assignments and issues a fractional CFO will likely encounterThe greatest opportunity for fractional CFOs?Understanding your value
K2's Formatting Excel Spreadsheets Correctly 26-27
-
TBD
2.0 Credits
Member Price: $99
Creating and using Styles in Excel The Accounting Format and why you should use it How to Create Custom Formats Formatting dates for maximum impact The advantages of storing formats in templates