CPE Catalog & Events
K2's Accessing Your Company's Data With Power Query And Power BI
-
Webinar
2.00 Credits
Member Price: $79
Utilizing Power Query to access data from the web, spreadsheets, folders, and databases Using Power Query to perform various transformations to clean up data before importing it to Power BI or Excel Producing various reporting documents from data delivered from Power Query
Business Intelligence (BI) and Business Analytics (BA)
-
Webinar
2.00 Credits
Member Price: $79
The Rise of Business Intelligence (BI), Business Analytics (BA), and Big Data Why the interest in BI and BA? The analytics continuum How BA can provide a competitive advantage The difference between BI and BA The difference between forecasting and predictive analytics Fundamentals of analytical techniques Examples for the CFO and accounting function Benefits from applying analytics The impact of artificial intelligence (AI) on the accounting profession
Taking Advantage of Array Formulas in Excel
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Introduction to Array Formulas: This segment establishes the foundation by differentiating array formulas from regular Excel formulas and explaining their significance.Using Array Formulas: This section focuses on the practical application of array formulas, teaching participants how to effectively implement and utilize these formulas in a variety of common Excel tasks and scenarios.Dynamic Arrays and Spill Functions: This part covers the utilization of dynamic arrays and spill functions, highlighting their role in modern Excel data handling.Advanced Array Functions: Participants will delve into complex functions such as SUMPRODUCT, UNIQUE, SORT, and FILTER, focusing on multi-condition summing and data management.Using Array Constants: This section teaches how simplify the use of static values called Array Constants
Preparing and Reviewing Workpapers for Higher Quality Audits
-
Webinar
4.00 Credits
Member Price: $129
The primary purpose of workpaper documentation, and minimum documentation requirements for workpaper preparers 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
Business Consulting for CPAs
-
Webinar
4.00 Credits
Member Price: $129
What is Business Consulting? Identify the types of Management services your firm could offer. How to become the trusted advisor – identification of client’s needs? Learn how client expectations may create different performance and understanding levels for CPAs in business consulting engagements. Know what it takes to create a valuable outcome for the client. Understand the competitive advantages/disadvantages that your firm has versus non-CPA business consultants. Learn techniques to become a more effective consultant. Professional standards application
K2'S Artificial Intelligence For Accounting And Financial Professionals
-
Webinar
4.50 Credits
Member Price: $129
Exploring AI applications in accounting and finance Understanding AI features in everyday tools Embracing the future: AI's impact on finance and accounting
Forensic Accounting: Investigating Divorce Cases
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:The role of a forensic accountant in divorce proceedingsThe marketing of forensic accounting services to family law attorneysHow to conduct a financial investigationCommon areas to uncover hidden assets or incomeThe basic calculations in evaluating marital assetsTestifying in depositions and divorce court
LLC's & S Corps -- A Comparative Analysis
-
Webinar
4.00 Credits
Member Price: $129
Comparative analysis of LLCs and S Corporations Entity formation, compliance, and operational structures Self-employment tax and its implications for LLCs and S Corporations Form 2553 preparation and relief for late filings Rev. Proc. 2022-19 and Rev. Proc. 2023-3: analysis and application S Corporation eligibility errors and corrective measures Corporate governance and formalities for both entity types Shareholder stock and debt basis for S Corporations Forms 1120S, 1065, and related schedules (K-1, K-2, K-3) Officer reasonable compensation and general partner guaranteed payments Audit strategies, estate planning, and business continuation planning
How to Get a Better Return on Financial Statement Audits - Avoiding the Most Misapplied Risk-Based Audit Concepts
-
Webinar
8.00 Credits
Member Price: $225
Properly assessing inherent, control, and fraud risk on an engagement, and linking the results to an appropriately tailored detailed audit plan based on risk assessment and client service goals, regardless of entity type (for-profit, nonprofit, governmental) Leveraging strong substantive analytic procedures as audit evidence to cut back on tests of details The most common efficiency opportunities for tailoring your audit approach based on risk How to use the workpaper review process as a tool for producing a more effective and efficient engagement Using audit documentation to enhance audit quality, while ensuring every workpaper has a purpose How to use the client to your advantage in planning and performing the audit Learn how to get the engagement out the door – on time and on budget!
Taxation of the Cannabis Industry
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Industrial hemp vs. marijuana.Income definitions under I.R.C. §61.Tax code restrictions: §280E and §471.State-specific marijuana laws.Cash management in cannabis businesses.Federal court case analysis.
HR's Role in Business Evolution: Strategy, Finance, and Growth
-
Webinar
1.20 Credits
Member Price: $39
Corporate Culture Strategic Planning Leadership Staff Development Use of Generative AI
K2'S Tech Update
-
Webinar
2.00 Credits
Member Price: $79
Trends in AI and machine learning Applications of quantum computing in accounting and finance The growing role of blockchain and digital currencies in accounting Innovations in software and hardware
Single Audit Requirements for California Non-federal Entities 25-26
-
Webinar
2.00 Credits
Member Price: $99
Review of state law nonprofit audit requirements. Unique Single Audit requirements for California charitable corporations.
Inventory Observation - Cretaceous Conservatory Simulation
-
Webinar
3.00 Credits
Member Price: $99
Obsservation Auditing
Surgent's Introduction to Forensic Accounting
-
Webinar
4.00 Credits
Member Price: $159
Review of the different aspects of forensic accounting The civil litigation process as it relates to forensic accounting Litigation services provided by forensic accountants Fraud detection and prevention Various types of fraud Training and certifications in forensic accounting Forensic accounting in bankruptcy proceedings Forensic accounting in family law proceedings Calculating damages for use in litigation Valuations Ethical issues pertinent to forensic accounting
Reasonable Compensation for S Corps
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Explain the payroll tax advantage of taking distributions over wagesReview key court cases that shape todays reasonable compensation landscapeHow to use court factors to stress test reasonable compensationBest practices for determining reasonable compensationReview of the IRS’s enforcement on reasonable compensation; past, present and future
Building a Better Budget in a Time of Uncertainty
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this class include:Budgets vs. ForecastsCyclicalityCore Earnings & Sustainable GrowthIdentifying Key Forecast DriversReasonableness in ForecastingApproaches to BudgetingBudgeting VariancesHorizontal AnalysisFlexible Budgeting
Internal Controls Over Compliance vs Compliance
-
Webinar
1.00 Credits
Member Price: $39
Compliance Supplements Yellowbook Accounting
Surgent's Weekly Expert Hour
-
Webinar
1.00 Credits
Member Price: $59
Each week’s topics will change based on the most critical issues affecting financial professionals
K2's Advanced Collaboration Solutions
-
Webinar
2.00 Credits
Member Price: $79
Enhanced Portals for Collaboration: Including PBC and 1040 workpaper integration Modern Payment Solutions: Understanding and integrating various payment options into your portal Effective Use of eSignatures: Streamlining processes and ensuring compliance Feature Checklist for Collaboration Tools: What to look for in the latest technology