CPE Catalog & Events
K2's 2023 Mastering Advanced Excel Functions
-
Online
4.00 Credits
Powerful new functions and features in Excel, such as XLOOKUP and Dynamic Arrays How to use “legacy” features and functions such as AGGREGATE Creating effective forecasts in Excel
Data & Predictive Analytics & Business Intelligence for Controllers/CFOs
-
Online
4.00 Credits
DA and BI relationship to accountant value. Current trends in BI and DA, including the emergence of AI tools like ChatGPT. The changing accountant roles: data analyst, data scientist, and data storyteller, with an emphasis on how ChatGPT can be utilized in these capacities. Obtaining datasets to compare and contrast with their organization's data, and how ChatGPT can assist in analyzing and interpreting this data. BI tools and the inclusion of AI technologies such as ChatGPT to streamline processes and improve analytical capabilities.
Audit 208: Audit Reporting Basics - Report Issuance Process
-
Online
2.00 Credits
The major topics covered in this course include:Objective of financial reporting and Inter-relationships of financial statements and disclosuresSpecial purpose framework financial statements and the impact on auditsTypes of audit reports, including reasons for modificationFinancial statement drafting and issuance processPerforming a final quality control check before report release
Surgent's Government and Nonprofit Frauds and Controls to Stop Them
-
Online
4.00 Credits
Examine real-world misappropriations of cash, check frauds, vendor scams, credit card abuse, grant frauds, benefit schemes, inventory thefts, and payroll frauds Consider and develop controls to stop fraud Tailor controls to the size and fit of the government or nonprofit
Small Firm Update
-
Online
0.00 Credits
Small firm finance trends Common pitfalls Best practices used across the country Q&A session
HR Guide to Evolving Business Strategy, Finance and Development
-
Online
1.20 Credits
Corporate Culture Strategic Planning Leadership Staff Development
Ethics in Today's World and Practical Application Tips
-
Online
2.00 Credits
Explore a time-line of business ethical issues and understand the "why's around their occurrence" Evaluate ethical theories Explore risk factors for identifying ethical situations Practical tips for profiling and dealing with ethical culture Practice you knowledge with real-life ethical scenarios
Accounting Fraud & Embezzlement: Case Studies from the Trenches
-
Online
2.00 Credits
Embezzlement Theft of public money Circumstances that allowed the fraud to occur
Introduction to Single Audit
-
Online
2.00 Credits
Compliance Federal Funds Single Audit
Excel - Auditing Your Spreadsheets for Maximum Accuracy
-
Online
2.00 Credits
The major topics that will be covered in this class include:Proofing techniquesExcel Auditing ToolsUsing the Data Validation featureTechniques to cross-foot and validate your spreadsheets
Surgent's Top 20 Effective Strategies for Avoiding RMD Mistakes and Penalties: Updated for the Proposed RMD Regulations, SECURE Act 2.0
-
Online
2.00 Credits
Who qualifies for the waiver of the RMD excise tax for 2021, 2022, and 2023? The rollover deadline for 2023 age 73 RMD Coverage of applicable provisions of SECURE Act 2.0 What is the required minimum distribution for an account owner? What is the required minimum distribution for a beneficiary IRA? Key explanations of RMD regulations The types of accounts that are subject to the required minimum distribution rules The parties that are subject to the required minimum distribution rules Exceptions and special considerations for required minimum distributions Rollover and transfer rules in an RMD year The various responsibilities for interested parties Qualified charitable distributions and how they are coordinated with RMDs and IRA contributions How the 10-year rule works for certain beneficiaries
Balance Sheet Management: The Least Understood Risk
-
Online
4.00 Credits
Understanding your balance sheet Analyze your balance sheet today and in the future Plan your balance sheet structure Properly balance debt and equity versus other funding sources Know the balance sheet pitfalls and risks to avoid Understand your cost of capital Interpret your cost of capital Evaluate the risks, pros and cons of debt Know how to raise debt Understand the risks, pros and cons of equity Examine alternative methods to raise financing Understand the decision process through real-world examples
K2's 2023 Microsoft 365/Office 365 - All The Things You Need To Know
-
Online
8.00 Credits
Understanding the Microsoft 365/Office 365 subscription model Working with vital 365-based apps and services Using Teams as your primary collaboration tool Taking advantage of lesser-known features and services in a Microsoft 365/Office 365 subscription
Ethical Performance Management
-
Online
2.00 Credits
The major topics covered in this class include:Definition and Benefits of Ethical Performance ManagementSetting Standards/Goal settingPreparing and Conducting the Appraisal InterviewLegal Considerations in Performance ManagementAvoiding Rater BiasFeedback and Coaching
Common Yellow Book & Single Audit Deficiencies - 2023
-
Online
4.00 Credits
ICOC Compliance Testing Major Program Determination
K2's 2024 Improving Productivity With Microsoft 365/Office 365 Cloud Applications
-
Online
4.00 Credits
Understanding the Cloud-based options available in a Microsoft 365/Office 365 environment How to use tools such as Teams, Planner, and Power Automate Storing data in SharePoint Online and OneDrive for Business
Tactics to Find Work Life Balance in a Complex World
-
Online
1.00 Credits
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
K2's 2023 Microsoft Teams
-
Online
4.00 Credits
Understanding the Teams platform Communicating and collaborating in Teams Adding applications and services to Teams Extending Teams to individuals outside your organization
GAAP Alternatives: The Perfect Storm of Accounting Updates
-
Online
1.00 Credits
The major topics covered in this class include:Review of special purpose frameworksDiscussion of non-GAAP options for financial reportingU.S GAAP alternatives for certain entities
VSCPA Tax Series Webinar
-
Virtual
2.00 Credits
TBD