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.
Hold Your Horses! How Landmark Fraud May Have Been Avoided
-
Online/Webcast
2.00 Credits
See more dates
What can we learn from one of the largest municipal frauds in U.S. history? Rita Crundwell stole nearly $54 million from the citizens of Dixon, Illinois over the course of two decades. This course examines circumstances that allowed this landmark fraud to occur. We will explore internal control deficiencies and other circumstances that hindered prevention or timely detection of Rita's scheme. 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
The Future of Work - Winning Talent Strategies - Micro-Credential Series Part 3
-
Online/Webcast
1.20 Credits
This course aims to reveal many examples of companies, leaders and industries who are building new talent models. The world of work is less certain than ever before and this world requires experimentation. In this course you will learn about many experiments that organizations are deploying to build a new model that fits the pace of change the world is experiencing today. IN this course we will consider many new models and approaches and learn from them. In a world of work with few benchmarks - today organizations need to learn how to experiment and become the benchmark. Speaker - Steve Cadigan
Audit 304: Auditing Basic Investments - Common Risks
-
Online/Webcast
2.00 Credits
See more dates
Auditing Investments - Understanding Risks and Procedures for the Most Common Investments will provide an overview for evaluating the proper recognition, measurement and disclosure of the most common investments types. Many small- and mid-size entities hold less-complex investments, including mutual funds, 'plain vanilla' derivatives (such as interest rate swaps), and permanent life insurance policies. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for auditing common investments. 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
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
Emotional Intelligence: The Critical Factor in Success
-
Online/Webcast
2.00 Credits
See more dates
Emotional intelligence is an individual's capacity to understand both their own and other people's emotions, as well as how to react to these feelings in an appropriate manner. Research proves that Emotional Intelligence (EI) is a compelling predictor of personal, professional and social success. Every business leader can improve their Emotional Intelligence, including you. Many businesses utilize EI for promotions and hiring. This session will discuss the twelve keys to EI and proven tactics to help every aspiring leader "work smarter". 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
Excel - Using Charts for a Non-Financial Audience
-
Online/Webcast
2.00 Credits
See more dates
This webinar will show you how to use Excel's charting and formatting features to present financial data to a non-financial audience. As the saying goes, "A picture is worth a thousand words." People tend to better understand your point when visuals are used. We will explore the many capabilities of presenting your data without showing rows and rows or columns and columns of data. Help your audience visualize the meaning of the data, whether it is a trend, an exception, a distribution or a good vs. bad relationship. 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
Engagement Management with the Microsoft 365 Planner App
-
Online/Webcast
2.00 Credits
See more dates
Are you using Excel to keep track of progress and task completion for your engagements? Or, are you using a sophisticated engagement management app that takes too much time or requires too much information to keep your task completion progress up to date? Worst of all, are you relying primarily on email communications to keep track of your engagement task completion progress? If any of these scenarios apply to your practice, this course will show you a better way to manage engagements from simple 1040 tax preparation to comprehensive audits. The Microsoft 365 Planner app, which you are likely already paying for as part of your Microsoft 365 subscription, provides a comprehensive, yet simple solution for all of your client engagements and internal projects. John Higgins, a nationally recognized strategic accounting technology advisor will guide you through the process of how to deploy this app to effectively manage all your projects. This app is effective for sole practitioners and firms of all sizes. 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
Long-Term Care Insurance: Make the Switch
-
Online/Webcast
1.00 Credits
See more dates
How to pay for the cost of long-term care remains a primary concern for most clients over the age of 50. Explore clients' motivations, misconceptions and objections to purchasing long-term care insurance, and a look at the latest long-term care solutions, including hybrids. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Katana Abbott, CFP, CSA
More Dates
Surgent's Guide and Update to Compilations, Reviews, and Preparations
-
Online/Webcast
4.00 Credits
See more dates
Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-25 by the ARSC. The course will also review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARSs requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform compilation, preparation, and review engagements.
More Dates
Office 365 Teams App - Optimizing Your Setup & Configuration
-
Online/Webcast
4.00 Credits
See more dates
If you are familiar with the Office 365 Teams app, you know it is an extremely powerful tool to transform the way you communicate, collaborate and share knowledge. What you may not know is how to configure Teams to optimize your ROI and how effectively your team members use it. This course takes you on a tour of the important setup and configuration settings you need to be familiar with to ensure the best Teams experience for your organization. Whether you are already using Teams, in the process of deploying it, or are contemplating whether or not to bring it into your organization, this course will prove to be invaluable. The information shared in this course is sure to help you avoid costly mistakes in your Teams app deployment. 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 H. Higgins, CPA.CITP
More Dates
Financial & Tax Accounting for S Corporations & Partnerships
-
Online/Webcast
8.00 Credits
See more dates
This program compares and contrasts the financial and tax accounting differences of partnerships, LLCs, and S corporations, as well as discuss the tax accounting for these entities. 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 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.
More Dates
Surgent's Understanding Non-Compete Agreements
-
Online/Webcast
2.00 Credits
See more dates
More and more employers rely on non-compete agreements to protect company assets. Although state laws vary, non-competes are often used to protect the creation and development of corporate goodwill, customer relationships and specialized training, among others. Today, employees are more likely to be asked to sign non-compete agreements as a condition to employment. Non-compete agreements are also a common component of a business sale agreement. This program surveys non-compete agreements from all angles. Whether you advise individual clients or work for an employer, the presentation provides an understanding of common issues that arise in the negotiation and enforcement of non-competes.
More Dates
S Corporation (Form 1120S) - Formation to Liquidation
-
Online/Webcast
8.00 Credits
See more dates
With the increasing complexity and ever-changing nature of tax laws and issues, today’s accountant needs a S corporation course focusing on the birth, growth, maturity, and death of a closely held S corporation. This case driven course will deal with S corporation income tax laws from formation to liquidation. **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 - J. Patrick Garverick
More Dates
Excel - Create KPI Dashboards for Maximum Impact
-
Online/Webcast
2.00 Credits
See more dates
Most accountants use Excel to help them make decisions about their data. However, as the amount of data grows, it becomes difficult to make strategic decisions based on rows and rows and columns and columns of data. In this course, you will learn how to build robust dashboards for analyzing key metrics in Excel. We will begin with some dashboard design guidelines, such as understanding your audience and identifying necessary metrics. Then, we will work through importing data, setting up calculated fields and columns, and creating key performance indicators (KPIs) for the dashboards. You will learn how you can add charts and eye-catching visuals with Power View, in order to make your dashboards easily understood. 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
Audit 305: Strengthening Substantive Analytic Procedures
-
Online/Webcast
2.00 Credits
See more dates
Substantive Analytic Procedures - Strengthening Evidence to Satisfy Audit Objectives will provide the tips and best practice techniques for strengthening substantive analytic procedures in order to reduce over-reliance on tests of details. One of the ways to perform a more effective and efficient audit is to maximize the use of substantive analytic procedures in the detailed audit plan. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for analytical procedures. 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
The Dark Web & Cybersecurity for Tax and Accounting Pros
-
Online/Webcast
2.00 Credits
See more dates
This course provides a concise overview of the Dark Web, a part of the internet that isn't indexed by search engines, and is often associated with anonymous transactions and nefarious activities. Discover the leading threats and risks that the Dark Web poses to accounting firms. Explore how practitioners can effectively mitigate the risk of data breaches, ransomware attacks, financial fraud and other risks connected to the Dark Web. You'll walk away with a foundational understanding of leading cybersecurity strategies that can help you maintain client trust and protect your firm's sensitive data in this complex and ever-changing threat landscape. 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
2024 Fiduciary Accounting for Estates and Trusts
-
Online/Webcast
4.00 Credits
See more dates
Financial accounting for trusts and estates is one of the least understood branches of accounting. It is not particularly concerned with recording income and expenses but is obsessed with determining whether receipts and expenditures are assigned to income or principal/corpus. This course will dive into this tricky area and provide a reporting guide for fiduciary accounting. Speaker - Doug Van Der Aa, CPA, JD
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
Budgeting: Presenting and Communicating your Numbers
-
Online/Webcast
2.00 Credits
The budgeting process can be a time consuming and frustrating process for accountants. The constraints and pressures can lead to poor decisions in both the technical and human components. This session will cover: Budgeting: Presenting and Communicating your Numbers • Now that the budget is complete, how we communicate our plan is critical. this session reveals some key guidelines in budget presentation and will identify key problems in how people often communicate financial plans. Speaker - Bob Mims