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.
Excel - Advanced Formatting to Improve Your Spreadsheets
-
Online/Webcast
2.00 Credits
In the "Excel - Formatting Spreadsheets for Beginners" class, you learned basic formatting of a spreadsheet. In this class, we take you to the next level by teaching you how to customize many of the formatting options. Learn to customize cell styles and how to use these styles in other workbooks. Most Excel users know how to select number formats but this class shows how to leverage the Custom Number Formatting option to create special formatting options. Many of the formatting options are applied manually, cell-by-cell or by range. This can be tedious if there is a condition by which you want to apply a format. You will learn to use Conditional Formatting to format based upon a criteria. Have you ever finalized a spreadsheet, only to accidently make changes over the top? This action is something that is very easy to do. This class demonstrates various options to prevent this from happening and will look at various security options within Excel. 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
Surgent's Understanding S Corporation Taxation: Late S Corporation Elections, Disproportionate Distributio
-
Online/Webcast
2.00 Credits
S corporation taxation has a lot of pieces. There are helpful elections you can make that can potentially save your client money, but there are also rigid rules to adhere to. For example, if there is more than one class of stock, it can terminate the S corporation election. Learning how to successfully navigate these rules can make all the difference. In this course, we will discuss some of the more common specialty areas experienced by practitioners - late filing relief for S corporation elections, disproportionate distributions, and selling S corporation shares. While these items may not come up on every single Form 1120-S, you will be able to add more value to clients when they do.
More Dates
Retirement Planning: Next Stage for You or Your Client
-
Online/Webcast
2.00 Credits
If you or your clients are facing that stage of life where careers are passing into the background, and a new "to be determined" life is emerging, then you are entering what is called "retirement". Some people are excited, some are scared, and most are both. There are many issues and questions people face at this time - what to do with time, financial, relationships, health, identity and more. This program summarizes the key research studies, provides stories from those who have made this work, and offers thoughtful, practical exercises from my award winning book NEXT STAGE. It will help you (or your clients) address key issues and develop a Master Plan for the transition. If not now, when? This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Tom Wilson
More Dates
Surgent's Applying ASC 820: The Basics of Fair Value Accounting
-
Online/Webcast
4.00 Credits
While once thought just to apply to banking and financial institutions, entities now need to apply fair value accounting under ASC 820 across a variety of transitions. From financial instruments to leases, business combination accounting and impairment measurement, GAAP either requires or allows the use of fair value measures in an ever-increasing number of circumstances. Now is the time for you to get up-to-speed on the basics of the fair value approach. In this course, we will review when fair value accounting is required and when an entity can select to use it. Then we will review the basics of the ASC 820 model, including the concept of "exit price," the various approaches which an entity may follow when using a fair value approach and the different levels of inputs which an entity may consider when determining fair value. Lastly, the course will provide examples on when and how to apply this complex accounting guidance.
More Dates
2024 Best-In-Class Recruiting Strategies
-
Online/Webcast
1.00 Credits
With over 4.3 employees leaving their jobs as of early 2022, The Great Resignation presents a huge challenge for companies as they attract and retain talent. During this course, you'll learn practical strategies you can implement immediately to ensure you have the right tools in your toolbox to win the war on talent. Speaker - Kelly Simants
More Dates
Analytical Procedures: Practical Applications and Standards
-
Online/Webcast
2.00 Credits
This session explores the nature of analytical procedures, with significant emphasis placed upon professional standards involving the use of analytical procedures in audit and review engagements. Practical examples to illustrate the application process will also be given. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Chris Harper, CPA
More Dates
Surgent's Starting a Small Business: What Every Trusted Advisor and Entrepreneur Needs to Know
-
Online/Webcast
2.00 Credits
Starting and owning a small business has often been referred to as the "Third Pillar of Wealth," right behind investments and owning real estate. Essentially, all businesses start off as "small businesses." Small businesses, however, require a large amount of preparation in order to successfully launch and grow. Starting a business requires the owners and managers to address a host of issues, including an understanding of applicable laws, appropriate financing, staffing requirements, marketing, liability protection, and many more. This course provides a broad overview of the critical issues business owners, as well as their professional advisors, must consider when starting and growing a small business. There is extensive research regarding best practices in this area, and this webinar is intended to distill down such information and focus on what is critical to get a small business up and running as seamlessly as possible.
More Dates
Advanced ChatGPT for Accountants
-
Online/Webcast
2.00 Credits
This course concisely explains the latest "see, hear, speak" multi-modal updates to ChatGPT and how they can be used in an accounting context. New features include vision processing, voice conversation, image generation, real-time Internet access, advanced data analysis, plugins and more. Discover how this technology can be used in mind-blowing ways to analyze financial data, optimize processes, and solve problems in the accounting domain. Through the lens of ChatGPT, practitioners can explore innovative solutions, automate routine tasks, and generate deeper insights and value to their clients and organizations in previously unimaginable workflows. You'll walk away with scores of advanced ChatGPT strategies and tips that can be immediately applied and deliver instant results to elevate the efficiency and effectiveness of your accounting projects and 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 - Garrett Wasny, MA, CMC, CITP/FIBP
More Dates
Form 1120S - Preparation and Analysis
-
Online/Webcast
2.00 Credits
This course provides an in-depth exploration of Form 1120S, the tax return form used by S corporations. Students will learn the intricacies of preparing and analyzing this form, including how to determine the taxable income of the S corporation, how to properly report and allocate income, deductions, and credits, and how to calculate the shareholder's basis in the S corporation. **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 PCAOB and SEC Update
-
Online/Webcast
2.00 Credits
It is imperative for public companies to produce quality financial reporting. This course will share insights into the latest SEC and PCAOB areas of emphasis and concern. 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
Tactics to Find Work Life Balance in a Complex World
-
Online/Webcast
1.00 Credits
This session will explore key aspects of getting more satisfaction out of the work you choose to do and how to find greater balance between the demands of work and other lifestyle choices in an ever more complex and changing world. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Ronald L Seigneur, CPA/ABV, ASA, CVA
More Dates
Communicating Financial Information to Non-Accountants
-
Online/Webcast
2.00 Credits
Do you ever get blank looks when you present your company's financial statements? Does your board nod knowingly, during your presentation, but never seem to have any meaningful questions? It could be that they have no idea what you are talking about and are just pretending to understand! Learn how to connect with your CEO, board, fellow managers, and ordinary employees so they understand your message. Learn to motivate them to action. Come hear a veteran CFO tell you how. 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 L. Daly, MBA, CPA, CMA, CPIM
More Dates
Surgent's Controller/CFO Update: Hot Topics Facing Today's Financial Professional
-
Online/Webcast
4.00 Credits
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
Yellow Book Independence and Single Audit Fundamentals
-
Online/Webcast
4.00 Credits
This CPE course explains Yellow Book independence including the general requirements, requirements for auditors providing non-audit services and documentation requirements. This course also explains the basic elements of a Uniform Guidance compliance audit, including an overview of requirements, major program determination with examples, an understanding of compliance requirements and related internal control over compliance, sampling, and single audit reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Adelina Burke, CPA
More Dates
2024 Annual Update for Accountants & Auditors
-
Online/Webcast
8.00 Credits
This course will start with the Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. We'll 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. We'll also review year 2 considerations for leases including modification accounting. Then we will switch gears, switching to the audit side of the house. We'll review the impact of the changes to auditing group audits as well as the status of the AICPA's quality management project management. This course will keep auditors up to date on the work of the ASB. 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
Surgent's Excel Budgeting Ideas
-
Online/Webcast
2.00 Credits
Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.
More Dates
Surgent's Food, Beverage, and Entertainment Expensing
-
Online/Webcast
2.00 Credits
The IRS has issued final regulations regarding the Tax Cuts and Jobs Act's (TCJA) elimination of the deduction for expenditures related to entertainment, amusement, or recreational activities and provided guidance to determine whether an activity is considered to be entertainment. The final regulations also address the 50% limitation on the deduction of food and beverage expenses and when the 50% limitation does not apply. Due to the pandemic, Congress changed the rules for 2021 and 2022 to allow for 100% deductibility for meals. These temporary rules no longer applied starting in 2023. To effectively advise clients, it is imperative for tax practitioners to understand these rules and be updated on the latest IRS guidance related to meals and entertainment.
More Dates
Using ChatGPT with Excel
-
Online/Webcast
2.00 Credits
In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. 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
How to Get a Better Return on Financial Statement Audits - Avoiding the Most Misapplied Risk-Based Audit Concepts
-
Online/Webcast
8.00 Credits
By far, the biggest contributing factor that leads to a profitable, yet high quality, financial statement audit is the proper identification, evaluation, and response to assessed risk of material misstatement. When designing your detailed audit plan, how and where you decide to spend your time is largely a matter of professional judgment. The proven tips and techniques for critically rethinking how you plan and design your audit taught in this course will help auditors enhance audit quality and manage profitability in all engagements. Speaker - Jennifer Louis
More Dates
Audit & Attest Quality Matters that Should be on Your Radar - Avoiding Common Deficiencies in SAS, SSARS and SSAE Engagements
-
Online/Webcast
8.00 Credits
Quality management is important. Every CPA firm that provides audit and other attest services must undergo a third-party quality control review. This session will provide you with the tips on how to avoid common quality control deficiencies in all services that are subject to peer review. Speaker - Jennifer Louis