CPE Catalog & Events

The major topics that will be covered in this course include:Introduction to PivotTables: Gain a solid understanding of what PivotTables are, their benefits in Excel, and how to prepare your data for creating effective PivotTables.Creating and Customizing PivotTables: Learn step-by-step how to build and format PivotTables, including filtering, sorting, and customizing layouts for optimal data analysis. Focus on Using PivotTables to Analyze Data: Explore techniques to summarize, group, and compare data with PivotTables, uncovering trends and insights for better decision-making.Advanced PivotTable Features: Discover advanced tools such as slicers, timelines, and using PowerPivot for deeper analytical capabilities. Data Visualization with PivotCharts: Learn to create PivotCharts from your PivotTables and customize them to visually present data insights effectively to stakeholders.

The major topics that will be covered in this course include:Complex and nuanced communications related to:Budget Allocation and Negotiation TechniquesCompensation and Benefits StructuringManaging Financial Performance and LayoffsFinancial and HR Aspects of Mergers and AcquisitionsRegulatory Compliance and Ethical Financial PracticesStrategies for Financial Crisis ManagementEffective Performance Management Systems

The major topics that will be covered in this class include:Definition of what qualifies as an entertainment expenseStrategies to deduct business entertainment expensesDeductibility of mealsSituations not subject to the 50% meals and entertainment reductionHow to handle automobile issues related to employer-provided parkingProper accounting for deductible vs. non-deductible expendituresThe four steps to analyze business expensesThe latest federal legislation, cases and rulings

The major topics that will be covered in this course include:Current individual tax issuesCurrent business entity tax issuesAny current tax legislation occurring during the periodOther issues affecting the profession, including IRS procedure, current cases, payroll, and other federal tax issues

The major topics that will be covered in this course include:Introduction to Ethics and Ethical DilemmasEthical Codes and Professional StandardsFraud and the Fraud TriangleEthical Decision-Making ModelsFinancial Statement Manipulation TacticsCash Flow and Key Metrics Misrepresentations

The major topics covered in this class include:Awareness of advanced functionsCreative methods for data manipulationUsing intellectual curiosity and professional skepticism to develop a problem-solving mentalityReal-life examples of innovative ways to analyze and report data with ExcelUsing Excel to perform e-mail mergesMany other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolboxEnhance creativity in your approach to developing Excel models

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

The major topics covered in this class include:Career choicesEthical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation

The major topics that will be covered in this course include:Building a high-performing team comprised of multi-generational workers.How to effectively communicate with the millennial worker.Leveraging younger staff in business development opportunities.Measuring the productivity of a millennial workforce.

The major topics that will be covered in this course include:The role of a forensic accountant in divorce proceedingsThe marketing of forensic accounting services to family law attorneysHow to conduct a financial investigationCommon areas to uncover hidden assets or incomeThe basic calculations in evaluating marital assetsTestifying in depositions and divorce court

The major topics that will be covered in this course include:AICPA Accounting and Review Services Committee standards update and new practice aidAICPA Auditing Standards Board standards update including recent changes to the audit and attestation standardsAICPA’s new Quality Management Standards - Overview, implementation considerations, timeline, and AICPA implementation resourcesPCAOB, IAASB standard-setting agenda and potential future AICPA ASB standards changesUpdate on AICPA’s Enhancing Audit Quality InitiativeTrends in audit quality including the DOL’s audit quality studyFrequent peer review findings and practice tips for achieving high practice qualityLatest on the DOL’s audit quality study

The major topics that will be covered in this course include:Explore research for common answers to "what does ethics mean to you?" and examine whether those are valid.Identify common ethical barriers - reflecting the latest from the ACFE Report to the Nations.Discover ways to improve ethical response.Practice, using practical advice from leading thinkers in ethics.

Major topics covered in this course include:Introduction to ChatGPT and artificial intelligence chatbot technologiesAutomating frequently asked questions and the onboarding processVerifying and reviewing financial recordsProviding real-time support to clientsGenerating financial reportsAutomating tax return preparation and financial planningProviding guidance on financial decision making

California property taxation updated in light of Proposition 19 passage Qualified business income deductions [IRC Sec. 199A] Opportunity zone deferral related to real estate [IRC Sec. 1400Z-2] Passive activities loss rules [IRC Sec. 469] Real estate professional rules [IRC Sec. 469(c)(7)] Interest expense deduction rules [IRC Sec. 163] Home sale exclusion [IRC Sec. 121] 1031 exchanges Estate planning and gifting with real estate

The major topics that will be covered in this course include:Fundamentals of AI and how it differs from traditional accounting softwareGenerative AI, AI agents, and embedded AI applications in accountingAI-powered automation for routine accounting tasks and workflowsData security and privacy considerations in digital accounting environmentsStrategies for maintaining client relationships while embracing automationFuture trends including frontier AI models and embodied AI (robotics)Practical implementation of AI tools in accounting practice management

Disclosure - Overview Disclosure - Expense Disaggregation Implementation Guidance

FASB ASU with effective dates of 2024 and later SAS 149 Recent ethics interpretations

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

Why customer service is not just having nice people; it is truly serving the customer Analysis of the value of the customer to compare it to various costs creating an ROI How to develop a compliance program that adds value to the customer A hard look at several companies and industries that have mastered the dual objectives How recent developments have affected compliance and customer service

Calculation of the GST tax, and how it relates to the estate tax and gift tax Direct skips, taxable distributions, and taxable terminations GST tax allocations, Reverse QTIP election, and Exempt and Nonexempt Trusts Calculating the benefit of and designing Dynasty Trusts