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
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
Communication Miracles At Work and In Life - Part 1
-
Webinar
1.00 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
K2's Business Intelligence, Featuring Microsoft's Power BI Tools
-
Webinar
8.00 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
-
Webinar
1.00 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
-
Webinar
1.00 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
-
Webinar
1.00 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!
-
Webinar
2.00 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
-
Webinar
2.00 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
-
Webinar
2.00 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
-
Webinar
2.00 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
-
Webinar
2.00 Credits
Member Price: $79
AU-C 240 Auditing Yellowbook
AI Privacy, Security, and Compliance Masterclass
-
Webinar
2.00 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
Surgent's Understanding Partnership Taxation: PTE Elections, 754 Elections, and Selling a Partnership Interest
-
Webinar
2.00 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
-
Webinar
2.50 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
-
Webinar
4.00 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
-
Webinar
2.00 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)
-
Webinar
8.00 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
2025 Business Federal Tax Update - Navigating the Current Tax Landscape
-
Webinar
8.00 Credits
Member Price: $225
Thorough exploration of essential IRC Sections pertinent to business income taxation Comprehensive assessment of recent changes and updates in business taxation Examination of business changes arising from significant legislative updates Analysis of pertinent tax code sections, including Section 199A Addressing tax considerations for various business schedules (C, F, and E) Navigating partnership, corporation, and LLC taxation issues Unpacking the complexities of COVID-19-related subsidies and their tax implications Interaction of Code Section 461(l) with Section 382 and carryover rules Understanding defaulted loans, bankruptcy implications, and their tax treatment Grasping the impact of the CARES, HEROES, and HEALS acts on business income taxation Special rules governing the business use of a home Reporting requirements for converting personal use property to business use
ACPEN Signature 2025: Accounting & Auditing Update
-
Webinar
3.00 Credits
Member Price: $250
FASB Statements and Interpretations Statements on Auditing Standards and Statements on Quality Management Standards Ethics Interpretations