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.
Advanced Excel: Hidden Secrets and Gems
-
Online/Webcast
2.00 Credits
See more dates
This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel. Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level. 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
Streamlined Excel Reporting Series Session 1: PivotTable Fundamentals
-
Online/Webcast
2.00 Credits
See more dates
Harnessing the potential of PivotTables Whether you're just starting out or seeking to improve your Excel expertise, PivotTables are versatile and powerful tools for data analysis. This course delivers a well-organized method for effectively understanding and using PivotTables through: Practicing fundamentals with a leading expert in financial modeling Creating and using sample datasets Building PivotTables from the ground up Innovative possibilities for presenting data The core functionality of PivotTables for financial professionals is the ability to transform large datasets into meaningful summaries. By reorganizing data from a spreadsheet, PivotTables allows you to: Extract key information and identify trends quickly Simplify the process of analyzing data Reduce the time spent on repetitive tasks *Session 1 is one of four individual sessions. Each session builds on the previous one, so consider watching [Streamlined Excel Reporting Series Session 2: Working with PivotTables] (https://www.aicpa-cima.com/cpe-learning/webcast/streamlined-excel-reporting-series-session-2-working-with-pivottables) to tackle real-world issues and create powerful workbooks.*
More Dates
Surgent's A Complete Guide to Form 1099-K
-
Online/Webcast
2.00 Credits
See more dates
The Internal Revenue Code (IRC) requires entities making certain types of payments, including business payments to contractors, to file information returns with the IRS. Information returns are intended to improve voluntary compliance with tax law by providing information about potentially taxable transactions to the IRS and taxpayers. A payment settlement entity (PSE) must file Form 1099-K for payments made in settlement of reportable payment transactions for each calendar year.Speaker - Mike Tucker, Ph.D., LL.M., J.D., CPA
More Dates
Surgent's Critical Issues Involving Taxation of Construction Contractors
-
Online/Webcast
4.00 Credits
See more dates
Many consider taxation of construction contractors to be the most complex area of the Internal Revenue Code. Probably no other industry has so many elections and considerations that need to be considered and made in order to reduce or defer amounts owed. In this course, we will highlight these areas and discuss potential opportunities for practitioners and their clients. We will also discuss the impact of more recent legislation on construction taxation, including changes to net operating losses and the AMT rules. This is a critical presentation "tailor-made" for CPAs who either work for or represent construction contractors.Speaker - Dave Peters, CPA, CFP, CLU, CPCU, MST, MBA
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 Buying and Selling a Business: Tax and Structuring Overview
-
Online/Webcast
4.00 Credits
See more dates
One of the major transactions CPA clients are faced with is the purchase or disposition of a business. To help tax professionals advise those clients, this course offers a comprehensive analysis of the business and tax aspects of buying and selling a business. It is a practical guide to help practitioners and industry CPAs understand structuring techniques. All CPAs, including controllers and executives in industry, should understand how difficult the process of buying and selling a business has become.Speaker - Michael Frost, CPA
More Dates
How Recent Auditing Standards Improve Risk-Based Audits
-
Online/Webcast
4.00 Credits
See more dates
Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in the SASs. 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
Employment Law 101
-
Online/Webcast
1.00 Credits
See more dates
Review of the major employment laws governing the workplace, when they are triggered, and key compliance aspects under each law. This presentation is designed to give viewers enough information to issue spot when matters arise in the workplace. Speaker - Alana Ackels
More Dates
Leveraging ChatGPT for Innovative Business Advisory Services
-
Online/Webcast
2.00 Credits
See more dates
In this cutting-edge course, participants will gain a deep understanding of how to leverage ChatGPT, OpenAI's powerful language model, to innovate and enhance business advisory services in the accounting sector. The course integrates theory and practice, demonstrating how various enterprise evaluation methodologies can be applied in conjunction with ChatGPT for increased business analysis efficiency, profitability, and growth. It also provides hands-on training for implementing these techniques in real-world scenarios. 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 Engagement and Client Retention Best Practices
-
Online/Webcast
2.00 Credits
See more dates
Positive client relationships require work. Miscommunication, unrealistic expectations, and differing personality styles may strain a client's relationship with professional advisors. Fortunately, there are tested strategies that foster and strengthen client relationships. Creating appropriate boundaries early on is one of many effective strategies that can help. This course explores actions accounting and finance professionals can take to create and grow their client relationships. This webinar provides actionable insights on how to engage new and old clients alike. Strained client relationships can harm both the client and the firm's profitability. Yet automation, for example, allows some firms to remain more engaged while others miss the mark. There is a science underlying client retention that involves understanding the client journey, ensuring consistent client interactions, and equipping employees with the tools needed to satisfy client needs. Understanding these skills should help you protect the relationships that sustain your business. Speaker - Jason Cornell, Esq.
More Dates
How AI Is Automating Internal Control
-
Online/Webcast
4.00 Credits
See more dates
The term "artificial intelligence" (AI) has become mainstream and while most have a layperson's understanding of AI, few know the depth and breadth of this technology's capability. AI is affecting just about everything in business and in people's personal lives. The operation of an internal control system is also changing because of this incredible advancement. This session explains what AI is and how it works and then goes into detail about how it can be applied to a system of internal control. The material speaks about changes occurring in today's world as well as what's coming in the not-too-distant future. 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
2025 Governmental GAAP Update: Navigating GASB Standards
-
Online/Webcast
2.00 Credits
See more dates
This course begins with a look at the GASB standards effective this year, including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We'll include practical application of the topics in the form of case studies. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Melisa F. Galasso, CPA
More Dates
Benford's Law and Other Digital Analysis Techniques
-
Online/Webcast
1.80 Credits
See more dates
Numbers and especially the digits within those numbers can conceal a lot of information. Benford's Law and other digital analysis techniques can be the keys to unlocking that information. This session will explain what Benford's Law is, how it works, and how it can be used to reveal bogus information and made-up data. Accountants and auditors should understand how to use this valuable audit tool as well as other digital analysis techniques. But, if you attend this session, you must promise not to reveal the secret behind these techniques to any fraud perpetrators. Speaker - David Cotton
More Dates
Internal Control Best Practices
-
Online/Webcast
2.00 Credits
See more dates
Whether your organization is developing a new control framework or seeking to strengthen its current controls, practical development and implementation is critical. This course will review the intersectionality of controls and provide real-world examples and best practices from people to technology and process. Speaker - Melisa Galasso
More Dates
Inventory, Expense and Payroll Fraud
-
Online/Webcast
2.00 Credits
See more dates
Inventory is a wonderful place to both hide fraud and commit fraud. The reasons that inventory is subject to so much fraud is the it is often very large, spread out over a large area, and many people have access to it. When there are little or no internal controls related to inventory control, you are begging employees to steal it. No with so many ways to dispose of stolen inventory via the internet, i.e., EBAY, inventory fraud is much more appealing to a lot of individuals. The more common ways to commit expense fraud and how to cover it up will also be discussed. Travel and entertainment are some of the favorite areas of committing expense fraud. In addition, payroll fraud will be discussed. Although there are many ways to commit payroll fraud, it is very easy to prevent. This presentation is designed to familiarize the participants with the many ways to commit inventory, expense and payroll fraud, how to detect it, and more importantly, how to prevent it. Speaker - Dennis Dycus
More Dates
Surgent's Section 754 Step-Up in Basis: Understanding the Tax Issues for Partnerships and LLCs
-
Online/Webcast
2.00 Credits
See more dates
When a purchaser buys an existing partner's partnership interest or the interest of a member of a limited liability corporation (LLC) taxed as a partnership, the amount paid becomes the basis for the purchaser's partnership interest (outside basis). If the partnership's assets have appreciated sufficiently, the difference between the new partner's inside and outside basis can be substantial. This disparity can deprive the new partner of depreciation deductions and inflate his or her share of the gain from subsequent property dispositions unless a Section 754 election is in effect. The Section 754 election can also apply when a partnership makes a distribution of property and the basis of the distributed property to the partnership and the basis the partner/distributee will take in the distributed property are not equal. In this case, a partnership can recover basis it would otherwise lose if the 754 election were not in effect.Speaker - Mike Tucker, Ph.D., LL.M., J.D., CPA
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
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
Internal Control Frameworks for Single Audit
-
Online/Webcast
1.00 Credits
See more dates
The Uniform Guidance identifies COSO and the Green Book as best practices for internal controls in governmental audits. This course provides a comprehensive review of the COSO framework, including its 2013 update, and explores its application to the Green Book. Attendees will learn to recall the five components and 17 principles of internal control, understand the benefits of adopting internal control frameworks, and recognize the rationale behind the COSO 2013 update and its impact on auditing practices. Additionally, the course will cover how to leverage Part 6 of the Compliance Supplement to effectively document internal controls. Speaker - Melisa Galasso
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