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 - Building Powerful Lookup & Reference Formulas
-
Online/Webcast
2.00 Credits
See more dates
Excel has over 500 functions that are built-in and ready to use. You just have to figure out which one to use and when. Integrating functions into each and every one of your spreadsheets not only improves efficiency, it also makes your task easier to execute. In this webinar, we will focus on Logical, Information and Lookup & Reference functions. In the Logical function section, you will learn to perform logical test using the IF function along with AND, OR and NOT. In the Information function section, you will learn various ERROR checking functions that can be combined with the Logical functions. In the Lookup & Reference section, you will learn to use the various LOOKUP functions and INDIRECT function. 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
The Role of Internal Control in the Risk-Based Audit
-
Online/Webcast
4.00 Credits
See more dates
This program addresses the role of client internal controls for balancing efficiency and effectiveness in a risk-based audit. Practical insights regarding an auditor's assessment of the risk of material misstatement when auditing financial statements of non-issuers will be explored, with particular emphasis on internal controls of small-to-medium clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. This event may be a rebroadcast of a live event and the instructor will be available for your questions during the event.Speaker - Chris Harper, CPA
More Dates
Audit 107: Auditing Cash - Applying Basic Audit Skills
-
Online/Webcast
2.00 Credits
See more dates
Auditing Cash - Applying Basic Skills to the Starting Point of Any Audit demonstrates how the approach to auditing different cash accounts may vary and how to strengthen inquiry which is an important audit procedure in this area. Cash tends to be one of the first areas assigned to new auditors, as there is typically little complexity and subjectivity involved. In addition, persuasive audit evidence from a third-party is generally available. However, research shows that around 80% of asset misappropriation relates to cash. Therefore, the audit of accounts and classes of disclosures related to cash and cash equivalents does tend to carry some level of risk of material misstatement. Note: This course is recommended as a part of a 16-hour audit skills curriculum for beginning auditors, while it is also appropriate for anyone who has responsibilities for auditing cash and cash equivalents. 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
Living to 100: The Challenges that Longevity Presents to Financial Planning for Clients
-
Online/Webcast
1.00 Credits
Clients are living longer. Not only does that present challenges to the work we do with them to make sure that their money lasts, but it also brings into play additional issues and challenges that we may not have had to tackle in the past. How do we plan for where clients will live (possibly as solo agers)? How do we deal with issues of diminished capacity? How do we plan for long term care and end of life issues? How do we have complicated family conversations? How do we make sure that our clients have their best long lives possible both financially and otherwise? Find out in this session where we will present tools you can use with clients to engage them in the planning process. Speaker - Sandra Adams
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
Surgent's Working Remotely: Best Practices, Challenges, and Opportunities
-
Online/Webcast
2.00 Credits
See more dates
Working from home presents both benefits and challenges for professionals. For employees, working from home provides opportunities to be more productive and gain time that would otherwise be spent commuting to and from the office. Employers who utilize remote work enjoy fewer fixed costs, more efficiency, and greater employee satisfaction. Without proper planning, professionals who work remotely may experience increased anxiety and disorganization. They may also jeopardize data privacy. However, when executed properly, working remotely can help organizations become more efficient and profitable, while at the same time improving employee morale. This course looks at how firms and companies have successfully implemented work from home programs and discusses mistakes that can be avoided through proper planning.
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.
More Dates
Tax Depreciation: Review and Update
-
Online/Webcast
2.00 Credits
See more dates
A discussion of recent law changes that impact capitalization, depreciation, and disposition of assets. 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
Excel - Advanced Financial and Statistical Calculations
-
Online/Webcast
2.00 Credits
See more dates
Depending on your version, Excel has over 500 functions already built in and ready to use. How many of those do you incorporate into your spreadsheets? After this course, you will learn some powerful functions that will take your calculating power to the next level. In this webinar, we will focus on Financial, Statistical and Math functions. In the Financial functions section, you will learn how to use the financial functions to build better amortization schedules. In the Statistical and Math functions sections, you will learn how to use various statistical functions to analyze your data. 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
Surgent's Basics of Employment Law for Non-HR Professionals
-
Online/Webcast
4.00 Credits
See more dates
Learn the basics of employment law and how they affect best practices to help control the interview and discover hidden talents of applicants.
More Dates
Audit 108: Auditing PP&E and Leases - Common Risks
-
Online/Webcast
2.00 Credits
See more dates
Auditing PP&E, Including Leases under Topic 842 - Digesting the Risks of Improper Treatment of Tangible Long-Lived Assets will address tips and techniques for auditing tangible long-lived assets for various assessed risk levels, with a special emphasis on lease accounting under Topic 842. Property, plant and equipment can range from a low-risk to a high-risk audit area, depending on the nature of transaction and events engaged in by the reporting entity. Construction, capitalized interest and complex leasing arrangements tend to result in higher risk of material misstatement. 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 Update on the SECURE 2.0 Act
-
Online/Webcast
2.00 Credits
See more dates
This course provides a comprehensive analysis of the SECURE 2.0 Act. The principal focus of the Act is to expand retirement coverage and increase retirement savings. As such, the Act has many important changes relating to IRAs and qualified plans. This legislation alters the landscape of retirement planning for taxpayers of all ages. Make sure you are up to date with the latest information available in order to effectively advise your clients on these important changes.
More Dates
Adobe Acrobat Tips for Working with PDF Files
-
Online/Webcast
2.00 Credits
See more dates
If you find yourself working with PDF files consistently throughout the day, this course will teach you how to review, annotate, format and organize PDF files more effectively and in less time. You will also learn how to use Adobe Acrobat for e-signatures to reduce document processing time significantly and enhance confidentiality. Adobe Acrobat has many features that you can take advantage of and this course will explain and demonstrate how to use 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 - John Higgins, CPA.CITP
More Dates
2024 PCAOB and SEC Update
-
Online/Webcast
2.00 Credits
See more dates
It is imperative for public companies to produce quality financial reporting. This course will share insights into the latest SEC and PCAOB areas of emphasis and concern. 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
Coaching Skills That Improve Performance
-
Online/Webcast
4.00 Credits
See more dates
Professional Athletes have multiple coaches - business people rarely utilize coaches. This course will focus on creating the coaching skills that are required to raise the performance of your employees. Coaching Model / Strategies Successful Communication Techniques Root Cause Analysis Performance Gap Analysis Personality impact on coaching model. Speaker - James Lindell
More Dates
Communicating Financial Data to Non-Financial Audiences
-
Online/Webcast
1.00 Credits
See more dates
Communicating financial data to those who aren't used to hearing it can be a challenge; however, there are some actions you can take to make the information easier to understand and relatable. This course provides you the necessary tools to communicate financial information to non-financial audiences. 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
K2's 2024 Harnessing ChatGPT - Unlocking Professional Efficiency
-
Online/Webcast
1.00 Credits
Are you ready to maximize the utility of ChatGPT? If so, participate in this session so you can learn the best ways to leverage this tool. Speaker - Thomas Stephens
Advanced Budgeting - Balance Sheet and Cash Flow Projections
-
Online/Webcast
1.00 Credits
See more dates
Unless you expect your organization to be stable in the short, medium and long term, you need to understand how to create long-term balance sheet and cash flow projections. Growing organizations must know whether they will have the resources to execute their business plan. Struggling organizations need to know if they will have the cash to survive. This session will increase your organization's ability to see its future and increase the confidence that your CEO, Board and bank have in you. 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
What's New in Excel
-
Online/Webcast
2.00 Credits
See more dates
Everyone knows that Excel is the most widely used spreadsheet application in the world today. However, because it is ever-changing, many users are unable to keep up with the latest features and capabilities of this ubiquitous application. In this session, we look at some of the most helpful new features and tools that have been added to both the Desktop version of Excel and the Web version. Content like this is valuable to anyone that regularly works with Excel - We hope you will attend! 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 AI Is Automating Internal Control
-
Online/Webcast
4.00 Credits
See more dates
The term "artificial intelligence" (AI) has become mainstream and while most have a layperson's understanding of AI, few know the depth and breadth of this technology's capability. AI is affecting just about everything in business and in people's personal lives. The operation of an internal control system is also changing because of this incredible advancement. This session explains what AI is and how it works and then goes into detail about how it can be applied to a system of internal control. The material speaks about changes occurring in today's world as well as what's coming in the not-too-distant future. 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