CPE Catalog & Events
Finding Errors in Excel Spreadsheets
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Understanding Common Excel Errors: Gain insights into the most common types of errors encountered in Excel, including formula errors, reference errors, and logic errors.Advanced Formulas and Functions: Learn to use advanced Excel functions and formulas that are crucial for error detection and data analysis.Data Validation Techniques: Master the art of data validation to prevent errors before they occur. This includes setting up data validation rules and using conditional formatting to highlight potential inaccuracies.Error Tracing and Auditing Tools: Delve into Excel's auditing tools to trace and fix errors. Learn to use Trace Precedents, Trace Dependents, and the Error Checking tool effectively.
Assessing Independence Under the New Yellow Book
-
Online
1.00 Credits
Member Price: $39
Independence Threats Safeguards
Cultural Transformation
-
Online
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:What is culture Why culture matters A process to change your organization’s culture
2024 Business Tax Update for Industry
-
Online
2.00 Credits
Member Price: $79
Recent Federal legislative, rules and tax developments impacting business taxpayers Impact of Inflation Reduction Act on business Depreciation rules and developments Business losses and interest expense Latest legislative, judicial, and IRS developments
Shortcuts that Excel Users Love
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this course include:The power of keyboard shortcutsOft used features with more capability than meets the eyeNew helpful featuresNote: This session is taught using Hands-On methodology. We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor.
Surgent's The Art of Delegation: Strategies for Improving Your Skills
-
Online
2.00 Credits
Member Price: $99
What is delegation? Why is delegation important? When and to whom should tasks be assigned? How can you delegate effectively? How do you deal with problems and issues when they arise?
Measuring Audit Risks
-
Online
3.00 Credits
Member Price: $129
The planning process – When it starts and when it ends Determining the audit objectives The importance of the nature, timing and extent of the audit process The importance of professional skepticism The preliminary engagement activities Documentation of audit risk Determining materiality
2024 Real Estate Tax Issues: Passive Activity, Self-Rental & Section 199A
-
Online
4.00 Credits
Member Price: $129
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 Self-rental income from directly owned properties and reporting on Form 1040, Schedule E, page 1 Self-rental income from indirectly owned (partnerships, S corporations) and reporting on Form 1040, Schedule E, page 2 Self-rental property and the Form 8582 (passive activity), the flow-through entity grouping election, and "former passive activities" rules A deep-dive look at the Section 199A flow-through entities deduction Calculation of qualified business income Application to rental real estate – “safe harbor” rule and aggregation rules
Implementation Challenges with the New FASB Lease Standard
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:FASB's Accounting Standard Update for Leases (ASC Topic 842).Key differences between ASC Topic 842 and ASC Topic 840.Commitments that are on the balance sheet: operating leases and finance leasesAllocation consideration to lease and nonlease components.Lease payments, discount rate, inception date, commencement date, lease term.Impairments of right-of-use asset, modifications, subleases.Policy elections and disclosures.
2024 Internal Controls That Could Have Prevented Frauds
-
Online
2.00 Credits
Member Price: $79
Examination of actual frauds Discussion of internal controls that could have prevented the frauds Contemplation of epiphanies for your own professional scenarios
Beneficiary Options for Inherited IRA and 401(k) Accounts
-
Online
2.00 Credits
Member Price: $89
Improve Spreadsheets by Building Controls in Excel
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Learn best practices when designing your spreadsheets How to create a proper worksheet structureLearn to use Excel's built in features to find errorsHow to create your custom controls to prevent and find errorsUsing links to quickly move to controlsUsing Conditional Formatting to highlight errors
Surgent's Construction Contractors: Accounting and Financial Reporting Issues
-
Online
4.00 Credits
Member Price: $159
Overall landscape of the construction industry GAAP and recent changes affecting the construction industry The new Revenue Recognition Standard and its impact on the construction industry The unique relationship between the contractor and the surety The new lease FASB ASC and its impact on the construction industry
Triple Your Memory, Prevent Dementia and Halve Your Stress - Part 2
-
Online
4.00 Credits
Member Price: $159
How our emotions follow the motion of our body, and how that can be used to instill instant confidence How to tap into a completely relaxed and/or confident state of mind in 10 seconds or less using advanced hypnotic conditioning and Neuro-Linguistic Programming techniques How to stay motivated to use the methods outlined in this course to advance your career and achieve a higher quality of life How to use the concept of constant learning to help you maintain a balanced and fulfilling lifestyle
Auditing Financial Statements of ERISA Plans
-
Online
4.00 Credits
Member Price: $213
Auditing the statement of net assets available for benefits Types and classification of common plan investments Plan investment audit procedures based upon type of audit and risk assessment Auditing the statement of changes in net assets available for benefits Audit procedures at the participant level required for investment gains (losses), contributions, and benefit payments or withdrawals Presentation and disclosure requirements in accordance with GAAP Audit considerations related to related parties, parties in interest and prohibited transactions, a plan's tax status and Form 5500, and Form 11-K filers, and related changes introduced by SAS No.136
Audit 404: Maximizing Analytic Procedure Evidence on Audits
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this course include:Financial statement analysis, and communicating insights to financial statement usersImproving audit quality through strong analytic procedures, including identifying and responding to risk of material misstatementDeveloping plausible expectations for comparison to actual financial resultsDetecting earnings management and other risks through analytic procedures
Cognitive Biases for Accountants
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:What are cognitive biases?Common judgment biases in the accounting professionProfessional judgment frameworksHow to use psychology to your advantageSimple and pragmatic steps to overcome bias
Internal Control Frameworks for Single Audit
-
Online
1.00 Credits
Member Price: $39
Auditing COSO 2013 Update
Accommodation Requests - Substance Abuse - Contagious Infections
-
Online
1.00 Credits
Member Price: $59
Accommodation requests - religious practices Accommodation requests - disabilities Substance Abuse - constructive confrontation Substance Abuse - duty to accommodate as a disability Disclosures of potentially contagious infections
Walkin', Talkin', Lookin' & Listenin' - Or Things Most of Us Don't Do Well
-
Online
2.00 Credits
Member Price: $109
The importance of making yourself available How to start a conversation and what to NOT talk about The art of how to listen When you don’t understand what they just said Don’t fool by equivocations when they respond to a question Materiality and perception