CPE Catalog & Events

Improve Spreadsheets by Building Controls in Excel

The major topics that will be covered in this class include: Learn best practices when designing your spreadsheets How to create a proper worksheet structure Learn to use Excel's built in features to find errors How to create your custom controls to prevent and find errors Using links to quickly move to controls Using Conditional Formatting to highlight errors

Mastering Partnership Basis: Inside and Outside Basis

The major topics that will be covered in this course include: Explain the use of both ""inside"" and ""outside” basis determination How to calculate tax basis capital accounts, including when the entity is formed, including the impact of contributed property. Clarify the importance of partnership capital accounts and partnerships debt on partner's tax basis. Explanation of how basis is impacted distributions and by sale and/or liquidation of the partnership interest. Comprehensive example to illustrate the mechanics of the basis determination process.

Mastering the Excel Lookup Function

The major topics that will be covered in this class include: A review of the various lookup functions, beyond VLOOKUP Learn which lookup works best for your situation How to apply the many lookup functions Discover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectively An in-depth review of the following functions: VLOOKUP / HLOOKUP XLOOKUP MATCH / INDEX XMATCH INDIRECT FILTER SORT / SORTBY UNIQUE An overview of some newer functions

Using Chat GPT with Excel

The major topics that will be covered in this class include: Introduction to ChatGPT and other AI (Artificial Intelligence) language models Discussion of best practices for using ChatGPT with Excel Use ChatGPT to create, debug and explain formulas Use ChatGPT to learn how to use Excel features Use ChatGPT to automate repetitive tasks in Excel Use ChatGPT to easily create macros

CPA to CFO: Essential Compentencies for Finance Leaders

The major topics that will be covered in this course include: Top competencies hiring executives seek in CFO candidates based on survey of 320+ CEOs and recruiters Critical thinking frameworks and strategy creation techniques for financial leadership Forward-looking financial skills including capital management, forecasting, and funding strategies Industry-specific requirements for high-growth companies and nonprofit organizations Practical career development strategies to build CFO-ready competencies

Ethics Based Leadership for Women

The major topics covered in this class include: Virtue ethics and leadership hallenges to leadership for women Self-awareness and defeating internal messages Imposter syndrome Speaking my truth, finding my voice Giving and receiving feedback Raise your hand, stand up and sit down

Fundamentals of Form 1040 -- Business

The major topics that will be covered in this course include: Self-employment and business income taxation (Schedule C, self-employment tax, business deductions) Reporting income from pass-through entities (Schedule E, Schedule K-1, Shareholder stock and debt basis on Form 7203) Application of Form 7217 for capital construction funds Best practices for self-employed clients and small business owners Key deductions and credits for business owners Avoiding common IRS audit triggers related to business income reporting Legislative updates impacting business income taxation in the current year

Fundamentals of Form 1040 -- Individual

The major topics that will be covered in this course include: Form 1040 essentials: filing requirements, due dates, and key schedules Filing status, dependency rules, and taxable income sources (wages, investment income) Adjustments to income, deductions and tax credits (standard vs. itemized deductions, EITC, Child Tax Credit, Education Credits) Preparer due diligence, Circular 230 compliance and taxpayer rights IRS cybersecurity considerations and best practices for taxpayer data security Lgislative updates

Navigating IRS Correspondence: Responding to IRS Letters

The major topics that will be covered in this course include: Types of IRS letters: General notices, audits, collections, return requests, and errors. Deadlines for responding to IRS correspondence. Communication best practices for dealing with the IRS. Avoiding escalation and penalties through proactive responses. Ensuring compliance when addressing IRS correspondence. Real-world examples of successful IRS communications. Common pitfalls in handling IRS letters and how to avoid them. Strategies for advising clients on IRS correspondence.

Overcoming Tech Adoption Challenges in CPA Firms

The major topics that will be covered in this course include: Five critical technology adoption challenges facing CPA firms today Digital maturity assessment models and implementation frameworks AI integration strategies for tax, audit, and advisory services Cybersecurity considerations and risk management protocols Case studies of successful technology transformations in accounting firms

Retaining Top Talent: Strategies for CPA Firms

The major topics that will be covered in this course include: The true cost of turnover versus retention investment Research findings on why professionals leave or stay Whole-person retention strategies beyond compensation Work-life balance solutions that maintain productivity Career development paths for non-partner track professionals Business model transformations for sustainable staffing Technology and outsourcing strategies to reduce burnout Retention strategies specific to diverse talent and younger professionals

Tax Update: H.R. 1 "One Big Beautiful Bill" & Form 1040

The major topics that will be covered in this course include: Individual Taxation: Child tax credit expansion, tip/overtime exclusions, SALT cap extension Income & Adjustments: Tip income exclusion, overtime relief, educator expenses Business Taxation: Bonus depreciation, §199A expansion, interest deduction limits Estate & Gift Tax: Increased exemption thresholds, charitable deduction changes Education Incentives: Student loan discharge, 529 plan expansion, new “Trump Accounts” Compliance & Reporting: 1099-K threshold changes

The Future of Audit: Technology, Talent & Transformation

The major topics that will be covered in this course include: Explore AI, blockchain, and data analytics impact on audits Address talent crisis through retention and upskilling strategies Navigate PCAOB standards and regulatory sandbox concepts Expand audits to include ESG and nonfinancial metrics Implement technology solutions for firms of all sizes

The One Big Beautiful Bill: 2025 Tax Legislation

The major topics that will be covered in this course include: The Congressional process in passing tax legislation.  Major Tax Provisions in the House version of Big Beautiful Bill  Individual  General Business International Health Care Accounts Qualified Opportunity Zones Industry Specific Provisions Tax Exempt Organizations Miscellaneous Provisions

The Role of Internal Control in the Risk-Based Audit

Unlock the Power of AI with Copilot i

The major topics that will be covered in this course include: Introduction to Copilot in Excel Automating Tasks and Enhancing Productivity Advanced Data Insights with Copilot

What's Behind the Data?

The major topics that will be covered in this course include: Ways in which data and information can be misleading Common pitfalls when encountering data How to re-evaluate the data to avoid those pitfalls

Workforce Transformation and Talent Management in 2025

The major topics that will be covered in this course include: Understanding why the traditional pyramid structure is failing firms The inverted pentagon framework and its talent retention advantages Impact of technology and AI on entry-level accounting roles The 6 Ps of Business Model Transformation implementation Accelerating specialized skills acquisition in your workforce Effective knowledge transfer through mentorship and job rotation Technology-driven training and development strategies Best practices from other industries for workforce transformation Building and retaining specialized middle layers of expertise Strategic pricing models to support the pentagon structure

Professionla Ethics: The American Institute of Certified Public Accountants' Comprehensive Course (For Licensure)

- AICPA Code of Professional Conduct and its Conceptual Framework- Ethics and independence rules from the AICPA and other regulators, including the U.S. government- Activities that discredit the profession- Ethics interpretations issued by PEEC- NOCLAR- AICPA Statements on Standards for Tax Services (SSTSs)- U.S. Treasury Department’s Circular No. 230- Internal Revenue Service (IRS) penalty provisions