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 Power Query Series: Introduction and First Connection
Available Until
On Demand Only
1.00 Credits
This course is designed for the Excel user to begin their data analytics journey with an introduction to a product created for their skill set: Power Query, using the Excel version. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the first in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.
Surgent's Power Query Series: Making a Connection
Available Until
On Demand Only
1.00 Credits
This course explores the workflow of making connections to various data sources using the Excel version of Power Query. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the second in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.
Surgent's Power Query Series: Merge Queries
Available Until
On Demand Only
1.00 Credits
A merge query combines two queries that have a common column or columns. This course discusses best practices for creating merge queries using Power Query (Excel version) and includes hands-on exercises to enable the user to demonstrate what they have learned. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the eighth in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.
Surgent's Power Query Series: More Transformations and Load Options
Available Until
On Demand Only
1.00 Credits
Power Query (Excel version) offers a wide range of transformation options. This course uses hands-on exercises to explore the data transformation process, focusing on data cleaning and data enrichment. In addition, this course explains query loading options and processes. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the sixth in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.
Surgent's Power Query Series: Use Cases
Available Until
On Demand Only
1.00 Credits
This course presents five use cases for specific data issues a user may encounter in Power Query (Excel version). Through hands-on examples, users are guided through the process of overcoming each of these issues. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the tenth in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.
Surgent's Power Query Series: Useful Transformations
Available Until
On Demand Only
1.00 Credits
This course covers a number of useful transformations using Power Query (Excel version) to clean, enrich, and shape data. Coverage includes pivoting and unpivoting, filtering and grouping, fuzzy matching, and more, with hands-on exercises for users to practice these skills. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the ninth in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.
Surgent's Preparation and Compilation Engagements Under the SSARS
Available Until
On Demand Only
4.00 Credits
Be the go-to person on financial statement compilation and preparation engagements. Specifically designed for those performing preparation and compilation engagements, this course will provide you with a hands-on application for performing preparation and compilation engagements under AR-C Section 70 and 80, respectively. You will learn the ins and outs of relevant sections of the SSARS related to preparation and compilation engagements with a focus on how recently issued updates to SSARS No. 21 impact these engagements. More importantly, you will be provided practical examples and illustrations to help you effectively and efficiently perform those engagements, including a detailed discussion of the reporting requirements under AR-C 80 related to compilation engagement. Lastly, the course will review recent peer review feedback on these types of engagements, highlighting areas where you can improve engagement quality.
Surgent's Preparing C Corporation Tax Returns for New Staff and Paraprofessionals
Available Until
On Demand Only
8.00 Credits
This course is a great foundation to introduce new preparers to tax rules related to business returns. The course provides new staff coverage of tax areas affecting all business entities, providing staff training which they may carry to other business entity returns. Such business tax topics include the sale of assets used in any trade or business (Form 4797), depreciation (Form 4562), deductible vs. non-deductible items, and the basics of uniform capitalization. The objective of this course is to train new staff accountants, data processing employees, paraprofessionals, and bookkeepers to prepare a complicated federal corporate income tax return. It is a hands-on, practical course in filling out most tax forms, with extra emphasis on form changes due to new tax law.
Surgent's Preparing Individual Tax Returns for New Staff and Paraprofessionals
Available Until
On Demand Only
8.00 Credits
The objective of this course is to train new staff accountants, data processing employees, paraprofessionals, and bookkeepers to prepare a moderately complex federal individual income tax return (Form 1040). Over the years, thousands of new staff have received practical, hands-on experience to become familiar with tax forms. This course covers the latest tax law changes, making it essential for your new staff.
Surgent's Preparing Not-for-Profit Financial Statements
Available Until
On Demand Only
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.
Surgent's Preparing and Reviewing Client Prepared Financial Statements
Available Until
On Demand Only
2.00 Credits
The ultimate objective of a financial statement audit is to issue the independent auditor's report. This module discusses the process, introduces key elements of financial statements, and provides best practices for auditors who either prepare or review the client's financial statements. (Please Note: This module is part of Surgent's Audit Skills Training: Level 2.)
Surgent's Project Management: Tips, Tricks, and Traps
Available Until
On Demand Only
2.00 Credits
This past year has shown us the need for numerous projects and the need to manage those projects in a unique way. Project management is a way of thinking highly recognized and practiced by large organizations, but often neglected by the smallest companies and entrepreneurs. This course quickly discusses the basics of project management thought and practice and then spends the majority of the time exploring some of the greatest mistakes that can be made, the ways to avoid them, and some of the tricks that have been introduced into the discipline. In the program we will explore some of the specific types of project management as well as some of the available software programs to make the task of project management easier. In an effort to avoid talking theory without concrete examples, we will often use examples born from projects needed as a result of our experiences with COVID-19.
Surgent's Proven Controls to Steer You Clear of Fraud
Available Until
On Demand Only
4.00 Credits
Every organization in the world will fall victim to fraud. This course will cover the means and methods available to reduce the prevalence of fraud. We will also discuss the controls that victim organizations employ in order to seek improvements for our own organizations.
Surgent's Public Speaking and Presentation Skills
Available Until
On Demand Only
2.00 Credits
Gerald Ford once said that "[n]othing in life is more important that the ability to communicate effectively." Public speaking remains a centuries-old skill that allows individuals to effectively communicate both at a personal and professional level. The benefits of good public speaking run long, whether it be the ability to persuade others, lead a team, or encourage critical thinking. This course is designed to refresh and refine speaking skills for professionals. Through this webinar, participants will gain a better understanding of the core skills of how to communicate effectively in groups - big or small. The webinar is intended to help those who already speak in public better improve their skills, while at the same time teaching more novice speakers how to approach a task that so many professionals dread - speaking in front of others.
Surgent's Quality Management and Peer Review
Available Until
On Demand Only
2.00 Credits
Regulators, investors, other capital markets stakeholders and users of the financial statements need accurate and transparent financial information for decision making. One reason that why the capital markets are as efficient as they are today, is that users believe that they can trust audited financial statements, in part, due to the fact that they are audited. The AICPA instituted its Enhancing Audit Quality Initiative in 2014 to help to improve regulator and stakeholder trust when it was being questioned. Education, outreach and changes to the peer review program have helped to increase audit quality over the last 8 years. In early 2021 the Auditing Standards Board issued an exposure draft that would make significant changes to the requirements that firms implement a system of quality control. The new standard will require a risk-based approach to quality management and enhance the guidance on the role of the engagement quality reviewer and the audit partner. This module will discuss these topics including the proposed changes to the quality standards which are expected to be effective in 2024. (Please Note: This module is part of Surgent's Audit Skills Training: Level 5.)
Surgent's Raising Financially Capable Children
Available Until
On Demand Only
2.00 Credits
This course focuses on the main elements of financial education and will help accounting and finance professionals guide their clients, and their clients' children, through a personalized teaching roadmap. Clients with wealth face questions about how to teach their children about money to raise financially capable children. Often, their first contact is to their accounting and financial professionals, so it is important to be able to provide a framework to help teach clients how to prepare their children for life with privilege. This course is designed for all practitioners who want to help their clients navigate the process of teaching the next generation about personal finances. Because every family and child are different, it is critical to develop a specific plan for each client, and likely each child and grandchild. By working with their clients' descendants, accounting and finance professionals not only build rapport and trust but also get to know the children and grandchildren, building firm value and long-term connection.
Surgent's Real Estate Taxation: Critical Considerations
Available Until
On Demand Only
4.00 Credits
This course is a 'deep dive' into many aspects involving the taxation of real estate for the mid-level practitioner moving into this complex area. You will deepen your understanding of the complex considerations and strategies that individuals must navigate in acquiring, operating, and selling real estate. You will leave the course able to navigate critical issues associated with the relevant returns and plan strategically for your company or clients. We will discuss in detail the impact that recent tax changes have had on the real estate industry, as well as new credits that are available after the Inflation Reduction Act of 2022.
Surgent's Recruiting and Retaining Next Gen Talent
Available Until
On Demand Only
1.00 Credits
When it comes to attracting the best talent, it is imperative to know your audience. It is critical for employers and managers to understand Next Gen employees (those born in 1980 or later), as this group is expected to comprise 62% of the workforce by 2025. To be successful, accounting and related professionals should understand how to create strong relationships with Next Gen talent, some of the most talented, energetic components of the workforce. Using sound research as a guide, this webinar addresses guidelines and procedures that have proven successful in attracting and retaining Next Gen employees so that companies can continue to grow.
Surgent's Reducing a Business Owner Client's Exposure to Social Security and Self-Employment Taxes
Available Until
On Demand Only
2.00 Credits
Many business owner clients wish to minimize their Social Security and self-employment tax liabilities. This course provides tax practitioners with the background to understand what kinds of income constitute self-employment income and earned income. It covers strategies that can be used to reduce clients' exposure to the self-employment tax and Social Security tax.
Surgent's Reporting Internal Control Deficiencies Under the Yellow Book
Available Until
On Demand Only
1.00 Credits
The Yellow Book contains performance and reporting requirements related to internal control deficiencies. This course is designed to help you understand these requirements and excel in applying them. We will also examine where the auditor draws the line as to whether an internal control deficiency is a significant deficiency or a material weakness.