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.
Taking Advantage of Array Formulas in Excel
-
Online/Webcast
2.00 Credits
See more dates
This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in 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
How to Double Your Firm's Revenue Through CFO and Advisory
Online/Webcast
1.00 Credits
See more dates
In this webinar, accountants will discover how to double their firm's revenue through CFO and advisory services. Many accounting firm owners are stuck in what we call The Accountant's Trap. It's where the firm owner is trapped working for low fees, dealing with high-demanding clients, all the while being burnt out on compliance and transactional work. To make matters worse, these firm owners can't raise their fees because there is always another accountant or bookkeeper willing to do the work for less -- not to mention all the tech companies trying to get into our space. Does this sound familiar? If so, this webinar is for you. This course is for any practice owner looking to transform their practice - and double their revenue - by offering a productized CFO/Advisory service. We'll cover the systems you need to transform your practice and the services you should offer to double your firm's revenue. 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
More Dates
Internal Control - Testing for Operating Effectiveness
Online/Webcast
2.00 Credits
See more dates
Properly designed and effectively operating internal control over financial reporting is critical for preventing, or detecting and correcting, material misstatement. This course describes how to satisfy the audit requirements related to taking a control reliance strategy by testing the operating effectiveness of internal controls, while promoting an effective and efficient financial statement audit. 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
Surgent's Tax Planning for Rental Real Estate
Online/Webcast
4.00 Credits
See more dates
The taxation of real estate is tricky. Taxpayers can own real estate in a number of different ways, including direct and indirect investments. There are numerous exceptions to being classified as a rental activity. How do you know if someone is a real estate professional? In this course, we will explore all these issues and many more. Through real-world examples and discussion, this course will delve into exceptions to rental status, qualifications for material participation, and requirements for active status. Additionally, we will cover the QBI and Section 1237 safe harbors and touch on some planning ideas related to depreciation recapture.Speaker - Dave Peters, CPA, CFP, CLU, CPCU, MST, MBA
More Dates
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
How Changes in Business Methods Affects Internal Control
Online/Webcast
8.00 Credits
See more dates
New Technology, the move toward telecommuting, the widespread adoption of electronic documentation, and a wide range of other factors have significantly and forever changed the way business is conducted. It should go without saying that changes in tools and methods lead to upheaval in any organizations internal control system. In this session, we look at all the changes that are occurring and discuss what's coming in the not too distant future. The material then looks at how internal controls have been affected and what other updates are on the horizon. Anyone trying to use controls to keep their organization efficient and secure should consider this session because the rate of change to both operational methods and control processes has been and will continue to be incredible. 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
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, including the 16 SASs effective since 2021 and beyond. The course also provides many hands-on examples and illustrations to help you apply the guidance in practice. On the financial front, the course covers the 9 ASUs issued in 2023, including ASUs covering crypto assets and leases for common control entities. 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 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.Speaker - Jason Carney, CPA, PMP, CISA
More Dates
Available Until
Available Until
Surgent's S Corporation Core Tax Issues From Formation Through Liquidation
Online/Webcast
8.00 Credits
See more dates
As experienced staff members master the preparation intricacies of an 1120-S tax return, they are expected to understand and apply the underlying concepts, principles and laws governing S corporation status. This course is designed to illustrate in both theory and practice overarching principles that govern S corporations from formation to revocation, termination and liquidation. Experienced, client-facing staff should be aware of the pitfalls that may inadvertently cause an S-status termination or may generate unintended tax consequences to shareholders.Speaker - Sue Smith, CPA
More Dates
Improve Spreadsheets by Building Controls in Excel
Online/Webcast
2.00 Credits
See more dates
In today's data-driven world, spreadsheets serve as the backbone of business and personal productivity. However, creating complex and error-prone spreadsheets can lead to critical mistakes and inefficiencies. This course aims to equip you with the knowledge and tools to build robust spreadsheets, implementing a range of controls and safeguards to ensure data integrity, streamline processes, and maximize accuracy. 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
Surgent's Controllership Skills Update: Mergers, Acquisitions, and Alliances
Online/Webcast
2.00 Credits
See more dates
Mergers, acquisitions, and partnering have long been strategic vehicles to grow or change an existing organization. Corporate America has extensive experience in merging with or acquiring firms. However, its track record of being able to unify an acquired firm with the acquirer and provide a single organization with increased growth potential has been somewhat shaky. This session provides a roadmap including specific actions for financial professionals focused on improving the results of an acquisition, sale, formation of an alliance, and/or outsourced activities. This program continues to be updated based upon trends and recent events. In addition to traditional topics, it includes discussions on the impact of taxes, corporate structures to manage M&A and internal venture capital, strategic spin-offs/splits, issues concerning goodwill, and managing outsourced activities. The program expands the topics covered in the Controllership Skills Update Series. As with the other programs, this brief session is aimed at renewing and expanding participants' existing skills, by providing specific actions to improve an organization's results. Real-world examples are used throughout the session.Speaker - Tony La Russo, BA, MBA, CMA
More Dates
Surgent's Guide to Partner Capital Account Reporting
Online/Webcast
2.00 Credits
See more dates
Tax practitioners are responsible for presenting partner capital accounts on the tax basis. But what does this mean and how have rules changed in recent years regarding partner capital accounts? This course covers exactly that. For tax practitioners preparing partnership 1065 forms, this course explains these complex rules in practical and understandable terms.Speaker - Mike Tucker, Ph.D., LL.M., J.D., CPA
More Dates
Mastering Microsoft 365 Copilot for CPAs
Online/Webcast
2.00 Credits
See more dates
Discover how Microsoft 365 Copilot can revolutionize your daily tasks as a CPA. Dive into the specific features and functionalities of this AI-powered assistant. Learn how to leverage Copilot to enhance productivity, automate routine tasks, and improve collaboration within your team. 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
Yellow Book Independence and Single Audit Fundamentals
Online/Webcast
4.00 Credits
See more dates
This CPE course explains Yellow Book independence including the general requirements, requirements for auditors providing non-audit services and documentation requirements. This course also explains the basic elements of a Uniform Guidance compliance audit, including an overview of requirements, major program determination with examples, an understanding of compliance requirements and related internal control over compliance, sampling, and single audit reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Adelina Burke, CPA
More Dates
Navigating IRS Correspondence: Responding to IRS Letters
Online/Webcast
2.00 Credits
See more dates
Participants will learn how to interpret the most common IRS correspondence, adhere to response deadlines, and effectively communicate with the IRS to resolve issues and minimize risks. It provides professionals with knowledge and strategies needed to handle the most common notices including audit requests, collections & return inquiries as well as error notices. Focusing on best practices to ensure compliance and avoiding penalties or escalation. 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
The Best Individual Income Tax Update Course by Surgent
Online/Webcast
8.00 Credits
See more dates
This highly informative course comprehensively covers all the latest tax law developments. The focus is on individual taxation and discussion of the planning opportunities practitioners need to understand to help clients respond effectively. You will come away from the course with the up-to-date knowledge to educate your individual tax clients and implement tax-saving ideas that will serve their ever-evolving needs. This course is continually updated to reflect enacted legislation. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BFTU.Speaker - Bob Lickwar, CPA
More Dates
Available Until
Available Until
Income Tax Analysis: Exploring In-Depth Concepts
Online/Webcast
2.00 Credits
See more dates
Financial statements prepared for stockholders and external users follow Generally Accepted Accounting Principles (GAAP), while tax returns adhere to the Internal Revenue Code (IRC). These frameworks differ in recognizing profitability, influencing reported income significantly. Companies often aim to minimize taxable income within legal bounds, while maintaining compliance with both financial reporting and tax regulations. - Timing Differences: Variations in income recognition and deductible expenses between GAAP and IRC create timing differences, impacting reported profitability and tax liabilities. - Deferred Tax Assets: Companies accrue deferred tax assets from overpaid taxes or carried-forward credits, which can offset future taxable income, reducing tax liabilities. - Deferred Tax Liabilities: When taxable income is less than reported income, deferred tax liabilities arise, necessitating future tax payments when temporary differences reverse. Join us to delve into these concepts, exploring how financial reporting choices and tax strategies shape a company's financial performance and compliance obligations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Eric Knight, CPA, DBA
More Dates
Forensic Accounting: Investigating Divorce Cases
Online/Webcast
4.00 Credits
See more dates
With over 50% of marriages ending in divorce, forensic accountants are frequently used in uncovering hidden income and assets. It is not uncommon for one spouse to hide money from another, sometimes for nefarious reasons. As a CPA, your services are valued by high-net-worth individuals who hire attorneys in their divorce proceedings. In this course, you will learn the art of financial investigations and how to uncover the truth in divorce cases, whether from offshore accounts to lifestyle analysis. Step by step, the course will teach you the valuable skills necessary in finding, analyzing, evaluating, and presenting your findings to your client and if needed, ultimately in divorce court. 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
Behind the Curtain: Exploring IRS Audit Technique Guides
Online/Webcast
2.00 Credits
See more dates
Have you ever considered a tax audit from the perspective of an IRS examiner? This session explains how you can use IRS Audit Technique Guides (ATGs) to enhance tax compliance. You will obtain a glimpse of the audit process from the viewpoint of an IRS agent as we explore insights that the IRS provides to its own examiners. 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
Advanced Excel for Staff - Build Reports and Analyze Data
Online/Webcast
2.00 Credits
See more dates
Advanced Excel for Staff - Build Reports and Analyze Data is a comprehensive, 2-hour course tailored for professionals looking to enhance their Microsoft Excel skills in creating reports and performing data analysis. This course bridges the gap between basic Excel functionality and the advanced techniques required for effective data-driven reports. Participants will learn to efficiently gather, organize, and structure data, apply calculations to derive key metrics, and create professional-grade reports that are both visually appealing and actionable. The course emphasizes practical application, providing participants with guidance on Excel's advanced tools and functions. By mastering workflows and best practices, learners will gain the confidence to tackle complex data challenges and streamline reporting processes. Additionally, participants will explore methods to validate and share their work, ensuring that reports are accurate, insightful, and easily communicated across teams. Whether you are tasked with preparing financial summaries, tracking performance metrics, or generating operational insights, this course will equip you with the tools to maximize Excel's potential, saving time and improving the quality of your outputs. 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
Surgent's Liquidation of Flow-Through Entities for LLCs and Partnerships
Online/Webcast
2.00 Credits
See more dates
Part of the technical competence of most experienced tax practitioners is the ability to advise owners of S corporations and partnerships or multiple-member LLCs treated as partnerships regarding the tax rules that apply when these entities liquidate. Entity liquidations do not occur every day; but they do occur, and often at very critical times in the business life of the entity and its owners. All tax practitioners should be able to advise their clients about the tax issues associated with client businesses that go out of existence and liquidate. This program explains the tax consequences associated with liquidating S corporations, partnerships, and multiple-member limited liability companies treated as partnerships.Speaker - Mike Tucker, Ph.D., LL.M., J.D., CPA