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.
Advanced Excel: Hidden Secrets and Gems
-
Online/Webcast
2.00 Credits
See more dates
This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel. Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level. 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
Build a Data Model for Analysis in Power BI
-
Online/Webcast
4.00 Credits
See more dates
This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. 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
The Leadership Skills of Tomorrow: Delegate and Listen
-
Online/Webcast
2.00 Credits
See more dates
Mastering two leadership skills will decrease your stress, and give you room to enjoy your career. Delegating and listening are key essential skills to hone to elevate your career. You were born with two ears and one mouth. And yet, good listeners aren't born. World-class listeners deliberately practice this skill, even when their audience is challenging. This is a skill which can be learned. Participants will gain awareness into their blind spots to listening, strategies to regain focus, how to stop interrupting, and demonstrate to their audience they are listening. How often have you said, "It would just be easier if I did this myself?" or "Nobody can do this task as well as I can, so I'll just do it myself." If this sounds like you, then it's time to start working on your delegation skills. Delegation is not only important as a means to save you time, but it is also about developing the next generation of leaders. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Julie G. Holunga, MBA, CPCC, ACC and Stephanie Wachman
More Dates
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 - Dr. Chris Harper
More Dates
Current Cybersecurity Risk Management Trends
-
Online/Webcast
2.00 Credits
See more dates
One of the top concerns of any organization's leadership is how to mitigate the risk of cybersecurity threats, along with the prevention and detection of fraud. This course will focus on the most common cybersecurity vulnerabilities and fraud trends, and best practices for managing them. 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
How AI Fits into the Accounting World
-
Online/Webcast
2.00 Credits
See more dates
This session is designed as a primer to introduce artificial intelligence (AI) and to discuss how it will impact accountants as they work. The material will briefly explain what AI is and then focus on ways that it is already serving those in the accounting realm. It will close with a look at future AI-centric developments that will have great potential to positively impact the accounting profession. Those wishing to gain an understanding of what artificial intelligence is and how it will be used by accountants should consider attending 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
Surgent's Communicating Financial Results to Stakeholders: A Guide for Client Advisory Services
-
Online/Webcast
2.00 Credits
See more dates
One of the most difficult things for any Client Advisory Services (CAS) professional to learn is how to communicate financial information to non-financial people. To be successful, it's crucial to master this skill, as we frequently explain accounting jargon to those unfamiliar with the field. In this course, we will explore how to properly communicate with stakeholders, including investors, clients, boards of directors, and even other departments. We will explore biases that people have when viewing financial information and even how to make sure we keep our message on point. If you are looking to move up in the financial services world, this course is a must for you.Speaker - Dave Peters, CPA, CFP, CLU, CPCU, MST, MBA
More Dates
Surgent's Depreciation Rules for Bonus and Section 179 Expensing
-
Online/Webcast
2.00 Credits
See more dates
The Tax Cuts and Jobs Act of 2017 (TCJA) has had a tremendous impact on commercial real estate, including liberalizing the depreciation provisions. Bonus depreciation was expanded and increased from 50 to 100 percent for qualifying assets placed in service beginning after September 27, 2017, through December 31, 2022. After December 31, 2022, the deduction percentage began decreasing by 20 percent per year, fully phasing out after 2026. Bonus depreciation is now available on new and used assets. President Trump favors a permanent extension of the 2017 tax provisions, and we anticipate legislative changes in 2025 that may make the changes in depreciation permanent or extend them beyond 2025. We will be watching legislative developments closely in 2025 to determine how 2025 legislative changes impact the tax depreciation rules.Speaker - Mike Tucker, Ph.D., LL.M., J.D., CPA
More Dates
Surgent's The Most Critical Challenges in Not-for-Profit Accounting Today
-
Online/Webcast
4.00 Credits
See more dates
In recent years, not-for-profits have applied critical new standards related to contributions of nonfinancial assets, leases, and more. However, with all the focus on the new stuff, have we forgotten any of the old stuff? FASB ASC 958 has a great deal to say about various accounting and reporting issues in the form of its implementation guidance and illustrations. Not knowing this guidance can result in lost time and erroneous applications of GAAP. In this course, we will review some of the most critical illustrative not-for-profit guidance issued by the FASB.Speaker - Charlie Blanton, CPA
More Dates
The SECURE Act 2.0 - Planning Opportunities for Employers
-
Online/Webcast
1.00 Credits
See more dates
The Secure Act 2.0 was passed in a flurry of year-end legislation. This one hour program will cover the important changes that employers need to know about company retirement plans. Employers will also need to consider how Secure Act 2.0 will the administration of existing plans or the creation of new ones. This course will provide a concise look at these hot topics. **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 - Allison McLeod
More Dates
Internal Control Frameworks for Single Audit
-
Online/Webcast
1.00 Credits
See more dates
The Uniform Guidance identifies COSO and the Green Book as best practices for internal controls in governmental audits. This course provides a comprehensive review of the COSO framework, including its 2013 update, and explores its application to the Green Book. Attendees will learn to recall the five components and 17 principles of internal control, understand the benefits of adopting internal control frameworks, and recognize the rationale behind the COSO 2013 update and its impact on auditing practices. Additionally, the course will cover how to leverage Part 6 of the Compliance Supplement to effectively document internal controls. Speaker - Melisa Galasso
More Dates
Forensic Accounting: When The Office Is A Crime Scene
-
Online/Webcast
4.00 Credits
See more dates
Embezzlement happens often to many small businesses. Unfortunately, the lack of internal controls allow the embezzlement to remain undetected for years. But when it is discovered, the small business owner will most likely contact their CPA for advice. What should you do when your client contacts you about their employee embezzling money from their business? What options should you present to your client? How can your client protect themselves, while investigating the embezzlement? What steps need to be taken about preserving any documents, emails, texts, or phone calls? This course teaches how to engage the client, properly identify the evidence needed to prove the crime, how to write the report for civil and criminal trial, and best practices in preserving electronic and paper evidence. 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
Compilation, Preparation and Review Basics and Peer Reviews
-
Online/Webcast
2.00 Credits
See more dates
Cover the basic requirements for performing preparation, compilation, and review engagements under Statements on Standards for Accounting and Review Services (SSARS), including the new SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions. Review common issues found on SSARS engagements in connection with peer reviews and the impact of various findings on the results of a peer review. Identify key issues to consider during SSARS engagements, and determine how to incorporate quality control recommendations and tips for performing high-quality SSARS engagements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the eventSpeaker - Allison M. Henry, CPA, CGMA
More Dates
Beyond the Basics: Financial Ratios You Might Be Overlooking
-
Online/Webcast
1.00 Credits
See more dates
Overview: Understanding your company's financial health requires more than just traditional metrics. This webinar is designed to reveal deeper insights through advanced, underutilized financial ratios. In this session, accounting and finance professionals will explore metrics such as operating leverage, free cash flow yield, and margin of safety-tools that go beyond standard ratios to deliver nuanced perspectives on profitability, risk exposure, and operational efficiency. 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
ChatGPT and Advanced Accounting Research
-
Online/Webcast
2.00 Credits
See more dates
This course provides a concise overview of how artificial intelligence, particularly ChatGPT and other AI tools, is transforming accounting research methodologies and practices. Students will explore the shift from traditional search engine-based research to AI-driven insights, learning how to leverage various AI platforms for enhanced financial analysis, regulatory compliance, and strategic decision-making. The course emphasizes practical applications of AI in accounting contexts while addressing critical considerations such as data verification, ethical usage, and professional judgment. 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
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
The Controllership Series: The Controllers Role in Internal Controls
-
Online/Webcast
1.50 Credits
See more dates
This course in part of our series on the Controllership Role. Internal control is relevant to everyone in the workplace. It represents our moral responsibility to understand and comply with organization policies and procedures. It also provides the means to hold individuals accountable for their work. The controller is an impactful position that affects a company's processes including financial, compliance and operational. Controller functions vary across companies often following the size and complexity of the business and the industry. Smaller companies require more versatility for the controller Larger companies are more able to segregate job responsibilities across other employees. The controller should be knowledgeable of the various controls to create a control system that will appropriately safeguard company assets and processes. Internal controls are typically comprised of control activities such as authorization, documentation, reconciliation, security and segregation of duties. Speaker - Lynn Fountain
More Dates
Contract Accounting, Lease Accounting, and their Impact on Construction Contractors
-
Online/Webcast
1.50 Credits
See more dates
Construction accounting is not just about revenue, but it is a lot about revenue. Leases too. Diving deep into the five-step approach for revenue recognition in the construction industry, this course has all of the rules and interpretations that you might need. Further, practical examples help to drive home the learning. Additionally, leases are critical for contractors. From equipment to warehouse space, leases appear prominently on many contractors' book. Review the current guidance and begin to understand the new guidance under ASC 842. Program features: Detailed discussion of the guidance under FASB ASC 606, Revenue from Contracts with Customers. Examples and exercises to understand the five-step recognition process. Detailed discussion of the guidance under FASB ASC 842, Leases. Reasons why leases are so important to contractors. A walkthrough of both current and future lease guidance.
More Dates
ChatGPT Vision: How Accountants can Chat with Imagery
-
Online/Webcast
2.00 Credits
See more dates
This course offers an in-depth exploration of the "vision" capabilities of ChatGPT specifically tailored for accountants. The session demonstrates how artificial intelligence can interpret and analyze visual content to revolutionize financial management. The curriculum covers a wide range of applications, from understanding GPT Vision and its unique benefits to leveraging aerial and street view imagery for comprehensive financial analysis. Through detailed case studies, participants will learn how to access and utilize GPT Vision effectively, incorporating it into tasks like data visualization, text and object recognition from images, and the use of descriptive, diagnostic, predictive, and prescriptive (DDPP) analysis methods to enhance decision-making processes. 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 Critical Issues Involving Taxation of Construction Contractors
-
Online/Webcast
4.00 Credits
See more dates
Many consider taxation of construction contractors to be the most complex area of the Internal Revenue Code. Probably no other industry has so many elections and considerations that need to be considered and made in order to reduce or defer amounts owed. In this course, we will highlight these areas and discuss potential opportunities for practitioners and their clients. We will also discuss the impact of more recent legislation on construction taxation, including changes to net operating losses and the AMT rules. This is a critical presentation "tailor-made" for CPAs who either work for or represent construction contractors.Speaker - Dave Peters, CPA, CFP, CLU, CPCU, MST, MBA