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 Excel Tables and Conditional Summing
-
Online
2.00 Credits
In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.
Surgent's Critical Conversations
-
Online
2.00 Credits
As uncomfortable as some conversations are, keeping your silence won't resolve the issue and may in fact add to it. No matter which side of the table you find yourself at in a "hard to have" talk, you can learn to benefit from the conversation. In the workshop, you'll learn how to recognize when a conversation becomes critical, how to plan effectively for the conversation, and which communications strategies can help you create a win/win outcome.
Surgent's Mastering Client Management for Accounting and Finance Professionals
-
Online
2.00 Credits
Do you want to build stronger relationships with your clients, improve client retention, and drive growth in your practice? This course delves into the essential strategies for effective client management in today's competitive landscape. Client relationships, like any relationship, can be challenging to manage. Miscommunication, differing work styles, and unrealistic expectations are some of the challenges accounting and finance professionals routinely encounter. However, when accounting clients and members of your team are on the same page, client loyalty and profitability improve while conflict is minimized. This webinar explores proven strategies to improve relationships between accounting and finance professionals and their clients.
Surgent's Preparation and Compilation Engagements Under the SSARS
-
Online
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 Guide and Update to Compilations, Reviews, and Preparations
-
Online
4.00 Credits
Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-25 by the ARSC. The course will also review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARSs requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform compilation, preparation, and review engagements.
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 Enterprise Risk Management Concepts and Strategy for Small and Medium-Sized Companies
-
Online
4.00 Credits
2020 taught us that major risks can come at us from any direction and with barely a warning. All organizations operate in a risk environment, but all too often, they either don't realize it or they don't develop a strategy to deal with the risks. In this session, we will explore how risks work in both for-profit and not-for-profit organizations and how they can develop a strategy to identify, evaluate, and mitigate those risks. This program will not teach how to eliminate risks, but how to strategize how to reduce their total effect. We will liberally use case studies of both for-profit and not-for-profit companies to bridge the gap between concept and actual implementation. In each area we will explore what our experiences of the pandemic have taught us about this part of risk management.
Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Online
2.00 Credits
Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work.
Surgent's Client Advisory Services (CAS): A Guide to the Variety of Offerings Professionals Can Provide
-
Online
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.
Surgent's Preparation and Compilation Engagements Under the SSARS
-
Online
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 Excel Budgeting Ideas
-
Online
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.
Surgent's Preparing Not-for-Profit Financial Statements
-
Online
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.This course qualifies for yellow book credit.
Surgent's Understanding How the IRS Rewards Whistleblowers
-
Online
2.00 Credits
In 2006, Congress passed the Tax Relief and Health Care Act. Prior to the Act's passage, rewards to individuals who provided information to the IRS regarding tax fraud were capped at $10 million. The Tax Relief and Health Care Act authorized the IRS to create a Whistleblower Office dedicated to investigating, processing and recovering claims concerning the underpayment of taxes. Under the IRS' new program, whistleblowers may recover 15 to 30 percent of the amount collected provided the taxes and amounts in dispute exceed $2 million. If the whistleblower's claim does not meet these criteria, the IRS may still consider granting an award under its pre-2006 Tax Relief Act discretionary authority. Given the rapid growth of this program, practitioners should have a basic understanding of the procedure and content for IRS Whistleblower claims, both from the perspective of a claimant's potential to recover and a taxpayer's exposure to liability.This course qualifies for IRS credit.
Surgent's Gaining a Competitive Advantage: Critical Skills for CFOs and Controllers
-
Online
4.00 Credits
All organizations are looking for ways to gain an advantage over the competition. This practical and interactive session will present a toolkit of ideas to help CFOs, controllers and finance professionals better position their organizations for the future. We know change is occurring at an exponential rate, and that has proven to be the case in all areas of finance, management, and leadership over the past year. The course deals with these new issues and will continue to be updated as necessary throughout the year. Become the "financial hero" of your organization and make a positive impact on the bottom-line.
Surgent's Getting Ahead: The Art of Marketing for CPAs
-
Online
2.00 Credits
To many clients, CPA firms all look the same. While services and specialties may vary significantly from one firm to another, it is hard for the average person to see this by simply looking at the sign outside our office door. Is there any way to make us stand out more to the outside world? Through surveys, statistics, and examples, this course looks at how CPA firms can develop a marketing plan beyond just relying on referrals. We look at the pluses and minuses of various marketing channels, regulatory constraints, and how to measure success in the competitive financial services space.
Surgent's Going Out on Your Own: Entity Types and Accounting Methods
-
Online
2.00 Credits
Starting a business is tough! There are lots of decisions to be made and things to think about. You may feel like you have a great idea. You have done your marketing research, developed a prototype, and even looked at locations for your new office. Then it dawns on you.. What type of entity do I need to be? Is there really an advantage to choosing one entity type over the other? In this class, we will dig into the differences between entity types - from taxes to liability. We will also look at the advantages and disadvantages of different methods of accounting. Whether you are a small business owner looking to start something new or a practitioner looking to expand your client advisory services, this course is the one for you!This course qualifies for IRS credit.
Surgent's Managing Millennials
-
Online
2.00 Credits
By 2025, millennials will represent 75% of the workforce. Whether you are an owner of a small practice or manager in a multinational corporation, it is important to understand characteristics and expectations of this large segment of the workforce. Research reveals that many of the common stereotypes surrounding millennials are unfounded and counterproductive. This course provides an understanding of who millennials are in comparison to their predecessors, the Gen-Xers and baby boomers. Equally important, the presentation will look at common myths regarding millennials and why understanding this class of employees provides opportunities for your organization to grow and succeed.
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 Features and Benefits of SEP IRAs and SIMPLE IRAs
-
Online
2.00 Credits
A challenge for many small business owners is choosing the `right' type of retirement plan for their businesses. Many hesitate to make a choice because they are intimidated by the governing rules. In those cases, an IRA-based retirement plan is an easy, effective, and efficient way to start a retirement plan. These IRA-based plans - SEP IRAs and SIMPLE IRAs - have low maintenance costs and are easy to communicate to employees. In some cases, employer contributions are discretionary, providing the business owners with the choice of whether to fund every year.