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.
K2's Excel Charting And Visualizations
-
Webinar
4.00 Credits
Member Price: $129
Understanding the best types of visualizations to use in specific situations Creating compelling visualizations using Excel Adding interactivity to your Excel-based visualizations
The Art of Accountability: Effective Strategies for Tough Conversations
-
Webinar
1.00 Credits
Member Price: $39
Leadership Conflict management Accountability Employee engagement
The Controllership Series - The Role of the Controller in ESG
-
Webinar
1.50 Credits
Member Price: $59
Accounting Finance SG Operations
K2's Small Business Accounting Solutions And Add-Ons
-
Webinar
2.00 Credits
Member Price: $79
Current landscape of small business accounting software Strengths and limitations of critical solutions Effective add-ons and integrations Implementation strategies
Analytical Procedures: Practical Applications and Standards
-
Webinar
2.00 Credits
Member Price: $79
Analytical procedures in audit and review engagements Practical examples and illustrations of analytical procedures The order of operations for accomplishing analytical procedures
Cost and Pricing Models: Boost Your Bottom Line
-
Webinar
2.00 Credits
Member Price: $79
Cost Accounting Activity-based Costing
Defining Where and Why Internal Controls are Needed
-
Webinar
2.00 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
From Numbers to Narrative: Effectively Presenting Your Budget and Reporting
-
Webinar
2.00 Credits
Member Price: $79
Identifying the ‘Big Picture’ and your role in effective communication Communicating so others can understand us Understanding a presentation’s anatomy? Tips and tricks for budget presentations
Mission-Critical Leadership: How Smart Managers Lead Well in All Directions
-
Webinar
2.00 Credits
Member Price: $79
Leadership foundations Leading downward Leading upward Practical leadership tools
PFP Update: Income Tax, Retirement and Estate Planning 25-26
-
Webinar
2.00 Credits
Member Price: $99
The personal financial planning process Relevance to income tax Retirement and estate planning concerns and solutions
Guide to Deducting Travel, Meals and Entertainment Expenses
-
Webinar
4.00 Credits
Member Price: $129
Recent tax legislation, rules and developments impacting travel and meals expense reporting Adequate accounting rules for reimbursements, including accountable plans, going paperless, reimbursement for non-deductible expenses Reporting travel expenses: travel status, simplified per diem "Directly related to" and associated with" tests Facility vs. activity expenses 9 exceptions to Section 274 Business meals: IRS Notice 2018-76
Comprehensive Pass-Through Owners? Basis and Distribution Rules 25-26
-
Webinar
8.00 Credits
Member Price: $329
Understand the four loss limitation rules applied on the owner s individual income tax return (i.e., basis, at-risk, passive, and excess business loss limitations) Determine how to calculate an owners initial tax basis of his pass-through entity Learn how to correctly make annual adjustments to a pass-through owners tax basis Identify what constitutes a debt basis for an S corporation shareholder Learn the tax ramifications of repaying loans to S corporation shareholders
Leases: ASC Topic 842 in Depth 25-26
-
Webinar
8.00 Credits
Member Price: $329
FASB ASC 842, Leases All recently released updates to ASC 842, Leases
Social Security Basics and Strategies for Maximizing Benefits 25-26
-
Webinar
8.00 Credits
Member Price: $329
Social Security planning, benefit calculation, and beneficiaries Recent changes to "file and suspend" and "restricted application" strategies Increasing benefits for self-employed individuals Planning for surviving spouses Integrating retirement plan distribution strategies with Social Security claiming strategies Coordinating drawing Social Security benefits with the start of Medicare benefits, including a discussion of IRMAA
Titans Annual Federal Tax Planning: Business & Estate Update 25-26
-
Webinar
8.00 Credits
Member Price: $329
New law provisions and guidance and tax form changes affecting business entities, tax-exempts and estates and trusts with emphasis on details of relevant energy and research credits, loss limitation and any federal law changes in 2025 Key cases and IRS and FTB guidance affecting partnerships, LLCs, C corporations, and S corporations Employment taxes and worker classification matters Accounting method developments Tax credits updates Federal and California The state of California and multistate significant developments, including nexus and sourcing Expired and expiring provisions Inflation-adjusted amounts for 2026
Money Laundering 101 for CPAs
-
Webinar
4.00 Credits
Member Price: $149
The major topics covered in this class include:The theory of money launderingCommon money laundering statutesExamples from court cases of money laundering statutesCommon occurrences with CPAsPossible money laundering transactionsApplying the money laundering statutes in real life scenarios
Thrive Amidst the Chaos - 3 Steps to Increase Your Energy and Learn to Dance in the Rain
-
Webinar
1.20 Credits
Member Price: $39
Health and Wellness Burnout Stress Management Employee Engagement
Best-In-Class Recruiting Strategies
-
Webinar
1.00 Credits
Member Price: $39
Recruiting & Retention Talent Management Employee Engagement
Mastering Communication Skills for the CPA
-
Webinar
2.00 Credits
Member Price: $79
Pervasive best practices for effective communication Specific strategies for written materials Unique considerations for verbal presentations The importance of recursive revision Tips for success Pitfalls to avoid