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.
Excel - Using PivotTables for Data Analysis
-
Online/Webcast
4.00 Credits
See more dates
Excel is the #1 data analysis tool for accountants, yet many accountants have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis. This session is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make analyzing data an easy task for all accountants. Participants will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features. 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
Key Cybersecurity Controls for CPAs
-
Online/Webcast
2.00 Credits
See more dates
This course will provide overview of key cybersecurity security domains that CPA's should evaluate in an audit. It will provide an overview of each security domain, and an overview of how to evaluate and assess the sufficiency of the cybersecurity control. Examples of security domains that will be covered include: Change management Access management Data integrity 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 Data Analytics Toolkit - Tools and Applications
-
Online/Webcast
2.00 Credits
See more dates
There is no shortage of data, but relatively few organizations have an environment and process to isolate, capture, analyze, and convert data into actionable information. Too often, we collect as much data as possible, continue to use historic measurements, and communicate data using traditional vehicles. Good decisions are not the result of the amount of data gathered, but of the quality and understanding of the information. The goal of this program is to explore a number of analytical tools and techniques and identify applications for them within an organization. Analytical techniques will be introduced throughout the discussion, and a significant amount of time will be spent addressing the steps needed to establish a data-driven environment and identifying and discussing potential/specific applications. In this way, participants get experience they can begin to use in their organizations. An expanded list of reference books and next level software is also provided.
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
Surgent's Ensure Your Accounting Team Is Operating at Peak Performance Through Engagement and Motivation
-
Online/Webcast
2.00 Credits
See more dates
Effective teamwork pays its own way by creating greater productivity and profitability in any accounting organization. A team of people working cooperatively can produce more than the sum of individual members working alone. One good idea stimulates another - but only if the team members are engaged and motivated to do so. Teamwork is inhibited in today's high-stress and changing accounting regulatory environment. Integrated into this informative yet pragmatic seminar are tried-and-true motivational principles for the realities of today's changing accounting workplace. It's not easy, but it can be done. You will learn how to form, motivate, steer, and get greater results from all team members by understanding what makes them tick and strategizing approaches to engage all team members.
More Dates
Surgent's Mastering Client Management for Accounting and Finance Professionals
-
Online/Webcast
2.00 Credits
See more dates
Do you want to build stronger relationships with your clients, improve client retention, and drive growth in your practice? This course delves into the essential strategies for effective client management in today's competitive landscape. Client relationships, like any relationship, can be challenging to manage. Miscommunication, differing work styles, and unrealistic expectations are some of the challenges accounting and finance professionals routinely encounter. However, when accounting clients and members of your team are on the same page, client loyalty and profitability improve while conflict is minimized. This webinar explores proven strategies to improve relationships between accounting and finance professionals and their clients.
More Dates
Audit 206: Analytical Procedures - Audit Fundamentals
-
Online/Webcast
2.00 Credits
See more dates
Analytical Procedures - Comprehending Financial Statement Audit Fundamentals will provide the tips and techniques necessary to gather sufficient appropriate audit evidence to support conclusions using analytic procedures common to financial statement audits. Properly designing, documenting and evaluating results of analytic review procedures is critical for performing an effective and efficient audit engagement. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has responsibilities for performing financial statement audit analytics. 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
Microsoft Outlook "Must Know" Email Tips
-
Online/Webcast
2.00 Credits
See more dates
If you use Outlook on a daily basis to process your email, chances are pretty good that you are missing out on a lot of opportunities to improve your efficiency in composing, processing and organizing your messages. There are many different features in Outlook that often get overlooked, even though we are working in the app all day, every day. John Higgins, a strategic advisor to the profession on Microsoft 365 deployment, will review numerous tips and features to improve your productivity in Outlook. You will learn many time-saving, practical ways to improve the quality of your email message. 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
Entertainment, Meals & Travel Expenses: Review and Update
-
Online/Webcast
2.00 Credits
See more dates
This program reviews the statutory and regulatory guidance as they relate to fringe benefits. There will be an emphasis on entertainment, meals and business transportation expenses, including qualified employer-provided parking, with a focus on planning opportunities. Recent federal tax legislation, cases and rulings will also be addressed. 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
Like-kind Exchanges in Real Estate Transactions
-
Online/Webcast
2.00 Credits
See more dates
Please join us for a discussion on like-kind exchanges (LKE), known as one of the last great tax legal "shelters" available to those buying and selling real property. We cover the basic structure of a LKE, and ways a taxpayer can utilize qualified third-party intermediaries (QI), and tenancy-in-common structures including Delaware Statutory Trusts (DST). We also explore creative solutions to sticky situations a taxpayer may find itself in obtaining replacement property. This course is ideal for CPAs, EAs, lawyers, real estate professionals, accountants or other tax 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 - Allison M. McLeod, LL.M., CPA
More Dates
Section 174: New Rules for Research & Experimentation
-
Online/Webcast
1.00 Credits
See more dates
This program addresses the most recent developments impacting taxpayers incurring research and experimentation costs. Emphasis will be placed on compliance with the 2022 change in Section 174 Amortization of research and experimental expenditures. 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
2024 Section 174: New Rules for the R&E Deduction
-
Online/Webcast
1.00 Credits
See more dates
This program addresses the most recent developments impacting taxpayers incurring research and experimentation costs. Emphasis will be placed on compliance with the 2022 change in Section 174 Amortization of research and experimental expenditures. **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 - Steven Dilley, CPA, JD, PhD
More Dates
Advanced Negotiations: Beyond Getting to Yes
-
Online/Webcast
1.00 Credits
See more dates
Anytime someone says "I want," "I need," or "Will you," you are in a negotiation. For decades, the negotiation techniques described in "Getting to Yes" by Fisher and Ury of the Harvard Negotiations Project were the world's standard negotiation methods. These techniques involved collaborative methods for discovering how to make the "pie" bigger and then split it. More recent research on human psychology has revealed new methods that will allow you to do even better. Sometimes, you can't settle for getting half of what you want. Sometimes you have to have it all. This webinar explores negotiation's human side, to give you powerful people skills that will let you get more. 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 L. Daly, MBA, CPA, CMA, CPIM
More Dates
GASB 96 -SBITA, GASB 94 P3, and GASB 87 Leases (Year 2)
-
Online/Webcast
2.00 Credits
See more dates
This is a 2 hour webcast that will focus on the similarities between all three of these GASB accounting standards that deal with contractual arrangements such as leases, Subscription-Based Information Technology Arrangements (SBITA) and P3s. Compare and contrast these standards as you prepare for implementation this year of GASB 94 and GASB 96, and review the implementation efforts of Leases in Year 2. Speaker - Frank Crawford, Christopher Pembrook
More Dates
Motivating the Right Way - Get the Most From Your Staff!
-
Online/Webcast
2.00 Credits
See more dates
Are you getting the most from your staff? Are you paying top-dollar and still not getting high performance? New research gives us the insights to effectively motivate your people. This session discusses proven people motivation tactics. Many 'old' methods really did not motivate in the past and certainly do not work today. Getting the most from your people requires new, very learnable, leadership techniques. Whether your business is large or a start-up, getting people to move forward as one is a challenge. This session will show you how to create an environment where your talented employees can 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 - Don Minges, MBA
More Dates
Surgent's Mastering the Basics of Inventory Accounting
-
Online/Webcast
4.00 Credits
See more dates
While many entities maintain inventory, they are often challenged when applying the complexities of inventory accounting. The goal of this course is to provide a detailed overview of inventory accounting concepts that can be applied to a variety of inventory types. The course will cover the basics of inventory capitalization, for both book and tax, as well as the basic inventory valuation methods, LIFO, FIFO, weighted average, and specific identification. Then the course will give a more detailed review of the LIFO and retail methodologies. It will cover the topics of inventory obsolescence reserves and other issues related to inventory accounting, including a discussion of how COVID-19 has impacted these accounting considerations. This course will be the one-shop stop to get you up-to-speed on the accounting for this critical, revenue-producing asset.
More Dates
How SAS Nos. 134-145 Improve Risk-Based Audits
-
Online/Webcast
4.00 Credits
See more dates
Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in SAS Nos. 134-145. 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
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 Industry Accountant Key Performance Metrics
-
Online/Webcast
8.00 Credits
See more dates
This course will explore some of the most essential tools for measuring financial and operational success, as well as improving results. Appendices will be provided to give students hands-on applicable materials that can be utilized after completion of the course.
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