Skip to main content

CPE Catalog+Events

Our comprehensive, easy-to-search list of all LCPA-sponsored courses helps you find exactly what you're looking for, or even a course on a new topic to expand your competencies.  TIP: When doing multiple searches for different events, be sure to clear filters between searches.

Showing 592 All Results

K2's 2023 Introduction To Excel Macros

-

Online/Webcast

4.00 Credits

You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, “One day, I’ll learn how to write macros.” Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel’s Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don’t miss this unique opportunity to learn how to begin working with macros – one of Excel’s most powerful tools. Speaker - Thomas Stephens

Surgent's Lessons Learned from Successful Companies

-

Online/Webcast

2.00 Credits

Why do some companies fail while others grow and succeed for generations? Common perceptions often attribute organizational success to great leadership, timing, or unique ideas. Although these traits certainly play a role in helping companies grow, research shows that corporate success often hinges on whether a company is value driven. Such companies have core ideologies that drive almost every major decision. In this course, we look at empirical data on why some companies succeed while others fail. By looking at companies that were created prior to 1950 (e.g., Disney, Marriott, or 3M), we can understand why certain organizations have been able to grow and achieve exceptional success through many different eras in the American economy. The lessons learned from these visionary companies can be broadly applied to organizations of all sizes, including accounting and financial service firms.Speaker - Jason Cornell

K2's 2023 Mastering Advanced Excel Functions

-

Online/Webcast

4.00 Credits

With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel’s more advanced features – some new and some legacy – to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel’s FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel. Speaker - Thomas Stephens

Surgent's Make Resilience Work for You - An Accounting Leader's Guide to a Holistic Approach for Managing Teams

-

Online/Webcast

2.00 Credits

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.Speaker - Susan Ward

Surgent's Government and Nonprofit Frauds and Controls to Stop Them

-

Online/Webcast

4.00 Credits

George Washington once wrote, "We ought not to look back, unless it is to derive useful lessons from past errors, and for the purpose of profiting by dear bought experience." The cost of fraud, dearly paid by governments and nonprofits, is too severe not to learn and profit from. In this course, we will look back at real-world government and nonprofit frauds and derive useful controls to stop them. The course materials utilize a highly illustrative and innovative format. Over 15 focused exercises are included to provide an enhanced working knowledge of fraud and anti-fraud controls to both auditors and industry professionals.Speaker - Charlie Blanton, CPA

K2's 2023 Microsoft Teams

-

Online/Webcast

4.00 Credits

Microsoft Teams is one of the most exciting personal and organizationally productivity tools to ever appear on the business landscape. With Teams, you can communicate and collaborate easily and securely with others, including colleagues outside your organization. Further, you can extend the already-robust functionality in Teams by incorporating add-in solutions with just a few clicks of the mouse. Unfortunately, despite Teams’ power and relatively simple interface, many organizations struggle with deploying and using Teams.  In this session, you will learn how you can get up and running quickly in Teams so that you can take full advantage of this powerful tool. More specifically, you will learn how you can get started in Teams and critical decisions that will affect your deployment. Also, you will learn how to work in Teams, including how to take advantage of the chat, voice, and video call services and how to share documents securely with others. Moreover, you will learn how to extend your Teams platform to external organizations for improved communication and collaboration. Additionally, you will identify how you can add other applications into Teams and optimize Team's configuration for the best overall efficiency and security. If you are working with Teams or plan to do so, this is one CPE session you can’t afford to miss! Speaker - Thomas Stephens

S Corporation Essentials: Review & Update

-

Online/Webcast

4.00 Credits

This program addresses the critical issues and special opportunities facing S-corporations, with a focus on reporting shareholder basis and distributions.  **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 leighanne.conroy@acpen.com. Speaker - Doug Van Der Aa, CPA, JD

Surgent's Mastering the Basics of Inventory Accounting

-

Online/Webcast

4.00 Credits

