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 2: Working with PivotTables
-
Online/Webcast
2.00 Credits
See more dates
Unlock the full potential of your data with PivotTables PivotTables are a versatile and transformative tool for organizing and analyzing data. Whether you're a beginner or an experienced user, this course will provide you with the knowledge and skills to make the most of PivotTables so that you can: Customize PivotTable options Execute advanced calculations Create insightful reports Moving beyond formula-based reports By delving into more advanced techniques for using PivotTables, you'll learn how to replace formula-based reports by: Incorporating multiple fields into the Values area Performing custom calculations using calculated fields and items Setting up PivotTable options to create sophisticated reports *Session 2 is one of four individual sessions. Each session builds on the previous one, so consider watching [Streamlined Excel Reporting Series Session 3: PivotTable Displays and Alternatives](Need new URL due to Title change) to tackle real-world issues and create powerful workbooks.*
More Dates
Recruit. Retain. Engage. Mastering LinkedIn for HR Success
-
Online/Webcast
2.00 Credits
See more dates
Today's savvy executives use LinkedIn to accelerate hiring, as well as, to promote employee retention and engagement. This interactive session is for the financial executive who is actively growing and nurturing a team or company and wants to leverage LinkedIn, which is the best digital resource available. Join us for this powerful webinar and unlock the full potential of LinkedIn as your HR secret weapon for recruiting top talent, retaining your best employees, and elevating overall team engagement. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Sandra Long
More Dates
Money Laundering 101 for CPAs
-
Online/Webcast
4.00 Credits
See more dates
CPAs spend most of their working lives reviewing bank statements and books and records of businesses. They are experts in understanding how to prepare financial statements according to GAAP. But would a CPA know a possible money laundering transaction if they saw it? Would they know about a money laundering business? Money laundering is a subject of many action and thriller movies, but rarely understood. This presentation will educate the CPA in understanding the basics of money laundering and how to identify money laundering. This presentation will help the CPA know the truth about money laundering, how to identify it, the statutes that define it, and the court cases that interpret it. 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
Addressing Common Documentation Deficiencies
-
Online/Webcast
2.00 Credits
See more dates
The Enhancing Audit Quality Initiative has identified inadequate or nonexistent audit documentation as one of the most significant issues facing the profession today. Over half of the engagements reviewed by the AICPA failed to meet the requirements of AU-C 230, highlighting a critical need for improvement. This course addresses common misconceptions about audit documentation and provides actionable strategies to overcome these deficiencies. Attendees will learn best practices to ensure compliance with professional standards, enhance audit quality, and mitigate risks associated with poor documentation. Whether you are an experienced professional or new to auditing, this course will help you strengthen your documentation practices and uphold the highest standards of the profession. Speaker - Jaclyn Veno
More Dates
FASB Update and Review
-
Online/Webcast
2.00 Credits
See more dates
Periodic FASB checkups are critical for accountants who deal with financial statements prepared in accordance with U.S. GAAP. This course introduces recent FASB pronouncements and revisits selected existing standards that are likely to be salient for private entities. This session also offers a preview of coming attractions by examining significant elements of the FASB's technical agenda. Speaker - Dr. Chris Harper
More Dates
Advanced Cost Accounting: Eliminate Calculation Distortions
-
Online/Webcast
2.00 Credits
See more dates
Organizations that use primitive costing methods make predictable mistakes, allocating too much cost to easy, high-volume "gravy" products and too little cost to difficult, low-volume "dog" jobs, putting an organization with inferior information at a significant competitive disadvantage. The secret to being the “smart competitor” is learning how to deal with overhead. This session will show you how to assign 16 key overhead categories. Whether you work in a wholesale, retail, healthcare, service or manufacturing business, you will find this session invaluable. Get your cost right, and you will be able to give the "dogs" to your competitors and keep the "gravy" for yourself. Speaker - John Daly
More Dates
Individual Tax Update: Recent Developments
-
Online/Webcast
2.00 Credits
See more dates
A discussion of the latest 2024/25 tax developments impacting individual taxpayers, with a focus on important provisions, rules and concepts. 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
Surgent's The Art of Delegation: Strategies for Improving Your Skills
-
Online/Webcast
2.00 Credits
See more dates
One of the most challenging skills for a manager or supervisor to master is delegation. This course will cover a variety of delegation-related topics and provide participants with the necessary knowledge and skills to delegate work and authority effectively.Speaker - Deb Brown
More Dates
Taking Advantage of Array Formulas in Excel
-
Online/Webcast
2.00 Credits
See more dates
This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel. 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
Internal Control - Testing for Operating Effectiveness
-
Online/Webcast
2.00 Credits
See more dates
Properly designed and effectively operating internal control over financial reporting is critical for preventing, or detecting and correcting, material misstatement. This course describes how to satisfy the audit requirements related to taking a control reliance strategy by testing the operating effectiveness of internal controls, while promoting an effective and efficient financial statement audit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Jennifer F. Louis, CPA
More Dates
Installment sales: Maximize Tax Benefits and Stay Compliant
-
Online/Webcast
1.00 Credits
See more dates
This course explores the complex rules of installment sales, with a focus on their tax treatment and strategies to maximize the benefits. 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
Surgent's Guide to the AICPA Quality Management Standards
-
Online/Webcast
2.00 Credits
See more dates
With only a few months to go before the AICPA's Statement on Quality Management Standards 1, 2, and 3 (SQMS 1, SQMS 2, and SQMS 3, respectively), SSARS No. 26, SAS 146, and SSAE 23 are required to be implemented, this course can help you meet the deadline. It focuses not simply on theory but on HOW to perform the steps involved. The Quality Management Suite of Standards must be implemented by December 15, 2025. The standards modernize the firm's approach to quality to reflect an increased focus on risk assessment, technology use, and the presence of outside experts on many engagements. Beginning with performing a risk-based approach, the standards provide accounting firms with the ability to enhance their quality control by shifting their focus to a proactive approach (management) from a reactive approach (control). The results of the firm's risk assessment will form the basis of its new Quality Management document. This is not just a tweak of the old document but a more robust document that adds new requirements from the new standards. We will cover how to perform a risk assessment, including the key provisions of the standards, and how to effectively implement a monitoring plan. We will also review how the firm will evaluate its System of Quality Management beginning in 2026.Speaker - Marci Thomas, CPA
More Dates
Surgent's Construction Contractors: Accounting and Financial Reporting Issues
-
Online/Webcast
4.00 Credits
See more dates
Accounting and financial reporting for construction contractors may be the most difficult area to be in compliance with the various standards. Also, construction engagements are, in many instances, more "dangerous" than most lines of business due to the many users of the financial statements. In this course, we will discuss why construction accounting and financial reporting are so complex and discuss the relationship between the contractor and the surety, both from an underwriting and claims perspective. We will also explore what the surety looks for in order to maximize potential bond credit.Speaker - Dave Peters, CPA, CFP, CLU, CPCU, MST, MBA
More Dates
How to Audit Inventory
-
Online/Webcast
2.00 Credits
See more dates
Inventory observations are often a right of passage for audit staff. This course will cover the basics of auditing inventory, including the related audit assertions, risks, & threats to inventory. During this course, we will also highlight the various substantive auditing procedures that staff should perform, and also walk through how to conduct a physical inventory observation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Jaclyn M. Veno, 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
Disrupt to Dominate: Mastering Change Leadership
-
Online/Webcast
4.00 Credits
See more dates
In an era defined by rapid change and uncertainty, effective leadership requires more than just managing teams; it demands the courage to disrupt and innovate. This course is your blueprint for transforming potential chaos into a strategic advantage and is designed for leaders at all levels-whether you're a seasoned CEO, an ambitious small business owner, or an individual contributor aspiring to influence greater change. You'll gain the insights and tools needed to not only adapt to change but to lead it effectively and confidently. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Tammy Daugherty
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.Speaker - Bryan L. Smith, CPA.CITP, CISA
More Dates
Surgent's Work-Life Balance: Maximizing Productivity and Understanding Related Tax Issues
-
Online/Webcast
2.00 Credits
See more dates
Working as a financial professional is an accomplishment that offers the potential for a good salary with long-term growth. Despite being a sought-after career, studies show that being overworked is the greatest source of anxiety and dissatisfaction among financial professionals. Left unchecked, a life centered exclusively around the demands of work can be both physically and emotionally detrimental. Establishing a work-life balance is difficult in any profession, yet financial professionals confront unique challenges that make this goal seem even more elusive. Technology results in being "always on," with no true time to disconnect and genuinely enjoy family, exercise, or hobbies. Lack of balance comes with costs, including poor health and lower productivity. Why are some professionals able to establish a successful balance between career demands and family while others are not? How are some firms able to achieve both high employee satisfaction and strong productivity? This course looks at research, surveys, and simple anecdotal information to provide a better understanding of how to achieve a realistic work-life balance in the modern world. The program also discusses the tax consequences that arise when professionals seek balance by working from home in one state while their employer is located in a different state.Speaker - Jason Cornell, Esq.
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
Business Partnerships: Managing Supplier Relationships
-
Online/Webcast
1.00 Credits
See more dates
As financial leaders, CPAs are often tasked with managing organizational risk. In this respect, the supplier relationship can be a tricky one. It is often one of the more familiar and comfortable business relationships we have, yet it may also be the one that presents the most significant risk to our company. In this course, we will explore how to manage the supplier relationship from onboarding to termination. Through case studies and best practices, we will discuss how to continue being a good partner to our suppliers while also understanding where potential risks exist. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - David Peters