CPE Catalog

K2's 2023 Excel Tips, Tricks, and Techniques for Accountants

Excel is the accountant’s tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Regardless of your level of experience, if you use Excel, you need this course to learn more efficient and effective ways to work with Excel. In this course, you will discover countless tips, tricks, and techniques to improve your general level of productivity, reduce the amount of time you spend on mundane tasks, such as formatting, and customize Excel for greater accuracy and efficiency. You will also learn valuable formula-building skills, best practices for linking Excel data from other worksheets and workbooks, and how to streamline report generation and printing processes. Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples that will improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience in delivering spreadsheet training to accounting and financial professionals, which assures you of the relevance and usefulness of the information and guidance provided during the program.

Advanced Negotiations: Beyond Getting to Yes

Anytime someone says "I want," "I need," or "Will you," you are in a negotiation. For decades, the negotiation techniques described in "Getting to Yes" by Fisher and Ury of the Harvard Negotiations Project were the world's standard negotiation methods. These techniques involved collaborative methods for discovering how to make the "pie" bigger and then split it. More recent research on human psychology has revealed new methods that will allow you to do even better. Sometimes, you can't settle for getting half of what you want. Sometimes you have to have it all. This webinar explores negotiation's human side, to give you powerful people skills that will let you get more. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Retirement Planning: Next Stage for You or Your Client

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.

Surgent's Ethical Considerations for the CPA

CPAs today face greater challenges than ever to maintain the high ethical standards of their profession. It is vitally important that all CPAs understand their professional responsibilities related to all aspects of their job. This course, which focuses on key components of the AICPA Code of Professional Conduct, reviews a history of the CPA profession and focuses on ethical requirements that CPAs must adhere to in their everyday practice, including practical examples of potential ethical dilemmas that practitioners may encounter, particularly those related to objectivity and independence. PLEASE NOTE: THIS COURSE COVERS GENERAL ETHICS AND IS APPLICABLE IN STATES IN WHICH STATE-SPECIFIC ETHICS IS NOT REQUIRED. This course does not qualify for IRS credit.

A Culture of Regulatory Ethics: A Competitive Advantage

In a competitive market, every company is looking for anyway to differentiate themselves from their competition. While we often look to new markets and data for a competitive advantage, ethics can be the factor that makes the biggest difference to customers, employees, and the public at large. Using surveys, research, case studies, and examples, this course will explore why the CPA credential and the AICPA Code of Professional Conduct is so different. We will discuss why CPA's are in a unique position of trust and how this can put their companies ahead. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

2025 Business Tax Update: Staying Ahead in Business Taxation

Get ready to elevate your tax game with the 2025 Business Tax Update, designed exclusively for tax practitioners looking to sharpen their skills in business income taxation. This course doesn't just scratch the surface – it thoroughly explores the complexities of the tax code, ensuring you're equipped to navigate the ever-evolving tax landscape with confidence. From recent legislative updates to complex tax considerations like COVID-19-related subsidies, this course covers it all. Gain practical strategies and insights that you can immediately apply to assist your clients in optimizing their business income tax planning. Don't miss this opportunity to stay ahead in business taxation and enhance your expertise in a rapidly changing regulatory environment. With a focus on real-world application and comprehensive exploration of essential topics, the 2025 Business Tax Update promises to be a game-changer for your tax practice. Whether you're dealing with partnership, corporation, or LLC taxation issues, this course provides precise guidance tailored to diverse business clients. Plus, you'll gain invaluable insights into recent legislative changes, including their implications on tax code sections like Section 199A. Stay at the forefront of business taxation and ensure you're delivering top-notch advice to your clients by enrolling in this essential course today. **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.

Applying the Uniform Guidance in Your Single Audits

Designed to provide you with the knowledge to be more efficient and effective at planning and performing audits in accordance with the requirements of the Uniform Guidance and the Single Audit Act, this course examines how the Single Audit Act relates to OMB Uniform Guidance, as well as the different types of guidance and requirements found in the Uniform Guidance. The course also covers responsibilities and requirements of the auditor and the auditee, how to identify federal assistance and how to determine a nonfederal entity's major programs. Make sure your skills are up to date with the latest information in this challenging audit area.

S Corporations: Key Issues, Compliance, and Tax Strategies - Tax Staff Essentials

New or existing clients and businesses need assistance with the most misunderstood areas of S corporations taxation and how they can use them to their advantage. Be prepared to explain the benefits and drawbacks of electing S corporation status and why business taxpayers may favor the pass-through entity over the C corporation. This course will give you the knowledge you need to speak effectively to potential business clients and existing shareholders about the S corporation business model that may work for them.

