CPE Catalog & Events
Complete Guide to Analyze Data with Excel PivotTables
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:Introduction to PivotTables: Gain a solid understanding of what PivotTables are, their benefits in Excel, and how to prepare your data for creating effective PivotTables.Creating and Customizing PivotTables: Learn step-by-step how to build and format PivotTables, including filtering, sorting, and customizing layouts for optimal data analysis. Focus on Using PivotTables to Analyze Data: Explore techniques to summarize, group, and compare data with PivotTables, uncovering trends and insights for better decision-making.Advanced PivotTable Features: Discover advanced tools such as slicers, timelines, and using PowerPivot for deeper analytical capabilities. Data Visualization with PivotCharts: Learn to create PivotCharts from your PivotTables and customize them to visually present data insights effectively to stakeholders.
ACPEN: K2’s Excel Best Practices
-
Webinar
8.00 Credits
Member Price: $250
Best practices associated with creating Excel workbooks, including managing workbooks How to secure Excel workbooks Collaboration options and best practices in Excel Effective reporting techniques in Excel
ACPEN: A Practical Guide to Trusts
-
Webinar
8.00 Credits
Member Price: $250
Trustee responsibilities and trust administration Strategies for probate avoidance and efficient asset distribution Tax treatment of revocable living trusts Marital deductions and bypass trusts Uses of irrevocable trusts in estate planning Benefits of irrevocable life insurance trusts Multi-generational wealth planning with dynasty trusts Overview of estate planning tools: GRIT, GRAT, GRUT, and QPRT
ACPEN Signature 2026: Small Business Recurring Tax Nightmares!
-
Webinar
8.00 Credits
Member Price: $250
Rules for Tracking Business Interest, Investment Interest and Personal Interest Expenses Employee or Independent Contractor and Risks of Misclassification. The Hobby Loss Rules and Passive Activity Loss Limitation Rules. CTRs, Reporting Bank Accounts (FBARs), Reporting Entity Interests and Trusts and New Rules for Taking Cash in or out of the EU. The Partnership Audit Rules and Tips for Partnership Audits. Qualification as a Real Estate Professional and Rental Rules for Real Estate Professionals Tax Treatment of Casualty Losses and Casualty Gains including the 1033 election for involuntary conversion items (cattle sold due to drought, eminent domain takings, etc.) Self-Employment Taxes of Subchapter S, LLC and LP owners
Understanding and Creating an Internal Control System
-
Webinar
8.00 Credits
Member Price: $239
The major topics covered in this course include:Underlying concepts of internal controlDefining where and why controls, policies and procedures are neededLegacy control measures that are still important for businesses todayCreating control measures that address the use and protection of technology
Profiles in Fraud
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Real life fraudsters: what they did, how they got away with it, how they finally were caughtProfiles: the characteristics the fraud perpetrators have in commonTechniques to prevent and deter these common schemes
ACPEN: Consulting Services Secrets
-
Webinar
1.00 Credits
Member Price: $39
Identifying a consulting specialty Building a practice and translating knowledge into products Managing consulting projects Marketing consulting projects Building a referral network Contingent fees Professional standards for consultants
ACPEN: Business Valuation - Asset Approach
-
Webinar
1.00 Credits
Member Price: $39
Fundamentals of Business Valuation and Appraisal Standards The Asset Approach: Methods, Applications, and Analysis
ACPEN: Generation Intelligence: Navigating the Generational Divide
-
Webinar
1.00 Credits
Member Price: $39
Generations
ACPEN: Cryptocurrency Transactions: Navigating Federal Tax Rules
-
Webinar
1.00 Credits
Member Price: $39
Review existing reporting rules Broker reporting requirements and Form 1099-DA Reporting crypto transactions Basis Safe Harbor Illustrative example
Beyond the Basics: Financial Ratios You Might Be Overlooking
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Understanding Cost Behavior and Its Impact on Decision-MakingContribution Margin and Break-Even AnalysisMargin of Safety and Its Role in Risk ManagementOperating Leverage and Financial SensitivityAnalyzing Asset Turnover for Operational EfficiencyCash Conversion Cycle and Working Capital InsightsFree Cash Flow Yield as a Valuation Tool
ACPEN: Functional Approach to Employee Benefits
-
Webinar
1.50 Credits
Member Price: $79
Benefits Benefits Communications Total Rewards
ACPEN: Emerging Risks and Resilience - How Accountants and Finance are Leading the Way - Part 2 Technology Disruption, Artificial Intelligence an
-
Webinar
1.60 Credits
Member Price: $79
Artificial Intelligence Emerging Risks for Acccountants and Finance Cybersecurity Risks
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: Advanced Excel: Hidden Secrets and Gems
-
Webinar
2.00 Credits
Member Price: $89
Awareness of advanced functions Creative methods for data manipulation Real-life examples of innovative ways to analyze and report data with Excel Using Excel to perform e-mail merges Many other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolbox
Form 1041 Advanced Series Part 3: Sec.199, Sec.67g & Charitable Deductions 26-27
-
Webinar
2.00 Credits
Member Price: $99
Review of New Rules under IRC Sec. 67(g) Review Surprises to Simple Trusts under IRC Sec. 67(g) Presentation Issues with IRC Sec. 199A Deduction and the Tier System Special Rules Relating to the Charitable Contribution Deduction Problem Examples
Navigating IRS Correspondence: Responding to IRS Letters
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Types of IRS letters: General notices, audits, collections, return requests, and errors.Deadlines for responding to IRS correspondence.Communication best practices for dealing with the IRS.Avoiding escalation and penalties through proactive responses.Ensuring compliance when addressing IRS correspondence.Real-world examples of successful IRS communications.Common pitfalls in handling IRS letters and how to avoid them.Strategies for advising clients on IRS correspondence.
PFP Update: Income Tax, Retirement and Estate Planning 26-27
-
Webinar
2.00 Credits
Member Price: $99
The personal financial planning process Relevance to income tax Retirement and estate planning concerns and solutions
Surgent's Unconscious Bias for Managers, Supervisors, and Executives
-
Webinar
2.00 Credits
Member Price: $99
Unconscious bias, including the five defining characteristics of unconscious bias The real-world impacts of unconscious biases, including impacts on racial minorities, women, and older workers The concept of microaggressions, with examples An effective strategy for adult learning that can be applied to change unconscious biases, which can also be used to learn other skills A framework for handling mistakes and using them to build trust and respect in the workplace. We call this the “oops, did I just say that?” section.