While many entities maintain inventory, they are often challenged when applying the complexities of inventory accounting. The goal of this course is to provide a detailed overview of inventory accounting concepts that can be applied to a variety of inventory types. The course will cover the basics of inventory capitalization, for both book and tax, as well as the basic inventory valuation methods, LIFO, FIFO, weighted average, and specific identification. Then the course will give a more detailed review of the LIFO and retail methodologies. It will cover the topics of inventory obsolescence reserves and other issues related to inventory accounting, including a discussion of how COVID-19 has impacted these accounting considerations. This course will be the one-shop stop to get you up-to-speed on the accounting for this critical, revenue-producing asset.Speaker - Samuel Monastra, CPA

Surgent's Preparing Not-for-Profit Financial Statements

-

Online/Webcast

8.00 Credits

In order to prepare accurate and effective not-for-profit financial statements, professionals must have a strong working knowledge of the reporting requirements. Now is the time to obtain that knowledge! This course explains the requirements, illustrates how the requirements manifest in the financial statements, and clarifies options available to not-for-profits in applying the requirements. The course covers key accounting areas that affect not-for-profits, including revenue recognition, contributions, and leases. The course materials utilize a highly illustrative and innovative format, including over 30 focused exercises to provide an enhanced working knowledge of not-for-profit accounting and reporting.Speaker - Charlie Blanton, CPA

Are Those Independent Contractors Really Independent Contractors?

-

Online/Webcast

1.00 Credits

Various legal tests are used to evaluate whether a worker should be classified as an employee or an independent contractor. There is no uniform standard or bright-line rule for determining whether an individual is properly classified as an independent contractor. Instead, the inquiry is always fact-intensive, and the analysis can vary based what body is performing it, i.e. the Internal Revenue Service (“IRS”), Department of Labor (“DOL”), various state agencies, or the courts. This presentation will review the various tests and highlight some of the common, most important factors for consideration.    Speaker - Alana Ackels

Surgent's Artificial Intelligence for Accounting and Finance Professionals

-

Online/Webcast

2.00 Credits

Accounting and finance professionals have used different forms of automation over the years to improve the efficiency and accuracy of their work. So far, technology has not been able to replace the knowledge, experience, and decision-making of seasoned professionals. Times are rapidly changing. Today, systems easily exceed humans in accuracy and consistency. Artificial intelligence (AI) brings opportunities for accountants and finance professionals in the short term to improve efficiency and accuracy, while providing more value for businesses and customers alike. In the long term, AI will offer profound changes to how professionals work and process data. This course is designed to review where we are and where we are headed in the world of AI.Speaker - Jason Cornell

Governmental GAAP Update - 2023

-

Online/Webcast

2.00 Credits

This two hour course will cover the GASB standards that are effective this year with a deeper dive into GASB 94, Public Private Partnerships and GASB 96, Subscription Based IT Arrangements. We'll also look at smaller standards that are effective for 2023 year ends. Speaker - Melisa Galasso

K2's 2023 Shredding Your Servers And Going Virtual

-

Online/Webcast

2.00 Credits

Most small and mid-sized businesses are at least considering cloud-based suites for business management, performance management, and productivity. Unfortunately, many owners and accounting professionals need to learn the difference between using cloud-native tools, employing a managed service provider, and utilizing a desktop hosting provider. This session helps participants understand the differences in the levels of service provided by these offerings and will also highlight some of the regulatory barriers which could create problems for your organization. Attend this session and learn what you need to know before saying “see ya” to your servers. Speaker - Brian Tankersley

AICPA's Accounting for Digital Assets Under U.S. GAAP, Part IV

-

Online/Webcast

1.00 Credits

Crypto lending and borrowing As you or your clients start to explore new ways to transact with crypto assets, one of the many possibilities is through involvement with crypto lending and borrowing. Gaining an understanding of the process of lending and borrowing crypto assets is the first step. This webcast provides the fundamentals related to these transactions and considerations for accounting from the perspectives of both lender and borrower. Part four of a seriesThis webcast is part four of a series that will bring to life the content incorporated in the AICPA practice aid Accounting for and Auditing of Digital Assets.This webcast will walk you through: The process of borrowing and lending crypto assets Crypto lending accounting considerations including derecognition models Crypto borrowing accounting considerations including how to account for the obligation.Add more valueWhether you're a CPA working with clients or an industry accountant responsible for corporate accounting policy, this webcast will give you a clear path to help your clients or entity by applying the appropriate accounting standards to your digital asset crypto lending and borrowing activities. Detailed examples and use cases will demonstrate the real-world application of this guidance.Learn valuable information to open your world of crypto assets even more. Speaker - Sean Prince

