CPE Catalog & Events
Mastering the Excel Lookup Functions
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:A review of the various lookup functions, beyond VLOOKUPLearn which lookup works best for your situationHow to apply the many lookup functionsDiscover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectivelyAn in-depth review of the following functions:VLOOKUP / HLOOKUPXLOOKUPMATCH / INDEXXMATCHINDIRECTFILTERSORT / SORTBYUNIQUEAn overview of some newer functions
Section 199A Deduction: Rules & Forms Reporting
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:A deep-dive look at the Section 199A flow-through entities deductionCalculation of qualified business incomeApplication to rental real estate - "safe harbor" rule and aggregation rulesSelf-rental rule for 199A compared to self-rental rule for passive activitiesDiffering impact on the sole proprietorship, partnerships and S corporationsForms reporting in Form 8995 and Form 8995-A199A flowchart
2024 Stand Out - How to Create a Unique Employer Brand
-
Online
1.00 Credits
Member Price: $39
Employer Brand Talent Management Future of Work Onboarding New Hires
The Controllers Role in Data Analytics and Big Data
-
Online
1.50 Credits
Member Price: $59
Accounting Finance Financial Statements
Introduction to Forensic Accounting
-
Online
1.50 Credits
Member Price: $59
Forensic Accounting Accounting Auditing Finance
The Dark Web & Cybersecurity for Tax and Accounting Pros
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this course include:Understanding the Dark WebDifferences between the Deep Web and the Dark WebPotential threats from the Dark WebCase studies of Dark Web exploitation in accountingStrategies for mitigating Dark Web threatsImplementing effective cybersecurity measuresRole of accountants in addressing Dark Web threats
2024 Managerial Accounting: Your Prescription for Better Decisions
-
Online
4.00 Credits
Member Price: $129
Target profit and Break-even analysis Relevant costs and decision-making Standard costs and variances Activity-based costing Segment reporting and analysis Budgeting
2024 S Corporation Essentials: Review & Update
-
Online
4.00 Credits
Member Price: $129
Recent tax legislation, rules, and developments impacting S-corporations S corporation shareholder basis in stock and debt Schedules K-2 and K-3 reporting Basis of indebtedness S corporation open account debt Limitation of deduction of losses AAA and distributions
Introduction to the Property & Casualty Insurance Industry
-
Online
1.00 Credits
Member Price: $55
The major topics covered in this class include:The unique regulatory world of insuranceDifferences from other industriesDifferences within the industryTypes of accountingInvolvement of specialistsTax considerations
2024 Partnerships/LLCs: Understanding Tax Basis Capital Accounts
-
Online
2.00 Credits
Member Price: $79
Discussion of the impact of the Section 199A flow-through entities deduction on partnerships and their partners The meaning of a “tax basis capital account” -- how do the financial accounting and tax capital accounts differ from one another How to determine a partner’s share of the partnership’s liabilities Distinguishing “recourse” loans from “nonrecourse” loans What are “qualified nonrecourse financing” loans and how they affect partners Review of the Sec. 704 “built-in gain or loss” rules and how they impact Schedule K-1 reporting
Diversity, Inclusion, Equity & Belonging
-
Online
1.00 Credits
Member Price: $39
Why should I be thinking about inclusion? Does racism impact my workplace at all? Where might I be vulnerable and unaware?
The Controller Function - Inventory Part 2 - Valuation, Inventory Methods and Inventory Fraud
-
Online
1.50 Credits
Member Price: $59
Accounting Finance Procurement Inventory
Feeling Stressed from Change & Uncertainty? How to Stay Positive when Things Get Tough
-
Online
1.50 Credits
Member Price: $69
Change management Leadership
2024 What's Changing in Risk Assessment
-
Online
2.00 Credits
Member Price: $79
Risk Assessment Internal Controls SAS 145
State Tax Nexus: Frequently Awkward Questions
-
Online
2.00 Credits
Member Price: $79
Frequently asked questions about income tax and sales tax nexus New developments Key factors in reviewing potential nexus consequences Nexus road trip to eight large states Tax impacts of remote work Free, multistate resources
Managing the Accounting Department
-
Online
4.00 Credits
Member Price: $159
Accounting Leadership Management
2024 All About Fraud - Examples, Prevention and Auditing
-
Online
4.00 Credits
Member Price: $129
Fraud Professional Skepticism Report To The Nation Fraud Schemes Prevention
2024 Comprehensive Estate Planning: Administration & Postmortem Strategies
-
Online
8.00 Credits
Member Price: $225
Introduction to Estate Administration How to Read a last will and testament Understanding the Entities Administration the Estate and Orderly Process The Probate process and the courts Special Issues in Estate Administration Postmortem Issues Regarding Income Taxation of Descendants and Estates Post Mortem Opportunities on the Estate Income Tax Return Available Post Mortem Estate Tax Elections Portability Election Disclaimers
2024 Individual Federal Tax Update
-
Online
8.00 Credits
Member Price: $225
Form 1040: Precise Tax Submissions Recent Tax Code Changes: Updated Filings IRC Sections Analysis: Understanding Tax Regulations Updates in Income Taxation: Compliance Assurance New Credits and Deductions: Maximizing Benefits Complex Income Issues: Tailored Strategies Itemized Deductions: Informed Client Benefits Health Considerations: Maximizing Financial Benefits Regulatory Shifts: Implications on Tax Strategies Tax Planning Strategies: Client Financial Success
Building Flexible Budgeting Models: Walking Through and Crunching The Numbers
-
Online
2.00 Credits
Member Price: $79
Budget defining, Budget cultures Tacticle budget issues Ideas for budget solutions and process solutions Understanding people in the budget process Communicating your budget to non financial types