CPE Catalog & Events
Complete Guide to Analyze Data with Excel PivotTables
-
TBD
0.0 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.
2026/27 AICPA Regulatory Ethics Update
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Update on ethics and independence developments from the AICPA Professional Ethics Executive Committee (PEEC)Recent developments shaping ethical requirements for the professionProposed and ongoing projects on PEEC's agenda
ACPEN: The Ethical Side of Trust, featuring Richard A. Karwic and Don Minges
-
TBD
1.0 Credits
Member Price: $39
The seven components of trust High standards, loyalty, doing the right thing, listen, empathy and accountability The value of trust How ethics relates to trust and how trust relates to ethics
ACPEN: Emerging Risks and Resilience - How Accounting and Finance are Leading the Way - Part 3: Blockchain and Financial Risks
-
TBD
1.2 Credits
Member Price: $39
HR Talent Blockchain Corporate Social Responsibility Financial Exposure Currency
ACPEN: K2’s Top Ten Productivity Booster Apps In Microsoft 365
-
TBD
2.0 Credits
Member Price: $89
Enhancing communication and collaboration: Shared Mailboxes, Groups, and Places Optimizing task and project management: Planner, Lists, and To Do Streamlining training and workflow automation: Stream, Viva Learning, Forms, Bookings, and Approvals
ACPEN: The Preparation of Form 706 and 709 – Understanding the Law
-
TBD
2.0 Credits
Member Price: $89
Estate and Gift Taxation Fundamentals Valuation of Estate Assets Components of the Gross Estate Deductions in Estate Taxation Charitable and Marital Deductions Tax Credits and Their Application
ACPEN: Better Forecasts: Be a Better Predictor
-
TBD
2.0 Credits
Member Price: $89
Why an open mind and the ability to doubt helps make great predictions Why it is better to be a fox than a hedgehog How non-conformists change the world How to focus on what matters How to learn from the past without hindsight bias
Ethical AI Practices for CPAs: Ensuring Responsible Use
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Understanding ethical implications of AIData privacy and security considerationsCompliance with regulations and professional standardsDeveloping ethical AI policies and procedures
Smarter Tax Services with Artificial Intelligence (AI) Tools
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of AI technology and how it worksIdentify where AI can be incorporated into tax research, planning, and compliance servicesDiscover new opportunities to enhance your client advisory tax services with AI toolsReview the market of emerging and AI enhanced tax software toolsLearn about the newest generation of AI enable 1040 source document collection and organizer applicationsReview specific use cases for generative AI tools (e.g. ChatGPT, Microsoft Copilot) in your tax services
ACPEN: Let's Meet at the Intersection of Fraud and Ethics
-
TBD
4.0 Credits
Member Price: $149
Examination of actual frauds Discussion of internal controls that could have prevented frauds Contemplation of epiphanies for your own professional scenarios The AICPA Code of Professional Conduct Other elements of professional conduct and compliance with professional standards
Hot Topics Audit & Attest Update - 2026
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this course include:The major topics that will be covered in this course include:Recent quality improvements to the SASs and SSARsOther matters that should be on your radar
ACPEN: The Essential FASB Update with Renee Rampulla
-
TBD
4.0 Credits
Member Price: $149
Hot GAAP topics Income Tax Disclosures Crypto Assets Governmental Grants Interim Reporting Lease Standard Post Implementation Review
ACPEN: Understanding the Tax Implications of Retirement Plan Distributions
-
TBD
1.0 Credits
Member Price: $39
Required minimum distributions for a deceased's heirs 2025 retirement plan contribution limits Required minimum distributions and contributions to charity Key provisions of Secure Act 2.0
ACPEN: The Radar Phenomenon
-
TBD
1.0 Credits
Member Price: $39
Internal Controls Fraud Prevention Fraud Investigation
ACPEN: Emerging Risks and Resilience - How Accounting and Finance are Leading the Way - Part 4: Managing Supply Chain Risks, Data Analytics, and
-
TBD
2.0 Credits
Member Price: $89
Third-party risks Supply chain Data analytics Risk management Operational resilience
ACPEN: Businesses Receiving Government Assistance
-
TBD
2.0 Credits
Member Price: $89
What is Yellow Book? What is different because of Yellow Book? When might Yellow Book apply to a business? Common application of concepts to businesses Answers to common questions
ACPEN: Taxation of Non-fungible Tokens (NFTs)
-
TBD
2.0 Credits
Member Price: $89
NFT basics Classification of NFTs Current Legislative and Policy Environment Tax implications of creation, sales and exchanges of NFTs
ACPEN: Building an Ethical Culture: Strengthening Your Ethical Backbone
-
TBD
2.0 Credits
Member Price: $85
Ethical Issues over the years Types of Business Ethics Issues Structure and application of the AICPA Code of Professional Conduct Role of social responsibility in shaping corporate behavior Factors For Evaluating Ethics Ethics 101 and Decision Making Profiling Ethical Culture
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: Finding the Right Fit: An Exploration Financial Reporting Options for SMEs
-
TBD
4.0 Credits
Member Price: $149
Unique needs of SMEs The menu of available frameworks Exploration of specific SPFs U.S. GAAP provisions for SMEs Considerations when selecting a framework Audit, review, and compilation implications Pitfalls to avoid Best practices to adopt