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.
Data and Statistical Analytics Using Microsoft Excel
-
Online/Webcast
2.00 Credits
See more dates
The role of the financial professional has shifted from reporting on the past to predicting the future, yet many practitioners still rely on manual, static workflows that fail to capture the full story within their data. This course bridges the gap between traditional accounting and modern data science by utilizing Excel's most powerful analytical engines to turn raw numbers into defensible business intelligence. We will move beyond simple averages, exploring how to use the Analysis ToolPak for deep statistical dives and leveraging Dynamic Arrays to build fluid, auto-updating models that respond to changing business conditions in real time. Participants will explore a modern analytics workflow that balances classic statistical rigor with cutting-edge efficiency. We will examine how to implement regression analysis for more accurate budgeting, utilize advanced forecasting functions to anticipate market shifts, and even leverage AI-assisted insights to find hidden patterns in sprawling datasets. By the end of this session, you will be able to distinguish between mere "data entry" and "data discovery," providing your firm or organization with the high-level analysis required to navigate an increasingly complex economic landscape.
More Dates
Behavioral Finance Biases
-
Online/Webcast
1.00 Credits
See more dates
If you have been a practitioner for any length of time, you know that there is often a difference between what clients should do and what they actually do. Have you ever wondered why that is? In this course, we will explore how we make decisions with less-than-perfect information. Through real-life examples and case studies, we will examine common behavioral biases and how to deal with them. 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
Elevating Excel Productivity With Microsoft Copilot
-
Online/Webcast
2.00 Credits
Many professionals already use Copilot to generate text and summarize meetings, among other activities. But few use Copilot to improve their productivity with Excel. In fact, Copilot can help even advanced Excel users to become more efficient, effective, and productive when working with Microsoft's ubiquitous spreadsheet application. In this session, you will learn how you can use Copilot to elevate your Excel game by in many areas, including data preparation and cleaning, creating formulas, analyzing data, writing scripts, and creating effective visualizations.
2026/27 Yellow Book Update
-
Online/Webcast
1.00 Credits
See more dates
Stay current on key developments affecting governmental audits with this focused update on the 2024 revision of the Yellow Book. This course highlights significant changes related to quality management and updates affecting key audit roles, with an emphasis on how these revisions impact audit planning and execution. The course also addresses the GAO's implementation delay and its implications for 2026 audit planning. Participants will gain context around recent leadership changes at the U.S. Government Accountability Office and what those transitions may signal for future guidance and oversight priorities. In addition, the course includes an overview of recent updates to the Green Book, helping auditors understand changes to internal control guidance that may affect governmental entities and Single Audit engagements. 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: K2’s Office Scripts – The New Macros
-
Online/Webcast
2.00 Credits
See more dates
Discover the power of Office Scripts, the game-changing feature that lets you automate tasks in Excel and other Office applications effortlessly. Unlike VBA, which is limited to Windows, Office Scripts run on any platform and device that supports Office on the web. With its modern and intuitive interface, you can easily create, edit, and share your scripts, all stored securely in the Cloud. Office Scripts seamlessly integrate with Office Online apps and Power Automate, enabling you to streamline processes and boost productivity like never before. Say goodbye to repetitive tasks and hello to efficiency with Office Scripts in Excel and beyond!
More Dates
Navigating IRS Correspondence: Responding to IRS Letters
-
Online/Webcast
2.00 Credits
See more dates
Participants will learn how to interpret the most common IRS correspondence, adhere to response deadlines, and effectively communicate with the IRS to resolve issues and minimize risks. It provides professionals with knowledge and strategies needed to handle the most common notices including audit requests, collections & return inquiries as well as error notices. Focusing on best practices to ensure compliance and avoiding penalties or escalation. 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 Government and Nonprofit Frauds and Controls to Stop Them
-
Online/Webcast
4.00 Credits
See more dates
The cost of fraud, dearly paid by governments and nonprofits, is too severe to not learn from past experiences. This course examines real-world fraud cases to uncover the lessons they provide and translate them into practical, preventive controls. Using a highly illustrative and innovative format, the course engages participants with over 15 focused exercises designed to build a strong working knowledge of fraud risks and effective anti-fraud controls. Whether you are an auditor or an industry professional, you'll gain actionable strategies to strengthen oversight, reduce vulnerabilities, and safeguard your organization.
More Dates
Conducting a Remote Audit
-
Online/Webcast
4.00 Credits
Remote auditing has become increasingly prevalent in today's environment. Considerations for a remote audit are detailed to help you properly perform the tasks necessary for a successful engagement.
Operations Level Internal Control
-
Online/Webcast
4.00 Credits
See more dates
Many leaders in business organizations of all sizes view the system of Internal Control almost purely as a protective security measure. A well-designed internal control system can and will drive all entity objectives which includes successful operations. This session uses information gathered from years of creating internal control systems as well as concepts from well-respected authoritative pronouncements and frameworks to illustrate the power of a strong and well supported control system as well as actions that can help establish such a system. Those that work with internal controls who are tasked with developing ways to improve operation level capabilities should strongly consider this session. 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
Financial & Tax Accounting for S Corporations & Partnerships
-
Online/Webcast
8.00 Credits
See more dates
This program compares and contrasts the financial and tax accounting differences of partnerships, LLCs, and S corporations, as well as discuss the tax accounting for these entities. 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
Individual Tax Fundamentals - Tax Staff Essentials
-
Online/Webcast
8.00 Credits
See more dates
Tax professionals can enhance their practice by studying tax-saving strategies for individual clients.
More Dates
Surgent's Audits of 401(k) Plans: New Developments and Critical Issues
-
Online/Webcast
8.00 Credits
See more dates
One of the most favored employee benefit plans, the 401(k) plan, provides unique challenges for auditors. Through this course, auditors will obtain an understanding of the rules and regulations unique to employee benefit plans and obtain practical guidance on applying them. Auditors will enhance their knowledge of the performance and reporting requirements through real-world examples, best practices, and efficient audit techniques that can be utilized in various audit engagements. Make sure your audits don't trigger a DOL inspection by conforming to all applicable rules and regulations.
More Dates
Surgent's Handbook for Mastering Basis, Distributions, and Loss Limitation Issues for S Corporations, LLCs, and Partnerships
-
Online/Webcast
8.00 Credits
See more dates
The most difficult concepts to master when dealing with flow-through business entities are the basis and distribution concepts. Major error and malpractice issues occur if the CPA does not fully understand the impact of these rules. This course is designed to focus on the practical applications of these rules.
More Dates
The Current and Future Landscape of Audit Technology
-
Online/Webcast
2.00 Credits
See more dates
Explore the transformative impact of technology on the audit profession in this forward-looking course. Gain practical insights into cutting-edge tools and trends, including data analytics, artificial intelligence (AI), and automation, and discover how these advancements are revolutionizing audit methodologies and improving audit quality. Through engaging demos, case studies, and actionable tips, you'll learn how to navigate the evolving audit landscape with confidence and adaptability. This session is designed to equip CPAs with the knowledge to embrace innovation and stay ahead in a rapidly changing profession. 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
Forensic Accounting: Finding Hidden Treasure in Tax Returns
-
Online/Webcast
4.00 Credits
See more dates
Almost every business and individual has to file tax returns, which can be a great treasure trove of information for forensic accountants. Whether in a divorce, partnership dispute, recreating books and records, or bankruptcy proceeding, analyzing tax return information should be an initial step in uncovering income and assets. The IRS retains a large amount of information, both from taxpayers and 3rd parties who report financial transactions. This course will be your guide in gathering, analyzing, and evaluating tax return information, so that you have a full picture of the financial investigation. Your presenter is a 20 year veteran with IRS-Criminal Investigation, who used this information as a basis for his federal criminal investigations. 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
2025-2026 Federal Tax Updates - Business Entities
-
Online/Webcast
8.00 Credits
See more dates
The tax landscape is constantly changing, challenging tax practitioner to stay abreast of these developments. This eight hour program will cover issues unique to business entities, including new court decisions, recent IRS publications, and the latest tax legislation that will impact businesses and individuals. The remaining time will be spent on IRS procedure and other issues. This course will provide a concise look at the hottest topics affecting every tax practitioner. 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: Taxation of Non-fungible Tokens (NFTs)
-
Online/Webcast
2.00 Credits
See more dates
Non-fungible Tokens (NFTs), unique, identifiable digital assets based on blockchain technologies, have become a fast-growing industry. This course will provide a background on how NFTs came into the mainstream marketplace. These materials will assist the practitioner to understand the tax implications of the creation, purchase and sale of these assets. **Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.
More Dates
ACPEN: What's Going on at the GASB (2026/27)
-
Online/Webcast
2.00 Credits
See more dates
This course provides a focused update on major recent pronouncements issued by the Governmental Accounting Standards Board. Coverage includes GASB Statement No. 103 (financial reporting model improvements), GASB Statement No. 104 (enhanced disclosures for capital assets), and GASB Statement No. 105 (subsequent events). Participants will also receive a high-level overview of active GASB exposure drafts and ongoing projects. The course is designed to help auditors, preparers, and financial leaders understand how these developments affect audits, financial statement preparation, and board reporting.
More Dates
An Accountant's Detailed Guide to Databases, Integration, and Data Sharing
-
Online/Webcast
2.00 Credits
See more dates
Every business professional today needs to know how to work with data. We are all generating more and more data every day. However, only some of us know how it can be effectively leveraged. There are many new opportunities for people who can effectively work with data. From helping their organizations make better decisions to working more effectively on projects to creating integration between applications and automating workflows. This course will take a longer and more in-depth look at how to use databases, structure data for optimum workflow, and share data between applications. This course teaches you how to effectively use Excel, Power BI, SQL, and other data-related technologies. You'll also discover how to integrate and share data between different applications. By the end of this course, you'll be able to utilize databases more effectively and make better decisions based on data analytics. We will go beyond the basics to give you the knowledge you need to start.
More Dates
Profiles in Fraud
-
Online/Webcast
1.00 Credits
See more dates
Nobody is immune to fraud risk. This course opens with stories of real fraud perpetrators then examines the similarities between the fraud perpetrators, discovering that they all have many common traits. It finishes with techniques accountants can use to deter these behaviors. 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
