CPE Catalog & Events

Explore PivotTable capabilities and functionality Retrieve data from a database and feed it into the PivotTable Pull web tables from web pages into Excel

The major topics covered in this course include:Entertaining lecture by a professional presenter, illustrated with relevant video clips and photographs, to cover the main points of the webinarWriting exercises, so you can see how these lessons apply to your own CPA practice and personal lifeTrue stories about CPAs and other leaders to show what can happen when apologies and criticism are done right, and the pitfalls of doing them the wrong way

The major topics covered in this course include:Securing individual documentsProtecting information resident in the CloudSecuring data stored on or accessed by mobile devices

The major topics that will be covered in this course include:Introduction to AI R&D in Accounting: Why internal AI research is essential for modern firms.Theory to Practice: Moving quickly from speculative AI concepts to actionable strategies.Managing Exponential Change: Understanding the urgency of adapting to AI’s rapid evolution.Proactive AI Engagement: Conducting in-house AI benchmarks, research, and hackathons.The Dual Role in AI Development: Balancing innovation with data security and ethical responsibilities.Internal AI Tools Creation: Encouraging accountants to develop AI solutions tailored to their needs.Data Security and Cyber Threats: Addressing AI-enabled cybercrime and protecting against internal risks.Mitigating AI Misuse: Recognizing abuse patterns and implementing safe practices.Challenges in AI Integration: Handling resistance, management concerns, and rapid technological shifts.Continuous Learning and Adaptation: Building a resilient, R&D-focused AI culture in accounting.

The major subjects that will be covered in this course include:Identify time wasters and adopt strategies for eliminating themRecognize the variety of causes of procrastination and apply techniques to overcome themUse practical techniques for prioritizing workDelegation strategiesIncorporate wellness and stress management into your day in short incrementsUnderstand their energy cycles and use it to manage your scheduleLearn techniques to decrease stress in the moment (based on neuroscience)

The major topics covered in this class include:Target profit analysisBreak-even analysisRelevant costs and decision-makingStandard costs and variancesActivity-based costingSegment reporting and analysis

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 major topics covered in this course include:Control design basicsAreas or segments of an enterprise to controlControls to reduce riskControls to drive operations

The major topics covered in this class include:The theory of money launderingCommon money laundering statutesExamples from court cases of money laundering statutesCommon occurrences with CPAsPossible money laundering transactionsApplying the money laundering statutes in real life scenarios

The major topics that will be covered in this class include:Review the Accounting Standards Codification, OCBOA/Special Purpose Frameworks, and AICPA financial reporting framework and their application to partnerships, LLCs and S corporationsFinancial accounting issues arising from changes in ownershipFinancial vs. tax accounting for partnership/LLC capital accountsSection 704(b) substantial economic effect rules and their relation to financial accountingThe integration of financial accounting with Forms 1065 and 1120SFinancial accounting basis for ownership interests vs. tax accounting basis for ownership interestsDeferred tax accounting for partnerships/LLCs and S corporationsFinancial accounting for the operations of a partnership/LLCFinancial accounting impact of the C to S election and the S to C electionFinancial and tax accounting for S corporation shareholder equity and partner capital accountsFinancial vs. tax accounting for loans to and from S corporations and their shareholders

Audit requirements for ERISA §103(a)(3)(C) audits An annual update of the changes affecting 401(k) plans Compliance issues associated with eligibility and enrollments, remittances, lack of oversight, compensation, vesting, and other topics Best practices for engagement planning, internal controls, risk assessment, and detailed testing Avoiding common mistakes while performing audit procedures Plan mergers and acquisitions Common audit reporting and disclosure issues

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

The major topics that will be covered in this course include:Financial Modeling with ChatGPT IntegrationAdvanced Ratio Analysis TechniquesRisk Assessment and Scenario AnalysisValuation Methods and ChatGPT ApplicationsUtilizing Performance Metrics in Financial AnalysisData Analysis and Interpretation with AIInvestment Analysis Enhanced by ChatGPT

The major topics that will be covered in this course include:Enterprise-wide risk management best practices for identifying, evaluating, and determining how to respond to relevant risks.The importance of risk and uncertainty disclosures in the preparation and fair presentation of financial statements, including evolving risks with cybersecurity and ESG.Coordinating risk management efforts, including the required involvement of corporate governance.How to embed risk management into day-to-day accounting and finance activities.

The major topics that will be covered in this course include:Current and noncurrent asset impairment. Insurance claims and related recoveries. Debt and liquidity issues. Government assistance and relief. Subsequent Events. Lease modifcations. Other matters.

The major topics covered in this course include:Underlying concepts of internal controlThe importance of control measure interdependency

The major topics covered in this class include:Basic requirements included in AR-C Section 60, General Principles; AR-C Section 70, Preparation of Financial Statements; AR-C Section 80, Compilation Engagements; and AR-C Section 90, Review of Financial Statements.New requirements included in SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions.Common peer review findings.Practice tips for high-quality engagements.

Defining progressive discipline, including typical steps in any progressive discipline process The importance of a fair disciplinary process When and how progressive discipline should be used, including using progressive discipline in the lead-up to termination Documentation best practices Limitations on at-will employment, including contracts and laws regarding discrimination and retaliation Avoiding key risks in the termination process Best practices for legally compliant termination procedures

The major topics that will be covered in this course include:Overview of budgeting toolsOverview of difference between budgeting and forecastingExamples of various budgeting and forecasting techniques

The major topics that will be covered in this class include:How organizations can find themselves defrauded due to lax oversight and weak internal controls.How the existence of the "trusted advisor" creates situations where CPAs can drop their professional skepticism.Illustrations of the issues companies should look for in preventing fraud and embezzlement.