CPE Catalog & Events
Start Here and Get on Course
Welcome to our online catalog. LCPA offers thousands of live and online courses to satisfy your professional development needs. Our easy-to-use filter enables you to find just the right courses to enhance your knowledge and help you succeed even more.
Whether you have an hour during lunch or an entire day, LCPA provides quality, flexible options to fit your schedule. Look for the "See more dates" dropdown to view availability. Several events/classes produced by LCPA can be taken either LIVE (In-Person) or VIRTUAL—please ensure you register for the correct one.
LCPA is proud to partner with ACPEN, CPA Crossings, Surgent, AHI, AICPA, and K2 Enterprises to deliver high-quality webcast and self-study content in a convenient and cost-effective manner. Stand-alone courses and all-access packages are available. Filter using the Vendor name. Learn more.
Streamlined Excel Reporting Series Session 3: PivotTable Wrap-Up and Web Data
-
Online/Webcast
2.00 Credits
In part 3 of this webcast series, we finish our PivotTable discussion by examining various ways to present report values, discussing the subtly of properly sorting a recurring-use PivotTable, and covering numerous filtering options, including slicers.
Tax Depreciation: Review and Update
-
Online/Webcast
2.00 Credits
See more dates
A discussion of recent law changes that impact capitalization, depreciation, and disposition of assets. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Mastering the Excel Lookup Functions
-
Online/Webcast
2.00 Credits
See more dates
In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Workforce Transformation and Talent Management in 2025
-
Online/Webcast
1.00 Credits
See more dates
The accounting profession faces unprecedented workforce challenges that demand a fundamental rethinking of traditional firm structures. This course examines why the century-old pyramid practice model is becoming obsolete and presents the inverted pentagon framework as a sustainable alternative. Based on comprehensive research showing that 52% of firms expect to shrink by 20% or more in the next five years, participants will learn how to restructure their firms to thrive with fewer entry-level staff while expanding specialized expertise. The course explores the "6 Ps of Business Model Transformation" - Precision Hiring, Proactive Retention, Practical Technology Implementation, Pricing Expertise, Practice Area Expansion/Focus, and People Acceleration. Drawing from success stories in manufacturing, healthcare, and technology industries, attendees will discover proven strategies for accelerating staff development, implementing effective knowledge transfer programs, and building sustainable talent pipelines in an era of technological disruption and demographic shifts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
How to Build a Custom AI Chatbot and GPT in Plain English
-
Online/Webcast
2.00 Credits
See more dates
Participants will learn to create customized AI chatbots that can enhance client interaction and internal operations-all without coding experience. This course provides a concise overview of specialized, task-oriented AI chatbots and GPT builders, focusing on how these technologies are revolutionizing professional workflows. Through hands-on exploration of platforms like AgentGPT, Claude Projects, Gemini Gems, and NotebookLM, participants will learn to design, deploy, and manage custom AI assistants tailored to their specific needs. The course emphasizes creating advanced AI apps that can understand context and solve complex problems autonomously. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
2026/27 Not-for-Profit GAAP Update
-
Online/Webcast
1.00 Credits
See more dates
Stay current on the latest accounting developments affecting not-for-profit organizations with this timely GAAP update. This course reviews recently issued Financial Accounting Standards Board Accounting Standards Updates (ASUs) impacting NFP financial reporting, along with standard-setting projects currently in the FASB pipeline. The course also introduces the International Non-Profit Accounting Standard (INPAS)-the first comprehensive global accounting framework designed specifically for non-profit organizations, launched in October 2025. Participants will gain perspective on the purpose and structure of INPAS and how it compares conceptually to U.S. GAAP requirements for NFPs. This course is designed to help practitioners, financial leaders, and auditors of not-for-profit organizations understand both current GAAP requirements and emerging global developments shaping the future of nonprofit financial reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Surgent's Establishing State Residency and Saving Your Clients Money
-
Online/Webcast
2.00 Credits
See more dates
Many of our clients are moving to one of the seven states with no personal income tax, particularly Florida and Texas. Others may maintain multiple homes with an eye toward eventually establishing residency in a state with no income tax. This course will give you practical tips for your clients seeking to establish residency in a new jurisdiction. Cash-strapped states are increasingly attempting to assess taxpayers who have declared domicile and residency elsewhere, for example in Florida, to maintain their diminishing tax base. Arm your clients with the tools needed to save money by successfully establishing domicile and residency. As a practitioner, you can't afford to be unaware of the latest issues affecting so many relocating baby boomers and others. Avoid that state audit with the information provided in this entertaining webinar.
More Dates
Surgent's Excel Budgeting Ideas
-
Online/Webcast
2.00 Credits
See more dates
Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.
More Dates
Surgent's Schedules K-2 and K-3: Preparation of Forms
-
Online/Webcast
2.00 Credits
See more dates
Many partnerships and S corporations are now required to complete the voluminous Schedules K-2 and K-3 to report foreign-related tax information. Updated for the 2025 tax year, this course is an essential guide for tax preparers on how to tackle the preparation of these forms. Understanding and preparing these forms requires a basic knowledge of various international tax topics, including sourcing of income, foreign tax credit income categories, effectively connected income, and fixed, determinable, annual, or periodical (FDAP) income. The course includes a brief discussion of key international tax concepts, a detailed walk-through of what information is required to be reported in different parts of the schedules, and practical advice from the field. The course also includes three comprehensive case studies on how the form should be completed for operating, real estate rental, and investment partnerships. Please note: Surgent also offers a companion course, "Schedules K-2 and K-3: Filing Requirements" (KFR2).
More Dates
Surgent's The Accountant as the Expert Witness
-
Online/Webcast
2.00 Credits
See more dates
As litigation becomes more complex, attorneys are relying more on accountants to serve as consulting experts or expert witnesses at trial. Serving as an expert witness is not as difficult as you might expect. Accounting experts educate lawyers and jurors on issues such as valuation, tax liability, and forensics. Learn how accountants become expert witnesses, the role they play during pre-litigation through to trial, and the techniques experts employ to avoid challenges from opposing counsel.
More Dates
Surgent's Understanding Partnership Taxation: Types of Basis, Contributions, and Distributions
-
Online/Webcast
4.00 Credits
See more dates
Calculating partnership basis is one of the most important things that we do as practitioners. However, it is also one of the most confusing. When we use the term "basis," we really could be referring to one of three different things. This course will explore the differences between inside basis, outside basis, and 704(b) basis. Through several examples and practice problems, we will show you how to easily distinguish among these terms. We will also explore the tax implications of initial contributions of property to a partnership as well as the different types of partnership distributions.
More Dates
ACPEN: K2’s QuickBooks Online For Accountants
-
Online/Webcast
8.00 Credits
See more dates
Discover the power of QuickBooks Online (QBO)! Intuit's cloud-based accounting platform has evolved and thrived over the past decade, now generating approximately five times the revenue of its desktop counterpart. Yet, many accountants and business professionals are still unaware of the extensive features QBO offers. Unlock the advantages of the subscription model and learn how to leverage QBO to manage inventory, enhance internal controls, create presentation-quality financial statements, and seamlessly migrate from QuickBooks Desktop or other accounting platforms. Join our dynamic session to explore the best practices for implementing, using, and excelling with QuickBooks Online. Don't miss out on the opportunity to elevate your accounting game with this surprisingly robust platform!
More Dates
The AI Revolution in 2026: What CPAs Should Know
-
Online/Webcast
2.00 Credits
See more dates
AI is reshaping accounting, tax, and finance. This update surveys the state of AI technology in 2026: core concepts, software tools, risks/controls, and practical CPA use cases. You will leave with an expanded AI vocabulary, a current view of the AI landscape, and actionable talking points for staff, clients, and service providers. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
How SAS Nos. 134-145 Improve Risk-Based Audits
-
Online/Webcast
4.00 Credits
See more dates
Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in SAS Nos. 134-145. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Executive Presence, Personal Brand: Structure Your Narrative
-
Online/Webcast
1.00 Credits
See more dates
Professional credibility is communicated, not assumed. In this 1-CPE session (Professional Development), participants examine structured approaches to articulating their professional identity. Drawing directly from the course framework, the session covers development of an elevator pitch, a professional value proposition, and a concise executive biography. Participants will analyze how credibility is established through clarity, relevance, and alignment with audience needs. The course emphasizes service-centered communication rather than self-promotion and provides structured guidance for refining professional messaging in leadership and client-facing contexts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
ACPEN: HR Investigations – Episode 3 – Gathering-Analyzing-Reporting
-
Online/Webcast
1.00 Credits
See more dates
Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session provides best practices for gathering and analyzing evidence and reporting the investigation results. Attendees will end the session with takeaways to immediately implement in future HR investigations. Three of three Episodes in the series.
More Dates
Surgent's Governing Agentic AI: Cybersecurity, Data, and Risk
-
Online/Webcast
2.00 Credits
See more dates
As accounting firms and financial institutions deploy agentic AI, they face significant governance challenges. This course focuses on cybersecurity, data governance, and risk management practices essential for the safe and effective use of autonomous systems. Participants will examine frameworks such as NIST AI RMF and the CSA's red-teaming guidelines, as well as case studies on AI-powered cyber incidents. The course equips professionals to assess agentic system vulnerabilities, implement controls, and integrate risk insights into enterprise compliance strategies. This course equips CPAs to fulfill their oversight responsibilities in safeguarding financial data and ensuring the reliability of autonomous systems within the enterprise's control environment.
More Dates
Comprehensive Audit & SSARS Update
-
Online/Webcast
1.00 Credits
See more dates
This course covers recently issued standards from the AICPA Auditing Standards Board and AICPA Accounting and Review Services Committee including the new Quality Management Standards. The session will highlight projects in progress at the Public Company Accounting Oversight Board, and International Auditing and Assurance Standards Board. The course will also recap recent changes and present common peer review findings and best practices to improve practice quality. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Don Farmer's Partnership Basis Deep Dive: Inside vs. Outside Basis
-
Online/Webcast
2.00 Credits
This course provides an in-depth examination of partnership basis concepts, focusing on the distinction and interaction between inside and outside basis. Participants will analyze contributions, allocations, distributions, liabilities, and basis adjustments that commonly lead to reporting errors. Emphasis is placed on reconciling partner capital accounts, K-1 reporting, and tax basis schedules.
Advanced Excel for Staff - Build Reports and Analyze Data
-
Online/Webcast
2.00 Credits
See more dates
Advanced Excel for Staff - Build Reports and Analyze Data is a comprehensive, 2-hour course tailored for professionals looking to enhance their Microsoft Excel skills in creating reports and performing data analysis. This course bridges the gap between basic Excel functionality and the advanced techniques required for effective data-driven reports. Participants will learn to efficiently gather, organize, and structure data, apply calculations to derive key metrics, and create professional-grade reports that are both visually appealing and actionable. The course emphasizes practical application, providing participants with guidance on Excel's advanced tools and functions. By mastering workflows and best practices, learners will gain the confidence to tackle complex data challenges and streamline reporting processes. Additionally, participants will explore methods to validate and share their work, ensuring that reports are accurate, insightful, and easily communicated across teams. Whether you are tasked with preparing financial summaries, tracking performance metrics, or generating operational insights, this course will equip you with the tools to maximize Excel's potential, saving time and improving the quality of your outputs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates