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.
SAS No. 122, AU 315, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement
-
Webinar
3.00 Credits
Member Price: $99
How the effect of a misstatement due to error effects the scope of our audit vs a misstatement due to fraud Inquires of management …….. and others The audit planning process; when we start and when we stop The importance of brainstorming and what two things should a talk about Revisions of our risk assessment Determining materiality
Just Ask Why - Searching for Answers: Generating Solutions
-
Webinar
4.00 Credits
Member Price: $129
The basic benefits of why The 5-15 report Curiosity and creativity
K2's Case Studies in Fraud and Technology Controls - 4 Hours
-
Webinar
4.00 Credits
Member Price: $129
Key fraud risks impacting businesses today Examples of fraud and the monetary impact on victims How to create, implement, and assess technology-based internal controls to reduce the probability of becoming a fraud victim
Audit Skills for Beginners
-
Webinar
4.00 Credits
Member Price: $129
Professional skepticism – Creating a mindset for finding fraud and error Audit documentation basics – Creating workpapers that pass review The audit risk model – Understanding the foundational principles Internal control fundamentals - Satisfying the requirements for evaluating the design and implementation of internal control over financial reporting
Al Capone to Cybercrime: The Journey of IRS Special Agents
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:Introduction to IRS Criminal Investigation (CI): Overview of its mission, role, and significance in maintaining tax compliance.Historical Evolution: From its inception in 1919 to its current role, highlighting key milestones and notable cases.Investigative Techniques and Tools: Detailed look at the methods and technologies used by CI agents to uncover financial crimes.Importance of IRS CI: Discussion on the impact of CI’s work on tax compliance, public confidence, and the broader financial system.Training of CI Agents: Insight into the rigorous training programs at FLETC and ongoing professional development.Process of Investigations: Step-by-step breakdown of how tax fraud and money laundering cases are initiated, investigated, and prosecuted.
2025 Annual Update for Governmental Accountants & Auditors
-
Webinar
3.00 Credits
Member Price: $189
Single Audit Updates Auditing & Accounting Yellowbook
Federal Tax Update - Individual & Business Current Developments
-
Webinar
8.00 Credits
Member Price: $300
Discuss the most recent individual and business income tax legislation passed to date Walk through major tax changes to corporations, partnerships and/or individuals and any changes to the income tax forms and other related schedules Review numerous business income tax provisions including but not limited to the 20% qualified business income (QBI) deduction; changes to NOLs, §461(l) business loss limitations, §163(j) business interest deduction limitations, accounting method changes, depreciation, retirement plans, fringe benefits and entertainment expenses Brush up on the individual and business income tax rates (e.g., income tax rates, capital gain tax rates, self-employment tax and alternative minimum tax (AMT), 3.8% net investment income tax) Discuss other individual income tax topics and changes to filing status, personal exemptions, itemized deductions, exclusions from income, adjustments to income and income tax credits (e.g., child tax credit and dependent care credit) Walk through the NEW final required minimum distribution (RMD) regulations Review other important IRS audit areas such as basis and at-risk limitations for S shareholders and partners, passive activity losses and real estate professionals and self-employment taxes
K2's Small Business Internal Controls, Security, and Fraud Prevention and Detection
-
Webinar
8.00 Credits
Member Price: $225
Common challenges associated with implementing appropriate internal controls in small business environments Fraud in small business environments Internal control options in small business accounting software Understanding the need for application controls and general controls
ACPEN Signature 2025: Annual Tax Update
-
Webinar
8.00 Credits
Member Price: $250
Federal tax changes and developments during 2025 and pending changes, including legislative, administrative and procedural changes Explore in detail the latest statutory, regulatory and judicial developments impacting tax issues
K2's QuickBooks for Accountants
-
Webinar
4.00 Credits
Member Price: $225
New features in QuickBooks Desktop and Online Enhancing internal controls in QuickBooks-based environments Improving financial and operational reporting when using QuickBooks and QuickBooks Online Best practices for setting up companies
Emotional Intelligence for Professionals: Mastering the Human Side of Success
-
Webinar
1.00 Credits
Member Price: $39
Emotions Relationships Emotional Intelligence Communication
K2's Introducing Artificial Intelligence To Human Resources Pros
-
Webinar
1.20 Credits
Member Price: $39
How to get started with AI Today's major AI platforms How to use AI tools AI risks that we must manage
Benford's Law and Other Digital Analysis Techniques
-
Webinar
1.80 Credits
Member Price: $79
Benford’s Law Digital Analysis Data analytics
Monthly Federal Tax Updates - January 2026
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Current individual tax issuesCurrent business entity tax issuesAny current tax legislation occurring during the periodOther issues affecting the profession, including IRS procedure, current cases, payroll, and other federal tax issues
Profitability Pricing: Boost your Bottom Line
-
Webinar
2.00 Credits
Member Price: $79
Competitive bids Achieving target profitability
Schedule C of Form 1040
-
Webinar
2.00 Credits
Member Price: $79
When Schedule C applies Cash v. Accrual method Typical business deductions Business vehicle expenses Section 179 and bonus depreciation
Optimize Your Staff's Performance
-
Webinar
4.00 Credits
Member Price: $129
The 4 perspectives of optimization The Two Circle Analysis. The What The How. The Leadership 10 The Fatal 13 5 thoughts for a healthy work environment
Fiduciary Accounting & Tax Planning for Estates & Trusts
-
Webinar
2.00 Credits
Member Price: $129
Fundamentals of fiduciary accounting Uniform Principal and Income Act Discretionary Power to Adjust Allocations between principal and income Trust accounting 3.8% Net Investment Income Form 1041 - Schedule I Section 645 Election Simple or complex trusts
Fundamentals of 1031 Exchanges 25-26
-
Webinar
8.00 Credits
Member Price: $329
Statutory framework for 1031 exchanges Business and investment property characterization Deferred exchange rules and techniques Exchange mathematics: boot, gain and basis Reporting for failed exchanges (over two tax periods) Improvement, reverse and non-safe harbor exchanges Partnership and TIC issues: IRC Sec. 761