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.
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
Emerging Innovations in Forensic Data Analytics, Crypto Currencies and AI, ChatGPT
-
Online/Webcast
2.00 Credits
See more dates
In this course, participants will learn about key trends and innovations impacting the field of forensic data analytics. From generative AI to ChatGPT, machine learning and transaction review, data sharing consortiums and cryptocurrency trends, this course is for the futurist who wants to be leading edge in compliance and anti-fraud technology innovation. Speaker - Vincent Walden
More Dates
The 10 Must Know Excel Features
-
Online/Webcast
2.00 Credits
See more dates
Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel's most impactful features. Whether you're streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. 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
IRS Cybersecurity Checklist
-
Online/Webcast
2.00 Credits
See more dates
This course is designed to provide learners with an understanding of the Internal Revenue Service (IRS) Cybersecurity Checklist and how it can be used to protect taxpayer data. The course will cover the basics of cybersecurity, including threats, risks, and vulnerabilities. Learners will be introduced to the IRS Cybersecurity Checklist, which provides a framework for organizations to assess and enhance their cybersecurity practices. The course will cover the various elements of the IRS Cybersecurity Checklist, including access control, data protection, and employee training. Learners will gain an understanding of the importance of each element and how it contributes to the overall security of taxpayer data. The course will also cover best practices for implementing each element of the IRS Cybersecurity Checklist. Throughout the course, learners will be presented with real-world examples of cybersecurity threats and breaches, highlighting the importance of effective cybersecurity practices. Learners will also be given practical exercises and assessments to reinforce their understanding of the IRS Cybersecurity Checklist. *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 - Arthur Werner
More Dates
2024 Governmental GAAP Update
-
Online/Webcast
2.00 Credits
See more dates
This course begins with a look at the GASB standards effective this year, including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We'll include practical application of the topics in the form of case studies. 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
Monthly Federal Tax Updates - March 2025
-
Online/Webcast
2.00 Credits
See more dates
Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. 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
What's Going on at the FASB (2024)
-
Online/Webcast
4.00 Credits
See more dates
The course will start with the Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. We will also review year 2 implications of the leases standard including modification accounting. We will then switch our attention to the items coming down the pike, including a look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation. 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
Audit 203: Auditing Accounts Receivable - Common Risks
-
Online/Webcast
2.00 Credits
See more dates
Auditing Accounts Receivable - Focusing Procedures for Testing Existence and Valuation will explain tips and best practice techniques for auditing common accounts receivable risks, primarily focusing on existence and valuation. Accounts receivable tends to carry higher risk of material misstatement due to the complexity and subjectivity involved with initial recognition, subsequent measurement, and valuation. In addition, revenue recognition is presumed to be a significant fraud risk. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has responsibilities for auditing accounts receivable. 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
Data Extraction, Transformation, Validation the Right Data Sources for Analysis
-
Online/Webcast
2.00 Credits
See more dates
In this course, we will explore the various types of data - both structured and unstructured - used in conducting fraud risk investigations and proactive monitoring. We will explore the various tools available on the market and techniques to confirm completeness and accuracy of the data before the analysis begins. The course will cover the process for selecting the right data sources to align with the various risks as well as pitfalls to avoid when preparing the data for analysis. Speaker - Vincent Walden
More Dates
2024 Fiduciary Accounting: Fundamentals & Rules
-
Online/Webcast
2.00 Credits
See more dates
This course will dive into the fundamentals of fiduciary accounting and provide a reporting guide for determining whether receipts and expenditures are assigned to income or principal/corpus. Speaker - Doug Van Der Aa, CPA, JD
More Dates
Invest in Your Mental Health and Avoid Burnout
-
Online/Webcast
2.00 Credits
See more dates
For the ambitious female finance professional, working hard and going above and beyond are necessary for success. Sadly, taking time to care for themselves can be seen as counter-productive to meeting their career goals. Over ninety percent of women executives are feeling significantly higher levels of stress that they attribute to increased responsibilities and priorities outside the workplace compared to life before the pandemic. Burnout is a syndrome resulting from chronic workplace stress that causes exhaustion, negativity toward one's job and reduced professional efficacy. It has become so pervasive that it's now recognized as an occupational phenomenon by the World Health Organization. To reignite your enthusiasm at work, you don't necessarily need to find a new job or time for a spa day or bubble bath. You need concrete strategies to invest in your mental health without compromising your ability to rise to the next level in your career. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Tara Whitney, CPA, ACC
More Dates
Power BI - OLAP Formulas & More Time Intelligent Functions
-
Online/Webcast
2.00 Credits
See more dates
This course is an extension of the Power BI series of courses that specifically explores using OLAP formulas and advanced time intelligent functions. OLAP formulas provide the ability to create a calculation in a cell that is based upon the measure in the data model. This powerful tool provides the ability to create calculations in an Excel worksheet without using a PivotTable to perform the calculation. Gone are the days of creating a PivotTable, then using those values in the PivotTable for additional calculations. When using Power BI to build a data model that connects to data files, you may want to know the date of these files. This class teaches you how to create a measure based upon the refresh date of your data. In the class "Power BI - Use Advanced Calculations with DAX Formulas," you learned the basics of time intelligent functions, the ability to calculate measures based upon dates. In THIS course, we will take it to the next step and teach you how to perform many more date-based calculations. 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
Payroll Essentials: Fringe Benefits: Taxable or Not?
-
Online/Webcast
2.00 Credits
See more dates
Fringe benefits are just another way of paying your employees. Do you know how to correctly track fringe benefits, as well as apply and report the various withholding tax rules for those fringe benefits? The IRS says fringe benefits must be included in and reported as a part of employee pay, but with any good tax law, there are always exclusions to that rule. Knowing how to handle fringe benefits can be complicated, especially in an area that changes on an annual basis. Attendees will leave with an understanding of what the requirements are around fringe benefits, what constitutes a fringe benefit, and whether it is taxable or not. We will also explore the evergreen areas of reporting S-Corp Shareholder Health, HSA, and when cash is not taxable compensation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Elizabeth Bystrom, 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.
More Dates
Erase the Mark: Best Practices in Penalty Abatement
-
Online/Webcast
2.00 Credits
See more dates
If there is a potential error, the IRS will assess a tax and add a hefty penalty, without even knowing the facts. As a tax professional, you will be exposed to the IRS and their methods of penalizing taxpayers for the smallest of violations. This presentation will focus on the rules and regulations that create the penalty, and the reasons that exist that the IRS will consider to remove those penalties. 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
Improve Design and Productivity with Excel Tables
-
Online/Webcast
2.00 Credits
See more dates
Excel tables are a fundamental feature that streamlines data organization, analysis, and visualization in Excel. Throughout this course, you will discover how to transform raw data into elegant, efficient, and visually appealing tables. By harnessing the full potential of Excel tables, you will be able to make better data-driven decisions and collaborate more effectively in various professional settings. Join us in "Improve Design and Productivity with Excel Tables" and unlock the full potential of Excel tables to revolutionize the way you manage, analyze, and present data, leading to improved efficiency and better decision-making in your personal and professional endeavors. 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 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
Audit 204: Auditing Basic Inventory - Focus on Observations
-
Online/Webcast
2.00 Credits
See more dates
Auditing Inventory - Performing Required Observations and Other Common Procedures will primarily focus on performing the inventory observation, while introducing other risk concepts related to inventory. Assets classified as inventory varies widely with the nature of the entity and industry. Depending on the complexity of the inventory and the related pricing model, risk of material misstatement will vary widely as well. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has responsibilities for auditing inventory. 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 International Tax Challenges and Opportunities for U.S. Filers
-
Online/Webcast
3.00 Credits
See more dates
Globalization continues to make it easier for taxpayers to live abroad, do business in other countries, or invest in foreign enterprises. This creates significant complications and tax planning opportunities when it comes to filing U.S. tax returns. This course provides an overview of the unique tax challenges and solutions presented to U.S. expats or investors living or investing abroad. It examines how foreign-source income is taxed in the U.S. and how the tax consequences could be mitigated by applying the tax treaties, claiming credit for foreign taxes paid, or excluding foreign-earned income. Additionally, the course discusses the numerous foreign informational form reporting requirements and the significant penalties that could be imposed by the IRS. Examples from real-life client scenarios are included.
More Dates
Servant Leadership 101
-
Online/Webcast
1.00 Credits
See more dates
The War for Talent is bad, and it's getting worse. In their efforts to win the war for talent, smart organizations have recognized the importance of fostering a great work culture. Many of these organizations are implementing Servant Leadership as their desired leadership style. In this session, learn what servant leadership is, as well as what it is not. Also, learn the benefits of having a great culture, the basics for assessing your culture, as well as how to coach your employees using a servant leadership style. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Jim Bitterle