CPE Catalog & Events
The 10 Must Know Excel Features
-
Webinar
2.00 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: K2’s Ten PDF Tips You Need To Know
-
Webinar
1.00 Credits
Member Price: $39
Converting documents to the PDF format Editing PDF documents Securing PDF documents Extracting data from PDFs
ACPEN: Appreciation Intelligence: The New AI Elevate Culture. Deepen Loyalty. Strengthen Performance.
-
Webinar
1.00 Credits
Member Price: $39
Appreciation Languages of appreciation Appreciation strategies
ACPEN: ProActive Response: Active Shooter Training - Recognize. Respond. Survive.
-
Webinar
2.00 Credits
Member Price: $89
Early Warning Signs Concerning Behavior Changes Getting out Barricading your area Fighting for survival Disarming the assailant Tourniquets (commercial and improvised) Pressure Dressings Chest Seals
ACPEN: Budget Mastery: Process, Problems, and Solutions
-
Webinar
2.00 Credits
Member Price: $89
Defining the budget process Common budgetary cultures and discussion of solutions Does your budget need an overhaul or just a tune up? How to make the budget flexible Making a better budget and maybe even a better you (or at least improving the perception of the budget work itself)
ACPEN: Stop Loss & Contract Review: Protecting Your Plan and Your Bottom Line
-
Webinar
2.00 Credits
Member Price: $89
Stop Loss TPA PBM Point Solutions
ACPEN: Metrics Management – Selecting the Right KPIs
-
Webinar
2.00 Credits
Member Price: $89
What makes a KPI meaningful and actionable Balancing financial, customer, operational, and learning metrics Selecting metrics at the responsibility-center level Understanding who the "customer"of a report really is Avoiding metric overload and bad incentives Linking departmental metrics to enterprise strategy The role of non-financial metrics in driving results Real-world KPI examples across industries
Accounting for the Gig Economy
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Characteristics unique to the gig economyIndependent contractor and employee classification considerationsRecordkeeping considerations for independent contractorsAccounting and reporting issues for gig economy participantsAudit and attestation for clients who participate in the gig economyTax and regulatory considerationsThe CPA as a trusted advisor for independent contractors
Form 1041 Advanced Series Part 1: Why Complex Trusts are Complicated 26-27
-
Webinar
2.00 Credits
Member Price: $99
How to Identify a Complex Trust and the Complications that Arise with Complex Trusts The Importance of Recognizing the Tier System used by Complex Trusts The Advantages and Requirements of the 65-day Rule Special Issues Related to the Charitable Contribution Deduction Use of a Checklist for Complex Trusts
Current Audit Environment and ASB Activity
-
Webinar
2.50 Credits
Member Price: $99
Current environment and implication for audit planning Key risk issues Audit challenges Recent Statements on Auditing Standards (SASs). ASB workplan SQMS No. 1, No. 2, and No. 3 SSARS No. 26
Tax Practice Conduct Standards: Circular 230 and AICPA Statements 26-27
-
Webinar
4.00 Credits
Member Price: $175
Federal and California statutory and regulatory standards governing tax preparers: Preparer penalty provisions, Circular 230 and; AICPA Statements on Standards for Tax Services Tax shelter and reportable transaction issues in depth Attorney-client, Sec. 7525 and work product privilege issues and Kovel arrangements
ACPEN: Avoiding Legal Liability and Peer Review Deficiencies in Nonaudit Services, Including Bookkeeping and Preparing Financial Statements
-
Webinar
4.00 Credits
Member Price: $149
Differentiating risks faced when performing nonaudit services, such as reviews, compilations, preparing financial statements, bookkeeping, tax return preparation, and similar Best practices for preventing quality control concerns that could lead to peer review deficiencies or malpractice claims Establishing an understanding with the client to minimize misunderstandings as to the nature and scope of engagements Explain situations when independence should be appropriately safeguarded when performing nonattest services
ACPEN: Planning for Small Business Success
-
Webinar
4.00 Credits
Member Price: $149
The integrated planning model The strategic plan Linkage with Performance Based Management Tracking success Real world examples
GAAP Update 26-27
-
Webinar
8.00 Credits
Member Price: $329
Equity method investments and joint ventures Changes in U.S. GAAP financial statement presentation and disclosure requirements Accounting and disclosure for crypto assets Various other Accounting Standards Updates (ASUs) issued during 2023 through 2026 FASB Technical Projects and Agenda, including recently exposed Proposed ASUs
Auditing Standards: A Comprehensive Review 26-27
-
Webinar
16.00 Credits
Member Price: $589
Efficient audit planning, documentation and research Risk assessment procedures relate control risk to substantive testing and reduce the risk of lawsuits Fraud requirements Testing management's estimates Auditing standards
Executive Presence, Personal Brand: Structure Your Narrative
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Components of executive presenceAudience-centered elevator pitch structureProfessional value proposition frameworkStructuring a concise executive biographyAligning personal narrative with organizational valueCommon pitfalls in professional self-presentationApplication and refinement exercise
Schedule K-1: What is it & What do I do with it?
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of Schedule K-1 for Partnerships, S Corporations, and Estates/TrustsReporting Schedule K-1 information on Form 1040Basis limitations, loss limitations, and material participation rulesQualified Business Income (QBI) Deduction and Schedule K-1 integrationSchedules K-2 and K-3 requirements
ACPEN: Risk Assessment of IT Systems
-
Webinar
1.00 Credits
Member Price: $39
Overview of SAS 145 Risk assessment requirements Role of IT in audit planning Understanding IT environments Identifying IT risks Areas of concern in IT systems Impact of IT risks on the audit
ACPEN: Mental Illness & Depression: Understanding & Supporting Employees Under the ADA
-
Webinar
1.00 Credits
Member Price: $39
Mental illness and depression Americans with Disabilities Act (ADA)
ACPEN: Revenue Recognition Topic 606 - Identify Performance Obligations Part 1
-
Webinar
1.20 Credits
Member Price: $39
Revenue Recognition Accounting