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
10 Keys to Outstanding Service and More Referrals
-
TBD
4.0 Credits
Member Price: $129
Communicate more powerfully with clients and other CPA's by understanding human behavior • How to judge if your communication is effective in motivating someone • How to get someone to really hear you and how to really hear what someone else is “not saying.” • How to communicate so that someone will happily do what you want How to create trust and get people to like working with you – inside and outside the firm • The 3 most important keys for getting someone to feel rapport with you • Why rapport is so important, and how to use it to profit in your work • How to quickly solve problems with people once you have their rapport Secret techniques that super-successful communicators use • How to persuade people without them knowing they are being persuaded • How Ronald Reagan, Oprah and Bill Clinton are similar, and how you can tap into their "magical abilities." • The three most important keys all successful communicators use How outstanding service can lead to more promotions and/or client development • The art of getting more referrals and turning referrals into clients • Why great service is better for your business in the long run • How to know what’s most important to your client or boss—so you can focus on that
Mastering Partnership Basis: Inside and Outside Basis
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Explain the use of both "inside" and "outside” basis determination.How to calculate tax basis capital accounts, including when the entity is formed, including the impact of contributed property.Clarify the importance of partnership capital accounts and partnerships debt on partner's tax basis.Explanation of how basis is impacted distributions and by sale and/or liquidation of the partnership interest.Comprehensive example to illustrate the mechanics of the basis determination process.
Leaders Eat Last. Why? - 1 Hour Session
-
TBD
1.0 Credits
Member Price: $39
Why building trust is essential How trusting relationships makes us more effective Steps to build trust
Public Procurement Basics: Protecting the People's Money
-
TBD
2.0 Credits
Member Price: $79
Auditing & Accounting Yellowbook Uniform Guidance Public Procurement
Supervision/Management Competencies: An Ethical Approach
-
TBD
2.0 Credits
Member Price: $89
The major topics covered in this course include:Overview of Virtue EthicsMilgram and Zimbardo case studiesNavigating the transition from "Buddy to Boss"Self-Awareness and Regard for OthersSetting Standards and Analyzing PerformanceUnconscious BiasCommunication Skills
Tactics to Find Work Life Balance in a Complex World
-
TBD
1.0 Credits
Member Price: $55
The major topics covered in this class include:How to get more out of one's workHow to achieve greater balance between today's ever more demanding and complex demands of work without losing sight of what is important in daily routinesExample of how to develop and be challenged by your own personal bucket list
Revenue Recognition Topic 606 - Identify the Contract Part 1
-
TBD
1.2 Credits
Member Price: $39
Revenue Recognition
Global Internal Audit Standards (GIAS) Domain V - Part 1
-
TBD
2.0 Credits
Member Price: $79
Internal Audit Internal Controls Standards Institute of Internal Auditors
2025 EBP Update: Standards, Compliance, and Best Practices
-
TBD
2.0 Credits
Member Price: $79
EPB Auditing Yellowbook
Integrity, Objectivity and Judgment: Values in Action
-
TBD
1.0 Credits
Member Price: $55
The major topics covered in this class include:AICPA Code of Conduct: Integrity and ObjectivityCase Study: Mortgage crisis of 2007-2010Case Study: World Com
K2's Ten PDF Tips You Need To Know
-
TBD
1.0 Credits
Member Price: $39
Converting documents to the PDF format Editing PDF documents Securing PDF documents Extracting data from PDFs
K2's What's New With QuickBooks
-
TBD
1.0 Credits
Member Price: $39
Licensing issues Pricing updates New and improved features Transitioning from QuickBooks Desktop to QuickBooks Online
Revenue Recognition - Determine the Transaction Price - Part 1
-
TBD
1.2 Credits
Member Price: $39
Revenue Recognition Accounting
The Controllership Series - The Financial Close Process
-
TBD
1.5 Credits
Member Price: $59
Accounting Finance Financial Statements
Like-Kind Exchanges
-
TBD
2.2 Credits
Member Price: $79
Like-kind exchanges (LKE) Qualified third party intermediaries (QI)
S Corporation Checkup: Tax Issues & Forms Reporting
-
TBD
4.0 Credits
Member Price: $129
Discuss the calculation of basis when the entity is formed including the impact of contributed property Explain the importance of shareholder loans to the entity Uses a comprehensive example to illustrate the mechanics of the basis determination process Schedules K-2 and K-3 Discuss how basis is impacted by distributions of corporation property Explain how basis is impacted by sale/or liquidation of the S corporation interest S corporation losses and how they impact Form 1040 Schedule E reporting Show how to get from the Schedule K-1 information to the basis calculations Comprehensive example to illustrate the mechanics of the basis determination process
2025 Accounting & Auditing Update for Small Businesses
-
TBD
4.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Accounting Standards Updates (ASUs) that are most likely to impact small businesses.ASUs initiated by the Private Company Council (PCC).Alternative reporting options to GAAP including FRF for SMEs and IFRS for SMEs.Audit standards that small business auditors will need to implement.
K2's Next Generation Excel Reporting
-
TBD
8.0 Credits
Member Price: $225
Identifying weaknesses in traditional reporting processes Using leading-edge features in Excel to improve reporting practices How to work with Power Query to solve common reporting challenges Adding Slicers and Timelines to your Excel-based reports
S Corporations: Comprehensive walk through of Form 1120S
-
TBD
8.0 Credits
Member Price: $239
The major topics that will be covered in this course include:Subchapter S status election and compliance requirementsRelief for late Form 2553 filings under Rev. Proc. 2022-19Comparison of Rev. Proc. 2022-19 and Rev. Proc. 2023-3I.R.C. §1361 and §1362 analysis for S Corporation electionsCorporate governance and formalities complianceShareholder stock and debt basis rulesBuilt-in capital gains and other aspects of Form 1120SSchedules K-1, K-2, and K-3 preparation and reporting requirementsOfficer reasonable compensation: requirements, advisory strategies, and audit defensesS Corporation eligibility errors and corrective measures