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 - Feature Review in 100 minutes
-
Online/Webcast
2.00 Credits
See more dates
Over the years, Excel has added MANY new features and functionality, yet most people still use it the same way they first learned it. Many of the features were added to Excel to enhance your ability to create spreadsheets more efficiently and with more accuracy. However, if you aren't aware of these new features, how can you use them? This class will focus on walking through each ribbon (menu) to explain the capability of various features in Excel. It is a great overview for both new and advanced Excel users to make sure you know all the capabilities of Excel. You may have seen many of the features but had no idea what they could do for you. This class will help you to understand these features and determine how you might take advantage of their capabilities. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, 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
Mastering the Excel Lookup Functions
-
Online/Webcast
2.00 Credits
See more dates
In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. 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
Section 199A Deduction: Rules & Forms Reporting
-
Online/Webcast
2.00 Credits
See more dates
This program addresses the Section 199A deduction for flow-through entity income, including a review of the major provisions, forms reporting, and recent developments. 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
2024 Stand Out - How to Create a Unique Employer Brand
-
Online/Webcast
1.00 Credits
Learn why creating an employer brand is so important and instrumental in competing in today's competitive marketplace. Elevate your recruiting experience for candidates and onboarding process for new hires to enhance your employer's brand. Speaker - Kelly Simants
The Controllers Role in Data Analytics and Big Data
-
Online/Webcast
1.50 Credits
See more dates
Today’s economy and all of the digital enhancements have impacted the way companies engage with their customers as well as how the company manages their internal practices. The business control function needs to keep pace. The rising importance of analytical capability is critical when defining the role of the modern controller. Execution of analytics can vary but there are still key questions that must be asked. What are the options and what we need to understand to decide the best way forward? This course focuses on the value that can be brought by the Controller when becoming involved with data analytics powered by technology and also Big Data. The digitized world we live in has made it important for the Controller function to evolve and take on this advanced task. Speaker - Lynn Fountain
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
Introduction to the Property & Casualty Insurance Industry
-
Online/Webcast
1.00 Credits
See more dates
The insurance industry has unique accounting and regulatory requirements. This course provides an introduction to those unique requirements, including the multiple layers of regulation, statutory vs. GAAP accounting, non-admitted assets, special treatment of taxes, and more! 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
2024 What's Changing in Risk Assessment
-
Online/Webcast
2.00 Credits
See more dates
SAS 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was issued in October 2021. The audit standard amends AU-C 315, including many changes to address common audit deficiencies. This course will provide an overview of SAS 145 and its changes to AU-C 315. Attendees will have an opportunity to evaluate the impact on audit methodology and documentation. Speaker - Melisa Galasso
More Dates
Managing the Accounting Department
-
Online/Webcast
4.00 Credits
Welcome to a management course that helps CFOs and Controllers lead the Accounting Department. It is essential that the Accounting Department have a Vision which is aligned with the Business goals. Controllers must also be comfortable with wearing multiple 'hats' in the business. The head of the Accounting Department must be skilled in a variety of leadership skills, technical skills, managerial skills and current management techniquest. Speaker - James Lindell
2024 All About Fraud - Examples, Prevention and Auditing
-
Online/Webcast
4.00 Credits
See more dates
Fraud is constantly in the news. Whether its employee retention credit mills, FTX, the City of Dixon, it appears like fraud is everywhere. We'll start this session with a review of the common fraud schemes as identified in the 2024 Report to the Nations. We'll also review the commonalities of fraudsters. We'll then look at methods of prevention. We'll close with a look at the auditor's responsibility for the consideration of fraud in AU-C 240. Speaker - Melisa Galasso
More Dates
Personal Leadership Skills
-
Online/Webcast
4.00 Credits
See more dates
People skills are the most significant skills that Professionals need to develop and yet are often the last skills perfected. This course will help participants understand personality types and the successful interactions with clients, peers and family. In addition, participants will learn Neuro-linguistic programming and develop the ability to better understand nonverbal language which is key in communication. Participants will also learn techniques to enhance memory and to improve the ability to recall key facts. Speaker - James Lindell
More Dates
2024 Topic 842 - Implementing Leases Workshop
-
Online/Webcast
4.00 Credits
See more dates
This updated course offers an in-depth look at the FASB leases standard (ASC 842), which requires organizations to recognize lease assets and liabilities on the balance sheet. This comprehensive course will cover recognition, measurement, presentation, and disclosure requirements, while also focusing on a critical area of change which is the proper identification of a lease using a principles-based approach. We will discuss implementation requirements from both the lessee and lessor accounting models. In addition, we explore a variety of scenarios, including short-term leases, purchase options, variable lease payments, and remeasurement. This course offers practical journal entry examples, lessons learned from implementation, and explores recently issued amendments to the lease accounting guidance. Speaker - Melisa Galasso
More Dates
K2's 2023 Six Essential Teams Features
-
Online/Webcast
1.00 Credits
See more dates
The mad scramble to remote work and utilize apps like Teams has been trying for most organizations over the past couple of years. With a rush to install and no time to plan, most team members did their best, prioritizing remote meetings as the primary concern. Therefore, as a result, Teams is vastly misunderstood and underutilized in most organizations. Join us in this session to go beyond the remote meetings aspect of Teams and to learn how to optimize efficiency, communication, and workflow with Teams. Speaker - Connie Clark
More Dates
2024 Internal Controls for Small and Medium-Sized Entities
-
Online/Webcast
1.00 Credits
See more dates
This session explores the importance of internal controls with an emphasis on best practices for small- and medium-sized entities. We will examine the roles of both preventive and detective controls and practical, cost-effective suggestions for implementing effective internal controls will be addressed. Speaker - Chris Harper
More Dates
Everything There is to Know About Summonsing
-
Online/Webcast
1.00 Credits
See more dates
You are likely familiar with and/or have experience with IRS summonses. BUT - Did you know there's a lot of procedure and decorum that goes into issuing a summons that you can leverage to help your client? This program will focus on the basics of an administrative summons, what the IRS can summons for, how you should comply with a summons, summons referral criteria, and common errors and misnomers the IRS can make in generating/serving a summons. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Billy L. Fauller, III, EA, CTRS, NTPI
More Dates
Surgent's Mastering Accounting for Income Taxes
-
Online/Webcast
4.00 Credits
See more dates
Since its inception nearly 30 years ago, many have continued to struggle with applying the current model for accounting for income taxes, ASC 740. But this does not have to be you. This course will provide you with the basic knowledge necessary to understand the complexities of this challenging topic. Through discussions and use of exercises, this course will analyze the authoritative literature to provide a thorough understanding of such topics as deferred taxes, income tax expense, uncertain tax positions and other classification and disclosure requirements related to income taxes. We will also explore some specialized areas of income tax accounting, such as intra-period allocations of income tax expense and accounting for changes in tax laws and rates, and we will review proposed updates to ASC 740 disclosures on which the FASB is contemplating. In summary, this course is the place to be to enhance your accounting for income taxes IQ.
More Dates
Power BI - Analyze Your Data With Excel Pivot Tables
-
Online/Webcast
4.00 Credits
See more dates
* This course is #3 in the Microsoft Power BI series of webinars. Click button in Program Content section below to see suggested viewing order. * Excel is a popular tool for data analysis, yet most users have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis. This session is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make data analyzation an easy task for all accountants. Participants will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, 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
Power BI - Advanced Data Analytics with Power Pivot
-
Online/Webcast
8.00 Credits
See more dates
This fast-paced course focuses on using Excel Power Pivot features to enhance data analysis. One of the strengths of Power Pivot is the formula language DAX (Data Analysis eXpressions). We will spend considerable time using the power of DAX to create meaningful calculations that add new dimensions to our data. We will also review the use of a date or calendar table that allows us to perform date analysis that was never possible before. This will allow us to use the new time-intelligent functions to perform complex calculations on our data such as: month-to-date, quarter-to-date, year-to-date, last year same period, last year-to-date, etc. We will also demonstrate the hottest tips and tricks that will take your data analysis to the next level. Although our focus will be on using Power Pivot, we will review some of the other Power BI Tools including: Power Query (Get & Transform), Power BI Desktop and Power BI Services (PowerBI.com). NOTE: If you want to apply the concepts presented, you will need Excel 2013, 2016 or 2019/Office 365 AND the Power Pivot add-in pre-installed. To see our full prerequisite recommendations, see PROGRAM CONTENT section below. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, 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
Financial Accounting for Related Party Transactions
-
Online/Webcast
2.00 Credits
See more dates
This course explores the FASB codification provisions and AICPA financial reporting framework for transaction with related parties, including business owners and special purpose entities. Real-life examples are used to illustrate the various authoritative standards and discuss the consequences of failing to comply. 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
Prioritizing Mental Health in the Post-COVID Workplace
-
Online/Webcast
1.20 Credits
See more dates
Over the last few years, mental health has become more of a mainstream issue. In fact, statistics indicate that approximately one in four adults experience a mental health condition. Therefore, it is more important now than ever for organizations to make mental health and wellness a priority, given all the rapid changes leading to higher levels of stress and uncertainty in the post-COVID workplace. The goal of this course is to outline the signs of mental health challenges in the workplace, such as changes in behavior, mood, or performance, while providing practical strategies for HR Professionals and Business Leaders to build and implement accommodations for a mentally healthy work environment. Speaker - Shannon White