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, Surgent, AHI, AICPA, and K2 Enterprises to deliver high-quality webcast and self-study content in a convenient and cost-effective manner. Stand-alone courses and all-access packages are available. Filter using the Vendor name. Learn more.
CFO Series: Beyond Likes & Shares: Social Media at Work
-
Online/Webcast
2.00 Credits
In our social media world of scrolling, liking, sharing, and sometimes reporting, there is a dilemma that hits hard in the workplace. Should we use social media? How can we use social media responsibly? Can we separate our personal self from our professional self? We will discuss the numerous errors made when dealing with social media and the negative fallout. Social media often drives cultural trends and conversations. Even if someone isn't directly participating in these conversations online, they may still be exposed to them through mainstream media, conversations with others, or public events. We will review what is and is not acceptable for a professional to do. Your people ARE using social media, but are they using it to inadvertently damage the organization and the brand? Be prepared with a plan before another social media fiasco happens.Speaker - Jane Mims, Ph.D.
Master the Art of CPA Communication: Boost Your Influence!
-
Online/Webcast
4.00 Credits
See more dates
Discover the communication edge that will take your CPA career to the next level. This comprehensive course empowers CPAs with the tools to enhance clarity, build trust, and drive decisions. Learn to transform complex jargon into actionable insights and develop powerful persuasion techniques that resonate with clients and stakeholders. Join me to sharpen your communication skills and elevate your professional impact. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Tammy Daugherty
More Dates
Advanced Cybersecurity - Beyond the Basics
-
Online/Webcast
4.00 Credits
See more dates
A deeper dive into Cybersecurity topics specific to CPAs and Fintech Organizations, expanding on the fundamentals from Cybersecurity 101 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. Kenneth W. Cooper, DCS, CISSP
More Dates
Surgent's Marijuana: A Generalized Business Viewpoint
-
Online/Webcast
2.00 Credits
See more dates
Each year, more states legalize cannabis (i.e., marijuana) for medical or recreational purposes. As legalization grows, so too does the cannabis industry. While some financial professionals have stayed away from this growing sector of the economy, others have embraced the opportunities the cannabis industry has to offer. The legalization of cannabis brings with it a complex regulatory landscape, which includes strict compliance with federal and state regulations. However, the complexity of this emerging market provides opportunities for accountants and other financial professionals. Behind the cannabis dispensaries are scores of related business sectors including food production, retail, farming, and chemical production, as well as facilities, design, and construction. Simply stated, the commercialization of marijuana offers financial professionals an opportunity to participate in an industry expected to reach $73 billion worldwide within six years.Speaker - Jason Cornell, Esq.
More Dates
Take Command of your Time
-
Online/Webcast
2.00 Credits
See more dates
Manage distractions, decrease stress and improve productivity. This training is designed to help business professionals improve their productivity and work performance by learning how to prioritize time, decrease distractions and lower stress. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Stephanie Wachman
More Dates
Controller Series: Technology - Must Have Excel Competencies
-
Online/Webcast
1.00 Credits
See more dates
Excel has long been included in the accountant's toolbox. Even though Microsoft Power BI and other big data tools such as Qlik and Tableau are becoming more important, Excel is still a "must have" tool. We cover what the accountants of today should know about Excel to improve their efficiency, access data, and gain insights into the company, industry, and economy.
More Dates
Criminal Tax: How CPAs Bring Value to Defense Attorneys
-
Online/Webcast
2.00 Credits
See more dates
CPAs can be requested to assist attorneys in litigation support in criminal proceedings. For criminal tax cases, the IRS has recommended prosecution. However, the rules and stakes are different than a simple civil audit. This presentation will focus on how to assist defense attorneys in calculating tax loss, asking the right questions, and probe possible weaknesses in criminal tax investigations. 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
Generative AI in Practice-Boost Efficiency and Profitability
-
Online/Webcast
2.00 Credits
See more dates
Unlock the potential of generative AI to streamline accounting, auditing, tax , and advisory services. This course focuses on practical applications that can save you time and enhance profitability. Learn how to integrate AI tools into your workflows to automate tasks, improve accuracy, and deliver higher-value services. 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
Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Online/Webcast
2.00 Credits
See more dates
Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work. Speaker - Jeff Lenning
More Dates
Nonprofit Internal Control - Practical Insights into Mitigating Financial Reporting, Compliance and Other Risks
-
Online/Webcast
4.00 Credits
See more dates
There is simply no denying that a sufficiently designed and effectively operating system of internal controls over reliable financial reporting is more important than ever. The primary objective of this course is to give participants "hands-on" practice in designing, evaluating, and communicating conclusions related to design and operating effectiveness of internal controls over reliable financial reporting and other risks for nonprofit environments. Speaker - Jennifer Louis
More Dates
Unlock the Power of AI with Copilot in Excel
-
Online/Webcast
2.00 Credits
See more dates
In the ever-evolving world of data analytics and business intelligence, Microsoft Excel continues to be an indispensable tool for professionals across industries. With the introduction of Copilot, Microsoft has integrated the power of artificial intelligence directly into Excel, revolutionizing how users work with data. This 2-hour interactive course, Unlock the Power of AI with Copilot in Excel, provides a comprehensive overview of how Copilot transforms traditional Excel workflows into dynamic, AI-driven processes, enabling users to accomplish tasks faster, more accurately, and with less manual effort. During this course, you'll discover how Copilot leverages AI to enhance productivity and streamline operations. Whether you're a seasoned Excel user or just beginning your journey, this course will guide you through practical applications and best practices to make the most of Copilot's capabilities. Through hands-on demonstrations and real-world examples, you'll see how Copilot can save time, improve decision-making, and elevate your analytical skills to new heights. This course not only focuses on the technical aspects of Copilot but also highlights its potential to transform your day-to-day work, from automating repetitive tasks to uncovering trends and insights you might otherwise overlook. By the end of the session, you'll be equipped with the knowledge and confidence to integrate Copilot into your workflows and unlock its full potential in Microsoft 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
Performance Management
-
Online/Webcast
1.00 Credits
See more dates
The tools for managing performance and addressing misconduct are not identical. The failure to point this out to leaders has often resulted in the use of the wrong tool. Reinforcing good performance and securing improvements in performance requires skill in coaching employees, making effective requests, and providing effective feedback. This course provides practical knowledge and scripts for setting, communicating, and enforcing performance expectations, such that personal and employer liability is avoided. Speaker - Mike Mirarchi
More Dates
What's Behind the Data?
-
Online/Webcast
2.00 Credits
See more dates
We are bombarded with information continually. So how do we determine what is valid and what isn't? This course points out common pitfalls inherent in data interpretation and gives practical tips to overcome those pitfalls by using real life examples. The course incorporates information from key thought leaders including Adam Grant, Alex Edmans, and Hans Rosling. 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
Deep Dive Into Common Auditing Deficiencies
-
Online/Webcast
4.00 Credits
See more dates
This course will review common deficiencies identified by the AICPA and state boards of accountancy. It features discussion on a variety of topics, including analytical procedures, sampling, group audits and risk assessment. We will review the areas of concern and how you can overcome them by employing best practices. 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
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
What You Can Learn From the Statement of Cash Flows
-
Online/Webcast
2.00 Credits
See more dates
This course allows you to get reacquainted with the statement of cash flows. We will refresh your skills regarding both the preparation and utilization of the statement of cash flows. Significant emphasis will be placed on the informational role of the statement of cash flows and insights that can be obtained using the statement of cash flows in concert with the other elements of a company's accrual-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 - Chris Harper, CPA
More Dates
Google Gemini AI for Accountants
-
Online/Webcast
2.00 Credits
See more dates
This course provides a concise overview of Gemini AI, Google's advanced multimodal artificial intelligence model. It explains how Gemini is integrated into different Google products, including Gmail, Docs, Sheets, Slides, and as a stand-alone chatbot. Participants will learn how Gemini enhances productivity by summarizing email threads, suggesting responses, drafting emails, generating formulas, creating tables, and more. By the end of the course, students will have a solid foundation in understanding Gemini AI's role in the evolving landscape of artificial intelligence. 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
Partnership Tax Updates (2025)
-
Online/Webcast
2.00 Credits
See more dates
The well-informed tax practitioner will want to attend this two hour program in order to stay current on recent updates on partnership tax! Content includes recent court decisions on partnership tax issues as well as current IRS procedural updates for passthroughs. 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
Using ChatGPT with Excel
-
Online/Webcast
2.00 Credits
See more dates
In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. 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
Private Company Simplified GAAP Alternatives
-
Online/Webcast
2.00 Credits
See more dates
The FASB formed the Private Company Council to provide certain alternatives in U.S. GAAP that are only available to nonpublic business entities, with limited exceptions for certain nonprofits. This course will provide insight into when adopting the accounting and financial reporting alternatives would be to the advantage of private companies. Speaker - Jennifer Louis