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.
Defining Where and Why Internal Controls are Needed
-
Online/Webcast
2.00 Credits
See more dates
Most organizations have many of the basic controls required to operate in place. However, a notable percentage of these companies do not have important measures that can help enhance security, productivity, and the quality of information available for decision making. In this session, we work to identify areas where important internal control measures are needed. We spend time explaining why these controls should be created, and show in detail some specific controls that would be beneficial if utilized. Those wishing to strengthen an internal control system should strongly consider attending 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.Speaker - Karl Egnatoff, CPA.CITP
More Dates
Current Nonprofit Fraud Trends
-
Online/Webcast
4.00 Credits
See more dates
Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. 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
Accounting for the Gig Economy
-
Online/Webcast
2.00 Credits
See more dates
Freelance work and other non-permanent employment arrangements are becoming increasingly popular ways for people to earn a living. Although these non-traditional activities offer novel, flexible ways to earn income from diverse sources, they also introduce nuanced recordkeeping, reporting, and attestation issues. We investigate characteristics of the gig economy, employee-versus-contractor considerations, bookkeeping, regulatory compliance, and external reporting considerations. We also explore best practices for CPAs who fulfill the role of trusted advisor for gig economy clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Dr. Christopher J. Harper, CPA, MBA
More Dates
Streamlined Excel Reporting Series Session 3: PivotTables Displays and Alternatives
-
Online/Webcast
2.00 Credits
See more dates
Essential techniques for displaying data in alternative ways You'll work alongside an expert instructor as you practice using PivotTables and exploring creative alternatives for insightful data presentation. You'll learn techniques for effective data presentation, including: Filtering and sorting data Cleaning and organizing data through text manipulation Using dynamic features to summarize and analyze large datasets Using slicers and filters for visual filtering Highlighting key Excel features through guided practice You'll walk through realistic scenarios that show alternative functions for greater data management, such as: GROUPBY PIVOTB PERCENTOF In addition, various text functions such as TEXTJOIN and TEXTSPLIT will be explained, highlighting how to concatenate and split text strings efficiently. *Session 3 is one of four individual sessions. Each session builds on the previous one, so consider watching [Streamlined Excel Reporting Series Session 4: External Data and PivotCharts](https://www.aicpa-cima.com/cpe-learning/webcast/streamlined-excel-reporting-series-session-4-external-data-and-pivotcharts) to tackle real-world issues and create powerful workbooks.*
More Dates
Surgent's Excel Shortcuts for Accountants
-
Online/Webcast
2.00 Credits
See more dates
This webinar presents a variety of time-saving ideas, shortcuts, and tips that are sure to boost personal productivity. We discuss better summing, address one of the biggest pitfalls that Excel users have faced over the past 25 years, present the most important keyboard shortcuts, demonstrate a better alternative to hiding rows or columns, illustrate how to quickly navigate to other workbooks and files, and demonstrate using Excel with styles.Speaker - Jeff Lenning
More Dates
Surgent's Home Office Rules
-
Online/Webcast
2.00 Credits
See more dates
Since 2017, employees have not been eligible to take an itemized deduction for a home office. The Tax Cuts and Jobs Act suspended all miscellaneous itemized deductions for tax years 2018 through 2025. That deduction is scheduled to go into effect in 2026. Self-employed individuals can deduct office expenses on Schedule C, Form 1040. The home office deduction includes typical office-connected expenditures such as supplies, postage, computers, printers, and all the other ordinary and necessary expenses a person would have in connection with running a home office. The home office tax deduction for the self-employed would cover expenses for the business use of a home, which includes mortgage interest, rent, insurance, utilities, repairs, and depreciation. This program discusses many of the most important issues relating to the deductibility of home office-related expenses. Speaker - Mike Tucker, Ph.D., LL.M., J.D., CPA
More Dates
Retaining Talent in a Competitive Marketplace
-
Online/Webcast
4.00 Credits
See more dates
Retaining Talent in a Competitive Marketplace -Creating a Benefits Program Employees Care About In today's competitive marketplace, retaining talented employees is becoming increasingly difficult. A solid benefits program can make a difference in the fight for talent - but only if those benefits matter to the employees you are trying to hire! Through statistics and case studies, this course will explore what benefits are most valuable to employees. We will also explore the basic types of retirement and health insurance plans and discuss what financial leaders should consider before adopting a benefits package. 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
More Dates
Navigating IRS Collections: The Collection Process
-
Online/Webcast
2.00 Credits
See more dates
This course is designed for tax professionals seeking to understand and navigate the IRS collection process effectively. Participants will gain indepth knowledge of the various collection methods employed by the IRS, including liens, levies and wage garnishments. Additionall, participants will leand strategies to avoid or halt collection actions and the implications of the statute of limitations on tax collection. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Mary Jane Hourani, MM, EA, NTPI Fellow
More Dates
Master the Art of CPA Communication: Boost Your Influence!
-
Online/Webcast
4.00 Credits
See more dates
Discover the communication edge that will take your CPA career to the next level. This comprehensive course empowers CPAs with the tools to enhance clarity, build trust, and drive decisions. Learn to transform complex jargon into actionable insights and develop powerful persuasion techniques that resonate with clients and stakeholders. Join me to sharpen your communication skills and elevate your professional impact. 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
Supporting Mental Wellness to Thrive in Work and Life
-
Online/Webcast
2.00 Credits
See more dates
In today's fast-paced world, maintaining a healthy work-life balance is essential for mental wellness. This course is designed to provide practical tools and strategies to help you create a balanced, fulfilling life. You'll learn actionable techniques for improving sleep hygiene, incorporating proper nutrition, fostering open communication, and managing stress. Whether you're struggling with burnout, seeking better work-life harmony, or simply looking to improve your overall well-being, this course offers valuable insights and tools to help you thrive. Designed to fit into your busy schedule, it delivers the guidance you need to make practical, sustainable changes in your life, starting today. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Alexis Smith, PA-C
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
Forgotten Managerial Accounting Tools for CPAs
-
Online/Webcast
2.00 Credits
See more dates
This session revisits managerial accounting techniques that you may not have considered for many years, even though they could be invaluable for CPAs in both business and public accounting. You will appreciate a fresh perspective of concepts you may not have considered since your college days. We will illustrate concepts with practical examples that you can immediately bring back to the office! 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
How to Build a Custom AI Chatbot and GPT in Plain English
-
Online/Webcast
2.00 Credits
See more dates
Participants will learn to create customized AI chatbots that can enhance client interaction and internal operations-all without coding experience. This course provides a concise overview of specialized, task-oriented AI chatbots and GPT builders, focusing on how these technologies are revolutionizing professional workflows. Through hands-on exploration of platforms like AgentGPT, Claude Projects, Gemini Gems, and NotebookLM, participants will learn to design, deploy, and manage custom AI assistants tailored to their specific needs. The course emphasizes creating advanced AI apps that can understand context and solve complex problems autonomously. 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
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
Shortcuts that Excel Users Love
-
Online/Webcast
2.00 Credits
See more dates
Many people that use Microsoft Excel know a great deal about the functionality of the application. There are, however, a tremendous number of hidden tools that a high percentage of users overlook. Additionally, there are newer features that some have not had the opportunity to explore. This session shows some of the numerous time-saving tools and features that often go unused by spreadsheet creators. People that wish to become more efficient when using Excel should take 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.Speaker - Karl Egnatoff, CPA.CITP
More Dates
Casualty Losses: Disaster Relief Act of 2024
-
Online/Webcast
1.00 Credits
See more dates
Literally thousands of individual taxpayers may have increased deductions or exclusions from gross income as a result of the Disaster Relief Act of 2024! Casualty provisions of the Act are retroactive to December 19, 2019 through early 2025. Both low and high income taxpayers may benefit from the Act through exclusions of payments received as compensation for wildfire damages - retroactive to 2014! This course will review the provisions of this new act. 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 Tax Research
-
Online/Webcast
2.00 Credits
See more dates
Answering clients' tax questions accurately and on time is a key challenge for tax practitioners. Through simple, plain language explanations and examples, this course will help practitioners perform tax research more efficiently by describing the structure of the primary sources, highlighting the differences between primary and secondary sources, and detailing the steps in the tax research process.Speaker - Dave Peters, CPA, CFP, CLU, CPCU, MST, MBA
More Dates
Build a Data Model for Analysis in Power BI
-
Online/Webcast
4.00 Credits
See more dates
This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. 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
How to Start a CFO Service
-
Online/Webcast
1.00 Credits
See more dates
This Masterclass is a one-hour training to show accountants how they can grow their practice this year through CFO and business advisory services. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Adam Lean