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
Surgent's Work-Life Balance: Maximizing Productivity and Understanding Related Tax Issues
-
Online
2.00 Credits
Member Price: $99
Discuss how productivity strategies may improve work-life balance Understand the state tax consequences that may arise when working from home Identify and discuss challenges unique to financial professionals Review how some organizations are providing support to improve work-life balance Explore the role of alternative work arrangements Examine challenges unique to auditors versus tax professionals A comparison of work-life balance between public and industry accountants How work-family conflict varies among financial professionals Recommendations for improving work-life balance
Planning for Small Business Success
-
Online
4.00 Credits
Member Price: $159
The integrated planning model The strategic plan Linkage with Performance Based Management Tracking success Real world examples
Internal Control Frameworks for Single Audit
-
Online
1.00 Credits
Member Price: $59
COSO 2013 Update Yellowbook Accounting
Minimizing Workplace Warfare
-
Online
1.20 Credits
Member Price: $59
Sources of Workplace Conflict Conflict Resolution Strategies Communication Skills and Active Listening Conflict Management Techniques
Data Analytics: Practical Insights for Today's Accountant
-
Online
2.00 Credits
Member Price: $109
Apply new effective tools in business processes Better understand how to use data analytics in public accounting engagements Identify popular software packages that may be useful for accomplishing data analytics
Keeping Up with the FASB
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this class include:Review of current items on the FASB agendaDiscuss the new revenue recognition standardProvide an update on the new lease accounting standardAddress U.S. GAAP alternatives for certain entities
S Corporation Essentials: Stock & Loan Basis Reporting
-
Online
2.00 Credits
Member Price: $109
Basis of stock and debt Form 1040, Schedule E Shareholder basis of indebtedness Limitation of deduction of losses AAA and distributions
Business Partnerships: Managing Supplier Relationships
-
Online
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Overview of supplier contractsCase studies of successful and not-so-successful supplier relationshipsRisk potentials
Introduction to Forensic Accounting
-
Online
1.80 Credits
Member Price: $79
Forensic Accounting Accounting Auditing Finance
Listening to the Statement of Cash Flows
-
Online
2.00 Credits
Member Price: $109
Preparation of the statement of cash flows Importance of identifying sources and uses of cash in financial reporting Financial statement analysis Cash-related financial statement disclosures
Revenue Recognition Topic 606 - Identify Performance Obligations Part 2
-
Online
1.40 Credits
Member Price: $59
Revenue Recognition Accounting
Ethical Responsibilities for CPAs: Ethics 25-26
-
Online
4.00 Credits
Member Price: $175
Ethical Responsibilities for CPAs The AICPA Code of Professional Conduct PCAOB Ethical Standards The Sarbanes Oxley Act The Foreign Corrupt Practices Act Circular 230 for Tax Practitioners The Dodd-Frank Banking Reform Act
Surgent's Introduction to Forensic Accounting
-
Online
4.00 Credits
Member Price: $159
Review of the different aspects of forensic accounting The civil litigation process as it relates to forensic accounting Litigation services provided by forensic accountants Fraud detection and prevention Various types of fraud Training and certifications in forensic accounting Forensic accounting in bankruptcy proceedings Forensic accounting in family law proceedings Calculating damages for use in litigation Valuations Ethical issues pertinent to forensic accounting
Partnership Checkup: Tax Issues & Forms Reporting
-
Online
4.00 Credits
Member Price: $159
Clarify the importance of partnership capital accounts and partnerships debt on partner's tax basis Impact of contributed property Explain the importance of shareholder loans to the entity Discuss how basis is impacted by distributions of corporation property and the sale/or liquidation of the S corporation interest Comprehensive examples illustrate the mechanics of the basis determination process Discusses how S corporation losses impact Form 1040 Schedule E reporting How to get from the Schedule K-1 information to the basis calculations
Yellow Book Independence and Single Audit Fundamentals
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this class include:The conceptual framework approach to independenceIndependence threats related to preparing financial statements and accounting recordsConsideration of specific non-audit services that would and would not impair independenceDocumentation necessary to support adequate consideration of auditor considerationFundamentals of a compliance audit performed under the Uniform GuidanceSchedule of expenditure of federal awardsDetermination of major programsUsing the Compliance Supplement Uniform Guidance administrative requirements and cost principles Testing internal control over complianceTesting complianceWriting an audit findingReporting requirements of a single audit
Implementing and Maintaining an Internal Control System
-
Online
8.00 Credits
Member Price: $239
The major topics covered in this course include:Control creation and implementation basicsImplementation and update procedures for an Internal Control systemMaintaining existing internal controls
Cryptocurrency 15 Years Later - A Market Update
-
Online
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Update on the cryptocurrency marketplaceCryptocurrency exchanges - the good, the bad and the uglyOverview of cryptocurrency taxation regulationsThe technology behind cryptocurrency - Proof of stake, Layer 2, wallets and moreBlockchain technology update
Become a Data Analysis Expert
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Data Analysis Process Flow: An introduction to the Data Analysis Process Flow and how it is your pathway to becoming a Data Analysis Expert.Data Modeling: A comprehensive discussion of building a data model and calculating metrics.Data Visualizations: An understanding how visualizations can present data in a more insightful and impactful manner.
Instant Audit? Just Add Risk Assessment
-
Online
1.00 Credits
Member Price: $59
The audit risk model Risk assessment Linking risks to audit procedures Other responses to risks Documentation