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.
Streamlined Excel Reporting Series Session 4: External Data and PivotCharts
-
Online/Webcast
2.00 Credits
See more dates
Extracting data for richer insights You'll gain meaningful analysis techniques while working alongside an industry expert and knowledgeable instructor. This session begins with the GETPIVOTDATA function to enable report customization. It's a great starting point before moving on to more advanced techniques. Power Query introduction With its user-friendly interface, Power Query empowers Excel users to take the next step by enabling seamless data import and transformation. With Power Query, you will explore features, including: Getting and transforming data Loading data Managing columns Data source settings Layouts and parameters Visualizing with PivotCharts A well-designed chart can effectively illustrate data trends and comparisons. You'll learn how to create and customize PivotCharts to elevate your reports and make the data more accessible to others. *Session 4 is one of four individual sessions. Each session builds on the previous one, so consider watching all the sessions [Streamlined Excel Reporting Series](https://www.aicpa-cima.com/cpe-learning/webcast/streamlined-excel-reporting-series) to tackle real-world issues and create powerful workbooks.*
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
Surgent's 2025 Tax Update for Client Advisory Services
-
Online/Webcast
4.00 Credits
See more dates
Client advisory services (CAS) professionals are becoming a more integral part of the operations of any CPA firm. As such, they must stay on top of changing tax law. In this course, we will explore tax changes in areas CAS professionals are involved with - information reporting, payroll tax issues, and tax credit and deduction documentation. We will also discuss relevant changes to individual and business tax returns so that CAS professionals can better assist clients with tax needs in the upcoming year.Speaker - Dave Peters, CPA, CFP, CLU, CPCU, MST, MBA
More Dates
Surgent's Controller/CFO Update: Hot Topics Facing Today's Financial Professional
-
Online/Webcast
4.00 Credits
See more dates
In today's rapidly changing world, finance professionals are required to wear many hats and are often the keys to the success of the organization. On one hand, they need to be abreast of the latest proven financial skills for making the best decisions, and on the other hand they need the best skills to motivate, manage, and lead people. Being pigeon-holed into one area or another is neither good for career building nor good for the organization. We'll cover the latest issues that all CFOs and controllers need to know about and provide how-to guidance to allow for immediate use in their organizations.Speaker - Art Pulis, MBA
More Dates
Avoiding Legal Liability and Peer Review Deficiencies in Nonaudit Services, Including Bookkeeping and Preparing Financial Statements
-
Online/Webcast
8.00 Credits
See more dates
The majority of peer review deficiencies and malpractice claims result from nonaudit services. This course will provide best practices for avoiding legal liability and quality control concerns. Speaker - Jennifer Louis
More Dates
Complete Guide to Analyze Data with Excel PivotTables
-
Online/Webcast
4.00 Credits
See more dates
Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. 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
Walter Haig's Business Financial Health Checkup
-
Online/Webcast
8.00 Credits
See more dates
This course fills an important need for both financial managers and accountants in the practice of public accounting by offering the tools to help ensure the future success of a business. Practical guidance for the effective use of benchmarking and analytical procedure is also provided. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Walter J. Haig
More Dates
CPA to CFO
-
Online/Webcast
1.00 Credits
See more dates
This Masterclass is a one-hour training exclusively for CPAs and accountants. Rely less on tax season and use your expertise to help business owners have a better future! Designed for CPAs, but also applicable to enrolled agents and accountants, this webinar covers the steps necessary to effectively transform a tax or accounting practice into an advisory service. We explore what it means to be a CFO/advisor to small-to-medium sizes businesses and what qualifications are necessary to offer such a service. We will also cover how to find and convert leads and how to price and package services, including combining advisory services with the firm's current offerings. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Lacey Harnar
More Dates
Synchronize Your Files to the Cloud with SharePoint -Updated
-
Online/Webcast
2.00 Credits
See more dates
One of the most cost effective methods for storing your files safely and economically in the cloud is with Microsoft 365 OneDrive and SharePoint apps. If you use either or both of these cloud storage apps, this course is a "must take." There are often times when you want or need cloud based files to be stored on your local laptop or desktop PC. With the OneDrive Sync app, you can have the best of both worlds. You can have copies of a file stored locally and in the cloud simultaneously. The Synch app will update both copies of the file in real time for any changes that are made in the local or cloud copy of the file. A classic example is if you have a QuickBooks Desktop data file that you need to store locally to work with the files in QuickBooks. However, you also want the file stored in the cloud for anytime, anywhere access and enhanced security. The Sync app facilitates this scenario effortlessly. Nationally recognized accounting technology advisor and thought leader, John Higgins, will take you through the step-by-step process of setting up and using the Sync app. 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
Making Culture A Competitive Advantage
-
Online/Webcast
1.00 Credits
See more dates
In the world of work today, nothing is more critical than Culture. If people are your competitive advantage, then culture is the best way to help your people realize a great destination. While many leaders and companies talk a lot about culture, few take the time to really plan, build, and invest in a great culture. Today, the world of work could not be more challenging, and the changes that we are seeing in the workforce, such as the rise of remote workers and increasing turnover, are adding to the complexity. Now more than ever, Culture must become your competitive advantage. In this course, you will learn about the key macro changes in the workforce and what some leading companies and leaders are doing to create amazing cultures and high-performing organizations. From LinkedIn to Patagonia to Eventbrite, you will learn from some top organizations ow they have successfully leveraged culture. You will learn what Culture is and can be, and you will learn what culture is not. As you set sail in 2024 and beyond as a leader, you will benefit from this class and learn how to make culture your competitive advantage. Your teacher for the class is Steve Cadigan, whom many credit for being the architect of LinkedIn's world-class and groundbreaking culture. Speaker - Steve Cadigan
More Dates
Accounting and Disclosure Issues After a Natural Disaster
-
Online/Webcast
2.00 Credits
See more dates
The repercussions from a natural disaster can be devastating. Properly accounting and reporting for the impact of those disasters can be confusing. This course will focus on some of the most FAQ related to the proper treatment of accounting for disasters in GAAP basis financial statements. 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
Surgent's Excel Budgeting Ideas
-
Online/Webcast
2.00 Credits
See more dates
Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.Speaker - Jeff Lenning
More Dates
Surgent's Food, Beverage, and Entertainment Expensing
-
Online/Webcast
2.00 Credits
See more dates
The IRS has issued final regulations regarding the Tax Cuts and Jobs Act's (TCJA) elimination of the deduction for expenditures related to entertainment, amusement, or recreational activities and provided guidance to determine whether an activity is considered to be entertainment. The final regulations also address the 50% limitation on the deduction of food and beverage expenses and when the 50% limitation does not apply. Due to the pandemic, Congress changed the rules for 2021 and 2022 to allow for 100% deductibility for meals. These temporary rules no longer applied starting in 2023. To effectively advise clients, it is imperative for tax practitioners to understand these rules and be updated on the latest IRS guidance related to meals and entertainment. Speaker - Mike Tucker, Ph.D., LL.M., J.D., CPA
More Dates
SAS No. 122, AU 315, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement
-
Online/Webcast
3.00 Credits
See more dates
If you do not understand the entity that you are auditing, you won’t know what type of transactions they should be entering into. As a result, you won’t recognize those transactions they should not be there. In other words, you will be performing the audit without having any idea of what you should be looking at. This statement requires that the auditor document their understanding of the entity and its environment that it operates in as well as assessing the risks of material misstatement. Prior to this statement, auditors often assessed risk at maximum and did not evaluate internal controls. A big change made by this statement is that, while it allowed the auditor to continue to assess risk at maximum, they now must first evaluate internal controls in order to have a basis for making such an assumption. As a result, auditors are now required to document their evaluation of internal controls on every financial statement audit. This presentation is an overview of the many procedures auditors are now required to perform and document on every audit related to their understanding of the entity and its environment and the basis for assessing the risk of material misstatement. Speaker - Dennis Dycus
More Dates
2025 Annual Update for Not-for-Profit Accountants & Auditors
-
Online/Webcast
8.00 Credits
See more dates
The Not-for-Profit Advisory Committee (NAC) has been meeting with FASB to discuss the impact of various standards on the nonprofit community. We'll look at the work of the NAC and the impact they've had. We'll then transition to the Accounting Standards Updates (ASUs) issued by the FASB that impact nonprofit entities. We'll review year 2 considerations of the leases standard. We'll also review common nonprofit deficiencies identified in peer review. Once we've wrapped up the accounting update, the course shifts to the audit side of the house with a look at what's going on at the AICPA. We'll review the impact of the changes to group audits as the changes coming down the pike for quality management. This course will keep auditors up to date on the work of the ASB. 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
Defining Where and Why Internal Controls are Needed
-
Online/Webcast
2.00 Credits
See more dates
Most organizations have many of the basic controls required to operate in place. However, a notable percentage of these companies do not have important measures that can help enhance security, productivity, and the quality of information available for decision making. In this session, we work to identify areas where important internal control measures are needed. We spend time explaining why these controls should be created, and show in detail some specific controls that would be beneficial if utilized. Those wishing to strengthen an internal control system should strongly 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
Current Nonprofit Fraud Trends
-
Online/Webcast
4.00 Credits
See more dates
Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. 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 for the Gig Economy
-
Online/Webcast
2.00 Credits
See more dates
Freelance work and other non-permanent employment arrangements are becoming increasingly popular ways for people to earn a living. Although these non-traditional activities offer novel, flexible ways to earn income from diverse sources, they also introduce nuanced recordkeeping, reporting, and attestation issues. We investigate characteristics of the gig economy, employee-versus-contractor considerations, bookkeeping, regulatory compliance, and external reporting considerations. We also explore best practices for CPAs who fulfill the role of trusted advisor for gig economy clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Dr. Christopher J. Harper, CPA, MBA
More Dates
Streamlined Excel Reporting Series Session 3: PivotTables Displays and Alternatives
-
Online/Webcast
2.00 Credits
See more dates
Essential techniques for displaying data in alternative ways You'll work alongside an expert instructor as you practice using PivotTables and exploring creative alternatives for insightful data presentation. You'll learn techniques for effective data presentation, including: Filtering and sorting data Cleaning and organizing data through text manipulation Using dynamic features to summarize and analyze large datasets Using slicers and filters for visual filtering Highlighting key Excel features through guided practice You'll walk through realistic scenarios that show alternative functions for greater data management, such as: GROUPBY PIVOTB PERCENTOF In addition, various text functions such as TEXTJOIN and TEXTSPLIT will be explained, highlighting how to concatenate and split text strings efficiently. *Session 3 is one of four individual sessions. Each session builds on the previous one, so consider watching [Streamlined Excel Reporting Series Session 4: External Data and PivotCharts](https://www.aicpa-cima.com/cpe-learning/webcast/streamlined-excel-reporting-series-session-4-external-data-and-pivotcharts) to tackle real-world issues and create powerful workbooks.*
More Dates
Surgent's Excel Shortcuts for Accountants
-
Online/Webcast
2.00 Credits
See more dates
This webinar presents a variety of time-saving ideas, shortcuts, and tips that are sure to boost personal productivity. We discuss better summing, address one of the biggest pitfalls that Excel users have faced over the past 25 years, present the most important keyboard shortcuts, demonstrate a better alternative to hiding rows or columns, illustrate how to quickly navigate to other workbooks and files, and demonstrate using Excel with styles.Speaker - Jeff Lenning