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.
Surgent's Data Security: Best Practices to Protect Your Business and Yourself
-
Online/Webcast
1.00 Credits
See more dates
Data security is a front-of-mind topic for most businesses because the risk and cost statistics are sobering. Each of us is in the crosshairs because a typical internet-connected computer faces a cyberattack every 39 seconds. Businesses of all sizes should be cognizant of the ethical issues that must be considered when planning their approach to privacy and data security. In this webinar, we will explore both the risks we have traditionally faced in the workplace personally, as well as the novel set of data privacy threats and compliance challenge issues employers face with a remote and mobile workforce.Speaker - Mark McCreary, CIPP/US
More Dates
Surgent's Real Estate for Accounting and Finance Professionals
-
Online/Webcast
2.00 Credits
See more dates
Explore the intricacies of federal income taxation as it intertwines with rental real estate activities. This course delves into the calculation of rental income, understanding the nuances of deductions, and unraveling the complexities of passive activity loss rules. Whether it's mastering Schedule E or understanding Congress' intent behind tax laws, professionals will leave with an enriched understanding.Speaker - Daniel Johnson
More Dates
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. Speaker - Jason Cornell, Esq.
More Dates
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.Speaker - Dave Peters, CPA, CFP, CLU, CPCU, MST, MBA
More Dates
Surgent's Purchase and Sale of a Residence: Critical Tax Issues
-
Online/Webcast
2.00 Credits
See more dates
Many clients end up selling one or more residences during their lifetimes. Tax practitioners must be aware of the tax rules that relate to such sales in order to assist their clients regarding these sales. This program provides general tax practitioners with the tax rules they need to know to help their clients when they sell a personal residence. This program is a comprehensive survey of the various tax issues associated with the sale of a residence.Speaker - Mike Tucker, Ph.D., LL.M., J.D., CPA
More Dates
Surgent's Controller/CFO Update: Hot Topics Facing Today's Financial Professional
-
Online/Webcast
4.00 Credits
See more dates
In today's rapidly changing world, finance professionals are required to wear many hats and are often the keys to the success of the organization. On one hand, they need to be abreast of the latest proven financial skills for making the best decisions, and on the other hand they need the best skills to motivate, manage, and lead people. Being pigeon-holed into one area or another is neither good for career building nor good for the organization. We'll cover the latest issues that all CFOs and controllers need to know about and provide how-to guidance to allow for immediate use in their organizations.Speaker - Art Pulis, MBA
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 Exploring Business Valuation Fundamentals
-
Online/Webcast
2.00 Credits
See more dates
What makes a business valuable? Who determines value? What are the key factors that make businesses valuable? In this course, we explore the different ways to value a business. We will apply foundational valuation and corporate finance concepts to real world examples in an effort to see what makes up an investment's price.Speaker - Dave Peters, CPA, CFP, CLU, CPCU, MST, MBA
More Dates
Surgent's Excel Tables and Conditional Summing
-
Online/Webcast
2.00 Credits
See more dates
In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.Speaker - Jeff Lenning
More Dates
Surgent's Critical Conversations
-
Online/Webcast
2.00 Credits
See more dates
As uncomfortable as some conversations are, keeping your silence won't resolve the issue and may in fact add to it. No matter which side of the table you find yourself at in a "hard to have" talk, you can learn to benefit from the conversation. In the workshop, you'll learn how to recognize when a conversation becomes critical, how to plan effectively for the conversation, and which communications strategies can help you create a win/win outcome. Speaker - Deb Brown
More Dates
Surgent's Forms 7217 and 7203
-
Online/Webcast
2.00 Credits
See more dates
IRS Form 7217 is an IRS tax form required for partners receiving distributions of property from partnerships. Starting for tax years beginning in 2024, a partner who receives property from a partnership must file Form 7217 with his or her annual income tax return. Form 7217 is filed by any partner receiving a distribution of property from a partnership to report the basis of the distributed property, including any basis adjustment to such property as required by Section 732(a)(2) or (b). This new IRS form is part of the IRS's general concern regarding basis shifting in favor of high marginal tax rate related partners. Form 7217 is now required and details the types of property distributed, the aggregate basis, and the allocation of basis to the distributed property. Form 7203 is designed to assist in tracking an S corporation shareholder's stock and debt basis. Form 7203 is a significant improvement from the worksheets the IRS provided formerly and over time will serve to help partners and partnerships keep track of their stock and debt basis. The course covers the structure and organization of Form 7203 as well as how an S corporation shareholder's stock and debt basis are calculated.Speaker - Mike Tucker, Ph.D., LL.M., J.D., CPA
More Dates
Surgent's Mastering Client Management for Accounting and Finance Professionals
-
Online/Webcast
2.00 Credits
See more dates
Do you want to build stronger relationships with your clients, improve client retention, and drive growth in your practice? This course delves into the essential strategies for effective client management in today's competitive landscape. Client relationships, like any relationship, can be challenging to manage. Miscommunication, differing work styles, and unrealistic expectations are some of the challenges accounting and finance professionals routinely encounter. However, when accounting clients and members of your team are on the same page, client loyalty and profitability improve while conflict is minimized. This webinar explores proven strategies to improve relationships between accounting and finance professionals and their clients.Speaker - Jason Cornell, Esq.
More Dates
Surgent's Preparation and Compilation Engagements Under the SSARS
-
Online/Webcast
4.00 Credits
See more dates
Be the go-to person on financial statement compilation and preparation engagements. Specifically designed for those performing preparation and compilation engagements, this course will provide you with a hands-on application for performing preparation and compilation engagements under AR-C Section 70 and 80, respectively. You will learn the ins and outs of relevant sections of the SSARS related to preparation and compilation engagements with a focus on how recently issued updates to SSARS No. 21 impact these engagements. More importantly, you will be provided practical examples and illustrations to help you effectively and efficiently perform those engagements, including a detailed discussion of the reporting requirements under AR-C 80 related to compilation engagement. Lastly, the course will review recent peer review feedback on these types of engagements, highlighting areas where you can improve engagement quality.Speaker - Ken Levine
More Dates
Surgent's Guide and Update to Compilations, Reviews, and Preparations
-
Online/Webcast
4.00 Credits
See more dates
Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-25 by the ARSC. The course will also review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARSs requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform compilation, preparation, and review engagements.Speaker - Ken Levine
More Dates
Surgent's A Guide to Gig Economy Tax Issues
-
Online/Webcast
2.00 Credits
See more dates
The IRS defines the "gig economy" as people earning income providing on-demand work, services, or goods on either a part-time or full-time basis. The economic times we live in are changing and tax practitioners must learn how the rules apply in this new gig economy. The tax rules that apply to gig workers challenge traditional ideas of who is an employee and who is an independent contractor, and tax practitioners must have the knowledge to make this determination. This program addresses federal and state tax issues tax practitioners must address with clients and their own workers.Speaker - Mike Tucker, Ph.D., LL.M., J.D., CPA
More Dates
Surgent's Business Writing: Professional & Effective Emails
-
Online/Webcast
2.00 Credits
See more dates
Good writing is good business. Studies show that the average business worker receives 121 emails per day. That's a lot of emails. Are your emails effective? Are they being read? Are they professional and tone-smart? In this course, you will learn techniques and skills to get your emails to stand out and improve their effectiveness and professionalism.Speaker - Margaret Uhrich
More Dates
Surgent's Employer's Handbook: Health Care, Retirement, and Fringe Benefit Tax Issues
-
Online/Webcast
4.00 Credits
See more dates
The employer-employee relationship strains both sides in uncertain times, and businesses need CPAs, controllers, and other advisors to provide understanding of the complex legal, tax, and health care issues associated with all aspects of employment. This course provides in-depth coverage of this critical area.Speaker - Dave Peters, CPA, CFP, CLU, CPCU, MST, MBA
More Dates
Surgent's Enterprise Risk Management Concepts and Strategy for Small and Medium-Sized Companies
-
Online/Webcast
4.00 Credits
See more dates
The past few years have taught us that major risks can come at us from any direction and with barely a warning. All organizations operate in a risk environment, but all too often, they either don't realize it or they don't develop a strategy to deal with the risks. In this session, we will explore how risks work in both for-profit and not-for-profit organizations and how they can develop a strategy to identify, evaluate, and mitigate those risks. This program will not teach how to eliminate risks, but how to strategize how to reduce their total effect. We will liberally use case studies of both for-profit and not-for-profit companies to bridge the gap between concept and actual implementation. In each area we will explore what our experiences of the pandemic have taught us about this part of risk management.Speaker - Art Pulis, MBA
More Dates
Surgent's A Complete Guide to Reporting Form 1099-DA
-
Online/Webcast
2.00 Credits
See more dates
For each digital asset sale that a broker has affected for a customer in 2025, the broker must complete Form 1099-DA. A broker includes any person who, in the ordinary course of a trade or business, stands ready to affect sales of digital assets to be made by others. This program covers the required rules for reporting digital asset transactions on Form 1099-DA.Speaker - Mike Tucker, Ph.D., LL.M., J.D., CPA
More Dates
Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Online/Webcast
2.00 Credits
See more dates
Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work. Speaker - Jeff Lenning