Skip to main content

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.

Showing 3721 All Results

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.Speaker - Bryan L. Smith, CPA.CITP, CISA

More Dates

2024 Federal Tax Update for Individuals with Doug Van Der Aa

-

Online/Webcast

4.00 Credits

See more dates

This program will address recent legislation, rulings and developments affecting individual taxpayers and provide practitioners with a comprehensive update for the upcoming tax season. **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 - Doug Van Der Aa, CPA, JD

More Dates

2024 Internal Controls for Small and Medium-Sized Entities

-

Online/Webcast

1.00 Credits

See more dates

This session explores the importance of internal controls with an emphasis on best practices for small- and medium-sized entities.  We will examine the roles of both preventive and detective controls and practical, cost-effective suggestions for implementing effective internal controls will be addressed. Speaker - Chris Harper

More Dates

IRS Revenue Officers, Field Collection, and Best Practices

-

Online/Webcast

1.00 Credits

See more dates

You've probably been there. You have a client in your office with excess baggage. That's right, they're in field collection with a Revenue Officer. Now what are you going to do? How are you going to get where you want to be? This program will provide an overview of field collection, how to effectively work with Revenue Officers, general case processing, and important IRM deadlines. This will include taking a deep dive into the "RO Mindset" along with structuring your casework to flow with IRS case processing actions so you can get to the outcome you want. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Billy L. Fauller, III, EA, CTRS, NTPI

More Dates

Eight Biggest Threats to your business and introducing Three Pillars of Cybersecurity

-

Online/Webcast

1.00 Credits

See more dates

Cybercrime is on the rise and CPAs that handle sensitive client data are often the target of cybercrimes.  By attending this session you'll learn what the eight biggest threats are to your business and uncover the three pillars of cybersecurity that you can build your firm's defense around. Speaker - Jon Melloy

More Dates

Cyber Attacks Through Impersonation

-

Online/Webcast

1.00 Credits

See more dates

This course describes how cyber attacks through impersonation are conducted. It also provides practical advice and recommended security controls to implement, reducing the likelihood and impact of an impersonation cyber attack. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Petrina Youhan, CPA, CISSP

More Dates

Surgent's Understanding S Corporation Taxation: Shareholder Basis, AAA, and Retained Earnings

-

Online/Webcast

2.00 Credits

See more dates

Even though they have been around for several years, the tax laws pertaining to S corporations remain some of the more difficult areas of the Internal Revenue Code. Given the rising popularity of S corporations, understanding how shareholder basis and the equity section of the balance sheet work together for tax purposes is imperative for nearly any tax practitioner. In this course, we will discuss this relationship. Using examples and illustrations, we will show how contributions, operating transactions, and distributions affect shareholder basis as well as equity.

More Dates

Surgent's Required Minimum Distributions: Compliance and Planning

-

Online/Webcast

4.00 Credits

See more dates

Required minimum distributions (RMDs) from employer retirement plans and IRAs must be made or steep penalties will be incurred. Planning opportunities exist in certain situations to minimize distributions. Also, special rules exist for inherited retirement funds. Your clients depend on you to help them navigate the rules regarding required minimum distributions and the taxation of distributions. This course addresses compliance issues and planning opportunities regarding required minimum distributions.

More Dates

The Role of Internal Control in the Risk-Based Audit

-

Online/Webcast

4.00 Credits

See more dates

This program addresses the role of client internal controls for balancing efficiency and effectiveness in a risk-based audit. Practical insights regarding an auditor's assessment of the risk of material misstatement when auditing financial statements of non-issuers will be explored, with particular emphasis on internal controls of small-to-medium clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. This event may be a rebroadcast of a live event and the instructor will be available for your questions during the event.Speaker - Chris Harper, CPA

More Dates

Surgent's Advanced Individual Income Tax Return Issues

-

Online/Webcast

8.00 Credits

See more dates

Most Accounting and Financial Professionals have been preparing individual income tax returns for years, and while many of the returns are easy, there are always a number of issues that come up in busy season of which experienced practitioners wish they had more knowledge. This course is designed to explore the tough tax issues for experienced practitioners and help them provide better planning strategies and results for their higher income clients.

More Dates

Surgent's Annual Accounting and Auditing Update

-

Online/Webcast

8.00 Credits

See more dates

Designed for accounting and attestation practitioners at all levels in both public accounting and business and industry, this course provides a comprehensive review of recent standard-setting activities of the FASB and AICPA. In addition to providing a detailed review of SAS No. 145, this course will bring you up to date on FASB and AICPA standards issued over the past few years. The course also provides many hands-on examples and illustrations to help you apply the guidance in practice. In addition to a financial accounting update, the course will discuss what you will need to do differently as you adopt new audit standards 142-149 over the next few years, including a detailed review of the new audit requirements under SAS 142. The course will also cover the key changes related to SSARS No. 25. Finally, the course reviews the AICPA's quality management project. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.

