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
Controller Series: Communicating for Connections with Coworkers, Customers, and Stakeholders
-
Online/Webcast
1.00 Credits
See more dates
How you communicate with your internal and external customer can make or break your career! We all know how to talk, but how do we make sure we are really connecting with others? This course will discuss different personality styles and demonstrate the different ways to communicate information to them. See how recognizing their personality style(s) can turn communication breakdowns into breakthroughs.
More Dates
State Tax Nexus: Frequently Awkward Questions
-
Online/Webcast
2.00 Credits
See more dates
Award winning discussion leader Mark Hugh discusses both nexus basics and new developments in the dynamic, ever changing world of state income and sales tax nexus. This valuable course answers your frequently asked questions, reviews key factors in examining potential nexus consequences, takes a tour through the rules in states comprising 50% of the US, and identifies free, online multistate resources. *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 Speaker - Mark Hugh
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 Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Online/Webcast
2.00 Credits
See more dates
How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.Speaker - Jeff Lenning
More Dates
Surgent's Found It! Reporting Findings in Yellow Book and Single Audits
-
Online/Webcast
2.00 Credits
See more dates
When auditors detect findings in Yellow Book and single audits, they do not just communicate them in some shabby little letter to management; they get reported! In this course, we will examine what types of findings get reported, how they get reported, and where they get reported! This course will take you from just checking a box and fulfilling a requirement to developing and delivering findings that make a meaningful difference to your clients.Speaker - Charlie Blanton, CPA
More Dates
Surgent's Top Individual Tax Planning Strategies
-
Online/Webcast
2.00 Credits
See more dates
The Inflation Reduction Act (IRA) and SECURE Act 2.0 both contained tax law changes that impact many individuals in 2025 and in later years. This program covers many of these changes as well as other tax topics that continue to impact individual income taxpayers.Speaker - Mike Tucker, Ph.D., LL.M., J.D., CPA
More Dates
Surgent's Virtual Currency: Keeping Up with the Tax Code
-
Online/Webcast
2.00 Credits
See more dates
Whether you are an experienced veteran or new to the industry, one of the toughest parts of being a tax practitioner is keeping up with all of the changes in tax legislation. This course takes a look at recent changes to tax law from a practitioner perspective. In this session, we will explore the nuances of virtual currency and the new Form 8300 reporting requirements.Speaker - Dave Peters, CPA, CFP, CLU, CPCU, MST, MBA
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.Speaker - Robert Nordlander, CPA, CFE
More Dates
Live Webinar K2's Excel Tips, Tricks, and Techniques for Accountants
-
Online/Webcast
8.00 Credits
See more dates
Excel is the accountant's tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Regardless of your experience level, if you use Excel, you need this course to learn more efficient and effective ways to work with Excel. In this course, you will discover countless tips, tricks, and techniques to improve your general level of productivity, reduce the amount of time you spend on mundane tasks, such as formatting, and customize Excel for greater accuracy and efficiency. You will also learn valuable formula-building skills, best practices for linking Excel data from other worksheets and workbooks, and streamlining report generation and printing processes. Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples to improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience delivering spreadsheet training to accounting and financial professionals, assuring you of the relevance and usefulness of the information and guidance provided during the program.Speaker - Brian Tankersley
More Dates
ACPEN Signature 2025: Financial Statement Preparation: Compilation and Review Update
-
Online/Webcast
8.00 Credits
See more dates
This course is designed to assist CPAs who perform financial statement preparation, compilation, or review engagements. Our panelists will provide an in-depth analysis of the SSARS and will provide practice tips that will assist you in performing profitable standard compliant engagements. Speaker - Laura Billingsley, James Smith, Kurt Oestriecher
More Dates
Coaching the Next Generation of CPAs
-
Online/Webcast
2.00 Credits
See more dates
Attracting and retaining staff is critical to an organization's success, especially in the age of the millennial worker who will change jobs multiple times in the course of a career. This course will focus on best practices for nurturing the human element of your organization, especially millennial workers who comprise a growing percentage or the workforce. 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
Revenue Recognition - Topic 606 Disclosures
-
Online/Webcast
1.20 Credits
See more dates
The standard also requires information about the following categories: disaggregation of revenue contract balances performance obligations This webinar will deal directly with disclosure requirements for the standard. Several courses currently exist on the platform related to an overview of the standard and deep dive into individual steps of the standards. Speaker - Lynn Fountain
More Dates
How to Gain Efficiencies in Your Accounting Processes and Program Operations
-
Online/Webcast
1.50 Credits
The current economic environment has changed how organizations view their accounting operations. Your business faces challenges that could lead to valuable opportunities for streamlining through automation, outsourcing and technology. In this webcast, accounting professionals will share insights from their experiences, including 10 key tips to keep financial reporting and accounting running smoothly during times of change and turnover. This webcast is a rebroadcast from the 2024 AICPA & CIMA Not-For-Profit Industry Conference.
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
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
Becoming Conflict Competent
-
Online/Webcast
2.00 Credits
See more dates
Conflict is often avoided, or dealt with in a passive manner. When ignored, conflict often escalates and can become polarizing. In this session, participants will gain insights for enhancing their natural responses to conflict, learn healthy communication styles, and build constructive behaviors to manage conflict. 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
Exploring Internal Controls That Could Have Prevented Frauds
-
Online/Webcast
2.00 Credits
See more dates
This course examines actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters' ability to accomplish their nefarious acts. 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
Surgent's Establishing State Residency and Saving Your Clients Money
-
Online/Webcast
2.00 Credits
See more dates
Many of our clients are moving to one of the seven states with no personal income tax, particularly Florida and Texas. Others may maintain multiple homes with an eye toward eventually establishing residency in a state with no income tax. This course will give you practical tips for your clients seeking to establish residency in a new jurisdiction. Cash-strapped states are increasingly attempting to assess taxpayers who have declared domicile and residency elsewhere, for example in Florida, to maintain their diminishing tax base. Arm your clients with the tools needed to save money by successfully establishing domicile and residency. As a practitioner, you can't afford to be unaware of the latest issues affecting so many relocating baby boomers and others. Avoid that state audit with the information provided in this entertaining webinar.Speaker - Ciro Poppiti, Esq.
More Dates
Surgent's Excel Budgeting Ideas
-
Online/Webcast
2.00 Credits
See more dates
Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.Speaker - Jeff Lenning