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.
Excel for Accounting Professionals Session 5: Error Trapping and Improving Lookups
-
Online/Webcast
2.00 Credits
See more dates
Practical hands-on Excel learning exercises taught by a highly engaging expert in the field You'll develop your expertise with real-world Excel workbooks. Despite the popularity of VLOOKUP, it has its drawbacks. This session will address these drawbacks while offering alternatives. You'll walk through the VLOOKUP and IFERROR functions, and explore the following topics: Improving the use of VLOOKUP with VALUE/TEXT Improving the use of VLOOKUP with MATCH. Moving beyond VLOOKUP with INDEX Trapping errors with IFERROR Moving beyond basic Excel functions Grasping the limitations and possible enhancements for the VLOOKUP feature, along with methods to handle errors can elevate your proficiency in Excel. You'll also partake in hands-on Excel activities that showcase the integration of functions and their use in crafting spreadsheets, encompassing: Combining functions to enhance flexibility Utilizing functions for atypical data categories Perfecting sophisticated lookup functions *Session 5 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 6: List Comparisons and Indenting] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-6--list-comparisons-and-indenting) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Using ChatGPT with Excel
-
Online/Webcast
2.00 Credits
See more dates
In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. 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 Successful Communication
-
Online/Webcast
4.00 Credits
See more dates
Technology has created numerous ways for us to communicate with each other - but it's also increased the number of ways in which the message can get garbled. Effective communications skills are crucial to successful management. Learn how to control your message with clear communications strategies. You'll learn to recognize communication barriers, assess styles and behaviors, and learn how to listen more effectively as well.Speaker - Sarah Acuna
More Dates
Enterprise-Wide Risk Management in Accounting and Finance
-
Online/Webcast
4.00 Credits
See more dates
Organizations are challenged with identifying, evaluating, and responding to a wide variety of risks. This course will discuss tips and best practices for enterprise-wide risk management for accounting and finance professionals. 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
Building Security and Efficiency With Internal Control
-
Online/Webcast
8.00 Credits
See more dates
A well-designed internal controls system can and will drive all entity objectives. Too many times control creators focus too much on security. It is important to properly balance protection-based measures with those designed to enhance efficiency. This session works to illustrate the power of a strong and well supported control system. It also discusses steps to take in order to establish such a system. This material is becoming more and more beneficial as companies strive to address many new business challenges such as evolving markets, the rapid rate of change in the business world and the notable increase in governmental and industry-based regulation. Those that desire a balanced and workplace enhancing control system should strongly consider this session. 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
How to Start a CFO Service
-
Online/Webcast
1.00 Credits
See more dates
This Masterclass is a one-hour training to show accountants how they can grow their practice this year through CFO and business advisory services. 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
K2's Saving Time With Electronic Forms
-
Online/Webcast
1.00 Credits
See more dates
Web portals, "low-code/no-code" data collection, and survey tools have changed how we collect data. Modern solutions like Microsoft 365 Forms, Zoho Survey, SurveyMonkey, Microsoft PowerApps, and legacy tools like Adobe Acrobat Forms allow users to create web forms and integrate the resulting data into business process workflows. This session introduces the range of available tools, demonstrates standard features, and shows how tools permit users to expose or conceal questions based on answers given earlier in the survey. Attend this session to learn how to use tools you already own to efficiently collect data from your team, customers, and vendors. Speaker - Brian Tankersley
More Dates
ChatGPT: What Every CPA Should Know-Updated
-
Online/Webcast
2.00 Credits
See more dates
Don't look now, but ChatGPT is taking the business world, including the accounting profession, by storm. Every CPA, whether in public accounting or working in corporate, should have a fundamental understanding of ChatGPT and generative AI applications more broadly. This course will provide you with a foundation of knowledge about ChatGPT technology that will prepare you to have conversations with clients, customers, colleagues and service providers. More importantly, you will learn how to leverage ChatGPT to increase your personal productivity. If you feel your ChatGPT knowledge is lacking, that will not be the case after you attend this course, taught by John Higgins, one of the leading technology strategists and thought leaders for the accounting profession. 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
Surgent's Hiring New Workers and Payroll Taxes
-
Online/Webcast
2.00 Credits
See more dates
When a new employee is hired, there are a lot of things the employer needs to take care of. Aside from getting employment contracts signed, training lined up, and the new hire breakfast planned, employers are tasked with making sure all of the payroll forms are filled out. For many small business owners, this can be a source of anxiety. They often wonder if they have everything they need. They also hear horror stories about potential IRS penalties for not having all of the boxes checked. In this course, we will explore the payroll compliance side of hiring new employees. From the alphabet soup of forms that need to be filled out to the initial payroll tax forms, we have you covered if you are a new practitioner or new business owner. We will even discuss the surprisingly difficult-to-navigate world of unemployment insurance.Speaker - Dave Peters, CPA, CFP, CLU, CPCU, MST, MBA
More Dates
Guide Strategy, Attract Investments with Financial Forecasts
-
Online/Webcast
2.00 Credits
See more dates
Financial statement forecasting is essential for predicting a company's future financial health, guiding strategic decisions, and attracting investments. By analyzing historical data, market trends, and assumptions, businesses can anticipate risks and opportunities, enabling effective planning, resource allocation, and long-term stability and growth. - Forecasting Process: This involves projecting future income, expenses, and resources. By leveraging historical data and market insights, businesses can predict financial health, shaping strategic planning, investment decisions, and risk management. - Forecasting Profitability: Predicting future earnings informs strategic decisions, investment planning, and resource allocation. It facilitates effective budgeting, cash flow management, risk assessment, and enhances attractiveness to investors for sustainable growth. - Forecasting the Balance Sheet: Analysts forecast to predict a company's future financial position, assessing growth potential, solvency, and capital structure. This informs investment decisions, strategic planning, and risk management, ensuring financial stability and growth. Join our webinar to explore these concepts with a practical example, guiding you through the forecasting process and demonstrating its practical applications 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 - Eric Knight, CPA, DBA
More Dates
2025 A&A Update With Technology Implementation
-
Online/Webcast
4.00 Credits
See more dates
Stay informed and prepared with this comprehensive annual update on the latest developments in accounting and auditing. We'll begin with a deep dive into the Accounting Standards Updates (ASUs) effective in 2025, followed by insights from the FAF's 2024 PCC Review and an overview of FASB's Invitation to Comment - Agenda Consultation, which will shape the future of accounting standards. On the auditing side, we'll tackle the essential changes in quality management standards that firms must implement by the end of 2025. The session will also highlight common deficiencies identified by the DOL in EBP (Employee Benefit Plan) engagements and provide a peek at upcoming projects from the Auditing Standards Board (ASB). Join us to gain practical insights and actionable takeaways to navigate these updates with confidence. Finally, we will close the course by exploring the audit technology adoption process to help transform resistance into resilience as the industry embraces new technologies. We will learn how to overcome common barriers to deliver a successful implementation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Melisa F. Galasso, CPA
More Dates
Corporate Transparency Act Developments
-
Online/Webcast
2.00 Credits
See more dates
U.S. Department of Treasury's Financial Crimes Enforcement Network (FinCEN) imposed a new reporting requirement that went into effect on January 1, 2024. Millions of businesses may have to file a Beneficial Ownership Information (BOI) Report. In a surprise turn of events, the Federal District Court from the Northern District of Alabama ruled on March 1, 2024 in National Small Business United v. Yellen ("NSB") that the CTA is unconstitutional. This course will discuss the CTA's provisions and the court's decision in NSB. Also covered will be future implications for business entities and steps to consider given the recent ruling. We will also discuss recent proposed rulemaking by FinCen with respect to nonfinanced purchases of residential real estate and gratuitous transfers so that businesses can prepare for any additional reporting burdens that might arise. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Allison M. McLeod, LL.M., CPA
More Dates
Excel for Accounting Professionals Session 6: List Comparisons and Indenting
-
Online/Webcast
2.00 Credits
See more dates
Major benefits of detailed Excel workbooks Understanding list comparisons in Excel is vital for improved workbook efficiency. In this webcast, the facilitator will walk you through comprehensive learning exercises that provide an overview of the following topics: Performing list comparisons Building multicolumn list comparisons Using lookups Indenting commands In-depth training for Excel upskilling This webcast is crafted to enable active participation as you follow the demonstrations. It will navigate you through the intricacies associated with working Excel columns, helping you to apply key functions effectively for significant improvements through the following: ISERROR COUNTIFS SUMIFS *Session 6 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 7: Data- Driven Workbooks and Concatenation] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-7--date-driven-workbooks-and-concatenation) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Surgent's Representing a Client in an IRS Audit
-
Online/Webcast
3.00 Credits
See more dates
Recent legislation in Congress has provided the IRS with substantially increased funding to bolster its human staff and purchase software that will allow the IRS to audit many more taxpayers in a more effective way. The IRS believes it can target the right kinds of taxpayers for audits so that it will not waste its time on audits that produce little, if any, revenue. The purpose of this program is to discuss the current state of IRS audits and the anticipated increases in the IRS's ability to audit wealthier taxpayers in an efficient way. The course will discuss the state of the IRS's current audits and where the IRS is headed with audits in the coming years. Tax practitioners should also be aware of the state of the IRS's efforts to target efficiencies so as to produce the most revenue.Speaker - Mike Tucker, Ph.D., LL.M., J.D., CPA
More Dates
S Corporations: Calculating Shareholder Basis
-
Online/Webcast
2.00 Credits
See more dates
A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans. How to use the Form 1120S, Schedule K-1 information for basis determination. An illustrative example demonstrates how the process works, as well as the many potential pitfalls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Steven C. Dilley, CPA, JD, PhD
More Dates
Comprehensive Audit & SSARS Update
-
Online/Webcast
4.00 Credits
See more dates
This course covers recently issued standards from the AICPA Auditing Standards Board and AICPA Accounting and Review Services Committee including the new Quality Management Standards. The session will highlight projects in progress at the Public Company Accounting Oversight Board, and International Auditing and Assurance Standards Board. The course will also recap recent changes and present common peer review findings and best practices to improve practice quality. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Allison M. Henry, CPA, CGMA
More Dates
Fraud Busters: Controls to Prevent & Detect Fraud
-
Online/Webcast
2.00 Credits
See more dates
This course investigates actual real-world fraud schemes and discusses what controls could have prevented the fraud from occurring, and what controls could detect and curtail the fraud scheme. The instructor speaks from experience, finding multiple frauds very early in her career leading to a career-long focus on fraud prevention and detection. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Keely Gohl, CPA, CGMA
More Dates
Professional Skepticism for the Public Accountant
-
Online/Webcast
1.00 Credits
See more dates
Accountants are expected to demonstrate a questioning mindset. While such professional skepticism is an obvious requirement for assurance engagements, it is applicable elsewhere in the practice of public accounting. In fact, a skeptical mindset offers benefits to both public accountants and those who work in industry. This course provides specific examples of professional skepticism while suggesting best practices. Speaker - Dr. Chris Harper
More Dates
ChatGPT and Advanced Policy Manual Development for ACCTs
-
Online/Webcast
2.00 Credits
See more dates
This course provides a concise overview of how to leverage ChatGPT and other AI tools to develop comprehensive, efficient, and compliant policy manuals for accounting firms. The revolutionary PRIME Method (Policy Refinement and Integration through AI-Managed Elaboration) empowers accounting professionals to create sophisticated policy documentation while maintaining human oversight and expertise. 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 Engagement and Client Retention Best Practices
-
Online/Webcast
2.00 Credits
See more dates
Positive client relationships require work. Miscommunication, unrealistic expectations, and differing personality styles may strain a client's relationship with professional advisors. Fortunately, there are tested strategies that foster and strengthen client relationships. Creating appropriate boundaries early on is one of many effective strategies that can help. This course explores actions accounting and finance professionals can take to create and grow their client relationships. This webinar provides actionable insights on how to engage new and old clients alike. Strained client relationships can harm both the client and the firm's profitability. Yet automation, for example, allows some firms to remain more engaged while others miss the mark. There is a science underlying client retention that involves understanding the client journey, ensuring consistent client interactions, and equipping employees with the tools needed to satisfy client needs. Understanding these skills should help you protect the relationships that sustain your business. Speaker - Jason Cornell, Esq.