CPE Catalog & Events
How AI Fits into the Accounting World 26-27
-
TBD
2.0 Credits
Member Price: $99
An overview of AI constructs. How artificial intelligence is being used by accountants today. Accounting-centric AI developments on the horizon.
Smart Formula Selection in Excel: What to Use When
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this class include:Introduction to Strategic Formula Use:Why choosing the right formula matters: clarity, performance, and maintenanceCommon traps: overusing IF, defaulting to familiar tools, ignoring modern functionsHow Excel offers multiple ways to solve the same problem and how to pick wiselyConditional Logic and Branching Tools:IFS vs SWITCH vs nested IF: comparing readability and structureWhen to simplify logic and how to avoid nested nightmaresSummarizing Data:SUMIFS vs SUMPRODUCT: multiple conditions, weighted sums, totalsFiltering and Output Control:FILTER vs IF + INDEX: dynamic data extraction with vs without Excel 365Trade-offs in backward compatibility and ease of useCustom Output and Decision Trees:CHOOSE vs SWITCH vs LOOKUP: logic trees and category mappingEmbedded Variables and Reusability:LET vs named ranges: clarity and efficiency for long formulasUsing LAMBDA with LET to create custom functionsSimplifying and documenting complex calculationsBest Practices for Formula Selection:Criteria for deciding: readability, flexibility, future maintenanceTips for avoiding overengineering and formula bloat
Surgent's Annual Update for Defined Contribution Plans
-
TBD
1.0 Credits
Member Price: $99
Common risks and pitfalls associated with defined contribution plans Nuances of the fair value disclosures New reporting and disclosure requirements for the current year Results of DOL Audit Quality Study
Surgent's Section 754 Step-Up in Basis: Understanding the Tax Issues for Partnerships and LLCs
-
TBD
2.0 Credits
Member Price: $99
How and why a partnership makes a 754 election The effect of the 754 election when an interest in a partnership is sold or inherited How the 754 election applies when a partnership makes a distribution of property to one or more of its partners How to make the 754 basis adjustment
ACPEN: Mastering Rapport Skills for Fun and Profit
-
TBD
4.0 Credits
Member Price: $149
1. How to get people to like you What leads to people liking each other Why people judge you, and how to avoid negative judgments What goes on when we first meet someone How to put someone at ease 2. The Elements of Trust Why we trust someone, and how you can create trust What leads to a "special bond" How to repair "broken trust" How to establish trust in just a few minutes 3. Mastering Non-Verbal Communication Why non-verbal communication is so important How to connect with someone in a non verbal manner How to create trust and rapport through non verbal means 4. What to Say to Establish Immediate Rapport The most effective way to instant intimacy How to handle your fear of rejection How to feel immediately confident when talking to anyone How to get almost anyone to really like you through the use of questions
Create Measures in Power BI that Define Your Metrics
-
TBD
0.0 Credits
Member Price: $149
The major topics that will be covered in this class include:Introduction to DAX: Understanding the fundamentals of DAX and its role in Power BI.Advanced DAX Formulas: Delving into complex DAX functions and formulas for creating sophisticated measures.Time Intelligence in DAX: Exploring time-based functions to analyze data over different periods.Validating Measures with DAX: Techniques for ensuring accuracy and reliability in your DAX measures.Using PivotTables for Measure Validation: Employing PivotTables in Power BI to test and confirm the effectiveness of DAX measures.
ACPEN: K2’s Excel Essentials For Staff Accountants
-
TBD
8.0 Credits
Member Price: $250
Best practices for creating and working with Excel workbooks Effectively using Excel functions when creating formulas The importance of PivotTables in modern reporting environments Best practices for formatting your workbooks
Microsoft 365 Application Lightning Round Review-Updated
-
TBD
0.0 Credits
Member Price: $55
The major topics covered in this course include:Lightning round review of the following apps, with an explanation and demonstration of what each of them offersTeams - the foundation of all that you do in Microsoft 365SharePoint / OneDrive - secure cloud storagePower BI - the new financial reporting modelStream - the YouTube for your organizationBookings - streamline your appointment scheduling OneNote - get your content organized for quick retrieval Lists - create custom list tracking reportsTo Do - consolidate all your Outlook, Planner and general "to do's" in one appPlanner - manage simple and complex engagements and projects in an intuitive appA quick look at many of the remaining apps
How AI Fits into the Accounting World
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this course include:An overview of AI constructs.How artificial intelligence is being used by accountants today.Accounting-centric AI developments on the horizon.
ACPEN: A Strategic Approach to Understanding Compensation Structures
-
TBD
1.5 Credits
Member Price: $79
Compensation
ACPEN: Benford’s Law and Other Digital Analysis Techniques
-
TBD
1.8 Credits
Member Price: $79
Benford’s Law Digital Analysis Data analytics
ACPEN: GASB 96 –SBITA, GASB 94 P3, and GASB 87 Leases (Year 2)
-
TBD
2.0 Credits
Member Price: $89
Requirements of GASB 96, GASB 94, and GASB 87 Implementation of GASB 96, 94 and 87
ACPEN: HR’s Role in Business Evolution: Strategy, Finance, and Growth
-
TBD
2.0 Credits
Member Price: $89
Corporate Culture Strategic Planning Leadership Staff Development Use of Generative AI
ACPEN: Navigating IRS : Responding to IRS Notices & Letters
-
TBD
2.0 Credits
Member Price: $89
Types of IRS letters: audits, collection, balance due, unreported income How to respond to CP2000, CP14, CP75, CP504, and other notices Steps to take upon receiving a letter: deadlines, records, prep Penalties and interest associated with non-response Sample response structure and real-life examples Documentation and tracking practices for correspondence Common mistakes and how to avoid them AI-supported correspondence management and ethical considerations
The Current and Future Landscape of Audit Technology
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Explore the transformative impact of technology on the audit profession in this forward-looking courseGain practical insights into cutting-edge tools and trends, including data analytics, artificial intelligence (AI), and automationNavigate the evolving audit landscape with confidence and adaptability
ACPEN: Global Internal Audit Standards (GIAS) Domain IV - Part 1
-
TBD
1.2 Credits
Member Price: $99
Internal Audit GIAS Standards Institute of Internal Auditors Accounting Auditing
ACPEN: Data Analytics & Journal Entry Testing for Auditors
-
TBD
3.5 Credits
Member Price: $109
Data Analytics Journal Entry Testing Fraud Detection
ACPEN: The Essential Guide to Understanding Private Company Financial Statement Disclosures with Renee Rampulla
-
TBD
4.0 Credits
Member Price: $149
Common Private Company Accounting Policy Disclosures Numerous Sample Lease and Revenue Disclosures Unique OCBOA Disclosure Requirements and examples Research Techniques
Comprehensive Accounting and Financial Reporting Update
-
TBD
0.0 Credits
Member Price: $149
The major topics covered in this class include:CECL for nonfinancial institutions.Accounting for Paycheck Protection Program loans.Accounting for web-hosting services.Revenue recognition.Leases.FASB projects in progress.
Leadershift: Drive Results Through Ethical Performance Mgmnt
-
TBD
4.0 Credits
Member Price: $149
The major topics that will be covered in this course include:How Inspirational leadership is the foundation that ethically drives results.Simplify the complex: Walk through the Results Model and discover practical how-to examples of execution.Hacks for getting great results with specific examples you can leverage in your business:The How: Empower your people to feel like an owner, managing difficult conversations well, leading with empathy and what that looks like, how it should feel, motivational coaching techniques to get your employee relationships back on track, and unleashing the power of appreciation and gratitude.The What: Powerful score-carding, transformational goal-setting conversations, and positive accountable follow- up.