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.
Surgent's Client Advisory Services (CAS): A Guide to the Variety of Offerings Professionals Can Provide
-
Online/Webcast
2.00 Credits
According to a 2020 AICPA survey, advisory and consulting services were considered the greatest unmet needs of clients. The recent growth in Client Advisory Services (CAS) has led many to ask what is included in this broad category as well as how to develop the services for clients. With so much focus on the recent success of CAS offerings, now is the time to learn how the services differ from what you currently offer, which of your clients would benefit most, and what you need in place to add a quality CAS program to your firm's menu of services.Speaker - Christina Hilton, CPA
Surgent's Excel Shortcuts for Accountants
-
Online/Webcast
2.00 Credits
This webinar presents a variety of time-saving ideas, shortcuts, and tips that are sure to boost personal productivity. We discuss better summing, address one of the biggest pitfalls that Excel users have faced over the past 25 years, present the most important keyboard shortcuts, demonstrate a better alternative to hiding rows or columns, illustrate how to quickly navigate to other workbooks and files, and demonstrate using Excel with styles.Speaker - Jeff Lenning
Surgent's Perplexing Financial and Economic Issues for the CFO/Controller
-
Online/Webcast
8.00 Credits
For CFOs and Controllers, the emergence of regulatory, fiscal, and monetary policy directly impacting their organizations' costs, competitiveness, and financing options, are causing them to understand the effect of shocks well outside of their control. The Dodd-Frank Act, health care reform, shortfalls in Social Security, unfunded pension liabilities, and deficit spending will all be explored relative to their impact on the CFO/Controller and your organization.Speaker - Frank Ryan, CPA
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Online/Webcast
2.00 Credits
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.Speaker - Jeff Lenning
Surgent's Anatomy of a Ransomware Event and Incident Response
-
Online/Webcast
2.00 Credits
The past two years have ushered in an explosion of ransomware attacks affecting businesses and individuals. Many of us read or hear about these attacks, but there is little understanding of how they occur, how a response is undertaken, and how the chances of experiencing one can be reduced. Join us to learn about these topics so you can be prepared with the best response and the knowledge to avoid common mistakes in a ransomware event.Speaker - Mark McCreary, CIPP/US
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Online/Webcast
2.00 Credits
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.Speaker - Jeff Lenning
Surgent's Business Writing: Professional & Effective Emails
-
Online/Webcast
2.00 Credits
Good writing is good business. Studies show that the average business worker receives 121 emails per day. That's a lot of emails. Are your emails effective? Are they being read? Are they professional and tone-smart? In this course, you will learn techniques and skills to get your emails to stand out and improve their effectiveness and professionalism.Speaker - Margaret Uhrich
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.Speaker - Art Pulis, MBA
Surgent's Top 20 Questions Advisors Ask About the SECURE Acts and Other IRA Rules
-
Online/Webcast
2.00 Credits
It takes a while for advisors to gain an in-depth understanding of all the changes made to the tax laws that govern IRAs. This course focuses on the top 20 advisor questions about SECURE Act 1.0, SECURE Act 2.0, and other hot topics. The objective is to help the advisor ask the right probing questions when interacting with clients and to provide clients with responses based on their IRA profiles.Speaker - Denise Appleby, MJ, APA, CISP, CRPS, CRC
Surgent's Avoiding Deficiencies in Peer Reviews: Focus on Engagement Quality
-
Online/Webcast
4.00 Credits
With the AICPA's heightened focus on enhancing audit quality, increased oversight of the peer review process and the auditor's overall responsibility to provide high quality services, the focus on compliance with professional standards has never been greater. Recent peer reviews have indicated that auditors are often failing to perform and/or document certain critical components of an audit such as the auditor's assessment of risk and linking the results of the assessment to substantive procedures performed. In addition, auditors are not adequately documenting their consideration of fraud, expectations in analytical procedures and the appropriate level of work needed to understand an entity's internal control. Now is time to revisit the way that auditors are performing and documenting the work performed to meet professional standards. The ASB has not made significant changes to its quality standards since 2006. There are currently three standards on quality management in exposure draft that are expected to be issued in the second quarter of 2022. These changes will be substantive. This course will discuss the new standards. This course will also focus on the most significant items resulting in deficiencies identified in the peer review process. We will also discuss the applicable audit standards, documentation requirements and best practices. The objective of the course is to provide the insights necessary to help an auditor improve not just the quality of their work but also the perception of the accounting profession as a whole. Speaker - Marci Thomas, CPA
Surgent's Excel: Mastering PivotTables
-
Online/Webcast
2.00 Credits
PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.Speaker - Jeff Lenning
Surgent's Excel Shortcuts for Accountants
-
Online/Webcast
2.00 Credits
This webinar presents a variety of time-saving ideas, shortcuts, and tips that are sure to boost personal productivity. We discuss better summing, address one of the biggest pitfalls that Excel users have faced over the past 25 years, present the most important keyboard shortcuts, demonstrate a better alternative to hiding rows or columns, illustrate how to quickly navigate to other workbooks and files, and demonstrate using Excel with styles.Speaker - Jeff Lenning
Surgent's Basics of the Valuation of a Closely Held Business
-
Online/Webcast
4.00 Credits
An understanding of the basics of business valuation is an invaluable tool for practicing accountants to better assist clients who are considering buying or selling their business or an interest therein, contemplating estate tax planning or creating a buy-sell agreement, or dealing with the death of an owner, a shareholder dispute, or a divorce. Business valuation may also be a practice area an accountant would be interested in pursuing for increased billables. Many forward-thinking closely-held business owners are currently looking at possibly higher capital gain rates, particularly with a Democratic regime. Take this course to be well advised and prepared in order to better assist that potential selling owner. Speaker - Sandy Klevan
Surgent's The Accountant as the Expert Witness
-
Online/Webcast
2.00 Credits
As litigation becomes more complex, attorneys are relying more on accountants to serve as consulting experts or expert witnesses at trial. Serving as an expert witness is not as difficult as you might expect. Accounting experts educate lawyers and jurors on issues such as valuation, tax liability, and forensics. Learn how accountants become expert witnesses, the role they play during pre-litigation through to trial, and the techniques experts employ to avoid challenges from opposing counsel.Speaker - Jason Cornell
Surgent's Unlimited Plus Package
Available Until
Online/Webcast
0.00 Credits
Surgent's Unlimited Plus Package 2024 Get the best value CPE package on the market. For one low price, enjoy 12 months of access to every Surgent CPE course in every online format--plus unlimited CPE credits! This is the only package that includes premium courses, such as our late-breaking tax updates and specialized courses. Order a package now and you'll receive instructions via email from info@surgent.com. You'll be able to start registering for live webinars and accessing self-study courses right away. Earn as much CPE and explore as many topics as you'd like for one full year from the date of purchase. Pricing: As an LCPA member, you pay just $675– 25% off Surgent’s retail price!Package includes 12 months of access to: Over 8,000 credits 1,200+ live webinars 190+ self-study PDF courses 100+ on-demand webcasts Surgent's exclusive premium courses Why Choose the Unlimited Plus Package? Get unlimited 12-month access to ALL live webinars PLUS unlimited access to all self-study courses (including downloadable PDFs and on-demand webcasts). This package provides the best of both worlds: choose either interactive, instructor-led courses (with no exams) or self-paced, anytime-available learning for any topic you need! This is the ONLY Surgent package that includes access to all on-demand webcast Surgent webinars and self-study courses are constantly updated so no matter what format you pick, you'll get the latest information you need for your professional practice What Is Included in the Package? View all courses View webinars only View self-study courses only
Surgent's Unlimited Webinar Package
Available Until
Online/Webcast
0.00 Credits
Surgent's Unlimited Webinar Package 2024Get unlimited access to Surgent's webinar catalog. With 40+ webinars offered every week, including weekends, airing at a variety of convenient times throughout the day and evening, you’ll never have to worry about our webinars fitting in your schedule. And with the most modern webinar platform in the industry and interactive courses with renowned expert discussion leaders you’ll get the guidance and analysis you need with an unmatched customer experience. As an LCPA member, you pay just $525 – 30% off Surgent’s retail price! Order a package now and you'll instructions via email from info@surgent.com. You'll be able to start registering for live webinars courses right awayWhy Choose the Unlimited Webinar Package? Get unlimited access to over 1200 webinars Enjoy 12 months of access,?available one year from the date of purchase Includes 1-, 2-, 3-, 4-, and 8-hour options in all the topics CPAs need. Up to 5,000 credits! You'll earn live CPE credit without exams (certificates delivery within 24hours) All Surgent webinars feature high-quality audio and video, plus an easy-to-use attendance verification system (you'll just need to click the screen when prompted to verify that you're watching) Technical support and interactive Q&A are available throughout all webinars. What’s included? Click here to view the current course list. *Note: this package does not include premium webinars.