CPE + Events Catalog

If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2’s Advanced Excel. In this laptop-friendly program, you will learn critical advanced Excel skills in six key areas: 1) collaborating with other users and securing workbooks, 2) using tables to analyze and report data, 3) integrating and manipulating data from external sources, 4) creating and auditing complex formulas, 5) advanced data analysis tools, and 6) visualization techniques to analyze and communicate information. The course draws from over twenty-five years of experience delivering Excel training to accountants and other business professionals. Throughout the program, relevant, real-world examples reinforce the topics presented. Take advantage of this opportunity to become more efficient and proficient in Microsoft Office Excel, the tool of choice for accounting and financial professionals. This course covers advanced Excel topics found in Excel 2019 and newer.

This course provides in-depth information to enable the practitioner to make a well-informed decision as to whether a trust is the appropriate vehicle for a client’s financial, estate, and/or asset protection plan, and, if so, how the trust can best be implemented and operated. Participants will learn about the many different types of trusts that can be harnessed to save clients income, estate, generation-skipping, and other taxes, at both the federal and state level.

This course begins with a look at the GASB standards effective this year, including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We'll include practical application of the topics in the form of case studies. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course shows how undisciplined decisions in business can lead to government investigations and prison terms. We profile three entrepreneurs from three separate industries who built billion-dollar enterprises. Despite well-developed infrastructures, simple business decisions led to their being wrapped into government investigations, criminal indictments, and collateral consequences that accompany felony convictions for white-collar crime related to federal election laws, tax fraud, and securities fraud. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Hacks, attacks, ransomware, malware – where does it end? Unfortunately, tech crimes continue to plague businesses of all sizes. Participate in this session to learn how you can reduce the risk of becoming yet another victim.

Why do some companies fail while others grow and succeed for generations? Common perceptions often attribute organizational success to great leadership, timing, or unique ideas. Although these traits certainly play a role in helping companies grow, research shows that corporate success often hinges on whether a company is value driven. Such companies have core ideologies that drive almost every major decision. In this course, we look at empirical data on why some companies succeed while others fail. By looking at companies that were created prior to 1950 (e.g., Disney, Marriott, or 3M), we can understand why certain organizations have been able to grow and achieve exceptional success through many different eras in the American economy. The lessons learned from these visionary companies can be broadly applied to organizations of all sizes, including accounting and financial service firms.

Join us for an in-depth webcast on Charitable Remainder Trusts (CRTs) and the essential aspects of preparing Form 5227.  This course will provide a comprehensive overview of CRTs, including their purpose, benefits, and practical considerations. Moreover, we will delve into the intricacies of Form 5227, the informational return for charitable remainder trusts, ensuring you have the necessary knowledge to accurately complete and file this crucial document. During this webcast, Art Werner will guide you through the fundamental concepts of Charitable Remainder Trusts, illustrating how they can be utilized as a strategic tool for tax planning. We will explore various types of CRTs, their formation, and the different scenarios in which they are most beneficial.  A significant portion of the webcast will be dedicated to Form 5227, the reporting requirement for charitable remainder trusts. We will provide an in-depth analysis of the form's components, line by line, ensuring you gain a comprehensive understanding of the information it requires. From trust assets and income to distributions and charitable beneficiaries, we will cover each section, discussing common pitfalls and best practices for accurate reporting. Mr. Werner will address the recent updates and changes to Form 5227, enabling you to stay up to date with the latest compliance requirements.

The course provides a concise overview of how to use ChatGPT to more effectively and efficiently research IRS taxation law. It delves into techniques for extracting precise information from complex tax legislation, interpreting IRS guidelines with AI assistance, and utilizing ChatGPT's advanced language models for nuanced legal analysis. Participants will learn how to streamline their research process, identify relevant tax law precedents, and apply AI insights to real-world tax scenarios, enhancing their professional proficiency in navigating the intricate world of IRS taxation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Companies work hard to understand their client base. They focus on what products their clients will want to buy or services they want to pay for, but how often do they think about the differences in the people who comprise their workforce? Do we consider who our potential coworkers will be when interviewing for a new position? Do we think about what motivates the people who will ultimately produce the goods or services we provide? Today, the workforce includes people from four different generations. Sometimes the differences are points of contention creating roadblocks to success, while other times the differences make for great teamwork. Understanding what makes the different generations "tick" will help in everything from landing a job in a multi-generationally diverse company to creating a culture where employees thrive to produce the best possible products or provide superior services. This course will highlight the differences between the generations. It will cover what is important to each generation with respect to success in the workplace. It will illustrate how companies and managers can use this knowledge to create a workplace culture of cohesiveness. This course is beneficial for both people managers and those just trying to get a leg up in the workplace.

