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 for Staff - Build Reports and Analyze Data
-
Online/Webcast
2.00 Credits
See more dates
Advanced Excel for Staff - Build Reports and Analyze Data is a comprehensive, 2-hour course tailored for professionals looking to enhance their Microsoft Excel skills in creating reports and performing data analysis. This course bridges the gap between basic Excel functionality and the advanced techniques required for effective data-driven reports. Participants will learn to efficiently gather, organize, and structure data, apply calculations to derive key metrics, and create professional-grade reports that are both visually appealing and actionable. The course emphasizes practical application, providing participants with guidance on Excel's advanced tools and functions. By mastering workflows and best practices, learners will gain the confidence to tackle complex data challenges and streamline reporting processes. Additionally, participants will explore methods to validate and share their work, ensuring that reports are accurate, insightful, and easily communicated across teams. Whether you are tasked with preparing financial summaries, tracking performance metrics, or generating operational insights, this course will equip you with the tools to maximize Excel's potential, saving time and improving the quality of your outputs. 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
Tech Tips and Tricks for Excellent Video Conferences
Online/Webcast
2.00 Credits
See more dates
As working remotely becomes the new normal, virtual meetings are now the norm. How do you put your best foot forward and make sure your space and tech are up to the challenge. We will show you some of our favorite tech to make you stand out. From the best cameras and microphones for outstanding quality to using a green screen and making custom backgrounds, there are many ways to look and sound your best.
More Dates
2026/27 Not-for-Profit GAAP Update
Online/Webcast
1.00 Credits
See more dates
Stay current on the latest accounting developments affecting not-for-profit organizations with this timely GAAP update. This course reviews recently issued Financial Accounting Standards Board Accounting Standards Updates (ASUs) impacting NFP financial reporting, along with standard-setting projects currently in the FASB pipeline. The course also introduces the International Non-Profit Accounting Standard (INPAS)-the first comprehensive global accounting framework designed specifically for non-profit organizations, launched in October 2025. Participants will gain perspective on the purpose and structure of INPAS and how it compares conceptually to U.S. GAAP requirements for NFPs. This course is designed to help practitioners, financial leaders, and auditors of not-for-profit organizations understand both current GAAP requirements and emerging global developments shaping the future of nonprofit financial reporting. 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
Navigating IRS Correspondence: Responding to IRS Letters
Online/Webcast
2.00 Credits
See more dates
Participants will learn how to interpret the most common IRS correspondence, adhere to response deadlines, and effectively communicate with the IRS to resolve issues and minimize risks. It provides professionals with knowledge and strategies needed to handle the most common notices including audit requests, collections & return inquiries as well as error notices. Focusing on best practices to ensure compliance and avoiding penalties or escalation. 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 Ensure Your Accounting Team Is Operating at Peak Performance Through Engagement and Motivation
Online/Webcast
2.00 Credits
See more dates
Effective teamwork pays its own way by creating greater productivity and profitability in any accounting organization. A team of people working cooperatively can produce more than the sum of individual members working alone. One good idea stimulates another — but only if the team members are engaged and motivated to do so. Teamwork is inhibited in today's high-stress and changing accounting regulatory environment. Integrated into this informative yet pragmatic seminar are tried-and-true motivational principles for the realities of today's changing accounting workplace. It's not easy, but it can be done. You will learn how to form, motivate, steer, and get greater results from all team members by understanding what makes them tick and strategizing approaches to engage all team members.
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.
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.
More Dates
Surgent's Successful Communication
Online/Webcast
4.00 Credits
See more dates
Technology has created numerous ways for us to communicate with each other - but it's also increased the number of ways in which the message can get garbled. Effective communications skills are crucial to successful management. Learn how to control your message with clear communications strategies. You'll learn to recognize communication barriers, assess styles and behaviors, and learn how to listen more effectively as well.
More Dates
How Fraud Can Affect Smaller Organizations
Online/Webcast
4.00 Credits
See more dates
Many small to medium sized companies do not properly address the risk that arises related to fraud because these organizations do not have the resources needed to mitigate this risk or because owners or those in top level management underestimate the scope of the issue. All organizations, regardless of size, must be aware of the risks associated with intentional fraudulent acts and know that a significant and effective fraud scheme could even create going concern issues for some entities. In this session, we delve into the reasons that fraud takes place. The material discusses the types of defalcations that are often executed against smaller entities and then explores measures that organizations can implement to help stop fraud activities and add 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
Fraud Busters: Controls to Prevent & Detect Fraud
Online/Webcast
1.00 Credits
See more dates
This course investigates actual real-world fraud schemes and discusses what controls could have prevented the fraud from occurring, and what controls could detect and curtail the fraud scheme. The instructor speaks from experience, finding multiple frauds very early in her career leading to a career-long focus on fraud prevention and detection. 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 Defending Firms: Email Fraud, Cloud Risks, Cyber Insurance, and Remote Work Security
Online/Webcast
2.00 Credits
See more dates
Cyber threats targeting accounting and finance professionals are growing more sophisticated, putting sensitive financial data at risk. This session explores the most pressing cybersecurity challenges accounting and finance professionals face today, including email fraud, phishing attacks, cloud security risks, and securing remote work environments. It also addresses the role of cyber insurance. Through real-world case studies and practical strategies, participants will learn how to recognize and mitigate cyber threats, evaluate cyber insurance policies, and implement security measures that protect their firms and clients. Attendees will leave with actionable steps to strengthen their cybersecurity posture and ensure compliance with evolving regulatory and industry standards.
More Dates
Available Until
Surgent's Improving Your Profits: Identifying Cost Cutting Opportunities
Online/Webcast
2.00 Credits
See more dates
Part of one's duty as a CPA working in industry is to safeguard the assets of the organization. Cost cutting is one way to preserve assets and maintain a company's competitive position in the industry. However, what keeps us from ridding our organizations of unnecessary costs? In this course, we will look at the factors that prevent our companies from being as streamlined as they could be. By using statistics and survey data, we will attempt to show how to better negotiate and navigate budgeting and contracting decisions. We will also discuss financial statement analysis techniques, benchmarking, and cash flow management in an effort to better cut costs and maintain the long-run viability of an organization.
More Dates
Available Until
Surgent's Public Speaking and Presentation Skills
Online/Webcast
2.00 Credits
See more dates
Gerald Ford once said that "[n]othing in life is more important that the ability to communicate effectively." Public speaking remains a centuries-old skill that allows individuals to effectively communicate both at a personal and professional level. The benefits of good public speaking run long, whether it be the ability to persuade others, lead a team, or encourage critical thinking. This course is designed to refresh and refine speaking skills for professionals. Through this webinar, participants will gain a better understanding of the core skills of how to communicate effectively in groups — big or small. The webinar is intended to help those who already speak in public better improve their skills, while at the same time teaching more novice speakers how to approach a task that so many professionals dread — speaking in front of others.
More Dates
Surgent's Top Business Tax Planning Strategies
Online/Webcast
2.00 Credits
See more dates
Business strategies for 2026 are based on important tax changes made in the One Big Beautiful Bill Act (OBBBA). There are a number of important business tax changes that can be used to develop tax planning strategies that have great advantages for businesses and their owners. This program covers many important business tax changes and the implications for tax planning founded on them.
More Dates
Available Until
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.
More Dates
ACPEN: Schedule K-1: What is it & What Do I Do with It?
Online/Webcast
2.00 Credits
See more dates
This seminar provides a comprehensive overview of Schedule K-1, which taxpayers may receive from pass-through entities such as Partnerships, Subchapter S Corporations, or Estates/Trusts. The course will cover the most common characteristics of Schedule K-1, including how to report the information on Form 1040. Attendees will also learn about the Qualified Business Income (QBI) Deduction and its reporting criteria. Additionally, relevant topics such as basis and loss limitations, material participation, and integration with the QBI deduction will be addressed, along with a discussion of proposed changes to Schedules K-2 and K-3. *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
ACPEN: Best-in-Class Internal Controls: Best Practices for Finance Professionals
Online/Webcast
2.00 Credits
See more dates
Strong internal controls are the foundation of financial integrity and operational efficiency. In this interactive two-hour session, finance professionals will explore best-in-class internal control frameworks and leading practices to mitigate risks, enhance compliance, and improve organizational performance. Participants will gain insights into designing, implementing, and monitoring internal controls that align with regulatory expectations and industry standards. This course will provide real-world examples and practical strategies to strengthen controls in key financial processes, ensuring a culture of accountability and transparency.
More Dates
ACPEN: K2's Tech Update
Online/Webcast
2.00 Credits
See more dates
Staying current with today's technology is no longer optional; it is essential. Tech Update 2026 offers accounting professionals a clear, strategic view of the evolving tech landscape, enabling them to cut through the noise and make informed decisions. This forward-looking session is built for practitioners who want to leverage innovation to enhance client service, boost operational efficiency, and remain competitive. Explore the most impactful trends in artificial intelligence, quantum computing, automation, and cloud-based ecosystems. Understand how technologies like Microsoft 365 Copilot, generative AI tools, industry-specific SaaS platforms, and blockchain are reshaping the profession. Learn to identify which solutions align with your firm's goals-and which are just vendor hype.
More Dates
Basic Individual Taxation Course
Online/Webcast
2.00 Credits
See more dates
Please join us for an introductory course on the fundamentals of preparing and filing an individual federal income tax return. We will cover topics such as what the federal income tax is and how it is computed. 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
Building Bulletproof Spreadsheets: When Accuracy Is Everything
Online/Webcast
2.00 Credits
See more dates
This course equips accounting and finance professionals with practical methods to strengthen spreadsheet accuracy in environments where reliability directly affects reporting, analysis, and decision support. The content emphasizes modern Microsoft 365 capabilities, including dynamic arrays, data types, structured references, version history, and collaborative features that reduce formula risk and manual intervention. Participants see how sound workbook design, thoughtful data organization, and targeted validation rules reduce the likelihood of downstream errors and create spreadsheets that stand up to real-world pressures. The session also highlights common failure points found in finance teams-such as fragile formulas, inconsistent structures, and user-driven overrides-and demonstrates how to avoid them through protective controls, guided templates, and streamlined calculation flows. By combining updated Excel tools with practical design principles, participants leave with techniques that improve accuracy, enhance efficiency, and support higher-confidence financial outputs across their organizations.