CPE Catalog & Events
K2's Excel Tips, Tricks, and Techniques for Accountants
-
Online
8.00 Credits
Member Price: $225
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. Delivery Method: Individual webcastCPE Credit: Accounting, Computer software & applicationsProgram Level: Intermediate
How Changes in Business Methods Affects Internal Control
Online
8.00 Credits
Member Price: $239
New Technology, the move toward telecommuting, the widespread adoption of electronic documentation, and a wide range of other factors have significantly and forever changed the way business is conducted. It should go without saying that changes in tools and methods lead to upheaval in any organizations internal control system. In this session, we look at all the changes that are occurring and discuss what's coming in the not too distant future. The material then looks at how internal controls have been affected and what other updates are on the horizon. Anyone trying to use controls to keep their organization efficient and secure should consider this session because the rate of change to both operational methods and control processes has been and will continue to be incredible. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Surgent's A Complete Guide to the Yellow Book
Online
8.00 Credits
Member Price: $279
If you work with governments and not-for-profits, a thorough understanding of the Yellow Book is essential. This course will equip you with a comprehensive knowledge of the Yellow Book requirements and increase your confidence and proficiency in performing Yellow Book audits. Updated for the 2024 Yellow Book revision, the course materials utilize a highly illustrative and innovative format. Over 20 focused exercises are included to provide an enhanced knowledge of the Yellow Book.Delivery Method: Individual webcastCPE Credit: Auditing (governmental)Program Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Audits of 401(k) Plans: New Developments and Critical Issues
Online
8.00 Credits
Member Price: $299
One of the most favored employee benefit plans, the 401(k) plan, provides unique challenges for auditors. Through this course, auditors will obtain an understanding of the rules and regulations unique to employee benefit plans and obtain practical guidance on applying them. Auditors will enhance their knowledge of the performance and reporting requirements through real-world examples, best practices, and efficient audit techniques that can be utilized in various audit engagements. Make sure your audits don't trigger a DOL inspection by conforming to all applicable rules and regulations.Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Fiduciary Income Tax Returns - Form 1041 Workshop with Filled-in Forms
Online
8.00 Credits
Member Price: $279
This course is designed as a comprehensive guide to the core concepts of trust and estate income tax preparation. The course explains the common terminology and complicated income tax rules of estates and trusts, fiduciary accounting, and an introduction to or refresher on preparing Form 1041. This practical, over 300-page manual is an excellent reference source for your practice, which begins with quite simple cases. Building upon that base throughout the manual, the course ends with two complicated preparation cases, one trust and one estate, each with filled-in forms.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Long-Term Care Insurance: Make the Switch
Online
1.00 Credits
Member Price: $55
How to pay for the cost of long-term care remains a primary concern for most clients over the age of 50. Explore clients' motivations, misconceptions and objections to purchasing long-term care insurance, and a look at the latest long-term care solutions, including hybrids. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: Specialized knowledgeProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Fundamentals of Form 1040 -- Individual
Online
4.00 Credits
Member Price: $149
This course introduces professionals to the fundamentals of individual tax preparation. Participants will learn the essentials of Form 1040, including filing requirements, income reporting, and deductions. The session will also cover preparer responsibilities, due diligence, and taxpayer rights under Circular 230. By the end, attendees will have a solid understanding of the foundation of personal tax returns. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
See more dates
K2's Harnessing ChatGPT - Unlocking Professional Efficiency
Online
1.00 Credits
Member Price: $39
Enhance your productivity and streamline your accounting practices with ideas learned in this course. This dynamic program, designed specifically for accountants seeking a competitive edge, delves into the practical applications of ChatGPT in your daily workflow. From conducting comprehensive research and crafting compelling correspondence to swiftly addressing technical inquiries and optimizing Excel formulas, you will gain invaluable skills to expedite your tasks and improve overall efficiency. Furthermore, we will delve into the power of ChatGPT plugins, equipping you with the knowledge to process PDF documents seamlessly and efficiently navigate the vast expanse of the web. Join us on this transformative journey and unlock your potential as a proficient and empowered accountant. Delivery Method: Individual webcastCPE Credit: Information technologyProgram Level: Basic
K2'S Supercharging Your Spreadsheet Collaboration
Online
1.00 Credits
Member Price: $39
Collaboration is a key to productivity and success. But remote work can make collaboration more challenging, including collaborating on spreadsheets. Fortunately, tools such as portals with check-in/check-out capabilities, version control, comment tracking, and co-authoring can enable online spreadsheet collaboration. Further, Excel’s Inquire tool can facilitate spreadsheet collaboration in offline environments. Don’t let remote work hamper your spreadsheet collaboration needs! Participate in this session to learn how to collaborate on spreadsheets effectively from anywhere using tools you already own or license. Delivery Method: Individual webcastCPE Credit: Information technologyProgram Level: Intermediate
Employees Today and Tomorrow : Are Employees Assets?
Online
2.00 Credits
Member Price: $79
As the managers' role continue to evolve, it is crucial for us to understand the strategic aspects of managing a diverse workforce, beginning with understanding the big trends in employee demographics. We begin with a rhetorical question - asking if employees are assets? GAAP tells us they are not, so discussion will revolve around whether this treatment delivers an unhealthy bias on our view of the people in our organization. What do the most successful organizations believe and why? If you have an opinion as to whether employees are an asset or not, this is a fun session intended to be interactive with participation either live, virtual or both. Delivery Method: Individual webcastCPE Credit: Business management & organizationProgram Level: Intermediate
Communicating in a Virtual and Live Environment - Numbers Matter But So Do Words
Online
2.00 Credits
Member Price: $79
People fear presenting more than they do “death”. Communicating numbers is a scary proposition to overcome for both the presenter and the recipients. This course is designed to enhance the communication skills of CPAs and CFOs by emphasizing the importance of understanding and mastering the facts before delivering any presentation, understand the key elements of presenting a narrative, and provide examples to engage live and virtual teams in effective numbers presenting. The goal is to equip financial professionals with the tools needed to overcome fears and provide the best practices research on all types of presentations-from communicating complex financial information effectively to conducting a casual virtual meeting. This is a fun session intended to be interactive with participation either live, virtual or both. Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Intermediate
Depreciating & Expensing Business Assets
Online
2.00 Credits
Member Price: $79
This course will address recent tax legislation, rules, and developments related to capitalization and depreciation; Section 179 and 168(k) 100 % bonus deduction; Depreciation of automobiles, including new luxury auto limits; ADS depreciation for electing farm and real estate business. **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. Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Intermediate
Effectively Responding to IRS Letters
Online
2.00 Credits
Member Price: $79
This course equips tax professionals with the knowledge and strategies needed to handle the most common IRS letters, including general notices, audit requests, collections, return inquiries, and error notices. Participants will learn how to interpret IRS correspondence, adhere to response deadlines, and effectively communicate with the IRS to resolve issues and minimize risks. The session also highlights best practices for ensuring compliance and avoiding penalties or escalation, empowering attendees to navigate IRS correspondence with confidence. *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 Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Intermediate
K2's Taking Another Look At PDFs
Online
2.00 Credits
Member Price: $79
We’re all familiar with PDF documents. However, it’s safe to say that most professionals use only a tiny fraction of their features. This circumstance is unfortunate, considering all you can do with PDF documents. Therefore, isn’t it time to take another look at PDF K2’s Taking Another Look At PDFs documents and all you can do with them? Participate in this session to learn more about PDFs and how and why they should be a cornerstone technology in most organizations. Collaboration options, long-term storage and archival, and fillable forms are just a few features you will learn about in this session. If you’re ready to elevate your PDF productivity, this session is for you! Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Intermediate
Mergers & Acquisitions: Tips and Speed Bumps to Avoid
Online
2.00 Credits
Member Price: $79
Mergers, acquisitions and alliances have been and continue to be major avenues to organizational growth and increased competitive advantage. Despite the great initial promise of many mergers and alliances, few seem to yield the anticipated results. Numerous studies indicate that between 55% and 77% of mergers fail to accomplish their intended purpose. This course helps financial professionals, and their advisors identify, execute, and consummate mergers and acquisitions that create shareholder value while avoiding the many traps that can cause post-acquisition failure. Delivery Method: Individual webcastCPE Credit: Business management & organizationProgram Level: Intermediate
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
Online
2.00 Credits
Member Price: $99
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.Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Hiring and Firing of Employees - What You Can and Cannot Do
Online
2.00 Credits
Member Price: $99
There are numerous federal laws that restrict what businesses can do in terms of hiring and firing employees. Many of these laws impose significant penalties if employers violate them. Accordingly, it is crucial that all employers and their professional advisors understand these laws and apply them to their employment practices.Delivery Method: Individual webcastCPE Credit: Business lawProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
See more dates
Using AI to Instantly Transform Ideas into Revenue Streams
Online
2.00 Credits
Member Price: $89
Learn practical strategies to increase revenue generation using AI-driven ideation methods. This course provides a concise overview of cutting-edge artificial intelligence tools and methodologies that enable professionals to transform innovative ideas into sustainable revenue streams. Through a practical, hands-on approach, participants will explore various AI platforms and workflows that streamline the process of creating digital assets, content, and products. The course emphasizes real-world applications and demonstrates how to leverage AI technology to diversify service offerings and generate new income sources. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: Information technologyProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Taxation of Business Entities
Online
2.50 Credits
Member Price: $79
This course will introduce you the different types of business entities and the tax implications of contributions, distributions and earnings, among other topics. **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 Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Basic
Financial Statement Presentation and Disclosure
Online
4.00 Credits
Member Price: $129
This comprehensive session is a must-attend event for any professional accountant who prepares financial statements for either a private enterprise or a firm client. We illustrate best practices for presentation and disclosure by revisiting fundamentals of financial reporting for various industries. This workshop explores best practices for United States GAAP in addition to considerations for special purpose frameworks. Experienced accountants will benefit from a refresher whereas other accountants will appreciate formative skill-building insights. Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Intermediate