CPE Catalog & Events

The implementation of GASB No. 101 on compensated absences The 2025 application of GASB No. 102 regarding certain risk disclosures GASB No. 103 addressing improvements to the financial reporting model Additional recently issued GASB standards and projects

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.

The major topics that will be covered in this course include:Common conflicts CPAs faceThe impacts of having/not having crucial conversations Learn your conflict style and how to elevate your conflict capabilitiesIdentifying conflict triggersBest practices using an integrated approach from Crucial Conversations, Fierce Conversations, and Leading with Questions.Interviews from CPAs and real-life scenarios they faced and what crucial conversation approaches they used.

Communication Leadership Character Behavior

Setting and resetting performance expectations. On-the-spot counseling. Addressing erratic performance. Drafting and presenting performance appraisals.

Gain exclusion and tax-free reorganization planning Gain exclusion with sales of C corporation stock – Section 1202 Deferral of gain with installment reporting Gain planning with partnerships Basis planning – basis step-up at death, gifts of interests to family Restructuring the business entity – C vs. S corporation, partnerships, LLCs Real estate planning – retention vs sales, like-kind exchanges Employee stock ownership plans – special tax incentives Employee benefit planning with ownership change Taxes other than the federal income tax – state tax, estate, gift and generation-skipping taxes, and property taxes Prospects for tax law change

Common instances of accounting malpractice Current claim trends Frequent defenses to claims Statute of limitations Damages Claims by practice area

When is a person eligible to take Social Security benefits? Factors to consider when selecting an option for taking Social Security benefits Is there a best age to start taking Social Security benefits? How to maximize Social Security benefit payments for surviving spouses How can a divorced spouse collect Social Security benefits based on the work record of a former spouse? How minor children can collect Social Security benefits based on the work record of an older parent

The major topics that will be covered in this course include:Fundamentals of GPT Builder and AI agent customization techniquesIntegration of specialized knowledge bases and domain-specific expertiseSecurity and privacy considerations in AI chatbot deploymentCustom GPT development without coding expertiseImplementation of AI agents for customer support and workflow automationMulti-bot interactions and content creation strategiesBest practices for maintaining and scaling AI assistants

Sources of Workplace Conflict Conflict Resolution Strategies Communication Skills and Active Listening Conflict Management Techniques  

Emotional Intelligence Management Skills Teamwork Customer Relations

Insubordination Personality and attitude problems. Generalized disparaging comments Previously unaddressed conduct. Misconduct due to mental condition Corrective action meetings and documentation. Attendance control.

Communication Leadership Character Behavior

The major topics that will be covered in this course include:Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. Review year 2 implications of the leases standard including modification accounting. A look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation.

Change management Leadership

Identifying opportunity The three most common behavioral red flags that we should always look for The many ways to commit check fraud (it’s so easy) Why inventory is such a good place to hide theft of assets How to cover up inventory fraud Accounts Receivable Fraud and how it works How to count inventory that’s not there

Case studies that clarify the challenges of making appropriate ethical decisions in the fast-paced modern organizational world A frank discussion of how to decide between a teaching moment rather than a termination moment when bad decisions are made. Applying the structure of understanding ethical dilemmas, and then applying the nine-step resolution process to arrive at a fair and consistent decision.

What Form 1099-K is designed to do Filing thresholds for the Form 1099-K Who sends and who receives Form 1099-K Form 1099-K reporting thresholds Personal payments from family and friends Personal items sold at a gain or a loss Reporting provisions for gig workers, partnerships, and corporations Mistaken receipt of a Form 1099-K What to do when the Form 1099-K has a mistake Situations when the gross amount on a Form 1099-K must be shared How to handle the receipt of multiple Forms 1099-K

Managing interruptions The role of activity logs, to-do lists and a priority matrix The psychology of time management Staying on track of your time management plan Controlling procrastination Blocking out time Creating an effective time management plan

We'll explore what gratitude is and how expressions of it can vary from culture to culture. We'll also unpack several ways you can regularly say "thank you" to valued clients and colleagues, and we'll examine methods for evaluating gratitude in prospective and current employees.