CPE Catalog & Events
Mastering the Excel Lookup Functions
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this class include:A review of the various lookup functions, beyond VLOOKUPLearn which lookup works best for your situationHow to apply the many lookup functionsDiscover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectivelyAn in-depth review of the following functions:VLOOKUP / HLOOKUPXLOOKUPMATCH / INDEXXMATCHINDIRECTFILTERSORT / SORTBYUNIQUEAn overview of some newer functions
Fringe Benefits & Compensation Planning - Today and Beyond
-
TBD
8.0 Credits
Member Price: $225
Fringe Benefit Planning Fundamentals Strategies Tailored for Business Owners and Employees Navigating IRC §132 Fringe Benefit Option Cafeteria Plans Demystified Tax Management in Compensation Planning Understanding the Implications of Dependent Care and Educational Assistance Plans Implementing Flexible Spending Account Plans Effectively Design Features and Regulations of Group Term Life Insurance Plans Medical Savings Accounts Regulations Financing Options for Retiree Medical Benefits Health Care Benefits: Insured Plan vs. HMO Comparison ERISA Reporting and Disclosure Requirements IRC Common Control RulesOverview of Age and Sex Discrimination Rules
Getting SASsy - A Look at Recent Auditing Standards
-
TBD
1.0 Credits
Member Price: $39
Revised audit report layout Various auditing standards that will soon be effective Selected-procedures engagements and other attestation developments
Introduction to Not-for-Profit Accounting
-
TBD
2.0 Credits
Member Price: $79
Not-for-Profit Accounting Accounting & Auditing Yellowbook
Data Extraction, Transformation, Validation the Right Data Sources for Analysis
-
TBD
2.0 Credits
Member Price: $79
Understand various data types Structured vs. unstructured data Completeness and validation testing Selecting the right data sources for the job Risks and pitfalls to avoid
Advanced Excel: Hidden Secrets and Gems
-
TBD
2.0 Credits
Member Price: $89
The major topics covered in this class include:Awareness of advanced functionsCreative methods for data manipulationUsing intellectual curiosity and professional skepticism to develop a problem-solving mentalityReal-life examples of innovative ways to analyze and report data with ExcelUsing Excel to perform e-mail mergesMany other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolboxEnhance creativity in your approach to developing Excel models
Cost and Pricing Models: Boost Your Bottom Line
-
TBD
2.0 Credits
Member Price: $79
Cost Accounting Activity-based Costing
Fraud Case Studies: 21st Century Professional Misbehavior
-
TBD
4.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Salient provisions the AICPA Code of Professional ConductExamination of actual fraudsDiscussion of internal controls that could have prevented or mitigated actual fraudsContemplation of epiphanies for your own professional scenarios.Implications for professional conduct and compliance with professional standards
K2's Technology For CPAs - Don't Get Left Behind
-
TBD
8.0 Credits
Member Price: $225
Emerging technologies all business professionals should know Considerations associated with upgrading to Windows 11 Practical options for protecting your data New features in commonly-used applications such as Excel and Adobe Acrobat DC
Navigating IRS Collections: The Collection Process
-
TBD
2.0 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.
CPA to CFO
-
TBD
1.0 Credits
Member Price: $55
The major topics that will be covered in this course include:The steps necessary to effectively transform a tax or accounting practice into an advisory service.What it means to be a CFO/advisor to small-to-medium sizes businesses.What qualifications are necessary to offer an advisory service.How to find and convert leads and how to price and package services, including combining advisory services with the firm’s current offerings.
The Controllership Series - Managerial Accounting Basics and Costs
-
TBD
1.2 Credits
Member Price: $39
Accounting Finance
K2's Small Business Accounting Solutions And Add-Ons
-
TBD
2.0 Credits
Member Price: $79
Current landscape of small business accounting software Strengths and limitations of critical solutions Effective add-ons and integrations Implementation strategies
Roadmap to Ethical Decision Making
-
TBD
2.0 Credits
Member Price: $79
Provide best practice tips and practical strategies for preserving independence when assisting clients with technical matters Discuss the principles of professional conduct Address compliance with professional standards Use case studies to address circumstances that may create threats to independence
Selected Ethics Topics - 2024 - 2025
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Stay in compliance with recent ethics standards changes that impact your practice.Learn about key regulatory changes and initiatives impacting CPAs and the future of the profession.Discuss emerging issues and standard-setting activity that could affect your practice in the future. Explore practical applications of the standards and hear about common practice issues and challenges. Examples include private equity, technology, tax planning, audit quality, regulatory enforcement and standard-setting environment.Learn how failure to follow the standards can result in unwanted regulatory actions and publicity.
Strategic Government Budgeting: Tools for Long-Term Sustainability
-
TBD
2.0 Credits
Member Price: $79
Forecasting & Budgeting Auditing & Accounting Yellowbook
Generative AI in Practice-Boost Efficiency and Profitability
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Implementing AI for accounting automationEnhancing auditing processes with AI toolsAI applications in tax complianceLeveraging AI for business advisory services
Digging Deep with Excel Pivot Tables
-
TBD
1.0 Credits
Member Price: $39
Data preparation and cleansing Pivot table creation Pivot table customization Navigating Excel’s PivotTable Analyze tab
Introduction to Single Audit
-
TBD
2.0 Credits
Member Price: $79
Single Audit Accounting & Auditing Yellowbook
Defining Where and Why Internal Controls are Needed
-
TBD
2.0 Credits
Member Price: $89
The major topics covered in this course include:Control design basicsAreas or segments of an enterprise to controlControls to reduce riskControls to drive operations