Resilience training was originally developed to strengthen individuals in high-risk groups like law enforcement, firefighters, and the military. This course also speaks to accounting and finance experts in a very challenging discipline. Resilience training is based on the intriguing assumption that resilience can be learned. A resilience leader possesses mental toughness, competence, and confidence. A confident accounting or finance person makes better decisions and thinks in deliberate ways to meet adversity and pressure. Resilience is the ability to exercise tenacity, bounce back from tough times, or even triumph in the face of adversity. Today's accounting professionals will experience challenges but are able to reframe then as learning opportunities. Resilient accounting and finance professionals push their limits, learn from their mistakes, and are able to transform an organization and themselves.

The Family and Medical Leave Act (FMLA) and the Americans with Disabilities Act (ADA) were implemented to improve the lives of employees. FMLA allows eligible employees to take job-protected leave for their own serious health conditions or to care for sick family members. The ADA was intended to ensure "equality of opportunity" and "economic self-sufficiency" for individuals with disabilities. Yet both laws have proven challenging for employers. These laws are complex with rules that can be confusing and often misunderstood. This webinar is designed to provide information, guidelines, and examples of the key concepts under both laws.

QuickBooks remains one of the leading accounting solutions for small and growing businesses and Intuit has added numerous advanced features to the application over the past few releases. In this seminar, you will learn how to take advantage of many of QuickBooks’ new and advanced features to solve important issues. For example, you will learn advanced inventory management techniques, including the ability to change the default costing methodology in QuickBooks, and implementing lot and serial number tracking. You will also learn how to build complete sets of financial statements in Excel that link in real-time to underlying QuickBooks data files and how to create multi-company financial statements. Additionally, you will learn how to put the Client Data Review feature to work to streamline the process of identifying and correcting errors and closing accounting periods in QuickBooks. Knowing how to take advantage of the advanced tools and features available can determine your level of success when working with QuickBooks. Take advantage of this opportunity to learn about QuickBooks’ “deep” features so that you maximize your effectiveness with the application.

Add an invaluable skill set to your career. Showcasing a comprehensive cost accounting system of an actual company. Precisely identify direct costs for individual products and services. How to link direct costs with other direct costs. Identify certain fluctuating variable and semi-fixed costs that are, in fact, direct costs. Budgeting techniques for setting accurate standard costs and guidelines for revising standards during the year.

Best Practices for Identifying and Evaluating Audit Risk - Linking Risk to the Detailed Audit Plan will emphasize the key concepts and best practices that drive a thoughtful risk-based approach to forming an opinion on the financial statements. Properly identifying, assessing, and responding to risk through a detailed audit plan is critical to an effective and efficient financial statement audit. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff, while it is also appropriate for anyone who has the need to better understand how to link risk assessments to the detailed audit plan. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

George Washington once wrote, "We ought not to look back, unless it is to derive useful lessons from past errors, and for the purpose of profiting by dear bought experience." The cost of fraud, dearly paid by governments and nonprofits, is too severe not to learn and profit from. In this course, we will look back at real-world government and nonprofit frauds and derive useful controls to stop them. The course materials utilize a highly illustrative and innovative format. Over 15 focused exercises are included to provide an enhanced working knowledge of fraud and anti-fraud controls to both auditors and industry professionals.

This course will review the Accounting Standard Updates issued by the FASB that impact nonprofit entities. We will also look at the work of the Not-for-Profit Advisory Committee (NAC) and the projects they are advising the FASB on.

Non-fungible Tokens (NFTs), unique, identifiable digital assets based on blockchain technologies, have become a fast-growing industry. This course will provide a background on how NFTs came into the mainstream marketplace.  These materials will assist the practitioner to understand the tax implications of the creation, purchase and sale of these assets.  **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.

This webcast covers the function that sums better than the SUM function for accounting professionals.

This course is designed to provide an overview of the IRS Strategic Plan 2023-2026 and its impacts on the accounting profession and regulatory ethics. The course will cover the key goals and priorities of the IRS Strategic Plan, including improving service to taxpayers, enforcing the tax law fairly, transforming IRS operations, and fostering an inclusive and well-equipped workforce. Participants will learn about the specific measures the IRS plans to take to achieve these goals and the implications of these measures for tax professionals. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Office Scripts are an exciting new development for Excel and other applications. Although they are like macros in some respects, most users will likely find them easier to work with. Learn how to put this powerful automation tool to use!