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.
Internal Controls for Small and Medium-Sized Entities
-
Webinar
1.00 Credits
Member Price: $39
Overview of controls Preventative controls Detective controls Controls for SMEs
Safety Synergy: Uniting Elements for a Secure Workplace
-
Webinar
1.20 Credits
Member Price: $39
How to evaluate physical security Increase situational awareness Simple De-escalation techniques Mental Health awareness Safe Termination Strategy Active Shooter Response Overview
K2's Time To Advance Automation - Strategies And Tools For Efficiency
-
Webinar
2.00 Credits
Member Price: $79
Advanced Automation Strategies: Best practices for starting or enhancing your automation journey Key Tools for Automation: Exploring the latest features in Zoho, Zapier, Microsoft, and other tools Practical Automation in Finance: Automating tasks in accounts payable, banking, and approval workflows Navigating Common Pitfalls: Identifying and avoiding typical obstacles in automation projects
Why Auditors Fail To Detect Fraud
-
Webinar
2.00 Credits
Member Price: $79
Reasons auditors fail to detect fraud Willful Ignorance SAS No. 82 Additional documentation How and who to talk to Determining the Tone At the Top How to Determining Intent If you expect it, you will see it
Better Business Writing: Improve Your Speed and Quality
-
Webinar
2.00 Credits
Member Price: $79
Writing Communications
ChatGPT and Advanced Financial Analysis for Accountants
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Financial Modeling with ChatGPT IntegrationAdvanced Ratio Analysis TechniquesRisk Assessment and Scenario AnalysisValuation Methods and ChatGPT ApplicationsUtilizing Performance Metrics in Financial AnalysisData Analysis and Interpretation with AIInvestment Analysis Enhanced by ChatGPT
Deep Dive into Common Auditing Deficiencies
-
Webinar
4.00 Credits
Member Price: $129
Auditing Yellowbook GAAS
Enterprise-Wide Risk Management in Accounting and Finance
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:Enterprise-wide risk management best practices for identifying, evaluating, and determining how to respond to relevant risks.The importance of risk and uncertainty disclosures in the preparation and fair presentation of financial statements, including evolving risks with cybersecurity and ESG.Coordinating risk management efforts, including the required involvement of corporate governance.How to embed risk management into day-to-day accounting and finance activities.
Federal Tax Update for Individuals with Doug Van Der Aa
-
Webinar
4.00 Credits
Member Price: $129
"Tax-mageddon" - the all-important impending expiration/extension/renewal of the TCJA Recent legislative, judicial, and IRS developments impacting individual taxpayers 2025 Tax rates and inflation-adjusted figures Cryptocurrency reporting and new Form 1099-DA Form 1099-K and previously unreported income Review of significant changes in individual tax forms Recent federal tax legislation, cases and rulings affecting income of individual taxpayers
Preparing and Reviewing Workpapers - Essential Tips for Avoiding Deficient Audit and Other Attest Engagements
-
Webinar
8.00 Credits
Member Price: $225
Best practices for documenting complex and subjective procedures and conclusions, such as estimates, substantive analytic procedures, etc. that impact the nature and extent of audit documentation needed to support audit conclusions Discussing the financial statement audit risk concept, including how proper application better ensures a higher quality audit Tips for an efficient workpaper review process that complies with relevant standards Understanding the quality control standards and guidance related to a CPA firm’s responsibilities for its system of quality control Explain the importance of establishing, applying, and monitoring quality control policies and procedures related to audit documentation
K2's Advanced Excel
-
Webinar
4.00 Credits
Member Price: $225
Collaboration and security techniques Tables, data models, and PivotTables Advanced formulas Data queries Creating effective visualizations
Strategies for Guiding Clients Through Challenging Situations: Tax Insights
-
Webinar
8.00 Credits
Member Price: $245
Tax considerations in divorce, including support obligations and property division Bankruptcy, debt cancelation, and financial hardship tax implications Tax treatment of cohabitation, premarital agreements, and exemptions Child support, alimony, and dependency issues Business dissolution and tax consequences Filing status options and tax rate comparisons Head of household qualifications and tax advantages Impact of refunds, deficiencies, and marital property rules
Navigating IRS Collections: The Collection Process
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of the IRS collection process.Taxpayer rights and the Taxpayer Bill of Rights.Collection due process and appeals.Installment agreements and offers in compromise.Wage garnishments, levies, and liens.Penalties and interest.
Preparing to be a Forensic Accountant - Focus on Computer Forensics - Part 3 (Steganography)
-
Webinar
1.60 Credits
Member Price: $59
Forensic Accounting Accounting Auditing Finance
Fraud Unmasked: Understanding and Preventing White-Collar Crime with Dr. Richard G. Brody
-
Webinar
2.00 Credits
Member Price: $79
Fraud Prevention Accounting Business Ethics
Preparation, Compilation and Review Engagements
-
Webinar
2.00 Credits
Member Price: $79
Auditing Yellowbook
Advanced Negotiations: Never Split the Difference
-
Webinar
2.00 Credits
Member Price: $79
Negotiations Business Management
K2's Excel Tips - Today's Best Features
-
Webinar
2.00 Credits
Member Price: $79
New features and functions in Excel How to improve efficiency and effectiveness when working in Excel Taking advantage of Copilot integration with Excel Better ways of creating and working with formulas
2024 Revision to Government Auditing Standards Impact
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:Key changes made by the 2024 Revision to Government Auditing StandardsReview when the GAGAS requirements are applicable to a financial statement auditWhen reporting on key audit matters may apply in a GAGAS auditClarifications related to the independence requirements in a financial statement audit imposed by the 2024 Yellow BookReview the impact of the Quality Management Standards to a financial statement audit conducted under the 2024 Revision to Government Auditing StandardsOther important matters contained in the 2024 Government Auditing Standards related to financial statement audits