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.
S Corporation (Form 1120S) - Formation to Liquidation
-
Online/Webcast
8.00 Credits
See more dates
With the increasing complexity and ever-changing nature of tax laws and issues, today’s accountant needs a S corporation course focusing on the birth, growth, maturity, and death of a closely held S corporation. This case driven course will deal with S corporation income tax laws from formation to liquidation. **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
Excel - Create KPI Dashboards for Maximum Impact
-
Online/Webcast
2.00 Credits
See more dates
Most accountants use Excel to help them make decisions about their data. However, as the amount of data grows, it becomes difficult to make strategic decisions based on rows and rows and columns and columns of data. In this course, you will learn how to build robust dashboards for analyzing key metrics in Excel. We will begin with some dashboard design guidelines, such as understanding your audience and identifying necessary metrics. Then, we will work through importing data, setting up calculated fields and columns, and creating key performance indicators (KPIs) for the dashboards. You will learn how you can add charts and eye-catching visuals with Power View, in order to make your dashboards easily understood. 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
Audit 305: Strengthening Substantive Analytic Procedures
-
Online/Webcast
2.00 Credits
See more dates
Substantive Analytic Procedures - Strengthening Evidence to Satisfy Audit Objectives will provide the tips and best practice techniques for strengthening substantive analytic procedures in order to reduce over-reliance on tests of details. One of the ways to perform a more effective and efficient audit is to maximize the use of substantive analytic procedures in the detailed audit plan. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for analytical procedures. 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
The Dark Web & Cybersecurity for Tax and Accounting Pros
-
Online/Webcast
2.00 Credits
See more dates
This course provides a concise overview of the Dark Web, a part of the internet that isn't indexed by search engines, and is often associated with anonymous transactions and nefarious activities. Discover the leading threats and risks that the Dark Web poses to accounting firms. Explore how practitioners can effectively mitigate the risk of data breaches, ransomware attacks, financial fraud and other risks connected to the Dark Web. You'll walk away with a foundational understanding of leading cybersecurity strategies that can help you maintain client trust and protect your firm's sensitive data in this complex and ever-changing threat landscape. 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
2024 Fiduciary Accounting for Estates and Trusts
-
Online/Webcast
4.00 Credits
See more dates
Financial accounting for trusts and estates is one of the least understood branches of accounting. It is not particularly concerned with recording income and expenses but is obsessed with determining whether receipts and expenditures are assigned to income or principal/corpus. This course will dive into this tricky area and provide a reporting guide for fiduciary accounting. Speaker - Doug Van Der Aa, CPA, JD
More Dates
Excel - Functions and Formula Shootout
-
Online/Webcast
2.00 Credits
See more dates
Are you aware there are 470+ formula functions in Excel? Do you realize that they add new functions in every major version of Excel? Did you know that Microsoft adds new functions throughout the year in the Office 365 version of Excel? Are you stuck using old or simple functions like SUM or ROUND? Do you want to expand your knowledge of the extensive function library in Excel? If these questions peak your interest in becoming an Excel function expert, this course is right up your alley. This past-paced course digs into some of the most powerful functions in Excel. Although we cannot cover 470 functions, we will look at over 20 functions that will allow you to create advanced calculations in your spreadsheets. Some examples are: VLOOKUP, IF, IFS, FORECAST, RAND, SWITCH, TEXTJOIN, UNIQUE, SUBTOTAL, IS, TEXT and more! We will also provide example files that will include all the functions used during the class. It's time to take your Excel spreadsheets to the next level. This session is presented using Excel 2019/Office 365. Most 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
Budgeting: Presenting and Communicating your Numbers
-
Online/Webcast
2.00 Credits
The budgeting process can be a time consuming and frustrating process for accountants. The constraints and pressures can lead to poor decisions in both the technical and human components. This session will cover: Budgeting: Presenting and Communicating your Numbers • Now that the budget is complete, how we communicate our plan is critical. this session reveals some key guidelines in budget presentation and will identify key problems in how people often communicate financial plans. Speaker - Bob Mims
Cybersecurity 101 for CPAs
-
Online/Webcast
2.00 Credits
See more dates
This course provides an overview of cybersecurity from the CPA perspective. We will discuss the components of an IT environment that need to be considered in audits - e.g. network, operating systems, database, and application layers. Additionally, we will discuss an overview of cybersecurity frameworks under the influence of the AICPA and/or ISACA - e.g. SOC2, COBIT, COSO, SOX IT controls, etc. and key cybersecurity controls. 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/Dr. Kenneth W. Cooper, DCS,
More Dates
Surgent's Excel: Mastering PivotTables
-
Online/Webcast
2.00 Credits
See more dates
PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.
More Dates
Audit 306: Reviewing Workpapers - A Role in Quality Control
-
Online/Webcast
2.00 Credits
See more dates
Reviewing Workpapers - Embracing Responsibilities for Quality Control will provide the tips and tools for satisfying important workpaper reviewer responsibilities. Audit documentation provides the principal support for an auditor's report. Therefore, it is critical for workpaper reviewers to perform quality control procedures to ensure that technical, professional, and regulatory standards are met. In addition, the workpaper review process should be used as a tool for professional development and promoting efficient audits. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has workpaper review responsibilities. 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
Online Fraud Aimed at Individuals That Can Affect a Company
-
Online/Webcast
2.00 Credits
See more dates
We have all heard the statement that it is the people that work at a company that gives it value. It is, sometimes and unfortunately, also the people that provide fraudsters with an entry point into an organization that can lead to hardship. This is even more true now because cyber-attacks on both organization and individuals have increased notably. Many highly publicized corporate hacking events are successful, at least in part, because an individual was targeted. In this session, we look the types of fraud that take aim at individuals with a special focus on the growth of cyber-attacks. We then discuss measures that can be put forth to help employees protect both themselves and the 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 - Karl Egnatoff, CPA.CITP
More Dates
Surgent's Time Management for Professionals
-
Online/Webcast
2.00 Credits
See more dates
The phrase "time management" is misleading. No one manages time. Instead, we manage events in our lives which consume time. Like money, time is both finite and valuable; it should be budgeted and used wisely. Those individuals who "manage" or budget their time wisely often are more productive, less stressed, and able to achieve their goals more effectively than others. Professionals by nature place a high value on their time. Still, successful time management strategies vary based upon the personality, motivation, and discipline of each individual. This course provides simple, practical, and powerful techniques that help professionals work efficiently and achieve better balance in their lives. Successful time management skills also reduce the risk of burnout, which in turn improves the likelihood of achieving success in any endeavor.
More Dates
Surgent's Tax Loss Limitations Imposed on Individuals and Pass-through Entities
-
Online/Webcast
3.00 Credits
See more dates
Tax practitioners advising their business clients must be fully informed regarding the multiple loss limitation provisions that apply to individuals conducting businesses and pass-through entities. This program covers the loss limitation rules that tax practitioners must know in order to advise their individual and pass-through entity clients fully and adequately as to when and if a loss limitation applies. The loss limitations discussed in this program start with an introductory discussion of hobby loss rules and graduate to a more substantive discussion of the remaining loss limitations: basis limits, at-risk rules, passive loss limits, excess business loss limits, net operating losses, and the Section 163(j) interest limitation. Knowing when loss limits apply is essential for any tax practitioner. This program will put you in a position to advise clients fully and intelligently regarding each of the loss limits.
More Dates
Vexing Issues Facing Not-for-Profit Accountants
-
Online/Webcast
2.00 Credits
See more dates
Accounting standards affecting not-for-profit (NPF) organizations have become increasingly complex, and, as a result, a great deal of confusing exists as to how to properly account for certain transactions unique to these organizations. This course will clarify proper accounting and reporting for these troubling areas. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Daniel W. Bradley, CPA
More Dates
Integrate ChatGPT into Your Client Advisory Services-Updated
-
Online/Webcast
2.00 Credits
See more dates
Two of the hottest topics in the CPA profession today are CAS (client advisory services) and ChatGPT. This course will explain how to bring these two worlds together by integrating ChatGPT and other generative AI applications into your client advisory services. John Higgins, a leading advisor to the profession on ChatGPT and a seasoned client advisor on technology based solutions, will show you how you can position your firm and yourself as a "go to" advisor on how to embrace this technology in virtually any type of business. John will address how to use this technology as a research and writing assistant in your client services and how to advise your clients on this revolutionary technology and all benefits and "gotchas" that come with it. If you want to step up your advisory game, this course is a "must take." 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
Presentation Skills for Auditors
-
Online/Webcast
2.00 Credits
See more dates
Are you comfortable giving presentations and feel good about your performance, or does the experience make you anxious and leave you feeling dissatisfied? In this session, learn how to let your best self shine during interactions with your staff, the auditee, and the governing board. Jim Comer is an accomplished speechwriter and presentations skill coach for executives. Leita Fanta has led over 1500 full-day seminars. Let Jim and Leita help you establish genuine and comfortable professional relationships and avoid mistakes that will detract from your message. *Qualifies for Yellowbook credit This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Jim Comer
More Dates
Grading Your Auditors - Are You Getting the Most Value?
-
Online/Webcast
2.00 Credits
See more dates
An audit is an investment in reliable financial reporting and compliance, and an increased return on those dollars can be achieved by hiring the right auditors. This course will provide key factors for you to consider when evaluating whether you are getting the most quality and insight from your auditors, to enable them to perform the most value-added audit possible in the given circumstances - while retaining the trust of a CPA. 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
GAAP Alternatives: The Perfect Storm of Accounting Updates
-
Online/Webcast
1.00 Credits
See more dates
Companies operating in today's business climate are weathering a storm of major FASB updates. Companies and their advisors may want to consider non-GAAP options as they develop strategies involving revenue recognition, leasing, credit losses, and other FASB pronouncements. This session will provide an overview of special purpose frameworks that may present salient alternatives to U.S. GAAP for certain entities. 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
Implementing and Maintaining an Internal Control System
-
Online/Webcast
8.00 Credits
See more dates
Many organizations are successful as they create a system of internal controls, however some fail to properly implement the measures that are established. Moreover, entities regularly neglect the important process of testing, monitoring, and updating control procedures, which weakens the entire internal control structure. This session provides an overview of control creation methods and discusses ways to successfully implement policies and procedures. Additionally, it includes an array of control maintenance checklists that participants can take and adapt to their organization as they work to improve policies and procedures. Finally, it provides an understanding of the need for dynamic, fluid controls that adapt to changes in business tools and methods. Participants that take this course will have a strengthened ability to implement and maintain an internal control system. 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 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.