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.

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
ACPEN: K2’s Data Analytics For Accountants And Auditors
Online/Webcast
4.00 Credits
See more dates
In today's world of "Big Data" every business professional is a data analyst to some extent. This is especially true for auditors, who increasingly rely on data analytics to identify situations that require follow-up and investigation. Those who master the tools and techniques for thorough data analysis can achieve superior results in less time. Join our dynamic session to unlock the full potential of data analytics! You'll explore various tools and techniques, including Excel, multiple Excel add-ins, and Microsoft's Power BI application. Whether you're looking to enhance your skills or dive deeper into the world of data analytics, this course is designed for you. Our expert instructors will guide you through practical, real-world examples, ensuring you grasp the key concepts and apply them effectively. Don't miss this opportunity to elevate your data analysis skills and stay ahead in your field. Enroll now and transform your approach to data analytics!
More Dates
Coping With the Growth of Online Fraud
Online/Webcast
4.00 Credits
See more dates
Just about every company, no matter its size or the types of activities it undertakes, is at greater risk because of all the types of fraud that can be be carried out electronically. Potential perpetrators can be operating internally or externally and the scope of the damage that occurs is almost never limited to cyber-assets. While threat awareness is improving, there are still too many owners or top level executives that underestimate the scale of the issue. In this session, we delve into the types and the nature of many electronic defalcation schemes. The material then explores measures that organizations can implement to help stop these activities and add additional layers of security. 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 Annual Accounting and Auditing Update
Online/Webcast
8.00 Credits
See more dates
Designed as an all-you-need-to-know update for accounting, auditing, and attestation practitioners at all levels in public accounting and industry, this course provides a comprehensive review of recent standard-setting and rulemaking activities of the Financial Accounting Standards Board (FASB), American Institute of Certified Public Accountants (AICPA), Public Company Accounting Oversight Board (PCAOB), and Securities and Exchange Commission (SEC). On the financial accounting front, we will cover the FASB's Post-Implementation Review (PIR) report released in late 2025 for lease accounting under ASC 842 and discuss the best practices in applying the standard and identifying any ongoing issues practitioners are experiencing with applying the standard. We will also discuss the more than a dozen ASUs the FASB has issued since the beginning of 2024 and into 2026 covering government grants, derivatives and financial instruments, practical expedients for credit losses under ASC 326, and expense disaggregation on the income statement. Our focus on AICPA standards includes a detailed discussion of revamped AICPA quality management standards. The AICPA updated and modernized the standards by issuing Statement on Quality Management Standards 1, 2, and 3 (SQMS 1, SQMS 2, and SQMS 3, respectively), SSARS No. 26, and SAS 146, Quality Management for an Engagement Conducted in Accordance with Generally Accepted Auditing Standards (SAS 146). These standards, now effective as of December 15, 2025, modernize quality management standards to reflect an increased focus on risk assessment, technology use, and the presence of outside experts on engagements. We will also discuss AICPA's proposed SAS, The Auditor's Responsibilities Relating to Fraud in an Audit of Financial Statements, intended to supersede AU-C section 240. We will also cover new rules impacting public company audits and present case studies on recent fraudulent accounting stories and best practices for detecting and preventing such frauds. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.
More Dates
Available Until
Available Until
The Best S Corporation, Limited Liability, and Partnership Update Course by Surgent
Online/Webcast
8.00 Credits
See more dates
This year practitioners need to keep abreast of tax changes affecting pass-through entities used by their business clients and employers, and this enlightening course delivers that information. You will learn invaluable strategies, techniques, innovative tax-planning concepts, income-generating ideas, and other planning opportunities available to S corporations, partnerships, LLCs, and LLPs. In addition, this course will discuss current trends and emerging issues, helping practitioners stay informed about relevant and significant topics that may impact their clients. Continually updated to reflect enacted legislation.
More Dates
Available Until
Available Until
Microsoft 365 Application Lightning Round Review-Updated
Online/Webcast
1.00 Credits
Do you use Microsoft (Office) 365? Are you satisfied that you are getting the most that you can from it? If you answered yes then no, this course will provide a really high return on your investment of time and money in this application suite. John Higgins, one of the profession's leading experts on the integration of Microsoft 365 into business, will explain and demonstrate the depth and breadth of the Microsoft 365 ecosystem. The course is designed to raise your awareness of all that you can do with Microsoft 365 and substantially increase your monthly subscription ROI. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Advanced ChatGPT for Accountants
Online/Webcast
2.00 Credits
See more dates
This course concisely explains the latest "see, hear, speak" multi-modal updates to ChatGPT and how they can be used in an accounting context. New features include vision processing, voice conversation, image generation, real-time Internet access, advanced data analysis, plugins and more. Discover how this technology can be used in mind-blowing ways to analyze financial data, optimize processes, and solve problems in the accounting domain. Through the lens of ChatGPT, practitioners can explore innovative solutions, automate routine tasks, and generate deeper insights and value to their clients and organizations in previously unimaginable workflows. You'll walk away with scores of advanced ChatGPT strategies and tips that can be immediately applied and deliver instant results to elevate the efficiency and effectiveness of your accounting projects and tasks. 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 Annual Update for Governments and Not-for-Profits
Online/Webcast
4.00 Credits
This comprehensive annual update brings together key accounting and auditing developments affecting governmental and not-for-profit organizations. The course integrates recent standard-setting activity, emerging global frameworks, and major compliance updates to provide a well-rounded view of changes impacting financial reporting and audit requirements. Participants will begin with an overview of recent accounting developments affecting not-for-profit organizations, including Accounting Standards Updates issued by the Financial Accounting Standards Board and an introduction to the International Non-Profit Accounting Standard (INPAS). Emphasis is placed on understanding the purpose of INPAS and how it compares conceptually to U.S. GAAP for not-for-profit entities. The course then shifts to governmental accounting developments, covering recent pronouncements issued by the Governmental Accounting Standards Board, including GASB Statements No. 103, 104, and 105, along with a high-level overview of active GASB exposure drafts and projects. Participants will gain insight into how these changes affect financial reporting, disclosures, and communication with governing bodies. Finally, the course addresses recent developments affecting Single Audits, including the 2024 Uniform Guidance overhaul, updates to Appendix B of the AICPA GAS/Single Audit Guide, and recent guidance issued through the Office of Management and Budget (OMB). Reporting changes related to SAM.gov are also discussed. Designed for auditors, preparers, and financial leaders working with governmental and not-for-profit entities, this course helps participants understand how recent accounting and auditing changes intersect-and what to monitor as requirements continue to evolve. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
CFO Solutions to IRS Problems
Online/Webcast
4.00 Credits
See more dates
Many CPAs are becoming full-time or fractional CFOs for small businesses. In that position, they are the resident expert in finances, cash flow planning, and budgeting. But what about dealing with the IRS? The IRS has broad powers to administer the assessment and collection of taxes. From removing penalties to criminal prosecutions, this presentation focuses on how CFOs can prevent problems with the IRS and how to develop winning strategies if the IRS knocks on the door. 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: Revenue Recognition - Topic 606 Overview
Online/Webcast
1.80 Credits
This session is the beginning in a series on the new revenue recognition standard. The standard outlines five steps for proper compliance. At the surface, these steps seem simplistic. However, there are many considerations that should be considered within each step based on your process and industry. This course is designed to provide an overview of the technical guidance and outline the five steps involved in the revenue recognition model. We also explore some concepts to consider within each step and then evaluate some challenges that specific industry's may have when complying with the standard. Future courses will further delve into each step and provide example and scenarios that should be considered to properly apply the step.
ACPEN: From Numbers to Narrative: Effectively Presenting Your Budget and Reporting
Online/Webcast
2.00 Credits
See more dates
Perhaps the most important element of the budget process is its communication. If management does not understand the budget – there is an issue. Knowing the right ways to communicate at all levels is essential to stakeholders laying an ownership claim to successful budgets. This session reveals several key guidelines in successful budget presentations and will identify key problems in how people often communicate financial plans. Presenting your budget and reporting is the final part of a four part series, but can easily stand on its own course that is intended to be fun, enjoyable and educational.
More Dates
ACPEN: K2’s Excel Tips – Today’s Best Features
Online/Webcast
2.00 Credits
See more dates
Wow! So many new Excel features and so little time! Microsoft continues to add tremendous functionality to Excel - the business professional's tool of choice. Yet most Excel users have not discovered these new tools and remain mired in yesterday's practices for working in Excel. In this session, you will learn how to use many of Excel's latest features to work more efficiently and effectively with your spreadsheets. Participate in this session to learn about recently released features such as PIVOTBY, GROUPBY, Office Scripts, integration with Copilot, new ways to share and collaborate in Excel, and data entry and formula improvements. If you work with Excel - and who doesn't - this session is necessary to help you improve your efficiency and effectiveness when using Excel.
More Dates
ACPEN: Introverts Have Real Power, Why Quiet Leaders are So Successful
Online/Webcast
2.00 Credits
See more dates
Leaders were once chosen for their character, but today we live in an age where loudmouthed extroverts seem to take center stage in everything, including business, politics and entertainment. While the talkative, charismatic leader makes the front page of business magazines, recent research shows that successful business leaders tend to be more reserved, pensive and sometimes outright shy. Learn why your desire to spend significant time inside your own head may be your greatest asset. Whether you are introverted or not, you likely work with, manage or are a related to an introvert. We will discuss proven methods to better understand introverts, how to manage them, and how to get the most out of their amazing talents. If you want to enhance your leadership skills, this seminar is for you.
More Dates
Reconciling in QBO
Online/Webcast
2.00 Credits
Reconciliation is how you confirm that your QuickBooks Online checking accounts, savings account, credit cards, loan balances, and liabilities are correct. If you don't reconcile correctly every month, your reports will be wrong! Even if you use the QuickBooks Online banking feed, it's not a guarantee that your bank balances are correct. And when you have extra or missing transactions, your Profit & Loss and Balance Sheet are wrong! Reconciliation is the monthly step to confirm your checkbook balance, credit cards, liabilities, and loans have been entered correctly. The problem is that most businesses reconcile the transactions that ARE on the statement, but ignore the ones that are not. That's not Reconciling, that's "reconciling," and the result is that you may be paying your taxes wrong! In this class, not only will Alicia show you how to reconcile properly, but she'll show you how to trick out the interface to finish in seconds instead of hours. Even better, learn how to identify errors in your accounting data by how they appear in your Reconciliation window. Use reconciling as a troubleshooting tool for duplicated entries, misclassified categories, transactions coded to the wrong funding source, and receipt captures that didn't match the banking feed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Viewing A&A Through the Eyes of a Tax Practitioner
Online/Webcast
1.00 Credits
See more dates
This session offers insight for tax practitioners beyond merely checking a box to satisfy accounting and auditing requirements for license renewal. We devote significant attention to extracting utility from financial statements to support decision needs of both external financial statement users and internal stakeholders. We explore best practices for cross-functional support within firms that perform tax, accounting solutions, financial statement, and consulting services. We also highlight similarities and differences between U.S. GAAP and tax-basis accounting. 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
Master the Art of CPA Communication: Boost Your Influence!
Online/Webcast
2.00 Credits
See more dates
Discover the communication edge that will take your CPA career to the next level. This comprehensive course empowers CPAs with the tools to enhance clarity, build trust, and drive decisions. Learn to transform complex jargon into actionable insights and develop powerful persuasion techniques that resonate with clients and stakeholders. Join me to sharpen your communication skills and elevate your professional impact. 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: A Practical Guide to Trusts
Online/Webcast
8.00 Credits
See more dates
This course provides financial professionals with a comprehensive understanding of trusts and their role in estate planning. Participants will learn how to determine whether a trust aligns with a client's financial goals and explore strategies to maximize tax efficiency. The course covers various trust structures and their potential to reduce income, estate, and generation-skipping taxes at both federal and state levels. Additionally, it delves into trustee responsibilities and the benefits of irrevocable life insurance trusts and dynasty trusts. With a focus on practical applications and real-world scenarios, this course equips CPAs, EAs, attorneys, bankers, and financial planners with the expertise to navigate probate avoidance, streamline asset distribution, and manage complex tax considerations. Whether working with revocable or irrevocable trusts, participants will gain the tools to enhance their clients' financial well-being across generations. *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
Microsoft Teams for CPAs: Unlocking Its Full Potential
Online/Webcast
2.00 Credits
See more dates
Microsoft Teams is designed to be the foundation of your Microsoft 365 ecosystem deployment. When deployed effectively, Teams can serve as a powerful platform for communication, collaboration, and knowledge sharing across your firm or business. Unfortunately, most organizations are substantially underutilizing the capabilities of Teams. This course provides a review and demonstration of the key features of Microsoft Teams that you can harness to optimize the return on your Microsoft 365 investment. 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: GASB 96 –SBITA, GASB 94 P3, and GASB 87 Leases (Year 2)
Online/Webcast
2.00 Credits
See more dates
This is a 2 hour webcast that will focus on the similarities between all three of these GASB accounting standards that deal with contractual arrangements such as leases, Subscription-Based Information Technology Arrangements (SBITA) and P3s. Compare and contrast these standards as you prepare for implementation this year of GASB 94 and GASB 96, and review the implementation efforts of Leases in Year 2.
More Dates
ACPEN: Key Tax Issues for Individual Taxpayers
Online/Webcast
2.00 Credits
See more dates
This course addresses the most recent legislative developments impacting individual taxpayers, with a focus on important provisions, rules and concepts to apply when preparing client returns. **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.