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.
The Updated Nuts and Bolts of IRC Section 1031 Exchanges
-
Online/Webcast
2.00 Credits
See more dates
In today’s real estate market, IRC §1031 tax-deferred exchanges can be one of the most important planning tools available to the real estate investor. The use of this technique is filled with pitfalls and traps. This new course will assist the practitioner in understanding the mechanics of a tax-deferred exchange and the value of a tax-deferred exchange in both tax and financial planning. Updated August 2022 Speaker - Arthur Werner, Jordon Rosen
More Dates
Excel - Using Charts for a Non-Financial Audience
-
Online/Webcast
2.00 Credits
See more dates
This webinar will show you how to use Excel's charting and formatting features to present financial data to a non-financial audience. As the saying goes, "A picture is worth a thousand words." People tend to better understand your point when visuals are used. We will explore the many capabilities of presenting your data without showing rows and rows or columns and columns of data. Help your audience visualize the meaning of the data, whether it is a trend, an exception, a distribution or a good vs. bad relationship. 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
Preparing to be a Forensic Accountant - Cloud Forensics
-
Online/Webcast
1.50 Credits
See more dates
Cloud computing has become a source of cyber-crime. “Cloud forensics is the application of digital forensics in cloud computing as a subset of network forensics to gather and preserve evidence in a way that is suitable for presentation in a court of law.” Cloud forensics is a combination of the varied types of accounting forensics including: • Digital forensics • Network forensics. • Hardware forensics In cloud crime, the cloud is considered the object when the target of the crime is the cloud service provider they are directly affected by the act. It is considered the subject of the crime when the criminal act is committed within the cloud environment. It is considered the tool when it is used to plan or conduct a crime. This course will delve into the many concepts involved in cloud forensics. The course complements other courses in the series of Becoming a Forensic Accountant. Speaker - Lynn Fountain
More Dates
Excel - Functions and Formula Shootout
-
Online/Webcast
2.00 Credits
See more dates
Are you aware there are 470+ formula functions in Excel? Do you realize that they add new functions in every major version of Excel? Did you know that Microsoft adds new functions throughout the year in the Office 365 version of Excel? Are you stuck using old or simple functions like SUM or ROUND? Do you want to expand your knowledge of the extensive function library in Excel? If these questions peak your interest in becoming an Excel function expert, this course is right up your alley. This past-paced course digs into some of the most powerful functions in Excel. Although we cannot cover 470 functions, we will look at over 20 functions that will allow you to create advanced calculations in your spreadsheets. Some examples are: VLOOKUP, IF, IFS, FORECAST, RAND, SWITCH, TEXTJOIN, UNIQUE, SUBTOTAL, IS, TEXT and more! We will also provide example files that will include all the functions used during the class. It's time to take your Excel spreadsheets to the next level. This session is presented using Excel 2019/Office 365. 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
Surgent's Representing a Client in an IRS Audit
-
Online/Webcast
3.00 Credits
See more dates
Recent legislation in Congress has provided the IRS with substantially increased funding to bolster its human staff and purchase software that will allow the IRS to audit many more taxpayers in a more effective way. The IRS believes it can target the right kinds of taxpayers for audits so that it will not waste its time on audits that produce little, if any, revenue. The purpose of this program is to discuss the current state of IRS audits and the anticipated increases in the IRS's ability to audit wealthier taxpayers in an efficient way. Panelists will discuss the state of the IRS's current audits and where the IRS is headed with audits in the coming years. Tax practitioners should also be aware of the state of the IRS's efforts to target efficiencies so as to produce the most revenue.
More Dates
CFO Solutions to IRS Problems
-
Online/Webcast
4.00 Credits
See more dates
Many CPAs are becoming full-time or fractional CFOs for small businesses. In that position, they are the resident expert in finances, cash flow planning, and budgeting. But what about dealing with the IRS? The IRS has broad powers to administer the assessment and collection of taxes. From removing penalties to criminal prosecutions, this presentation focuses on how CFOs can prevent problems with the IRS and how to develop winning strategies if the IRS knocks on the door. 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
Audit 207: Sampling - Avoiding Common Mistakes on Audits
-
Online/Webcast
2.00 Credits
See more dates
Sampling - Avoiding Common Mistakes on Financial Statement and Compliance Audits will describe the proper process for both attribute testing and variable sampling in financial statement and compliance audits. Sampling is an important method for determining the extent of testing controls, testing compliance, and tests of substantive details. It allows the auditor to apply procedures to less than 100% of the population yet extend results to project likely conclusions about the entire population. 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 sampling responsibilities. 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
Coaching the Next Generation of CPAs
-
Online/Webcast
2.00 Credits
See more dates
Attracting and retaining staff is critical to an organization's success, especially in the age of the millennial worker who will change jobs multiple times in the course of a career. This course will focus on best practices for nurturing the human element of your organization, especially millennial workers who comprise a growing percentage or the workforce. 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 Engagement and Client Retention Best Practices
-
Online/Webcast
2.00 Credits
See more dates
Positive client relationships require work. Miscommunication, unrealistic expectations, and differing personality styles may strain a client's relationship with professional advisors. Fortunately, there are tested strategies that foster and strengthen client relationships. Creating appropriate boundaries early on is one of many effective strategies that can help. This course explores actions accounting and finance professionals can take to create and grow their client relationships. This webinar provides actionable insights on how to engage new and old clients alike. Strained client relationships can harm both the client and the firm's profitability. Yet automation, for example, allows some firms to remain more engaged while others miss the mark. There is a science underlying client retention that involves understanding the client journey, ensuring consistent client interactions, and equipping employees with the tools needed to satisfy client needs. Understanding these skills should help you protect the relationships that sustain your business.
More Dates
Clean, Transform & Load Data in Power BI
-
Online/Webcast
2.00 Credits
See more dates
This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. 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
Audit 208: Audit Reporting Basics - Report Issuance Process
-
Online/Webcast
2.00 Credits
See more dates
Audit Reporting Fundamentals - Introducing Core Concepts in the Audited Financial Statement Drafting and Issuance Process will provide tips and techniques necessary for issuing and reporting on high-quality financial statements prepared under any applicable financial reporting framework. The ultimate objective of a financial statement audit is to issue an auditor's report. 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 drafting and issuing audit reports. 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
QuickBooks ONLINE - Monthly Closeouts and Year-End Cleanups
-
Online/Webcast
2.00 Credits
See more dates
The process of closing out the books every month can make year-end accounting a breeze! But isn't this time consuming? Not when you know the steps to take on a monthly basis. We'll show you what to do in QuickBooks Online as well as what you can do monthly to ensure a tax return that will stand up again an IRS audit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Dawn W. Brolin, CPA, CFE
More Dates
Excel - Create KPI Dashboards for Maximum Impact
-
Online/Webcast
2.00 Credits
See more dates
Most accountants use Excel to help them make decisions about their data. However, as the amount of data grows, it becomes difficult to make strategic decisions based on rows and rows and columns and columns of data. In this course, you will learn how to build robust dashboards for analyzing key metrics in Excel. We will begin with some dashboard design guidelines, such as understanding your audience and identifying necessary metrics. Then, we will work through importing data, setting up calculated fields and columns, and creating key performance indicators (KPIs) for the dashboards. You will learn how you can add charts and eye-catching visuals with Power View, in order to make your dashboards easily understood. 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
IRS Penalties and Abatements
-
Online/Webcast
2.20 Credits
See more dates
Penalty abatement is a technique that tax practitioners can utilize to help their clients reduce penalties and interest they owe to the IRS if the taxpayer can prove “reasonable cause.” This informative and insightful webinar will provide you with some insider tips, practical steps and effective strategies to help your client manage IRS tax penalties and interest. Learn about various types of penalties that you may face and the various forms and procedures used for requesting penalty and interest abatement, including First Time and Reasonable Cause abatement. Plus, learn about the procedure to follow when requesting refund of paid penalties. **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 - Allison McLeod
More Dates
Surgent's Controller/CFO Update: Hot Topics Facing Today's Financial Professional
-
Online/Webcast
4.00 Credits
See more dates
In today's rapidly changing world, finance professionals are required to wear many hats and are often the keys to the success of the organization. On one hand, they need to be abreast of the latest proven financial skills for making the best decisions, and on the other hand they need the best skills to motivate, manage, and lead people. Being pigeon-holed into one area or another is neither good for career building nor good for the organization. This reality has proven to be even more true with the advent of COVID-19. We'll cover the latest issues that all CFOs and controllers need to know about and provide how-to guidance to allow for immediate use in their organizations. The program is focused on organizational success and will concentrate on ways to manage risk and achieve greater productivity.
More Dates
Walter Haig's AICPA Auditing Standards Update
-
Online/Webcast
8.00 Credits
See more dates
This course will enable practitioners to understand and apply the AICPA "clarification" auditing standards to audits of Small- and Medium-Sized Entities (SMEs). Further, this course will provide guidance on how to perform an effective, efficient and profitable audit engagement. The course is loaded with practical practice aids to help enable participants to comply with the standards. Troublesome areas as identified in peer reviews and litigation will be covered. Participants who take this course will enjoy smooth sailing in their peer reviews, guaranteed! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Walter J. Haig
More Dates
Surgent's Going Out on Your Own: Entity Types and Accounting Methods
-
Online/Webcast
2.00 Credits
See more dates
Starting a business is tough! There are lots of decisions to be made and things to think about. You may feel like you have a great idea. You have done your marketing research, developed a prototype, and even looked at locations for your new office. Then it dawns on you.. What type of entity do I need to be? Is there really an advantage to choosing one entity type over the other? In this class, we will dig into the differences between entity types - from taxes to liability. We will also look at the advantages and disadvantages of different methods of accounting. Whether you are a small business owner looking to start something new or a practitioner looking to expand your client advisory services, this course is the one for you!
More Dates
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Online/Webcast
2.00 Credits
See more dates
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.
More Dates
ChatGPT: What Every CPA Should Know-Updated
-
Online/Webcast
2.00 Credits
See more dates
Don't look now, but ChatGPT is taking the business world, including the accounting profession, by storm. Every CPA, whether in public accounting or working in corporate, should have a fundamental understanding of ChatGPT and generative AI applications more broadly. This course will provide you with a foundation of knowledge about ChatGPT technology that will prepare you to have conversations with clients, customers, colleagues and service providers. More importantly, you will learn how to leverage ChatGPT to increase your personal productivity. If you feel your ChatGPT knowledge is lacking, that will not be the case after you attend this course, taught by John Higgins, one of the leading technology strategists and thought leaders for the accounting profession. 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
How Fraud Can Affect Smaller Organizations
-
Online/Webcast
4.00 Credits
See more dates
Many small to medium sized companies do not properly address the risk that arises related to fraud because these organizations do not have the resources needed to mitigate this risk or because owners or those in top level management underestimate the scope of the issue. All organizations, regardless of size, must be aware of the risks associated with intentional fraudulent acts and know that a significant and effective fraud scheme could even create going concern issues for some entities. In this session, we delve into the reasons that fraud takes place. The material discusses the types of defalcations that are often executed against smaller entities and then explores measures that organizations can implement to help stop fraud activities and add security. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Karl Egnatoff, CPA.CITP