CPE Catalog & Member Events
Earn quality CPE, stay ahead on hot topics and connect with peers — in the format of your choice. ISCPA makes learning simple.
The 10 Must Know Excel Features
-
Webinar
2.00 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.
Finding the Right Fit: An Exploration Financial Reporting Options for SMEs
-
Webinar
4.00 Credits
Member Price: $149
Unique needs of SMEs The menu of available frameworks Exploration of specific SPFs U.S. GAAP provisions for SMEs Considerations when selecting a framework Audit, review, and compilation implications Pitfalls to avoid Best practices to adopt
Assessing the Real Ethics of an Organization
-
Webinar
1.00 Credits
Member Price: $39
What are the signs of an ethical versus unethical organization? The need for clear policies Policies should be detailed, clear and unambiguous The importance of ‘doing the right thing when no one else is looking’ How exceptions offer opportunities to the unethical Should exceptions be allowed?
Corporate Storytelling in Financial Reporting
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Purpose of Management Commentary (IFRS): Understanding the foundational objectivesPurpose of MD&A (AAP): SEC-mandated narrative disclosure requirementsHistorical Context: Past and present frameworks and the limitationsRecent Revisions: Key enhancements and ESG integrationPractical Examples: Real-world applications and improvementsConvergence & Guidance: Frameworks, comparisons, and implementation
Emerging Risks and Resilience - How Accountants and Finance are Leading the Way - Part 5: Governance, Culture, and Regulatory Risk Pressures
-
Webinar
2.00 Credits
Member Price: $99
Risk Management culture Governance processes Workforce management Corporate Financial management Regulatory changes
K2’s Data Security And Privacy Issues And Solutions
-
Webinar
2.00 Credits
Member Price: $89
Understanding the differences between data security and data privacy The major types of security and privacy breaches Key steps you can take to mitigate your risks of becoming another victim
Internal Control Fundamentals
-
Webinar
2.00 Credits
Member Price: $89
COSO Yellowbook Auditing
Listening to the Statement of Cash Flows
-
Webinar
2.00 Credits
Member Price: $89
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
The Preparation of Form 709 – Line-by-Line
-
Webinar
2.00 Credits
Member Price: $89
Gift tax fundamentals and exclusions Completing Form 709 accurately Gift-splitting and its tax implications Lifetime exemption and GSTT considerations Valuation of gifted assets Common filing mistakes and IRS audits Updates on new legislation impacting gift taxation
Internal Control Frameworks for Single Audit
-
Webinar
1.00 Credits
Member Price: $39
COSO 2013 Update Yellowbook Accounting
Internal Controls for Small and Medium-Sized Entities
-
Webinar
1.00 Credits
Member Price: $39
Overview of controls Preventative controls Detective controls Controls for SMEs
Be the Sun, Not the Salt
-
Webinar
1.00 Credits
Member Price: $39
What is the Heliotropic Effect? Be the Six Sun Pearls. Today is a good day to do good Be the bright spot in the room Be your own sun Do the next right thing Pet peeves bite Knowing isn't doing
Performance Management - Hiring to Retiring
-
Webinar
1.00 Credits
Member Price: $39
Employee Engagement Recruiting/Staffing Talent Management Employee Relations
Mastering Charitable Remainder Trusts and Form 5227 Compliance
-
Webinar
2.00 Credits
Member Price: $89
Introduction to Charitable Remainder Trusts (CRTs) Types of CRTs and their Benefits Formation and Funding of CRTs Identifying Suitable Candidates for CRTs Understanding Form 5227: An Overview Line-by-Line Breakdown of Form 5227 Reporting Trust Assets and Income Distributions and Charitable Beneficiaries Compliance Updates and Recent Changes to Form 5227 Best Practices for Accurate Completion and Filing
Accountants and Malpractice: Can We Get Sued for This?
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:How accountant liability is a very real threat in today's litigious society.A discussion of scenarios in which accounting professionals can find themselves inadvertently involved in a lawsuit.Pitfalls in which the accountant may find him- or her- self while dealing with clients.Real-life examples from the speaker's extensive experience as a practitioner and as an expert witness in accounting malpractice cases.
Communicate Financial Concepts to Non-Accountants
-
Webinar
2.00 Credits
Member Price: $89
The math literacy barrier The financial literacy barrier What to say and how to say it Communicating ideas graphically
K2's Optimizing Your CAS and Advisory Tech Stack
-
Webinar
2.00 Credits
Member Price: $89
CAS overview to understand the service offerings, client needs, and market opportunities Selecting technology tools in CAS for accounting, workflow, and client collaboration Designing Service Delivery Models that are scalable and efficient processes for CAS Managing client relationships and setting expectations to deliver consistent value
Unlocking Deep Secrets: Case Studies in Financial Analysis
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of financial statement analysisThe impact of GAAP on financial analysisOverview of the Balance SheetOverview of the Income StatementThe importance of the Statement of Cash FlowsCommon Size AnalysisTrend AnalysisProfitability Ratio AnalysisLiquidity Ratio AnalysisSolvency Ratio Analysis
Navigating Mergers & Acquisitions with AI: The Future of Deals
-
Webinar
4.00 Credits
Member Price: $149
Strategic Reasons for Mergers & Acquisitions Establishing Acquisition Principles and Target Criteria Business Valuation in the M&A Process Structuring the Transaction and Negotiating the Deal Conducting Effective Due Diligence Post-Transaction Integration and Deal Success
Coping With the Growth of Online Fraud
-
Webinar
4.00 Credits
Member Price: $149
The major topics covered in this course include:The actuation of online and other cyber fraudsFraudulent acts that are initiated electronicallyAutomated and employee driven methods that can reduce cyber-fraud risk