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.
Common Findings in Single Audits
-
Online/Webcast
1.00 Credits
See more dates
This CPE course provides an examination of the recent reports from a selection of Single Audit results. The instructor will go over the most common deficiencies found in Yellow Book and Single Audits and common peer review findings and OIG investigations. This course will also provide examples of common controls, best practices, and mitigation techniques. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Adelina Burke, CPA
More Dates
Project Management: Making Ideas a Reality
-
Online/Webcast
2.00 Credits
See more dates
A project doesn't just happen, it takes a dedicated person to help a team create something from nothing. The best project managers incorporate the art of people management and science of execution to guide an initiative from an idea to reality. Not everyone can hire a project manager, so the great news is these skills and techniques can be learned. This class will show how a project manager breaks down a concept and applies techniques needed to effectively lead a team through the visioning, scoping, testing and rolling out of an initiative. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Samantha Mansfield/Jessica Hartsfield
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
Introduction to Yellow Book: 8-Credit Boot Camp
-
Online/Webcast
8.00 Credits
See more dates
This course is designed for accountants in public practice and industry who focus on nonprofit and governmental entities. We will cover the basics needed to understand what makes nonprofit and governmental accounting & auditing unique. The course starts with the key financial reporting differences for governmental and nonprofit entities and then switches focus to review the fundamentals of Yellow Book and Uniform Guidance audits. This foundational course is perfect for those getting started in the nonprofit and governmental arena and those looking for a refresher. 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
Surgent's Audits of 401(k) Plans: New Developments and Critical Issues
-
Online/Webcast
8.00 Credits
See more dates
One of the most favored employee benefit plans, the 401(k) plan, provides unique challenges for auditors. Also, as many 401(k) plan administrators opt for ERISA Section 103(a)(3)(C) audits, audits of 401(k) plans will be significantly impacted by the now-effective SAS 136, the AICPA's new employee benefit plan auditing standard. Through this course, auditors will obtain an understanding of the rules and regulations unique to employee benefit plans and obtain practical guidance on applying them. Auditors will enhance their knowledge of the performance and reporting requirements of SAS 136 through real-world examples, best practices, and efficient audit techniques that can be utilized in various audit engagements. Make sure your audits don't trigger a DOL inspection by conforming to all applicable rules and regulations.
More Dates
The Choice of Entity Decision: What is Best for Your Client
-
Online/Webcast
2.00 Credits
See more dates
This course will identify the factors in the choice of entity decision while considering the impact of various recent tax act provisions. 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 - Two Must Know Features: Defined Names & Tables
-
Online/Webcast
2.00 Credits
See more dates
Excel has over 500 functions and among those, Defined Names is one of the top choices in creating formulas that make your spreadsheets work better for you. After understanding what they are and how to properly create Defined Names, you will wonder how you managed without them for so long. This course is designed to build the foundation to becoming an Excel Formula Expert. Our focus will be on design techniques that should be used when creating formulas. You will learn how to use Defined Names and Excel Tables as an important and fundamental part of EVERY spreadsheet. You will learn techniques that most advanced users don't implement in their spreadsheets but should. After completing this course, you will be well on your way to becoming an Excel Formula Expert. 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
Get started with Power BI
-
Online/Webcast
2.00 Credits
See more dates
Embark on a journey to master Power BI, a powerful tool for data analysis and business intelligence, in our comprehensive course, "Get Started with Power BI." This course is meticulously designed for professionals who seek to understand the full spectrum of Power BI capabilities, including its integration with Excel's Power BI features like Power Pivot and Power Query, and its comparison with standalone Power BI tools such as Power BI Desktop, Power BI Service, and Power BI Report Server. In the first part of the course, participants will be introduced to the fundamentals of Power BI. This includes an overview of Power BI's interface, key features, and its seamless integration with Excel. The course will cover Excel's Power BI tools - Power Pivot, for advanced data modeling, and Power Query, for efficient data transformation and preparation. This segment is essential for understanding how Power BI extends and enhances the data processing and analytical capabilities of Excel. The second section of the course delves into the standalone Power BI tools. Here, participants will explore Power BI Desktop for creating complex data models and sophisticated reports, Power BI Service for cloud-based collaboration and sharing, and Power BI Report Server for on-premises report deployment. This part of the course will focus on the unique features and strengths of these standalone tools, providing attendees with the skills to leverage Power BI in a variety of business contexts. 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
More Money: Strategic Ways to Improve Cash Flow
-
Online/Webcast
4.00 Credits
See more dates
Cash flow management is often the most important task of any CFO or financial leader. Regardless of whether one works in start-ups or established companies, non-profit or for-profit entities, cash flow makes our organizations run. Have you ever wondered whether you are optimizing your company's cash flow? In this course, we will explore how to improve your company's cash flow using analysis and financial theories in the context of real-world situations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - David Peters
More Dates
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
How To Use Microsoft 365 Forms to Create Online Surveys
-
Online/Webcast
1.00 Credits
See more dates
When you need to create a simple survey or form to capture data online, the Microsoft 365 Forms app can be just the right solution. You can use it for simple forms such as a client information form or client service evaluation form. You can create more sophisticated forms, such as a client tax organizer. All responses can remain confidential and can be viewed in Excel format for further analysis or to prepare the form data for import into another application. This course will take you through the step-by-step process for creating, distributing, compiling and analyzing digital forms and surveys. 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
Audit 103: Adapting to the Engagement - Complying with SSARS
-
Online/Webcast
2.00 Credits
See more dates
Adapting to the Engagement - Differentiating the Requirements of Preparations, Compilations, Reviews, and Audits is a critical foundational course. A CPA may perform various attest services under relevant professional standards, including compilations, reviews and audits. Reviews and audits are also considered assurance services, providing either limited or reasonable assurance that financial statements are free of material misstatement. In addition, the CPA may perform non-attest services, such as bookkeeping or preparation of financial statements. CPAs must fully understand the professional responsibilities related to each of these varying levels of services, in order to effectively and efficiently satisfy engagement objectives. Note: This course is recommended as a part of a 16-hour audit skills curriculum for beginning auditors and attest providers, while it is also appropriate for anyone who has assurance responsibilities under the SSARS. 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 Controllership Skills Update - Budgeting, Forecasting, and Big Data
-
Online/Webcast
2.00 Credits
See more dates
Budgets are the vehicle for allocating resources, measuring activities, and identifying needed changes and improvements. An organization's strategy is the primary driver of costs. To be effective, the budget must be linked to strategy and long-term plans. Numerous organizations have achieved a series of short-term targets (budgets) but failed longer term, demonstrating the lack of this necessary linkage. Forecasting, a critical part of any successful budgeting process, can be flawed by technical errors, organizational structure, or emotional forces. The establishment of a system to collect, process, and analyze big data can provide significant insights into the budgeting and forecasting process. An efficient system of incorporating big data and analytics into normal activities will improve management's decision-making. This brief program offers specific actions to improve your forecasting and budgeting activities. In addition, more advanced techniques are identified for the participant's further review, which can be applied throughout an organization. Good budgets effectively allocate resources, provide information for decision-making and serve as an early warning system for unforeseen events. A poor budgeting process fosters a false sense of security, provides inappropriate or inaccurate data, and reinforces the status quo. Budgets are about the organization's story, not just the raw numbers!
More Dates
Forensic Accounting: When The Office Is A Crime Scene
-
Online/Webcast
4.00 Credits
See more dates
Embezzlement happens often to many small businesses. Unfortunately, the lack of internal controls allow the embezzlement to remain undetected for years. But when it is discovered, the small business owner will most likely contact their CPA for advice. What should you do when your client contacts you about their employee embezzling money from their business? What options should you present to your client? How can your client protect themselves, while investigating the embezzlement? What steps need to be taken about preserving any documents, emails, texts, or phone calls? This course teaches how to engage the client, properly identify the evidence needed to prove the crime, how to write the report for civil and criminal trial, and best practices in preserving electronic and paper evidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Robert Nordlander, CPA, CFE
More Dates
Excel - Working with Text, Date & Time Functions & Formulas
-
Online/Webcast
2.00 Credits
See more dates
Want to automatically update the date and time on your spreadsheet? Or pick text strings from other cells to automatically copy and update to a different cell? You will learn how to incorporate text, date and time functions in your spreadsheet that will make data entry a breeze. In this webinar, we will focus on Text functions and Date & Time functions. In the Text function section, you will learn how to use the various Text functions to join and separate text entries as well as formatting the results. In the Date & Time function section, you will learn how to perform various date and time calculations. 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 Accountability: Stop the Blame Game
-
Online/Webcast
4.00 Credits
See more dates
Good managers know how to delegate, but it can be a challenge to manage employees who are more interested in passing the buck than being responsible. Lack of ownership and responsibility can bog down processes and shut down projects. This workshop will help you create a game plan for building a culture of accountability with your team.
More Dates
Audit 104: Audit Documentation - Workpapers To Pass Review
-
Online/Webcast
2.00 Credits
See more dates
Audit Documentation - Creating Workpapers That Pass Review is an important foundational course. Proper documentation is essential to a high-quality audit and other assurance services, as auditors are required to prepare and maintain documentation to demonstrate that sufficient and appropriate audit evidence was obtained to support the auditor's opinion. It is critical for workpapers to provide a clear understanding of the nature, timing and extent of procedures applied, the results of those procedures, source of evidence obtained, and conclusions reached. Both audit effectiveness and efficiency are directly impacted by the nature and extent of audit documentation. Note: This course is a part of a recommended 16-hour audit skills curriculum for beginning staff. 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 Artificial Intelligence for Accounting and Finance Professionals
-
Online/Webcast
2.00 Credits
See more dates
Accounting and finance professionals have used different forms of automation over the years to improve the efficiency and accuracy of their work. So far, technology has not been able to replace the knowledge, experience, and decision-making of seasoned professionals. Times are rapidly changing. Today, systems easily exceed humans in accuracy and consistency. Artificial intelligence (AI) brings opportunities for accountants and finance professionals in the short term to improve efficiency and accuracy, while providing more value for businesses and customers alike. In the long term, AI will offer profound changes to how professionals work and process data. This course is designed to review where we are and where we are headed in the world of AI.
More Dates
NFP Reporting and Presentation
-
Online/Webcast
2.00 Credits
See more dates
This CPE course provides an overview and changes with respect to ASU 2016-14 Presentation of Financial Statements and ASU 2016-18 Restricted Cash and Cash Equivalents in Statement of Cash Flows for Not-for-Profit Entities. This course provides common pitfalls and tips on functional expense reporting and, how to manage liquid resources, common peer review findings related to ASU 2016-14, and tips and suggestions on a successful audit. This course also reviews items to consider, given COVID-19, when preparing for an audit and reviewing financial statements. The instructor will explain the key facts and impacts of ASU 2018-08 Clarifying the Scope and Accounting Guidance for Contributions Received and Contributions Made, ASU 2019-03: Updating the Definition of Collections, ASU 2019-06: Extending the Private Company Accounting Alternatives on Goodwill and Certain Identifiable Intangibles to NFP Entities, and ASU 2020-07 Presentation and Disclosures by NFP Entities for Contributed Nonfinancial Assets. Lastly, this course will cover Cybersecurity Issues. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Adelina Burke, CPA
More Dates
Why Cybersecurity Matters to CPAs
-
Online/Webcast
2.00 Credits
See more dates
CPA's are responsible for understanding (1) the presence of fraudulent activity, (2) that financial reports are complete and accurate, and (3) applying the going concern principle to a business. Appropriate cybersecurity controls, processes and oversight directly impact these three areas. Fraud Bad actors can exploit systems with weak security controls to perform fraud. The increasing prevalence of hacked systems reflect this. Bad actors are stealing data, intellectual property, financial assets, and other information. Digital fraud is becoming more prevalent and can be substantially more damaging than historical types of fraud. Not only can digital fraud result in financial loss, but it can subject companies to expensive lawsuits, damage reputations and can even put a company out of business. Complete & Accurate Financial Reports Having cybersecurity controls on systems and networks is critical to ensure information reported in financial statements is complete and accurate. Data residing in financial reports is processed, stored and transmitted using IT Systems. It is important for CPA's to understand the required cybersecurity controls to prevent or detect inaccurate data in financial reports. Going Concern With an increasing volume of system hacks (e.g. Target, Experian, Sony, and most recently the US Government), it is no longer "if" you're going to get hacked, it is "When." If organizations do not have appropriate cybersecurity controls in place to protect against an attack, then a malicious hack can put them out of business. An organization's cybersecurity posture should be a factor in evaluating the Principle of Going 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 - Petrina Youhan, CPA, CISSP/Dr. Kenneth W. Cooper, DCS,