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.
Surgent's 2025 Tax Update for Client Advisory Services
-
Online/Webcast
4.00 Credits
See more dates
Client advisory services (CAS) professionals are becoming a more integral part of the operations of any CPA firm. As such, they must stay on top of changing tax law. In this course, we will explore tax changes in areas CAS professionals are involved with - information reporting, payroll tax issues, and tax credit and deduction documentation. We will also discuss relevant changes to individual and business tax returns so that CAS professionals can better assist clients with tax needs in the upcoming year.Speaker - Dave Peters, CPA, CFP, CLU, CPCU, MST, MBA
More Dates
Surgent's Avoiding Deficiencies in Peer Reviews: Focus on Engagement Quality
-
Online/Webcast
4.00 Credits
See more dates
With the AICPA's heightened focus on enhancing audit quality, increased oversight of the peer review process and the auditor's overall responsibility to provide high quality services, the focus on compliance with professional standards has never been greater. Add to that the requirement to implement the revised risk assessment standards (SAS 145) and it's easy to see why it's more important than ever to ensure that auditors have a good understanding of the requirements and comply with documentation standards. Recent peer reviews have indicated that auditors are often failing to perform and/or document certain critical components of an audit such as the auditor's assessment of risk and linking the results of the assessment to substantive procedures performed. In addition, auditors are not adequately documenting their consideration of fraud, expectations in analytical procedures and the appropriate level of work needed to understand an entity's internal control. The AICPA issued its Quality Management Standards in 2022. Firms are required to implement the standards by December 15, 2025. And the firm's evaluation of the System of Quality Management is required within one year after that. This is not just a matter of tweaking the firm's existing QM document, the standard requires a risk assessment process to identify risk. The objective of the course is to provide the insights necessary to help auditors and accountants improve not just the quality of their work but also the perception of the accounting profession as a whole. We will focus on the most significant items resulting in deficiencies identified in the peer review process. We will also discuss the applicable audit standards, documentation requirements, and best practices. We will address the new QM standards.Speaker - Marci Thomas, CPA
More Dates
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
You Don't Know What You Don't Know About Microsoft Excel
-
Online/Webcast
8.00 Credits
See more dates
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Karl Egnatoff, CPA.CITP
More Dates
Securing Your Data with a Password Management App - Updated
-
Online/Webcast
2.00 Credits
See more dates
Cybersecurity protection is one of the most important responsibilities of every CPA professional to protect the confidentiality of sensitive client information. While there are many aspects of cybersecurity that need to be addressed, the biggest vulnerability to protect against is unauthorized access to your application login credentials. Once your login credentials are breached, the cybercriminal essentially has the keys to your data kingdom. John Higgins, a national leader in the CPA technology, will demonstrate the ease with which you can protect all of your login credentials with maximum security with minimal expense. You will leave this course prepared to deploy this state of the art security tool in your organization. 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 A Complete Guide to Reporting Form 1099-DA
-
Online/Webcast
2.00 Credits
See more dates
For each digital asset sale that a broker has affected for a customer in 2025, the broker must complete Form 1099-DA. A broker includes any person who, in the ordinary course of a trade or business, stands ready to affect sales of digital assets to be made by others. This program covers the required rules for reporting digital asset transactions on Form 1099-DA.Speaker - Mike Tucker, Ph.D., LL.M., J.D., CPA
More Dates
Surgent's Contract Law for Accounting and Finance Professionals
-
Online/Webcast
2.00 Credits
See more dates
Accounting and finance professionals routinely encounter a broad range of legal issues while advising clients or performing routine job functions. Contract law tops the list as the most frequent issue that intersects with the accounting and finance professions. As trusted advisors, it is wise to understand the fundamentals of contract law for both personal and professional benefit. This course provides a broad overview of contract law basics geared specifically toward the accounting and finance professions. From contract formation to enforceability, this course offers an interesting look at how contract law intersects with accounting and finance. Participants should walk away with a better understanding of common issues that arise when reviewing contracts.Speaker - Jason Cornell, Esq.
More Dates
Surgent's Controllership Skills Update - Budgeting, Forecasting, and Big Data
-
Online/Webcast
2.00 Credits
See more dates
Budgets are the vehicle for allocating resources, measuring activities, and identifying needed changes and improvements. An organization's strategy is the primary driver of costs. To be effective, the budget must be linked to strategy and long-term plans. Numerous organizations have achieved a series of short-term targets (budgets) but failed longer term, demonstrating the lack of this necessary linkage. Forecasting, a critical part of any successful budgeting process, can be flawed by technical errors, organizational structure, or emotional forces. The establishment of a system to collect, process, and analyze big data can provide significant insights into the budgeting and forecasting process. An efficient system of incorporating big data and analytics into normal activities will improve management's decision-making. This brief program offers specific actions to improve your forecasting and budgeting activities. In addition, more advanced techniques are identified for the participant's further review, which can be applied throughout an organization. Good budgets effectively allocate resources, provide information for decision-making and serve as an early warning system for unforeseen events. A poor budgeting process fosters a false sense of security, provides inappropriate or inaccurate data, and reinforces the status quo. Budgets are about the organization's story, not just the raw numbers!Speaker - Tony La Russo, BA, MBA, CMA
More Dates
Surgent's Excel: Mastering PivotTables
-
Online/Webcast
2.00 Credits
See more dates
PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.Speaker - Jeff Lenning
More Dates
Surgent's Implementing Subscription Pricing to Your Practice
-
Online/Webcast
2.00 Credits
See more dates
This course is designed to provide accountants with a comprehensive understanding of the subscription pricing model. As the business world increasingly shifts toward subscription-based models, it's crucial for accountants to understand the financial implications and strategies associated with this pricing approach. This course will cover the basics of subscription pricing, how to set prices, and how to analyze the financial impacts of these decisions, as well as the specific impacts to your business. By the end of this course, participants will be equipped with the knowledge and skills to effectively manage the implementation of subscription pricing to their practice.Speaker - Christina Hilton, CPA
More Dates
Microsoft Teams - Everything You Need to Know from A to Z
-
Online/Webcast
4.00 Credits
See more dates
Microsoft Teams is one of the most popular tools for communication, collaboration, and knowledge sharing. If you use Microsoft Teams in your practice or business, this is a "must attend" course. You will learn everything you need to know to optimize the features of Teams and maximize your productivity. We will cover everything from how to effectively design your teams and channels configuration. How to utilize all the Teams features for posting conversations and working with your Office documents, PDF files and more. You will leave this course with the skills to master all the features of Teams! 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
Keeping Up with the FASB
-
Online/Webcast
2.00 Credits
See more dates
This course will explore significant elements of the FASB's technical agenda, focusing on recent updates to revenue recognition and lease accounting standards. A Special Purpose Framework overview will be provided, which may reveal salient alternatives to U.S. GAAP for certain entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Chris Harper, CPA
More Dates
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Online/Webcast
2.00 Credits
See more dates
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.Speaker - Jeff Lenning
More Dates
Understanding the New Forms K-2 and K-3
-
Online/Webcast
2.00 Credits
See more dates
Schedules K-2 and K-3 are promulgated by the IRS in order to standardize the reporting of foreign-related tax information for pass-through entities. Even pass-through entities that have no foreign activities, investments, or partners may have a reporting requirement. Schedules K-2 and K-3 for reporting partners' income, deductions, and credits from foreign activity are now required for passthrough returns (Form 1065, 1120-S and 8858). This requirement starts with returns with a tax year that ends in 2021. This course discusses each part of these schedules and explain these new reporting obligations in detail. 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. McLeod, LL.M., CPA
More Dates
Al Capone to Cybercrime: The Journey of IRS Special Agents
-
Online/Webcast
4.00 Credits
See more dates
Since 1919, the Internal Revenue Service had a civil and criminal function in the United States tax system. Little do people know, the IRS has an elite criminal function that started with five United States Postal Inspectors. From its early days in taking down Al Capone to now solving cybercrimes, the IRS special agents are tasked with investigating tax fraud, money laundering, and other white collar crimes. This presentation will show you the importance of this law enforcement function, the training, techniques, expertise, and actions that cause them to be known as the "world's finest financial investigators." This presentation has been prepared by a 20 year veteran with the IRS-Criminal Investigation. The presenter investigated crimes, and trained and mentored other special agents. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Robert Nordlander, CPA, CFE
More Dates
Becoming Conflict Competent
-
Online/Webcast
2.00 Credits
See more dates
Conflict is often avoided, or dealt with in a passive manner. When ignored, conflict often escalates and can become polarizing. In this session, participants will gain insights for enhancing their natural responses to conflict, learn healthy communication styles, and build constructive behaviors to manage conflict. 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
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 Reasonable Suspicion
-
Online/Webcast
1.00 Credits
See more dates
Given the opioid epidemic and the legalization of medical and recreational marijuana in a growing number of states, many employers are concerned about the impact drugs and alcohol may be having on the safety and security of their workplaces. Reasonable suspicion testing is among the best ways for employers to identify whether an employee is under the influence of drugs or alcohol while working. This webinar explores what managers and supervisors need to know to implement a Reasonable Suspicion Testing Policy.Speaker - Amy McAndrew, Esquire
More Dates
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.Speaker - Steven C. Dilley, CPA, JD, PhD
More Dates
Comprehensive Audit & SSARS Update
-
Online/Webcast
4.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.Speaker - Allison M. Henry, CPA, CGMA