More Dates

Surgent's Compilations, Reviews, and Preparations: Engagement Performance and Annual Update

-

Online/Webcast

8.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-26 by the ARSC. In addition to SSARS 26, the entire suite of quality management standards is discussed. However, knowing the standards is not enough. You need to be able to effectively apply them. To support this, the course will 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 SSARS requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform these types of engagements. This course is intended to be your go-to reference for training your staff and managing your SSARS No. 21-26 services in compliance with professional, ethical, and technical requirements.

More Dates

Surgent's Technical Business Practice Issues and Tax Forms for Experienced Practitioners

-

Online/Webcast

8.00 Credits

See more dates

Don't let the title frighten you. It is critical that staff be trained on the increasingly complex forms-related issues that challenge them each busy season. This course will help experienced staff focus on the essential amidst the cacophony of IRS and legislative changes and avoid costly mistakes. This course brings to the forefront advanced preparation issues, from individual returns to flow-through entities such as S corporations, LLCs, and partnerships.

More Dates

Walter Haig's AICPA Auditing Standards Update

-

Online/Webcast

8.00 Credits

See more dates

This course will enable practitioners to understand and apply the AICPA "clarification" auditing standards to audits of Small- and Medium-Sized Entities (SMEs). Further, this course will provide guidance on how to perform an effective, efficient and profitable audit engagement. The course is loaded with practical practice aids to help enable participants to comply with the standards. Troublesome areas as identified in peer reviews and litigation will be covered. Participants who take this course will enjoy smooth sailing in their peer reviews, guaranteed! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Walter J. Haig

More Dates

Qualified Business Income (QBI) Deduction (199A) - The Ins & Outs

-

Online/Webcast

8.00 Credits

See more dates

The Tax Cuts and Jobs Act (TCJA) was a major overhaul of our tax system that lowered the income tax rates for individual and corporate taxpayers and introduced the new 20% qualified business income (QBI) deduction for sole proprietors and pass-through entities. The cornerstone of this course is the comprehensive discussion of the 20% QBI deduction final regulations under IRC §199A.    **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 - J. Patrick Garverick

More Dates

S Corporation Preparation, Basis Calculations & Distributions - Form 1120S Schedule K & K-1 Analysis

-

Online/Webcast

8.00 Credits

See more dates

This comprehensive training is designed to get the accountant up to speed quickly with S corporation formation and preparation issues as well as a complete understanding of calculating a shareholder’s stock and debt basis. The cornerstone of this course is the in-depth line-by-line analysis of the Form 1120S Schedule K and K-1 and how these items affect the shareholder’s Federal individual income tax return. **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 - J. Patrick Garverick

More Dates

Surgent's Preparing Individual Tax Returns for New Staff and Paraprofessionals

-

Online/Webcast

8.00 Credits

See more dates

The objective of this course is to train new staff accountants, data processing employees, paraprofessionals, and bookkeepers to prepare a moderately complex federal individual income tax return (Form 1040). Over the years, thousands of new staff have received practical, hands-on experience to become familiar with tax forms. This course covers the latest tax law changes, making it essential for your new staff.

More Dates

Excel - Advanced Spreadsheet Troubleshooting Techniques

-

Online/Webcast

2.00 Credits

See more dates

Do you dread that annoying ERROR! message popping up on your spreadsheets? Tired of using the same long, elaborate formulas when you could be using the ones that are already built into Excel? Then this class is for you! In this webinar, we will focus on Debugging and Troubleshooting complex formulas. You will learn various techniques that will assist you in creating complex compound formulas. You will also learn techniques to resolve issues when you receive errors. This session will also discuss the 9 built-in error checking options and demonstrate resolution techniques. We will also review techniques to resolve rounding errors. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. 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

Busy Season Survival Strategies

-

Online/Webcast

2.00 Credits

Busy season is a time when effective communication and efficiency is vital, but that isn't so easy with increased workloads and pressure. Attend this session to explore accountability, communication, employee engagement, and stress management strategies. Leave this session with ideas you can implement immediately to ensure that the spring busy season is highly productive, positive and successful!Speaker - Renee Moelders/Samantha Mansfield

More Money: Strategic Ways to Improve Cash Flow

-

Online/Webcast

4.00 Credits

See more dates

Cash flow management is often the most important task of any CFO or financial leader. Regardless of whether one works in start-ups or established companies, non-profit or for-profit entities, cash flow makes our organizations run. Have you ever wondered whether you are optimizing your company's cash flow? In this course, we will explore how to improve your company's cash flow using analysis and financial theories in the context of real-world situations. 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