CPE Catalog & Events
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
The Controllers Role in Data Analytics and Big Data
-
Webinar
1.50 Credits
Member Price: $59
Accounting Finance Financial Statements
Eight Biggest Threats to your business and introducing Three Pillars of Cybersecurity
-
Webinar
1.00 Credits
Member Price: $39
Technology Cybersecurity
K2's After QuickBooks, What's Next?
-
Webinar
1.00 Credits
Member Price: $39
Transitioning from QuickBooks Pro and Premier – challenges and opportunities Overview and comparison of leading accounting software solutions Implementation strategies and best practices for modern accounting platforms
Revenue Recognition - Recognize Revenue
-
Webinar
1.00 Credits
Member Price: $39
Revenue Recognition Accounting
Creating Terrific Equity Compensation Plans: Beware of the Pitfalls
-
Webinar
2.00 Credits
Member Price: $79
Why most equity compensation plans fail? Complexity of GAAP accounting for equity compensation plans Tax implications of equity compensation plans Who and how an equity compensation plan should be administered? Compliance issues to consider Recommendations to design a better equity compensation plan
Cryptocurrencies for the CFO: Explaining Blockchain
-
Webinar
2.00 Credits
Member Price: $79
What is money? What are digital assets? Understanding the what, why, and how of cryptocurrencies Understanding the what, why, and how of blockchain NFT’s (Non-Fungible Tokens), their role and impact Explaining the crypto language
Global Internal Audit Standards (GIAS) Domain III - Part 2
-
Webinar
1.00 Credits
Member Price: $79
Internal Audit Internal Controls GIAS Institute of Internal Auditors Standards Accounting
Peeking Behind the Curtain: Exploring IRS Audit Technique Guides
-
Webinar
2.00 Credits
Member Price: $79
Overview of ATGs Best practices for utilizing ATGs Salient provisions of selected ATGs Insights auditors may obtain from analytical procedures Nuances associated with selected industries
The Controllership Series - The Treasury Function Part 1 - Cash and Investing
-
Webinar
1.00 Credits
Member Price: $79
Accounting Finance Cash Investments
Real Estate Tax Issues: Passive Activity, Self-Rental and Section 199A
-
Webinar
4.00 Credits
Member Price: $129
Integration of the real estate professional rules with reporting on Form 1040, Schedule E Real estate professionals and indirectly owned (partnerships, S corporations) entity's reporting on Form 1040 How "real estate business" is interpreted under the Section 199A rules and how it integrates with the passive activity rules Real estate professionals and the Form 8582 (Passive Activities) How to make the "grouping" election for passive activities and the flow-through deduction Definition of self-rental property - both for Sections 199A and 469 Reporting using Form 1040, Schedule E, page 1 and 2 Self-rental property and the Form 8582 (passive activity)
Learning to Teach "Tax" as a Second Language
-
Webinar
1.00 Credits
Member Price: $39
Accounting as a foreign language Commonly misunderstood concepts Communicating tax matters Client-practitioner interactions Interacting with tax authorities
Change Management: Your Leadership Role for Aligning Profits & Culture
-
Webinar
2.00 Credits
Member Price: $79
Why professional agility is critical, and how to develop it Foundational models for change management Proven strategies to prepare for change as individuals, teams & organizations Implementing change: A how-to look Leading through change for success of all involved
Clean, Transform & Load Data in Power BI
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Introduction to Power Query in Power BI: Understanding the interface and basic functionalities.Data Cleaning Techniques: Removing duplicates, handling null values, and data type conversions.Data Transformation: Advanced methods for manipulating data, including pivoting, merging, and appending queries.Data Loading: Efficiently loading data into the Power BI data model.Document the Process Steps: Setting up details for each step in the process so you can document what is happening and why.
The Controllership Series - Financial Statement Preparation
-
Webinar
1.60 Credits
Member Price: $89
Accounting Finance Financial Statement Preparation
The Role of Internal Audit in Enterprise-Wide Risk Management
-
Webinar
4.00 Credits
Member Price: $129
Benefits of enterprise risk management Important objectives, components and principles that underlie the COSO Framework Identifying events that could cause objectives to not be achieved Techniques for evaluating both "good" risks (opportunities) and "bad" risks (threats) The roles and responsibilities of key parties throughout an organization in managing risk
2024 Revision to Government Auditing Standards Impact
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:Key changes made by the 2024 Revision to Government Auditing StandardsReview when the GAGAS requirements are applicable to a financial statement auditWhen reporting on key audit matters may apply in a GAGAS auditClarifications related to the independence requirements in a financial statement audit imposed by the 2024 Yellow BookReview the impact of the Quality Management Standards to a financial statement audit conducted under the 2024 Revision to Government Auditing StandardsOther important matters contained in the 2024 Government Auditing Standards related to financial statement audits
Tax Season Update for Individuals with Steve Dilley
-
Webinar
4.00 Credits
Member Price: $149
The major topics covered in this class include:2024/25 legislative developments, cases and rulings impacting individual taxpayersChanges to Form 1040 and other related forms, worksheets and schedulesIndividual income items, itemized deductions and creditsUpdated tax rate schedule and other inflation adjusted itemsImplications for self-employed taxpayers of various legislationSection 199A changes, including use of carryforward passive activity and 199A lossesCapital gains and lossesPassive activity and hobby loss rules changes
How Changes in Business Methods Affects Internal Control
-
Webinar
8.00 Credits
Member Price: $239
The major topics covered in this class include:How is business changing.What is driving the change and how long will it last.How specifically is an organizations control system important.What steps are needed to “keep up” with the upheaval.
S Corporations: Calculating Shareholder Basis
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Discuss the calculation of basis when the entity is formed including the impact of contributed propertyExplain the importance of shareholder loans to the entityUses a comprehensive example to illustrate the mechanics of the basis determination processSchedule K-1 Basis and Form 7203Discuss how basis is impacted by distributions of corporation propertyExplain how basis is impacted by sale/or liquidation of the S corporation interestDiscuss how S corporation losses impact Form 1040 Schedule E reportingShow how to get from the Schedule K-1 information to the basis calculations