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.
A Practical Guide to Trusts
-
Online/Webcast
8.00 Credits
See more dates
This course provides in-depth information to enable the practitioner to make a well-informed decision as to whether a trust is the appropriate vehicle for a client’s financial, estate, and/or asset protection plan, and, if so, how the trust can best be implemented and operated. Participants will learn about the many different types of trusts that can be harnessed to save clients income, estate, generation-skipping, and other taxes, at both the federal and state level. Speaker - Arthur Werner
More Dates
Power BI - Advanced Data Analytics with Power Pivot
-
Online/Webcast
8.00 Credits
See more dates
This fast-paced course focuses on using Excel Power Pivot features to enhance data analysis. One of the strengths of Power Pivot is the formula language DAX (Data Analysis eXpressions). We will spend considerable time using the power of DAX to create meaningful calculations that add new dimensions to our data. We will also review the use of a date or calendar table that allows us to perform date analysis that was never possible before. This will allow us to use the new time-intelligent functions to perform complex calculations on our data such as: month-to-date, quarter-to-date, year-to-date, last year same period, last year-to-date, etc. We will also demonstrate the hottest tips and tricks that will take your data analysis to the next level. Although our focus will be on using Power Pivot, we will review some of the other Power BI Tools including: Power Query (Get & Transform), Power BI Desktop and Power BI Services (PowerBI.com). NOTE: If you want to apply the concepts presented, you will need Excel 2013, 2016 or 2019/Office 365 AND the Power Pivot add-in pre-installed. To see our full prerequisite recommendations, see PROGRAM CONTENT section below. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, 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
Forgotten Managerial Accounting Tools for CPAs
-
Online/Webcast
2.00 Credits
See more dates
This session revisits managerial accounting techniques that you may not have considered for many years, even though they could be invaluable for CPAs in both business and public accounting. You will appreciate a fresh perspective of concepts you may not have considered since your college days. We will illustrate concepts with practical examples that you can immediately bring back to the office! 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
Analyzing Financial Statements
-
Online/Webcast
2.00 Credits
See more dates
This course provides tools and insights into financial statement analysis - both quantitative and qualitative. We'll look not only at the three main financial statements but also dive into the MD&A and footnotes. We'll also discuss the affect of industry nuances on comparability of different analysis tools. 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
Surgent's Employee Stock Options: What Financial Professionals Should Know When Advising Their Clients
-
Online/Webcast
2.00 Credits
See more dates
Companies often offer stock options as an additional form of compensation to attract and retain the best talent. Used appropriately, stock options can generate significant wealth. Yet many employees are unfamiliar with how stock options work and why options serve as a valuable opportunity for employees to establish and grow their wealth. Unfortunately, employees who receive stock options are often unaware of their inherent risks. Research has shown that over 75% of employees have never exercised their stock options. Almost half of these individuals (48%), say they held off on selling their options due to fear of making a mistake. This course provides accounting and financial professionals with a broad overview of employee stock options. The program is designed to help participants better understand the fundamentals behind these investments and in turn, better advise their clients.
More Dates
Surgent's Features and Benefits of SEP IRAs and SIMPLE IRAs
-
Online/Webcast
2.00 Credits
See more dates
A challenge for many small business owners is choosing the `right' type of retirement plan for their businesses. Many hesitate to make a choice because they are intimidated by the governing rules. In those cases, an IRA-based retirement plan is an easy, effective, and efficient way to start a retirement plan. These IRA-based plans - SEP IRAs and SIMPLE IRAs - have low maintenance costs and are easy to communicate to employees. In some cases, employer contributions are discretionary, providing the business owners with the choice of whether to fund every year.
More Dates
Surgent's Going Out on Your Own: Entity Types and Accounting Methods
-
Online/Webcast
2.00 Credits
See more dates
Starting a business is tough! There are lots of decisions to be made and things to think about. You may feel like you have a great idea. You have done your marketing research, developed a prototype, and even looked at locations for your new office. Then it dawns on you.. What type of entity do I need to be? Is there really an advantage to choosing one entity type over the other? In this class, we will dig into the differences between entity types - from taxes to liability. We will also look at the advantages and disadvantages of different methods of accounting. Whether you are a small business owner looking to start something new or a practitioner looking to expand your client advisory services, this course is the one for you!
More Dates
Steps to Stop External Fraud
-
Online/Webcast
2.00 Credits
See more dates
Until recently, a percentage of organizations discounted the risk related to external fraud attempts. Most were only concerned with protecting physical assets such as inventory or fixed assets. However, because of the many highly publicized corporate hacking events, such as the ones that affected the Colonial Pipeline and JBS Meats, more attention is being paid to external fraud risk of all types. In this session, we look at what is included in a definition of external fraud and then delve into specific control issues that can give rise to increased risk. We then discuss measures that organizations can employ to help reduce exposure to external attacks. 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
Public Speaking and Confident Communication in Business
-
Online/Webcast
1.00 Credits
See more dates
No matter what role you play in your professional life, being able to command an audience--whether of one or of thousands--is an important skill. Public speaking, no matter how you slice it, is a practice that is worthy of attention. This workshop teaches you approachable strategies to improve your public speaking and presentation skills, recognizing that everyone comes with different comfort levels and experiences. There is no one-size-fits-all speaking style, and trying to force yourself into a specific presentation persona can be more harmful than helpful. Learn actionable tips to help you be more confident next time you need to take the proverbial (or literal) stage. Speaker - Jill Schiefelbein
More Dates
Monthly Federal Tax Updates - February 2025
-
Online/Webcast
2.00 Credits
See more dates
Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. 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
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Online/Webcast
2.00 Credits
See more dates
How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.
More Dates
What's Changing in A&A for Governmental Entities (2024)
-
Online/Webcast
4.00 Credits
See more dates
We kick off this course with a look at the GASB standards that are effective this year including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We will then switch to the audit side of the house to examine the impact of the 2024 Compliance Supplement on Single Audits and the changes to the Uniform Guidance. We close with a look at common deficiencies found in Single Audits. 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
Audit 201: Fraud Risk - Minimum Audit Requirements
-
Online/Webcast
2.00 Credits
See more dates
Fraud Risk - Complying with Minimum Audit Requirements will highlight the audit procedures most effective in identifying, assessing and responding to fraud risk. The financial statement auditor's overall responsibility is to obtain sufficient appropriate audit evidence to provide reasonable assurance as to whether the financial statements are materially misstated due to fraud or error. The difficulty is that there are inherent limitations related to detecting fraud due to deliberate schemes to conceal the intent to deceive, such as collusion. 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
Accounting & Auditing for Cryptocurrency
-
Online/Webcast
1.00 Credits
See more dates
Bitcoin and crypto have been in the news recently for a variety of reasons. This course will cover the basics of accounting and auditing for cryptocurrency including recent standard setting by the FASB as well as a look at the AICPA's Accounting for and Auditing of Digital Assets practice aid. Speaker - Jaclyn Veno
More Dates
Becoming a Fraud Investigator
-
Online/Webcast
2.00 Credits
See more dates
The course helps the forensic accountant prepare to perform a fraud investigation. We discuss occupational fraud schemes and their characteristics, and how to spot a fraud in progress. You will learn the skills a fraud investigator needs for successful investigations, as well as how to plan and prepare for a fraud investigation. This is the most practical fraud investigation course you will ever take. Rather than learning only the theory of fraud, you will learn how a forensic accountant actually investigates fraud from the beginning to the end. We focus on forensic accounting techniques used in the field to prove what happened, who was involved, how much money was stolen, and where the money went. Becoming a Fraud investigator is Part 1 of a series of four courses on fraud investigations. Each course is a stand-alone class that may be taken individually. For comprehensive instruction on completing a fraud investigation from start to finish, take all four. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Tracy L. Coenen, CPA, CFF
More Dates
Sustainability: Doing Well by Doing Good
-
Online/Webcast
2.00 Credits
See more dates
Looking for an idea that will help recruit and retain employees, engage customers, and invite investors? Sustainability is the solution! Sustainability is no longer just a "nice thing to do," it is both a business and moral imperative. Incorporating sustainable strategies into your day-to-day operations creates a competitive advantage, enhances your brand, and benefits the bottom line. On the business side, according to Harvard University, companies with strong sustainability initiatives have 4 times the sales growth, 8 times the employee engagement, and a 47% greater increase in stock value than their non-sustainable competitors. On the moral side, your customers and employees will no longer support an organization that does not address environmental and social issues. This session will explain the 6 benefits of sustainability and 6 steps to building a sustainable business. Learn how to make sustainability a competitive advantage to attract and retain loyal customers and high-performing employees. 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 Elder, CSP, CPA, CMA, CIA, CFF, CGMA, MS
More Dates
The Future of Communication: How AI and Synthetic Media Can Transform Your Business
-
Online/Webcast
1.20 Credits
See more dates
Did you know that AI can now write your marketing copy? Create videos with your digital likeness? Provide subjective advice to your clients? Produce training for your employees? Even if you're on the fence about trusting artificial intelligence tools, knowing about these technologies, especially when combined with forms of synthetic media (think deep fakes, but not nefarious), is important for any business leader. Imagine being able to have your likeness communicate in over 40 languages. Think about how amazing it would be to create customized content for every situation without building each piece from scratch. Marvel at how that *perfect* image can manifest from typing just a few keywords. In this session you'll learn about the evolution of communication technologies, how artificial intelligence has expanded our range of connective possibilities, and what possibilities exist for leveraging these channels of communication in your business. Speaker - Jill Schiefelbein
More Dates
Project Management: Getting the Best Out of Your Team
-
Online/Webcast
2.00 Credits
See more dates
With capacity challenges on the mind of many tax and accounting leaders, finding ways for their teams to work more efficiently is crucial. They need their teams to not be busy, but deliver value, and continue to develop their skills and knowledge. Project Management techniques help uncover inefficiencies and gaps in current processes, as well as, manage the planning and forecasting needed to drive necessary changes for future success. In this session, learn when to incorporate project management best practices that can help you get the best out of your team.Speaker - Samantha Mansfield/Jessica Hartsfield
More Dates
Surgent's Guide to Understanding the At-Risk Basis Rules and Forms 6198 and 7203
-
Online/Webcast
2.00 Credits
See more dates
Many tax clients with losses from their S corporations, partnerships, and multiple-member LLCs treated as partnerships will want to use these losses to offset their other income from other sources. This program explains when, why, and how the at-risk rules apply to allow or to prevent the owner of a pass-through entity from taking a loss from a pass-through entity and using it to offset other income. This program is extremely helpful for anyone with pass-through entity clients.
More Dates
The 10 Must Know Excel Features
-
Online/Webcast
2.00 Credits
See more dates
Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel's most impactful features. Whether you're streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. 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