CPE Catalog & Events
Taking Advantage of Array Formulas in Excel
-
TBD
2.0 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
Communication Miracles At Work and In Life - Part 1
-
TBD
4.0 Credits
Member Price: $129
1. Why people behave as they do, and how you can effectively motivate anyone to cooperate with you How to judge if your communication is effective in motivating someone How to get someone to really hear you How to communicate so that someone will happily do what you want 2. How to create trust and get people to like working with you 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 3. How to handle difficult people Why some people are difficult to deal with, and what you can do about it How you can turn a difficult employee or customer into a powerful asset How to easily solve problems with people who are upset at you 4. Secret techniques that super-successful communicators use How Ronald Reagan and Bill Clinton are similar, and how you can tap into their "magic abilities" The three most important keys all successful communicators use
Forensic Accounting: Crafting Expert Reports
-
TBD
4.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Introduction to Forensic Accounting: Gain an understanding of the fundamentals, roles, and responsibilities of forensic accountants in uncovering financial discrepancies, fraud, and economic damages.Maintain Ethical Integrity: Learn the importance of ethics in forensic accounting and strategies for ethical decision-making.Expert Report Preparation: Learn the essential components, best practices, and common pitfalls in writing clear, concise, and objective expert reports for legal proceedings.Investigation Report Writing: Explore the methodologies for conducting investigations, gathering evidence, and crafting thorough and accurate investigation reports.Economic Damages Writing: Understand the methodologies and best practices for calculating economic damages, including lost profits, business valuation, and other financial impacts.Reviewing Investigation Reports and Economic Damages: Analyze real-world examples to review and critique investigation reports and damage calculations, highlighting key insights and lessons learned.
K2's Business Intelligence, Featuring Microsoft's Power BI Tools
-
TBD
8.0 Credits
Member Price: $225
The importance of Business Intelligence in today’s business climate Differentiating between Power BI licensing options A hands-on approach to creating effective Power BI reports and dashboards
K2's Harnessing ChatGPT - Unlocking Professional Efficiency
-
TBD
1.0 Credits
Member Price: $39
Leveraging prompt engineering in ChatGPT for various accounting tasks Exploring the applications and limitations of ChatGPT in accounting Empowering efficiency for everyday accounting tasks
K2'S Supercharging Your Spreadsheet Collaboration
-
TBD
1.0 Credits
Member Price: $39
Collaboration methods using Microsoft Office and Microsoft 365 Ways to track changes to sheets and compare different versions of a file Tools for sharing and responding to comments among a team from within a file
Performance Management
-
TBD
1.0 Credits
Member Price: $39
Setting and resetting performance expectations On-the-spot counseling Addressing erratic performance Drafting and presenting performance appraisals
Awesome Business Lessons from the Past: Learn from the Best!
-
TBD
2.0 Credits
Member Price: $79
The six methods to get others to like you How to learn what others want What are twelve ways to win others to your way of thinking? How to destroy your enemies What are the fundamental principles of Henry Ford’s success? Focus on technology, training and ‘Scientific Method’ Value of training and education The need for fun What are the thirteen steps necessary to plan for success? All plans must adjust to changing realities What are the traps to avoid? How to use these principles to move your organization forward
K2's Accounting Solutions And Add-Ons For Small Businesses
-
TBD
2.0 Credits
Member Price: $79
Overview of small business accounting solutions Strengths and shortfalls of various accounting and add-on solutions
Liquidity & Uncertainty Disclosures for Nonprofits
-
TBD
2.0 Credits
Member Price: $79
Required disclosure related to liquidity and other significant uncertainties for fair presentation of financial statements Evaluating the need for going concern and other uncertainty disclosures in the current environment
Accounting Update in a Post COVID-19 World
-
TBD
2.0 Credits
Member Price: $79
Risk assessment Government assistance Pandemic-related accounting pronouncements Learning to be an auditor in a pandemic environment Financial statement disclosures Exploring liquidity options
Considerations of Fraud
-
TBD
2.0 Credits
Member Price: $79
AU-C 240 Auditing Yellowbook
AI Privacy, Security, and Compliance Masterclass
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Introduction: What is AI Security, Privacy and Compliance (AISPC)?Why AI Security, Privacy and Compliance (AISPC) is Increasingly Important for AccountantsAISPC Policy Best PracticesKey Tactical Questions for Addressing Data Security and PrivacyOpenAI and Compliance with Government RegulationsOpenAI and Two-Factor AuthenticationOther OpenAI Security, Privacy and Compliance ConsiderationsBest Practices for Secure Data Sharing with GPT How to Create a GenAI and ChatGPT Usage Policy for Your OperationsGeneral AI Policy Do’s and Don’tsAI Copyright Compliance & Protection GuideDeepfakes and Synthetic Media: A New Frontier for Fraud and MisinformationFrom Financial Oversight to AI Governance: The Sarbanes-Oxley Legacy and Accountants' New Frontier in AI Security, Privacy, Compliance and EthicsKey Takeaways
Let's End Business Ethics
-
TBD
2.0 Credits
Member Price: $79
Ethics defined Are there business ethics? How to identify ethical issues Deciphering your ethical code Why ethical behavior is good for your business How to make ethical decisions
Surgent's Ethics for Tax Professionals
-
TBD
2.0 Credits
Member Price: $99
What does practicing before the IRS mean? Who may practice before the IRS? What should a tax preparer do if he or she has knowledge of a client's omission of income from a tax return? May a tax preparer rely on the work of other tax return preparers? May a tax preparer rely on and use client-provided information? Standards associated with giving advice to clients Abolition of the disclaimer requirement When must a tax preparer examine a client’s books and records?
Surgent's Understanding Partnership Taxation: PTE Elections, 754 Elections, and Selling a Partnership Interest
-
TBD
2.0 Credits
Member Price: $99
Notice 2020-75: PTE elections What is a 754 election? What if a 754 election is not in effect? Tax implications of a partnership interest sale on the seller Look-through provisions
Taxation of Business Entities
-
TBD
2.5 Credits
Member Price: $79
Types of business entities (Sole proprietorship, Partnership, Corporation, Limited Liability Company and Limited Liability Partnership) Considerations in choosing a business entity, including taxes, limited liability protection, management & control, funding options & opportunities, tax consequences for the owners and the business. Future tax considerations that will impact various business entities.
Financial Statement Presentation and Disclosure
-
TBD
4.0 Credits
Member Price: $129
U.S. GAAP and Special purpose frameworks Form and content of financial statements: Balance sheets Income statements; Statements of cash flows Retained earnings and/or owners’ equity statements Comprehensive income Supplementary information Comparative vs. single-period financial statements Sufficiency of disclosures Illustrative disclosures frequently encountered in small-to-medium reporting entities Industry-specific nuances
The Art of Marketing for CPAs
-
TBD
4.0 Credits
Member Price: $129
Why marketing and self promotion are so important today What keeps people from learning this skill, and how to overcome those obstacles How to get people (your boss, co-workers or clients) to like working with you How to sell someone on your services in a single minute How to attract more clients or the attention of your boss in a way that "wows" them How to get referrals from your clients or glowing reviews from your boss The 3 communication skills every business person needs to master, and why The 3 principles that really lead to more success in the business world, and how you can use those principles for you company and career
Hands-On Tax Return Workshop - Partnerships & LLCs (Form 1065)
-
TBD
8.0 Credits
Member Price: $300
Extensive review of the partnership income tax laws with an emphasis on any new legislative changes Comparison of partnerships, LLCs and LLPs Overview the formation of a partnership/LLC and the §704(c) pre-contribution gain or loss rules Schedule K analysis– determine if income statement items are separately (i.e. schedule K) or non-separately stated income and expense items How schedule K items get allocated to partners on schedule K-1s Look at detailed Schedule K-1 information reporting to partners needed for the qualified business income (QBI) deduction, 3.8% net investment income tax and business interest expense limitations Learn the special tax treatment of fringe benefits paid on behalf of the partners and LLC members Comparing the tax and §704(b) book capital account computations Discuss partner guaranteed payments and self-employment tax issues Schedule M-1 – reconciliation of income or loss per books with income or loss per income tax return Schedule M-2 – analysis of partners’ capital accounts Review the importance and basics of calculating a partner/member’s outside tax basis. Overview of the tax treatment of distributions, recourse and nonrecourse debt allocations, §754 election for optional basis adjustments and §743/§734 mandatory basis adjustments