CPE Catalog & Events
The 10 Must Know Excel Features
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.
Effective Governance for Nonprofit Success
-
TBD
1.0 Credits
Member Price: $39
Yellowbook Accounting and Auditing Nonprofit
Mastering IRS Form 7217: Partnership Property Distributions
-
TBD
1.0 Credits
Member Price: $55
The major topics that will be covered in this course include:Property distributions in liquidation of a partner’s interestSection 751 and its impact on property distributions from a partnershipMechanics of completing Form 7217 – new for 2024The Section 754 election and its role in partnership property distributions
The Controllership Series - Managerial Accounting Basics and Costs
-
TBD
1.2 Credits
Member Price: $39
Accounting Finance
The Controller Function - Strategic and Annual Planning
-
TBD
1.2 Credits
Member Price: $39
Accounting Finance Auditing
SECURE Act 2.0: What You Need to Know
-
TBD
1.0 Credits
Member Price: $29
Expanding Automatic Enrollment in Retirement Plans Increased Age for RMDs Higher Catch-up Contribution Limit Emergency Expense Penalty-Free Withdrawals “Starter” 401(k)s for Certain Employers Part-time Worker Improved Coverage
The Controllership Series - Sales, Collections and Customer Credit
-
TBD
1.5 Credits
Member Price: $59
Accounting Sales Collections
Avoiding Peer Review Deficiencies and Professional Liability in Public Accounting
-
TBD
4.0 Credits
Member Price: $129
Differentiating risks faced when performing various levels of professional services, such as audits, reviews, compilations, preparing financial statements, bookkeeping, tax return preparation, and similar Best practices for preventing quality control concerns that could lead to peer review deficiencies or malpractice claims Establishing an understanding with the client to minimize misunderstandings as to the nature and scope of engagements Explain situations when independence should be appropriately safeguarded when performing nonattest services
Federal Tax Update for Business with Doug Van Der Aa
-
TBD
4.0 Credits
Member Price: $129
"Tax-mageddon" - the all-important impending expiration/extension/renewal of the TCJA Other recent legislative, judicial, and IRS developments impacting business taxpayers Current status of Research and Experimentation costs and Interest Expense Limitation Phaseout of Bonus Depreciation and MACRS issues S corporation and partnership developments Other miscellaneous business developments
Digging Deep with Excel Pivot Tables
-
TBD
1.0 Credits
Member Price: $39
Data preparation and cleansing Pivot table creation Pivot table customization Navigating Excel’s PivotTable Analyze tab
Global Internal Audit Standards (GIAS) - Overview and Contrast to 2017 International Professional Practices Framework (IPPF)
-
TBD
1.6 Credits
Member Price: $79
Accounting Internal Controls Internal Audit Standards
Build Better Budgets: Fundamental Techniques
-
TBD
2.0 Credits
Member Price: $79
Advantages of budgeting The role of budgeting Master budgeting Flexible budgeting Standards and variances Capital budgeting
Bytes, Bias, and Balance: Data Ethics for Tech-Savvy Accountants
-
TBD
2.0 Credits
Member Price: $79
AI Auditing & Accounting Yellowbook
Common Sense CFO: Dealing with Ever Changing Accounting Standards and Strategy Demands
-
TBD
2.0 Credits
Member Price: $79
Understanding the modern finance and accounting organization chart GAAP accounting changes Why so many changes? The speed of change and complexity Accepting reality Recognizing and fixing the top five accounting problems and errors Leases Revenue Management estimates Why is strategy necessary? What is strategy? The two keys to strategy? Why do some financial leaders lack strategic skills? Balancing strategy with our day-to-day roles
K2's Taking A Fresh Look At Teams
-
TBD
2.0 Credits
Member Price: $79
How Teams got to where it is today Major components in Teams Collaboration options Extending Teams functionality
Tax Season Update for Business with Steve Dilley
-
TBD
4.0 Credits
Member Price: $245
Update on significant 2024-25 business tax developments and related cases and rulings Review of recent business tax provisions and their integration into tax forms Depreciation changes in Section 179 and Sec. 168(k) bonus depreciation Tax issues impacting "gig" workers, including Form 1099-K The details on what happened to the various "sunset" provisions of the 2017 tax act
Implementing an AI-Enabled Marketing Strategy for Your Firm
-
TBD
1.0 Credits
Member Price: $55
The major topics that will be covered in this course include:Module 1: Introduction to AI in Marketing The Basics of AI – Concepts and TerminologyModule 2: Leveraging AI Tools and Technologies Overview of AI Tools for MarketingModule 3: Practical Strategies for AI Integration Integrating AI into Your Marketing WorkflowModule 4: Measuring AI-Driven Marketing Effectiveness Key Metrics for Assessing AI-Driven CampaignsModule 5: Real-Life Case Studies and Success Stories Case Studies of Firms Successfully Using AI in MarketingModule 6: Developing Your AI-Enabled Marketing Strategy Creating a Custom AI Marketing Strategy
Preparing to be a Forensic Accountant - Focus on Computer Forensics - Part 3 (Steganography)
-
TBD
1.6 Credits
Member Price: $59
Forensic Accounting Accounting Auditing Finance
Fraud Unmasked: Understanding and Preventing White-Collar Crime with Dr. Richard G. Brody
-
TBD
2.0 Credits
Member Price: $79
Fraud Prevention Accounting Business Ethics
Devious Ethics: Avoiding Snakes in Suits
-
TBD
2.0 Credits
Member Price: $79
Discuss psychopathy's symptoms Review accounting professional ethics standards for dealing with a boss, co-worker or client who is breaking the rules Look at precautions you should take when considering a new boss or employee Help identify someone who might con you or your company