CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Online
2.00 Credits
How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Online
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.
Surgent's Unique Tax Attributes of Different Entity Types
-
Online
2.00 Credits
When putting together a financial plan, it is important to remember that the tax situation of the business and the individual are often intertwined. Therefore, decisions about entity type are vitally important. Practitioners need to understand not only how different entities are taxed, but also which taxes will have the greatest impact on the individual owner. In this course, we will explore when self-employment taxes apply to business income, as well as some of the lesser-known taxes that apply to flow-through entities. We will even explore when a PTE election could be helpful to a small business owner.This course qualifies for IRS credit.
Surgent's Advising a Client Regarding the Tax Consequences Associated with Buying or Selling a Business
-
Online
3.00 Credits
Buying and selling a business can be a complex transaction with many tax issues. These issues include whether the transaction is or should be a stock or an asset sale when the business involved is a corporation, as well as the tax consequences associated with the sale of a partnership or a C or S corporation. Tax practitioners who advise clients who are buying or selling a business primarily focus on the tax issues that apply. This program explains and analyzes the tax issues practitioners must address in order to properly advise clients who are either buyers or sellers of businesses.This course qualifies for IRS credit.
Surgent's Current Issues in Accounting and Auditing: An Annual Update
-
Online
4.00 Credits
Designed for accounting and attestation practitioners at all levels in both public accounting and business and industry, this course provides a detailed review of SAS No. 145 and brings you up to date on FASB and AICPA standards issued over the past few years. The course also provides many hands-on examples and illustrations to help apply the guidance in practice and discusses other important A&A practice matters to be aware of, including an update on peer review and audit quality.
Surgent's Anatomy of a Ransomware Event and Incident Response
-
Online
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.
Surgent's Business Writing: Professional & Effective Emails
-
Online
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.
Surgent's Business Law for Small Business Owners
-
Online
4.00 Credits
One of the most intimidating aspects of going into business for yourself is compliance. Tax, employment, and regulatory laws are difficult to navigate, so it often falls on the CPA to know the basics in these areas to help their clients avoid costly litigation. In this course, we will cover basic compliance areas for small business owners. We will look at the main elements of a contract, taxation of entity types, worker classification, property law, and many of the other areas that are often overwhelming for small business owners. By being able to speak to these issues, practitioners will be able to add value and help their small business owner clients grow and thrive.
Surgent's Real Estate for Accounting and Finance Professionals
-
Online
2.00 Credits
Explore the intricacies of federal income taxation as it intertwines with rental real estate activities. This course delves into the calculation of rental income, understanding the nuances of deductions, and unraveling the complexities of passive activity loss rules. Whether it's mastering Schedule E or understanding Congress' intent behind tax laws, professionals will leave with an enriched understanding.This course qualifies for IRS credit.
Surgent's Sale and Transfer of Energy Credits: Final Regulations and IRS Guidance
-
Online
2.00 Credits
The Inflation Reduction Act of 2022 included significant business credits for energy investments in vehicles, manufacturing, alternative fuels, and carbon capture, effective for tax years beginning on or after January 1, 2023. As part of this legislation, Congress authorized two novel credit delivery mechanisms: direct pay of the credit under Section 6417 and transfer or sale of the credits under Section 6418. This course will focus on final regulations under these two Code sections, enabling tax practitioners to confidently advise their clients regarding claiming, transferring, and purchasing credits.This course qualifies for IRS credit.
Surgent's Unconscious Bias for Managers, Supervisors, and Executives
-
Online
2.00 Credits
Understanding unconscious bias is key to creating an inclusive workplace and to making the best business decisions. This course explores the concept of unconscious bias, the science behind it, and how it can affect the way employers hire, evaluate, and treat employees. We will also discuss strategies employers can use to reduce unconscious bias and create a more inclusive workplace.
Surgent's Ethical Considerations for CPAs
-
Online
2.00 Credits
As accounting firm's non-attest offerings to their attest clients become more diversified, such engagements increase firms' exposure to independence violations. In order to thread the needle of providing value-added services and upholding their independence obligations, firms need to have a strong foundational understanding of the applicable ethical and independence rules which govern these engagements. In this course, we'll review the relevant sections of the AICPA Code of Professional Conduct regarding independence, objectivity, and conflicts of interest. The course will focus on the Code's Independence Rule and common threats to auditor's independence. In particular, the course will focus on those unique considerations related to non-attest services, both from the perspective of AICPA interpretations and other applicable rules and regulations. PLEASE NOTE: THIS COURSE COVERS GENERAL ETHICS AND IS APPLICABLE IN STATES IN WHICH STATE-SPECIFIC ETHICS IS NOT REQUIRED.
Surgent's Controller/CFO Update: Hot Topics Facing Today's Financial Professional
-
Online
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.
Surgent's Ethics for the Industry Accountant
-
Online
4.00 Credits
While ethics training is required by many states, the true value of the CPA license is in understanding how critically important ethical behavior is to our customers, our firms, and the public. This course will explore the basic tenets of ethical behavior and use case studies to explore ethical dilemmas in various companies and organizations with a focus on dilemmas that may face CPAs in the industry.
Surgent's How to Effectively Represent Clients Under IRS Audit
-
Online
2.00 Credits
Increased funding resulting from the enactment of the Inflation Reduction Act will allow the IRS to target many more wealthy individuals and large businesses for audit. These efforts will become more intense over the next several years as the IRS employs artificial intelligence in more of its audits. This program discusses how and when the IRS's energized audit efforts will result in more audits of taxpayers and what attendees need to know to effectively represent clients that the IRS audits.This course qualifies for IRS credit.
Surgent's Excel Shortcuts for Accountants
-
Online
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.
Surgent's Top 20 Questions Advisors Ask About the SECURE Acts and Other IRA Rules
-
Online
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.This course qualifies for IRS credit.
Surgent's Engagement and Client Retention Best Practices
-
Online
2.00 Credits
Positive client relationships require work. Miscommunication, unrealistic expectations, and differing personality styles may strain a client's relationship with professional advisors. Fortunately, there are tested strategies that foster and strengthen client relationships. Creating appropriate boundaries early on is one of many effective strategies that can help. This course explores actions accounting and finance professionals can take to create and grow their client relationships. This webinar provides actionable insights on how to engage new and old clients alike. Strained client relationships can harm both the client and the firm's profitability. Yet automation, for example, allows some firms to remain more engaged while others miss the mark. There is a science underlying client retention that involves understanding the client journey, ensuring consistent client interactions, and equipping employees with the tools needed to satisfy client needs. Understanding these skills should help you protect the relationships that sustain your business.
Surgent's Social Security: Dispelling Common Myths with Essential Truths
-
Online
2.00 Credits
For roughly 90% of American retirees, Social Security income will be the foundation of their retirement income. Yet, many are ill-prepared and lack understanding of the critical aspects of making an informed claiming decision. Further challenged to separate fact from fiction, consumers crave accurate information from knowledgeable professionals to make the most out of these coveted monthly benefits. This course dispels common myths about Social Security that lead to confusion and replaces them with the truth to an empowered retirement. Help your clients navigate their claiming age decisions with greater confidence, equipped with the essential truths they should consider before pushing the Social Security "on" button.
Surgent's Workplace Harassment: How to Prevent Harassment and Reduce Liability Risks in Today's Changing Environment
-
Online
2.00 Credits
Workplace harassment - especially sexual harassment - has dominated headlines in light of the #MeToo movement. While nothing suggests that such harassment is more prevalent than it was before the movement, people now feel more empowered to speak out, and the standard of appropriate workplace conduct is changing. With harassment claims to the U.S. Equal Employment Opportunity Commission increasing over 50% in 2018, it is more important than ever to understand how to prevent and avoid harassment in the workplace.