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.
Our 2025 Course Listing is on its way!
Check back soon for our extensive list of hundreds of courses to fit your learning goals.
Taking Advantage of Array Formulas in Excel
-
Online/Webcast
2.00 Credits
See more dates
This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in 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
Securing Your Data with a Password Management App - Updated
-
Online/Webcast
2.00 Credits
See more dates
Cybersecurity protection is one of the most important responsibilities of every CPA professional to protect the confidentiality of sensitive client information. While there are many aspects of cybersecurity that need to be addressed, the biggest vulnerability to protect against is unauthorized access to your application login credentials. Once your login credentials are breached, the cybercriminal essentially has the keys to your data kingdom. John Higgins, a national leader in the CPA technology, will demonstrate the ease with which you can protect all of your login credentials with maximum security with minimal expense. You will leave this course prepared to deploy this state of the art security tool in your organization. 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 Annual Update for Defined Contribution Plans
-
Online/Webcast
2.00 Credits
See more dates
This course will provide a general understanding of the new reporting and disclosure requirements for employee benefit plans under the now effective SAS 136, the AICPA's new employee benefit plan auditing standard. Participants will be provided with an insight into the common errors and mistakes made by auditors and plan administrators, as well as the new requirements of both groups under the new SAS. The course will discuss the results from the Department of Labor's ("DOL") Criminal Enforcement initiative and audit quality study, and focus on the causes of the recent increase in the number of deficient engagements identified by the peer review process. This course will provide auditors and plan administrators with up-to-date information regarding defined contribution plans auditing, reporting and disclosure requirements, including those related to the new ERISA Section 103(A)(3)(c) audits under SAS 136.Speaker - Melissa Critcher, CPA, PC
More Dates
Surgent's Excel: Mastering PivotTables
-
Online/Webcast
2.00 Credits
See more dates
PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.Speaker - Jeff Lenning
More Dates
Surgent's Guide to Calculating S Corporation Shareholder Stock and Loan Basis
-
Online/Webcast
2.00 Credits
See more dates
This program discusses, in a practical way, how an S corporation shareholder calculates their stock and loan basis on Form 7203. Form 7203 is the IRS Form on which a shareholder is sometimes required to calculate their stock and loan basis. This topic is particularly important when an S corporation has a loss and the shareholders wish to know whether they are entitled to fully utilize the loss that has been allocated to them against their other income.Speaker - Mike Tucker, Ph.D., LL.M., J.D., CPA
More Dates
Surgent's Understanding S Corporation Taxation: Compensation Issues and Entity-Level Taxes
-
Online/Webcast
2.00 Credits
See more dates
Even though they have been around for several years, the tax laws pertaining to S corporations remain some of the more difficult areas of the Internal Revenue Code. In this course, we will examine how S corporations break away from the normal tax rules for flow-through entities. We will explore which employee benefits are disallowed for S corporation shareholders, as well as which taxes are assessed at the entity level. Finally, we will discuss how state level taxation may have changed permanently with the addition of PTE elections.Speaker - Dave Peters, CPA, CFP, CLU, CPCU, MST, MBA
More Dates
Surgent's Work-Life Balance: Maximizing Productivity and Understanding Related Tax Issues
-
Online/Webcast
2.00 Credits
See more dates
Working as a financial professional is an accomplishment that offers the potential for a good salary with long-term growth. Despite being a sought-after career, studies show that being overworked is the greatest source of anxiety and dissatisfaction among financial professionals. Left unchecked, a life centered exclusively around the demands of work can be both physically and emotionally detrimental. Establishing a work-life balance is difficult in any profession, yet financial professionals confront unique challenges that make this goal seem even more elusive. Technology results in being "always on," with no true time to disconnect and genuinely enjoy family, exercise, or hobbies. Lack of balance comes with costs, including poor health and lower productivity. Why are some professionals able to establish a successful balance between career demands and family while others are not? How are some firms able to achieve both high employee satisfaction and strong productivity? This webinar looks at research, surveys, and simple anecdotal information to provide a better understanding of how to achieve a realistic work-life balance in the modern world. We also discuss the tax consequences that arise when professionals seek balance by working from home in one state while their employer is located in a different state.Speaker - Jason Cornell, Esq.
More Dates
Surgent's Coaching Skills for Managers and Supervisors
-
Online/Webcast
4.00 Credits
See more dates
This one-day course will teach effective skills for coaching and training employees. You'll learn how to identify the characteristics of effective coaches and develop coaching strategies to support and assist your team, with the goal of helping them improve morale, productivity and quality. And, you'll learn a five-step approach for giving constructive criticism while managing defensive reactions.Speaker - Sarah Acuna
More Dates
Becoming Conflict Competent
-
Online/Webcast
2.00 Credits
See more dates
Conflict is often avoided, or dealt with in a passive manner. When ignored, conflict often escalates and can become polarizing. In this session, participants will gain insights for enhancing their natural responses to conflict, learn healthy communication styles, and build constructive behaviors to manage conflict. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Julie G. Holunga, MBA, CPCC, ACC and Stephanie Wachman
More Dates
Create Visuals in Power BI to Successfully Analyze Data
-
Online/Webcast
4.00 Credits
See more dates
Unlock the full potential of your data with our cutting-edge course, "Create Visuals in Power BI to Successfully Analyze Data." Designed to span a focused, four-hour session, this course is your gateway to mastering the art of data visualization using the powerful tools of Microsoft Power BI Desktop and PowerBI.com. Whether you're a business professional, a budding data analyst, or simply someone interested in the world of data science, this course is tailored to enhance your skills in transforming raw data into visually stunning and insightful reports. Dive into the intuitive interfaces of Power BI Desktop and PowerBI.com, and learn to navigate these platforms with ease and confidence. The course is meticulously structured to provide you with demonstrations and practical knowledge. Starting with a comprehensive tour of the Power BI Desktop and PowerBI.com interfaces, you'll quickly move to the core of creating impactful visuals. Explore a wide array of available visuals and learn how to select the most effective ones for your data stories. Through detailed sessions on building interactivity into your visuals, you will discover how to create dynamic reports that not only captivate but also communicate effectively. This course will also guide you through the process of publishing your reports on PowerBI.com, ensuring that your insights reach their intended audience with the right impact. By the end of this transformative journey, you will be adept at leveraging the full capabilities of Power BI. Your newfound ability to create interactive, engaging, and informative visual reports will make you an indispensable asset in any data-driven decision-making process. Embrace this opportunity to elevate your professional profile, enhance your analytical capabilities, and become a sought-after expert in the field of data visualization. Join us for "Create Visuals in Power BI to Successfully Analyze Data" and step into the future of data analysis with confidence and skill. 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
Advanced Excel: Hidden Secrets and Gems
-
Online/Webcast
2.00 Credits
See more dates
This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel. Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level. 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
Surgent's Implementing Subscription Pricing to Your Practice
-
Online/Webcast
2.00 Credits
See more dates
This course is designed to provide accountants with a comprehensive understanding of the subscription pricing model. As the business world increasingly shifts toward subscription-based models, it's crucial for accountants to understand the financial implications and strategies associated with this pricing approach. This course will cover the basics of subscription pricing, how to set prices, and how to analyze the financial impacts of these decisions, as well as the specific impacts to your business. By the end of this course, participants will be equipped with the knowledge and skills to effectively manage the implementation of subscription pricing to their practice.Speaker - Christina Hilton, CPA
More Dates
How SAS Nos. 134-145 Improve Risk-Based Audits
-
Online/Webcast
4.00 Credits
See more dates
Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in SAS Nos. 134-145. 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 The Risks and Benefits of ChatGPT and Artificial Intelligence
-
Online/Webcast
2.00 Credits
See more dates
We see multiple stories about the rapid growth of artificial intelligence (AI) and its entry into our lives in the form of AI tools, including ChatGPT. They seem to be everywhere. It is difficult to overstate how much things will change with the rise of these new technologies, or how important it is that companies embrace the opportunity to execute them correctly. Having conversations regarding the proper adoption of these technologies and tools is a crucial first step, including drafting policies to assist companies with their beneficial and thoughtful implementation and use. This course will define the state of AI tools, what benefits and risks exist, and which steps to take to begin adopting these technologies with appropriate guardrails, policies, and training. It is less likely that AI will destroy industries, and more likely that companies that embrace AI will overtake those companies that do not.Speaker - Mark McCreary, CIPP/US
More Dates
Create Paginated Reports with Power BI Report Builder
-
Online/Webcast
2.00 Credits
See more dates
Elevate your data reporting skills to new heights with our cutting-edge course, "Create Paginated Reports with Power BI Report Builder." This two-hour, expertly crafted training is designed to transform the way you visualize and present data, leveraging the powerful capabilities of Microsoft Power BI Report Builder. Ideal for professionals who aspire to turn complex data into compelling, print-ready reports, this course is a game-changer in the realm of data visualization and business intelligence. Delve into the world of paginated reporting with a curriculum that balances theoretical knowledge with practical examples and demonstrations. You'll learn how to navigate the Power BI Report Builder interface with ease, design intricate report layouts, and connect to diverse data sources for comprehensive reporting. The course covers a spectrum of skills, from creating eye-catching visualizations to utilizing advanced features like sub-reports and drill-through capabilities. By the end of this session, you'll be adept at publishing and sharing professional-grade, paginated reports that can inform and persuade your audience. Enroll now and take the first step towards mastering the art of paginated reporting with Power BI Report Builder. 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
ChatGPT for Accountants: 50+ Use Cases
-
Online/Webcast
2.00 Credits
See more dates
This course will explore the use of ChatGPT and artificial intelligence chatbot technologies in the accounting profession. Participants will learn how to utilize ChatGPT to automate tasks, improve efficiency and accuracy, and provide real-time support to 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 - Garrett Wasny, MA, CMC, CITP/FIBP
More Dates
Side-Hustle CFO
-
Online/Webcast
1.00 Credits
See more dates
This Masterclass is a one-hour training exclusively for employed accountants and bookkeepers. Start a business on the side offering CFO Advisory services to small businesses! Designed exclusively for accountants and CPAs, this class focuses on how you can use your knowledge and experience to start an advisory service in your spare time. By providing a service that your clients really want, you can supplement your income by upwards of $6k per month working only 4 hours per client - with only 3 clients. We'll cover the systems you need to start your own advisory service including how to package, price and market your business. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Adam Lean
More Dates
Tactics to Find Work Life Balance in a Complex World
-
Online/Webcast
1.00 Credits
See more dates
This session will explore key aspects of getting more satisfaction out of the work you choose to do and how to find greater balance between the demands of work and other lifestyle choices in an ever more complex and changing world. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Ronald L Seigneur, CPA/ABV, ASA, CVA
More Dates
Exploring Internal Controls That Could Have Prevented Frauds
-
Online/Webcast
2.00 Credits
See more dates
This course examines actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters' ability to accomplish their nefarious acts. 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
How Recent Auditing Standards Improve Risk-Based Audits
-
Online/Webcast
4.00 Credits
See more dates
Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in the SASs. 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