Surgent's Annual Accounting and Auditing Update

Designed for accounting and attestation practitioners at all levels in both public accounting and business and industry, this course provides a comprehensive review of recent standard-setting activities of the FASB and AICPA. In addition to providing a detailed review of SAS No. 145, this course will bring 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 you apply the guidance in practice. In addition to a financial accounting update, the course will discuss what you will need to do differently as you adopt new audit standards 142-149 over the next few years, including a detailed review of the new audit requirements under SAS 142. The course will also cover the key changes related to SSARS No. 25. Finally, the course reviews the AICPA's quality management project. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.

Surgent's The Complete Guide to Payroll Taxes and 1099 Issues

Employment taxes are often overlooked as an area where more planning may be effective. Payroll taxes have become an increasing burden for the average business, and IRS penalties for noncompliance have risen dramatically in recent years. They have also been subject to employer incentives. The Service has announced that uncovering noncompliance by employers ranks high on its audit list. This course presents a comprehensive overview of federal payroll taxes, Form 1099, and related compliance issues.

The Best Federal Tax Update Course by Surgent

In this continually revised course, tax advisors will be fully updated on the most recent enacted legislation and IRS guidance, as well as major trends on the horizon with a view toward planning considerations. This update course is designed for all practitioners, both those working in public accounting as well as those in private industry, who need the latest information on tax changes. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BITU.This course qualifies for CFP credit.This course qualifies for IRS credit.

Understanding and Creating an Internal Control System

Successful organizations, both large and small, must understand the importance of effective internal controls and be able to develop a system of controls that will keep the entity on its intended course. Moreover, those that design policies and procedures benefit by knowing why control measures are necessary. This session sets forth internal control concepts and explains the importance of strong internal control policies. The material highlights some of the reasons that measures are needed and it also provides an overview of control creation methods. Finally, it discusses ways to successfully implement the developed policies and procedures. Participants that take this course will gain a well-rounded understanding of internal control procedures of all types. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Partnership/LLC Taxation: Tax Basis Capital Accounts

This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes. Emphasis will be placed on partners "tax basis" capital accounts, now required for tax form reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Wealth & Asset Management Conference - A Virtual Event

Social Media: The Bare Necessities

Social media has become a ubiquitous phenomenon in our business world. However, just because it exists is not a good reason to use it. This workshop is designed to give you an overview of the social media landscape to help you decide if you want to engage with and on social media and, if so, what channel(s) are most strategic for you and your business. The workshop ends with a simple framework to help you use social media as a credibility strategy for your business, giving you a strategy for creating a year's worth of social media content in a single day.

The Head and Heart of Ethics - Featuring Bob Mims and Don Minges

There are multiple facets to ethical choices, including should you use your ‘head’ or your ‘heart’? What are the pros and the cons?  How can we balance these opposing views?  This seminar outlines the value of; trust, courage, fairness, sensitivity, persistence, honesty and gracefulness – to help us make better ethical decisions.

Avoiding Budget People Issues: Managing Budgeting's Soft Side

The budgeting process can be a time consuming and frustrating process for accountants.  The constraints and pressures can lead to poor decisions in both the technical and human components.  This session will cover: Avoiding Budget People Issues:  Managing Budgeting’s Soft Side •    Financial plans have a technical component and human component.  We can resolve some of our budget issues by exploring the process’ human aspect.  This session includes a case study that measures an individual’s personality type and then explores how to use our strengths and weaknesses to create to a better plan.  

Advanced Cost Accounting

Organizations that use primitive costing methods make predictable mistakes. They allocate too much cost to easy, high-volume "gravy" products and too little cost to difficult, low-volume "dog" products. This puts the organization with inferior information at a significant disadvantage against a competitor who has a better cost model. The secret to having a great cost model is learning how to deal with overhead. This webinar will show you how to assign 16 key categories of overhead. Whether you work in a wholesale, retail, health care, service or manufacturing business. This session will give you important insights into how to handle overhead. If you get your costing right, you will be able to give the "dogs" to your competitors and keep the "gravy" for yourself.

Surgent's Top 20 Questions Advisors Ask About the SECURE Acts and Other IRA Rules

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.

Become Rich Without Selling Your Soul

Getting rich requires many things.  First, you need to know how to overcome previous limitations you may have had about making a lot of money.  Second, you need to know and use the best financial strategies for becoming wealthy--including the latest investment and marketing strategies.   And third, you need to be able to enjoy your lifestyle, and look at what obstacles get in the way of you being rich and fully contented.  By exploring the latest methods for achieving financial and personal success, you'll be able to make a lot more money and have a great time doing it.