Surgent's Integrated Planning, Forecasting, and Budgeting for Organizational Success

-

Online/Webcast

4.00 Credits

Planning may be one of the most important assignments of the finance professional; however, it is often accomplished in a way that can harm the organization. In many cases, huge sums are spent only to have a planning document developed that does not serve to bring the company together, but rather causes internal division. In some situations the budget can actually harm both productivity and alignment. This course is designed to bring planning, budgeting, and forecasting together into one fully aligned process that is easier, more efficient, and fully engages all parts of the organization. Rather than the plan being owned by the finance department, it is owned and followed by everyone from the CEO to the entry-level employee.Speaker - Art Pulis, MBA

2023 Compliance Update on Arbitration Agreements, Severance Agreements, Confidentiality and Non-Disparagement Agreements

-

Online/Webcast

1.00 Credits

In the last year, our country has seen the passage of multiple federal laws impacting the enforceability to common employment documents. Several federal agencies have also issued opinions that could impact common employment documents. This presentation will review those new laws and opinions and discuss the potential impact they may have on arbitration agreements, severance agreements, confidentiality agreement, and non-disparagement agreements.   Speaker - Alana Ackels

Surgent's A Complete Tax Guide to Exit Planning

-

Online/Webcast

2.00 Credits

When exit planning, it is important to weigh various issues, including tax implications, to achieve an effective management and/or ownership change. Many envision tax-free reorganizations being the most preferable structure to avoid capital gains tax, but the opportunities come at a cost to the seller. This course will provide a well-rounded discussion of the various strategies to consider when advising on exiting a business.Speaker - Bob Lickwar, CPA

Surgent's Opportunities in the Metaverse for Accounting and Other Professionals

-

Online/Webcast

2.00 Credits

It is no secret that accounting firms, like many other organizations, have begun launching operations in the metaverse. For those unsure, the metaverse is a digital or virtual space where participants simulate a host of activities ranging from shopping to entertainment and business transactions. Why wouldn't accounting firms and other professionals want to get in early on this new frontier? All types of businesses have begun purchasing and setting up shop in this new virtual world. These are no small endeavors - professionals are creating business plans to operate successfully in the virtual world that started off originally as a niche format for gamers. Accounting firms are starting to announce their acquisition of virtual real estate, and some are paying a premium to obtain prime locations. To operate successfully in the metaverse, professionals need to understand the environment and the rules of the game. This course provides an introduction to the metaverse and an overview of opportunities, risks and rewards for professionals who wish to stay relevant in the ever-expanding virtual world. Participants will walk away with an understanding of where we are in this rapidly developing space, plus gain insights on how to establish a presence or advise clients who wish to explore metaverse opportunities.Speaker - Jason Cornell

Surgent's Data Analytics Toolkit - Tools and Applications

-

Online/Webcast

2.00 Credits

There is no shortage of data, but relatively few organizations have an environment and process to isolate, capture, analyze, and convert data into actionable information. Too often, we collect as much data as possible, continue to use historic measurements, and communicate data using traditional vehicles. Good decisions are not the result of the amount of data gathered, but of the quality and understanding of the information. The goal of this program is to explore a number of analytical tools and techniques and identify applications for them within an organization. Analytical techniques will be introduced throughout the discussion, and a significant amount of time will be spent addressing the steps needed to establish a data-driven environment and identifying and discussing potential/specific applications. In this way, participants get experience they can begin to use in their organizations. An expanded list of reference books and next level software is also provided.Speaker - Tony La Russo, BA, MBA, CMA

K2's 2023 The Best Kept Secrets Of Microsoft 365

-

Online/Webcast

2.00 Credits

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