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.
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.
More Dates
ACPEN: Triple Your Memory, Prevent Dementia and Halve Your Stress - Part 1
-
Online/Webcast
4.00 Credits
See more dates
This is not your average CPE course! In this fun and practical course, you'll learn how to remember names, where you put things, what you read, or anything else 300% (or more) effectively than before. You will also learn how to prevent dementia, and halve your stress by using exercises that take under two minutes a day to do. Additionally, you'll receive information on ways to improve your memory by improving your overall health and wellness. This course will give you an overview of natural supplements to enhance your memory as well as share tips to improve your sleep. This course will change your life both now and in the future by making sure you know the best ways to remember information, handle stress and keep your mind sharp until the day you die. The information in this course to help increase your professional efficiency and improve your overall quality of life.
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.
More Dates
CPA to CFO: Essential Competencies for Finance Leaders
-
Online/Webcast
1.00 Credits
See more dates
The path from CPA to CFO has evolved dramatically in recent years, with only 43% of S&P 1000 CFOs holding CPA licenses in 2022, down from 55% a decade earlier. This comprehensive course, based on groundbreaking research from the Pennsylvania Institute of CPAs surveying over 320 CEOs and hiring executives, reveals what today's leaders truly seek in CFO candidates and provides a roadmap for CPAs to secure their seat at the executive table. Participants will discover the five critical competencies that distinguish successful CFO candidates: forward-looking financial acumen that goes beyond traditional reporting, strategic leadership skills including critical thinking and strategy creation, the evolving role of emotional intelligence, industry-specific expertise requirements, and the balance between technical proficiency and visionary leadership. Through practical frameworks, real-world examples, and actionable strategies, attendees will learn how to transform their CPA foundation into a comprehensive skill set that meets the dynamic demands of modern CFO roles, whether in high-growth companies, nonprofits, or traditional corporations. 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
Risk Assessment Under SAS No. 145
-
Online/Webcast
2.00 Credits
See more dates
Overcome the challenges commonly faced when conducting risk assessment in conjunction with SAS No. 145.
More Dates
Surgent's Workplace Harassment: How to Prevent Harassment and Reduce Liability Risks in Today’s Changing Environment
-
Online/Webcast
2.00 Credits
See more dates
Workplace harassment — especially sexual harassment — has dominated headlines in the last several years. With discussions of workplace harassment in the news, employees better understand their rights and feel more empowered to speak out, and the standard of appropriate workplace conduct is changing. With workplace harassment claims continuing to be filed at a steady pace with the United States Equal Employment Opportunity Commission, state agencies, and the courts, it is more important than ever to understand how to prevent and avoid harassment in the workplace.
More Dates
Create Measures in Power BI that Define Your Metrics
-
Online/Webcast
4.00 Credits
See more dates
Unlock the full potential of your data with our specialized course, "Create Measures in Power BI that Define Your Metrics". Designed for professionals who aspire to excel in the dynamic world of data analysis, this 4-hour intensive training delves deep into the advanced functionalities of Microsoft Power BI. You'll embark on a journey to master the art of Data Analysis Expressions (DAX), a powerful tool in the Power BI suite to create metrics. This course is meticulously crafted to transform you into a proficient user, capable of harnessing complex DAX calculations to bring your data to life. The course content is thoughtfully structured to ensure a comprehensive learning experience. Starting with the foundational elements of DAX, you'll rapidly progress to tackle advanced formulas and time-intelligent functions, essential for nuanced data analysis. The highlight of the course is the emphasis on the DAX calculation process, a crucial aspect for validating measures in Power BI. Additionally, the practical application of PivotTables for measure validation will equip you with the skills to confirm the accuracy and effectiveness of your data measures. These advanced techniques are not just theoretical concepts but are presented through engaging, real-world scenarios, enabling you to apply your learning immediately to your daily tasks. This course is an invaluable step towards mastering Power BI and making data-driven decisions with confidence. 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
Operations Level Internal Control
-
Online/Webcast
4.00 Credits
See more dates
Many leaders in business organizations of all sizes view the system of Internal Control almost purely as a protective security measure. A well-designed internal control system can and will drive all entity objectives which includes successful operations. This session uses information gathered from years of creating internal control systems as well as concepts from well-respected authoritative pronouncements and frameworks to illustrate the power of a strong and well supported control system as well as actions that can help establish such a system. Those that work with internal controls who are tasked with developing ways to improve operation level capabilities should strongly consider this session. 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
No Tax on Overtime: Payroll Compliance
-
Online/Webcast
2.00 Credits
See more dates
This course provides tax and accounting professionals with a comprehensive overview of overtime requirements under the Fair Labor Standards Act (FLSA). Participants will explore the statutory definition of overtime, exemptions, and the calculation of the "regular rate of pay." Through practical examples and compliance-focused scenarios learners will gain the skills to identify risks, properly compute overtime pay, and advise clients or employers on best practices. The course emphasizes regulatory compliance, accurate application of rules, and strategies to avoid common pitfalls in wage and hour audits. 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
Public Procurement Basics: Protecting the People's Money
-
Online/Webcast
2.00 Credits
See more dates
Procurement is a critical component of successful government operations. While there are challenges in public procurement, there are a number of guidelines and requirements that will help lead you to success. This course will offer guidance on how governments can meet complicated procurement needs and develop best practices that protect public and Federal funds. 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 Tax and Advisory with Agentic AI
-
Online/Webcast
2.00 Credits
See more dates
This course examines how agentic AI is revolutionizing tax compliance, planning, and advisory services. Participants will explore real-world deployments by leading firms such as EY, which has developed agents that handle millions of global tax transactions. The course also delves into cross-border compliance issues, transfer pricing automation, and emerging advisory models powered by agent-led simulations. Risks related to bias, unauthorized practice, and data privacy will be addressed, with guidance on aligning autonomous operations with professional and regulatory standards. CPAs must understand these advancements to ensure tax compliance, manage client expectations, and mitigate professional liability risks when providing agent-assisted advisory services.
More Dates
Forensic Accounting: Finding Hidden Treasure in Tax Returns
-
Online/Webcast
4.00 Credits
See more dates
Almost every business and individual has to file tax returns, which can be a great treasure trove of information for forensic accountants. Whether in a divorce, partnership dispute, recreating books and records, or bankruptcy proceeding, analyzing tax return information should be an initial step in uncovering income and assets. The IRS retains a large amount of information, both from taxpayers and 3rd parties who report financial transactions. This course will be your guide in gathering, analyzing, and evaluating tax return information, so that you have a full picture of the financial investigation. Your presenter is a 20 year veteran with IRS-Criminal Investigation, who used this information as a basis for his federal criminal investigations. 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
Take Command of your Time
-
Online/Webcast
2.00 Credits
See more dates
Manage distractions, decrease stress and improve productivity. This training is designed to help business professionals improve their productivity and work performance by learning how to prioritize time, decrease distractions and lower stress. 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
Finding Errors in Excel Spreadsheets
-
Online/Webcast
2.00 Credits
See more dates
This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. 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
The Crucial Connection - Why You Should Care About Your Client's System of Internal Control
-
Online/Webcast
1.50 Credits
See more dates
Learn why your client's system of internal control is important to achieving an effective and efficient audit. Gain an understanding of how to identify which IT applications and IT controls are relevant.
More Dates
AI & Accounting in Manufacturing
-
Online/Webcast
2.00 Credits
See more dates
This course provides a concise overview of how artificial intelligence (AI) is reshaping financial oversight in the global manufacturing sector. With factories evolving into digital ecosystems powered by intelligent automation, predictive analytics, and edge computing, the role of accounting and finance professionals is rapidly transforming. Participants will explore how AI technologies intersect with core financial functions-cost accounting, audit, tax compliance, and financial planning-while enabling real-time reporting, fraud detection, and predictive decision-making. Drawing on current global trends and real-world case studies, the course offers actionable insights into integrating AI into financial operations, elevating the strategic role of accounting in manufacturing enterprises. 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
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.
More Dates
Risk Wrangling: Surviving the Modern Business Rodeo
-
Online/Webcast
1.00 Credits
See more dates
Risk-based factors are becoming exponentially important considerations for accountants in both public practice and industry. We examine the nature of risks for today's enterprises while exploring the role of internal controls for mitigating business risks. We also explore SAS 145 and other guidance aimed at risk considerations for professional engagements. Public and private accountants will enhance their capabilities for assessing and addressing risks faced by today's organizations. 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
Resistance to Resilience: Strive for Tech Change Acceptance
-
Online/Webcast
1.00 Credits
See more dates
Technology adoption often comes with resistance, but it's possible to transform this challenge into an opportunity for growth. This course explores the journey from resistance to resilience in embracing new technologies, focusing on overcoming barriers and ensuring successful implementation. Participants will examine cutting-edge audit technologies, including AI, data analytics, and automation, and learn how to align these innovations with both organizational and personal goals. Through case studies, insights into the Technology Acceptance Model (TAM), and practical discussions, participants will gain the tools and strategies to foster acceptance, driving seamless integration of new technology into both individual tasks and team workflows. 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
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