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, and Surgent to deliver high-quality webcast and self-study content conveniently and cost-effectively. Stand-alone courses and all-access packages are available. Filter using the Vendor name. Learn more.
Our 2025 Course Listing is on its way!
Check back soon for our extensive list of hundreds of courses to fit your learning goals.
Complete Guide to Analyze Data with Excel PivotTables
-
Online/Webcast
4.00 Credits
See more dates
Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Bryan L. Smith, CPA.CITP, CISA
More Dates
Unlocking Deep Secrets: Case Studies in Financial Analysis
-
Online/Webcast
2.00 Credits
See more dates
Unlock the secrets to understanding a company's financial health and management performance through comprehensive financial analysis. This seminar will guide you through essential tools such as vertical analysis, horizontal analysis, and ratio analysis to gain deep insights into business performance. - Vertical Analysis: Learn how to express each line item of financial statements as a percentage, making it easier to compare companies of different sizes and identify key trends. - Horizontal Analysis: Discover how to compare financial information over multiple periods to spot significant changes and trends, providing a clearer picture of a company's growth and performance. - Ratio Analysis: Dive into calculating and interpreting financial ratios to assess profitability, liquidity, and solvency. Understand how these ratios reveal the effectiveness of management and the potential of the business. This seminar goes beyond just teaching terms and formulas. We will apply these analytical tools to real-world financial data, demonstrating how to derive meaningful insights and make informed decisions. Join us to enhance your financial analysis skills and gain a competitive edge in evaluating business performance. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Eric Knight, CPA, DBA
More Dates
Tax Implications of Retirement Plan Distributions
-
Online/Webcast
1.00 Credits
See more dates
This session will address the complex rules of retirement distributions, review key provisions of the SECURE Act 2.0, and provide practical strategies of maximizing tax benefits for your client. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Steven C. Dilley, CPA, JD, PhD
More Dates
AI Revolution: The Big Picture for CPAs
-
Online/Webcast
2.00 Credits
See more dates
Discover how artificial intelligence is transforming the accounting, tax and finance landscape. This course offers CPAs a comprehensive overview of AI technologies, with a special emphasis on generative AI tools such as ChatGPT and Google Gemini. Learn how these advancements are reshaping business operations and what they mean for your professional role. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - John Higgins, CPA.CITP
More Dates
Surgent's Home Office Rules
-
Online/Webcast
2.00 Credits
See more dates
Since 2017, employees have not been eligible to take an itemized deduction for a home office. The Tax Cuts and Jobs Act suspended all miscellaneous itemized deductions for tax years 2018 through 2025. That deduction is scheduled to go into effect in 2026. Self-employed individuals can deduct office expenses on Schedule C, Form 1040. The home office deduction includes typical office-connected expenditures such as supplies, postage, computers, printers, and all the other ordinary and necessary expenses a person would have in connection with running a home office. The home office tax deduction for the self-employed would cover expenses for the business use of a home, which includes mortgage interest, rent, insurance, utilities, repairs, and depreciation. This program discusses many of the most important issues relating to the deductibility of home office-related expenses. Speaker - Mike Tucker, Ph.D., LL.M., J.D., CPA
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.Speaker - Jason Cornell, Esq.
More Dates
COSO's Internal Control Framework Essentials
-
Online/Webcast
3.50 Credits
See more dates
COSO framework overview Gain an overview of COSO's internal control framework comprising five components and their related principles. Learn how to evaluate the control environment, risk assessment, control activities, information and communication, and monitoring activities at your or your client's entity. Through real-life examples, enhance your understanding of how to apply the framework as it relates to financial reporting whether you are an auditor or entity management.
More Dates
Surgent's Taking Advantage of Installment Sales and Like-Kind Exchanges
-
Online/Webcast
4.00 Credits
See more dates
When real property is sold for a gain, we always try to find ways to defer recognizing income so it won't be necessary to send a check to Uncle Sam. There are two provisions within the Internal Revenue Code that allow the taxpayer to defer recognition of immediate taxable gain in the year of sale: installment sales and like-kind exchanges. Knowing how and when to utilize these provisions makes the Accounting and Finance Professionals very valuable to either their client or the entity they work for. We will also discuss recent proposals which could impact the future of these two provisions.Speaker - Dave Peters, CPA, CFP, CLU, CPCU, MST, MBA
More Dates
Surgent's Accountability and Action
-
Online/Webcast
4.00 Credits
See more dates
Good managers know how to delegate, but it can be a challenge to manage employees who are more interested in passing the buck than being responsible. Lack of ownership and responsibility can bog down processes and shut down projects. This workshop will help you create a game plan for building a culture of accountability with your team.Speaker - Sarah Acuna
More Dates
Surgent's Top 20 Questions Advisors Ask About the SECURE Acts and Other IRA Rules
-
Online/Webcast
2.00 Credits
See more dates
Advisors often ask clarifying questions as they increasingly gain an understanding of new and existing tax laws that govern IRAs. Some provisions see more questions than others due to their complexity, popularity, and level of impact on tax benefits. This course focuses on the top 20 of these questions and on SECURE Act 1.0, SECURE Act 2.0, and other hot topics. This course aims to help the advisor provide clients with the correct responses based on their IRA profiles.Speaker - Denise Appleby, MJ, APA, CISP, CRPS, CRC
More Dates
The Art of Engaging in Difficult Conversations
-
Online/Webcast
2.00 Credits
See more dates
Difficult conversations tend to be avoided because professionals shy away from the uncomfortable, and the fear of polarizing their relationships. Participants will learn strategies and tactics to engage in productive conversations which address challenges and deepen relationships. They will understand where and why they are avoiding having difficult conversations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Julie G. Holunga, MBA, CPCC, ACC and Stephanie Wachman
More Dates
Surgent's Advising a Client Regarding the Tax Consequences Associated with Buying or Selling a Business
-
Online/Webcast
3.00 Credits
See more dates
Buying and selling a business can be a complex transaction with many tax issues. These issues include whether the transaction is or should be a stock or an asset sale when the business involved is a corporation, as well as the tax consequences associated with the sale of a partnership or a C or S corporation. Tax practitioners who advise clients who are buying or selling a business primarily focus on the tax issues that apply. This program explains and analyzes the tax issues practitioners must address in order to properly advise clients who are either buyers or sellers of businesses.Speaker - Mike Tucker, Ph.D., LL.M., J.D., CPA
More Dates
Comprehensive Accounting and Financial Reporting Update
-
Online/Webcast
4.00 Credits
See more dates
This course covers recently issued accounting and financial statement reporting standards from the Financial Accounting Standards Board. Key implementation challenges and experiences from public company filings will be identified. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Allison M. Henry, CPA, CGMA
More Dates
Entertainment, Meals & Travel Expenses: Review and Update
-
Online/Webcast
2.00 Credits
See more dates
This program reviews the statutory and regulatory guidance as they relate to fringe benefits. There will be an emphasis on entertainment, meals and business transportation expenses, including qualified employer-provided parking, with a focus on planning opportunities. Recent federal tax legislation, cases and rulings will also be addressed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Steven C. Dilley, CPA, JD, PhD
More Dates
Clean, Transform & Load Data in Power BI
-
Online/Webcast
2.00 Credits
See more dates
This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Bryan L. Smith, CPA.CITP, CISA
More Dates
ChatGPT for Accountants: 50+ Use Cases
-
Online/Webcast
2.00 Credits
See more dates
This course will explore the use of ChatGPT and artificial intelligence chatbot technologies in the accounting profession. Participants will learn how to utilize ChatGPT to automate tasks, improve efficiency and accuracy, and provide real-time support to clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Garrett Wasny, MA, CMC, CITP/FIBP
More Dates
Tactics to Find Work Life Balance in a Complex World
-
Online/Webcast
1.00 Credits
See more dates
This session will explore key aspects of getting more satisfaction out of the work you choose to do and how to find greater balance between the demands of work and other lifestyle choices in an ever more complex and changing world. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Ronald L Seigneur, CPA/ABV, ASA, CVA
More Dates
Surgent's Individual and Financial-Planning Tax Camp
-
Online/Webcast
8.00 Credits
See more dates
Each year brings its own set of tax planning challenges, and this year is no exception. This course aims to arm tax planners with planning strategies and ideas that all clients, but in particular, wealthy clients, middle-income clients, and closely held business owners need to consider right now to take advantage of present opportunities and plan for future tax advantages. Learn strategies that can really have an impact on client lives, while also bringing value to you and your firm. This material is continuously updated for recent legislation impacting individual taxpayers.Speaker - Bob Lickwar, CPA
More Dates
ChatGPT and Advanced Financial Analysis for Accountants
-
Online/Webcast
2.00 Credits
See more dates
This course provides a concise overview of how to utilize ChatGPT for advanced financial analysis in accounting. The session reveals how to combine sophisticated evaluation and interpretation of financial data with the cutting-edge AI capabilities of ChatGPT. Aimed at enhancing the understanding of an entity's performance, predicting future financial health, and aiding in informed business decision-making, this course goes beyond basic financial statement analysis to include a wide array of techniques and tools. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Garrett Wasny, MA, CMC, CITP/FIBP
More Dates
Surgent's Best Practices in Not-for-Profit Accounting and Reporting
-
Online/Webcast
4.00 Credits
See more dates
Don't just wing it when you can soar! To catch the eye of resource providers and fulfill the needs of leadership, it is essential that not-for-profits prepare financial statements which excel. This course will empower you with the knowledge of not-for-profit accounting and reporting to surpass the expectations of financial statement users. Over 15 focused exercises are included to illustrate and refine today's best practices in not-for-profit accounting and reporting.Speaker - Charlie Blanton, CPA