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.
K2's 2024 Better Reporting With QuickBooks Online
-
Online/Webcast
1.00 Credits
See more dates
AI is an extremely popular topic these days, and for good reason! However, does AI present yet another threat to your privacy? Get answers to this question and more in this session. Speaker - Thomas Stephens
More Dates
K2's 2023 The Best Kept Secrets Of Microsoft 365
-
Online/Webcast
2.00 Credits
See more dates
Many organizations have implemented Microsoft 365/Office 365 at a basic level, but few have truly explored the breadth and depth of tools included with their subscriptions. Some less commonly known apps help you manage shared email boxes, create and use web forms, schedule appointments, trade shifts, create real-time closed captions, and translate presentations. Attend this session and learn more about the hidden features in Microsoft 365 that you can use to level up your productivity. Speaker - Brian Tankersley
More Dates
2024 Topic 842: Understanding the New Lease Accounting Standard
-
Online/Webcast
2.00 Credits
See more dates
It’s a whole new world for lessees under ASC topic 842. Soon nearly all leases will need to be disclosed as a liability on the balance sheet – from buildings right down to autos and copiers. Although the greatest impact will be on large entities, this will affect the financial statements of small and mid-size entities as well. This program will dive into the new standard on leases, effective dates, and address what you need to know now. Speaker - Chris Harper
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 Make Resilience Work for You - An Accounting Leader's Guide to a Holistic Approach for Managing
-
Online/Webcast
2.00 Credits
See more dates
Resilience training was originally developed to strengthen individuals in high-risk groups like law enforcement, firefighters, and the military. This course also speaks to accounting and finance experts in a very challenging discipline. Resilience training is based on the intriguing assumption that resilience can be learned. A resilience leader possesses mental toughness, competence, and confidence. A confident accounting or finance person makes better decisions and thinks in deliberate ways to meet adversity and pressure. Resilience is the ability to exercise tenacity, bounce back from tough times, or even triumph in the face of adversity. Today's accounting professionals will experience challenges but are able to reframe then as learning opportunities. Resilient accounting and finance professionals push their limits, learn from their mistakes, and are able to transform an organization and themselves.
More Dates
Surgent's Successfully Completing a Gift Tax Return -- Form 709
-
Online/Webcast
2.00 Credits
See more dates
Since the early 2000s, the estate tax burden on taxpayers has gradually decreased along with the number of practitioners specializing in the field. Nevertheless, some of your most wealthy clients will have a taxable estate. For these select clients, making large gifts before death can be extremely tax efficient for the client and profitable for the practitioner filing the gift tax return. Learning how to file a basic gift tax return can help you attract and retain clients, increase your value-add, and generate revenue.
More Dates
ChatGPT Bootcamp for CPAs with John Higgins
-
Online/Webcast
4.00 Credits
See more dates
ChatGPT is the fastest growing application in the history of technology with over 100 million users adopting it in within two months. It is a revolutionary technology that boosts the quality and efficiency of business processes in every industry. As "knowledge workers", CPAs and CFOs are positioned to be prime beneficiaries of this technology. This half day hands-on course will get you well on your way to becoming a ChatGPT expert. John Higgins, a nationally recognized advisor and educator on CPA technology, will guide you through the process of accessing ChatGPT and applying it to a variety of practical accounting, finance and tax scenarios. This course will catapult you to the top of the pyramid of CPAs who are knowledgeable in ChatGPT and you will be ready to put it to use in your day-to-day tasks. 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
Common Deficiencies in EBP Audits
-
Online/Webcast
2.00 Credits
See more dates
During this presentation, the most common mistakes made by employee benefit plan auditors, as well as plan sponsors will be identified. Best practices for handling specific issues that arise during the course of the engagement will also be explored. This discussion will help auditors recognize potential pitfalls in audit procedures/documentation and assist plan sponsors with compliance issues. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Melissa Critcher, CPA
More Dates
Engagement Management with the Microsoft 365 Planner App
-
Online/Webcast
2.00 Credits
See more dates
Are you using Excel to keep track of progress and task completion for your engagements? Or, are you using a sophisticated engagement management app that takes too much time or requires too much information to keep your task completion progress up to date? Worst of all, are you relying primarily on email communications to keep track of your engagement task completion progress? If any of these scenarios apply to your practice, this course will show you a better way to manage engagements from simple 1040 tax preparation to comprehensive audits. The Microsoft 365 Planner app, which you are likely already paying for as part of your Microsoft 365 subscription, provides a comprehensive, yet simple solution for all of your client engagements and internal projects. John Higgins, a nationally recognized strategic accounting technology advisor will guide you through the process of how to deploy this app to effectively manage all your projects. This app is effective for sole practitioners and firms of all sizes. 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 IRS Tax Examinations and Hot Issues
-
Online/Webcast
4.00 Credits
See more dates
Due to IRS issue focused examinations, Accounting and Finance Professionals need to understand what types of returns are selected for examination and ways to help clients survive an IRS audit with little or no change. As a result of issue focused examinations, Accounting and Finance Professionals must understand what the high audit risk area issues are and what the IRS is focusing on when a return is examined. In addition, because tax-related identity theft is a common issue for many taxpayers, it is critical for Accounting and Finance Professionals to understand the procedures necessary to resolve this matter for their clients.
More Dates
K2's 2024 Consumer Electronics Show 2024 - Navigating The Future Of Technology
-
Online/Webcast
1.00 Credits
See more dates
Small businesses have better options now than ever before in the market of accounting solutions. Participate in this session to learn more about these options and which might be best for you or your clients. Speaker - Thomas Stephens
More Dates
Keys to Building an Inclusive and Culturally Competent Workplace: A Guide for HR Professionals and Business Owners
-
Online/Webcast
1.80 Credits
See more dates
HR Professionals are business leaders who, regardless of their level of experience, are responsible for maintaining a high level of interpersonal proficiency in their job function. The willingness to gain a genuine understanding and respect for diversity and the incorporation of a safe and inclusive environment of employees in the workplace, is a strong measure of the HR Professionals’ efficacy in this area. This training is geared towards improving and/ or elevating the HR Professionals’ knowledge of cultural competence in the workplace and what it means to truly adopt a culture of diversity and inclusivity. When HR professionals take responsibility for teaching others about the differences and benefits that multiple cultures and diverse backgrounds bring to the organization, research shows that companies are more likely to win top talent and yield improvement in customer orientation, employee satisfaction and decision making, as well as a cycle of increasing returns. Speaker - Shannon White
More Dates
Audit 306: Reviewing Workpapers - A Role in Quality Control
-
Online/Webcast
2.00 Credits
See more dates
Reviewing Workpapers - Embracing Responsibilities for Quality Control will provide the tips and tools for satisfying important workpaper reviewer responsibilities. Audit documentation provides the principal support for an auditor's report. Therefore, it is critical for workpaper reviewers to perform quality control procedures to ensure that technical, professional, and regulatory standards are met. In addition, the workpaper review process should be used as a tool for professional development and promoting efficient audits. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has workpaper review 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
Surgent's Implementing the New Risk Assessment Standard
-
Online/Webcast
2.00 Credits
See more dates
The auditor's responsibilities related to risk assessment have changed! This power-packed course will empower you with the working knowledge of SAS No. 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, to successfully apply the standard.
More Dates
Change: Embrace & Enjoy - It Is Inevitable
-
Online/Webcast
2.00 Credits
See more dates
We see change every day, but we ignore it as a key risk. Even though change is natural, it is also natural for humans to fight it. Why do humans think we can control everything? What are the steps we can take to adapt to change? Learn more about how we can become better at recognizing change and how we can embrace and adapt to the many changes we see every day. Change is inevitable. We can adapt to it or be replaced. We will discuss practical insights that will help you be even more successful in the office and in life. Effective leaders should not miss this course. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Don Minges, MBA
More Dates
Preparing to be a Forensic Accountant - Focus on Network Forensics
-
Online/Webcast
1.50 Credits
See more dates
Network forensics - defined as the investigation of network traffic patterns and data captured in transit between computing devices - can provide insight into the source and extent of an attack. It is used in forensic accounting and with the expansion of information technology it has become a growing field. Network forensics is a relatively new field of forensic science. Computing has become network centric. Data is now available outside of disk-based digital evidence. Network forensics can be performed as a standalone investigation or alongside a computer forensics analysis. When used alongside a computer forensic analysis it is used to reveal links between digital devices or reconstruct how a crime was committed. Network investigations deal with volatile and dynamic information and is a sub-branch of digital forensics. It relates to the monitoring and analysis of computer network traffic for information gathering, legal evidence, or intrusion detection. This course is a complement to our other courses in the series on becoming a forensic accountant. Speaker - Lynn Fountain
More Dates
2024 Guide to Depreciating & Expensing Business Assets
-
Online/Webcast
2.00 Credits
See more dates
Following the ever-changing tax deprecation rules is not a game for the faint hearted! This course analyzes the current landscape of depreciating, capitalizing and disposing of business assets, with examples and illustrated case studies to enhance the CPAs understanding of the most current tax depreciation provisions. **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 - Steven Dilley, CPA, JD, PhD
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
K2's 2023 Small Business Internal Controls, Security, and Fraud Prevention and Detection
-
Online/Webcast
8.00 Credits
See more dates
Internal controls are more important than ever, and their importance increases daily. However, internal controls present a challenge for many smaller organizations. This program will teach you how to evaluate, develop, and implement an effective internal control structure in a small business environment. You will identify how to assess risk in smaller organizations and implement preventive, detective, deterrent, and compensating controls to mitigate these risks, even without proper segregation of duties. Additionally, participating in this program will teach you technology-focused techniques for preventing and detecting fraud and securing information systems and sensitive data. For small organizations, maintaining an effective system of internal controls presents a significant challenge. Realistically, implementing many theoretical concepts surrounding internal controls may not be possible in some cases. Consequently, many internal control structures foster an environment where too much risk exists. This factor and uncontrolled information systems can often lead to disastrous results. Participate in this program to learn the necessary insights and tools to design, implement, and monitor effective internal controls, security, and anti-fraud measures in small organizations. Speaker - Randolph (Randy) Johnston, Brian Tankersley, Thomas Stephens, Mac McClelland, Steven M. Yoss, Jr., CPA
More Dates
ChatGPT and Complex Financial and HR Conversations
-
Online/Webcast
2.00 Credits
See more dates
The course provides a concise overview of how accountants can use ChatGPT to assist with communications involving intricate and often sensitive topics that require a deep understanding of both financial principles and human resource policies. These conversations can range from budgeting and compensation to ethical considerations and regulatory compliance. The course also explores the use of ChatGPT in crafting clear, accurate, and empathetic responses to complex queries related to financial audits, tax planning, and employee benefits. It emphasizes the importance of balancing technical financial knowledge with effective communication skills to address diverse stakeholders' needs in various scenarios, from internal team discussions to client consultations. 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