CPE Catalog & Events
K2’s Mastering Advanced Excel Functions
-
Online
4.00 Credits
Member Price: $149
With approximately 500 functions now available in Excel, some newer and more powerful tools are easily overlooked. But if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel's more advanced features-some new and some legacy-to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel's FORECAST.ETS function. Regardless of your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Doing Debt Differently - Your Roadmap to Changes & Choices for Success
-
Online
4.00 Credits
Member Price: $149
Debt is a real problem for many clients, business owners, and the general public. It can be ever increasing and causes financial, emotional and physical challenges that seem to spiral out of control. What if you could help your clients “do debt differently”? This strategy turns the game upside down and presents solutions from the inside out. As a CPA, you are already a trusted advisor for your clients. What if you could help your clients be free of this burden? This is a tremendous resource you can offer to your clients, expanding the value of what you offer them by adding these processes to your packages. Clients will be happy to pay for this kind of relief as you support them in doing debt differently. If you are one of the many people who are personally burdened by this situation, these strategies, tools, mindsets and actions will personally help you get better results…so you can go back to the task of expanding and growing your business, sleeping better at night and gaining access to the creativity that will take you to your next level of financial fulfillment. Paying off debt is an inside/outside job. Successful strategies include the internal shifts to mindset and enhancing the inner qualities that are most helpful in paying off debt, and practical tools to help make the transition from thinking about paying off debt to actually doing it. This program combines both -- emotional support and dozens of tools and action steps to Do Debt Differently, including: An inventory process to objectively assess the situation and face it head on Guided mind/body processes to alleviate anxiety about the situation Creative exploration (writing and drawing) to gain clarity and specificity Stories and discussion to strengthen your access to the qualities that will be most helpful to your success Using a menu of options to create a personal action plan and an ongoing support team The techniques in this program are creative and easy, but immensely practical. We will combine practical, nuts-and-bolts action steps with powerful tools for mindset-shifting. There is no reason to continue to suffer the burden and overwhelm of debt. Relief is here! Through discussion, interactive exercises, skill building, mindset shifting and powerful actions, you and your clients could be on your way to a debt free life. Please join me for this empowering approach to changing your financial situation. Delivery Method: Individual webcast CPE Credit: 4Program Level: Basic
360 Budgeting: A Holistic Approach to Process and Solutions
-
Online
8.00 Credits
Member Price: $250
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 series will offer solutions to the budgeting woes from both the big picture and in the details. Budget Mastery: Process, Problems, and Solutions The budgeting process can be a mundane one for accountants. Let’s be realistic and agree that even the word “budget” does not bring excitement to you and your departmental colleagues. The constraints and pressures can lead to poor decisions in both the technical and human components. This session is the first part of a four part series and will cover the big picture of keeping the process fresh, pragmatic and useful. We discuss these keys in an engaging manner by discussing both our flaws and strengths, including how to build on these characteristics towards an enjoyable solutions-based method that should deliver effective results for your organization. Budget Mastery: Walkthroughs and Real World Calculations Towards Tying Budgets to Value This session takes a unique review of the fundamental budget issues faced by all and walks through a detailed modeling process intended to generate discussion and best practices to improve your organization’s financial modeling. From the beginning of the accounting process – ‘the chart of accounts’ to the end of the process – ‘the valuation of the company’, the budgeting cycle via a live case model to learn best practices common to successful companies. This course stands on its own but is part two of a four part budget mastery series. Budget Mastery: The Human Side of Budgeting-Navigating People's issues with 360 Insight You have a fantastic budget, but certain players are not pleased. Financial plans have a technical component and human component. We can resolve some of our budget issues by exploring the process’ human aspect. Understanding what makes you and others operate can enhance your understanding of the entire organization and build upon the respect and influence needed to navigate and lead the budgeting cycle. 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 a better budget process and quite frankly maybe a better you. This is a great and fun course on its own, but is also part three of a four part series on budget mastery. Budget Mastery: From Numbers to Narrative: Effectively Presenting Your Budget and Reporting Perhaps the most important element of the budget process is its communication. If management does not understand the budget – there is an issue. Knowing the right ways to communicate at all levels is essential to stakeholders laying an ownership claim to successful budgets. This session reveals several key guidelines in successful budget presentations and will identify key problems in how people often communicate financial plans. Presenting your budget and reporting is the final part of a four part series, but can easily stand on its own course that is intended to be fun, enjoyable and educational. Delivery Method: Individual webcast CPE Credit: 8Program Level: Intermediate
Preparing for & Conducting Discharge Meetings
-
Online
1.00 Credits
Member Price: $39
Over 80% of all employment-related lawsuits relate to termination. Every termination should be treated as a potential lawsuit. The facts supporting a leader's recommendation of discharge must be fully investigated. The discharge of an employee requires prior review and approval. Narrow self-interest, spite, or personal animosity must not play a part in making termination decisions. This course provides practical knowledge and scripts for handling discharges with good judgment such that personal and employer liability is avoided. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
Revenue Recognition Topic 606 Contract with Customers - Identify the Contract Part 2
-
Online
1.20 Credits
Member Price: $39
This course is a continuation of discussion over Step One in the revenue recognition process of Identify the Contract. Specifically, this session delves further into the considerations surrounding contract modifications, change orders, unpriced change orders, cancelations, non-finalized changes and accounting treatment when a contract does not exist. Delivery Method: Individual webcast CPE Credit: 1.2Program Level: Intermediate
Common Audit and Financial Reporting Deficiencies in State and Local Governments
-
Online
2.00 Credits
Member Price: $89
Common Audit and Financial Reporting Deficiencies in State and Local Governments, is a 2 hour webcast detailing many of the more common mistakes that auditors and accountants are making in either the preparation of their annual financial statements or the audits of such financial statements. Deficiencies in audit standards (AICPA, GAO, Single Audit) and preparation standards (GASB) noted in this webcast are driven by the most recent results found in audit organization peer reviews, workpaper or desk reviews, and various organizations checklists for oversight. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
Leaders Eat Last. Why? The Characteristics of Great Leaders
-
Online
2.00 Credits
Member Price: $89
If a great leader is someone we are willing to sacrifice for – what do those leaders do that makes us want to do more? Many of us work in dysfunctional organizations that want followers, but have no leaders that lead. What makes a leader effective? True leaders sacrifice, they are trustworthy and they empathize. We discuss the steps to take so you can become a true leader: including, integrity, humility, communication, self-control and self-awareness. With diligence, you can become a better leader and we will discuss how. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Budget Mastery: Walkthroughs and Real World Calculations Towards Tying Budgets To Value
-
Online
2.00 Credits
Member Price: $89
This session takes a unique review of the fundamental budget issues faced by all and walks through a detailed modeling process intended to generate discussion and best practices to improve your organization’s financial modeling. From the beginning of the accounting process – ‘the chart of accounts’ to the end of the process – ‘the valuation of the company’, the budgeting cycle via a live case model to learn best practices common to successful companies. This course stands on its own but is part two of a four part budget mastery series. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
K2’s Collaboration – Best Platforms And Practices
-
Online
2.00 Credits
Member Price: $89
Collaboration remains one of today's hottest topics. Technology has fueled today's collaboration options, and work-from anywhere environments virtually demand collaboration platforms. In this session, you will learn today's best tools and practices to facilitate more effective collaboration in your organization. In this session, you will learn about today's mainstream collaboration platforms & Microsoft 365, Google Workspace, and Zoho - and how these options are similar and differ. You will also learn about other collaboration options, including Slack, Zoom, and Webex, and you can incorporate these tools into your collaboration environments. Further, you will learn about some of the best practices and procedures that must be in place to optimize your collaborative environments and experiences. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
International Tax Treaties
-
Online
2.00 Credits
Member Price: $89
This course presents an overview of tax treaties and how they are used in structuring transactions and determining the tax impact of cross-border transactions. It discusses the ordering rules for local laws versus treaty laws, and the purpose of the tax treaties in avoiding and eliminating double taxation to promote trade and investment. The participant will learn about planning opportunities to contemplate when structuring foreign operations. **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 webcast CPE Credit: 2Program Level: Basic
International Cross Border Transactions
-
Online
2.20 Credits
Member Price: $89
Please join us for an introductory course in international cross border transactions. We will discuss typical situations in which a cross-border transaction arises, and how a taxpayer can utilize the rules to potentially decrease an entities effective tax rate. Other issues, such as documentation and IRS audit risk will also be covered. These rules will be illustrated by a hypothetical US- Canada transaction. **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 leighanne.conroy@acpen.com. Delivery Method: Individual webcast CPE Credit: 2.2Program Level: Basic
Rethinking Your Customers to Maximize Profitability: Identifying the Right Clients
-
Online
2.00 Credits
Member Price: $89
Some customers are unprofitable from an economic or time perspective – but many organizations do not differentiate or know the difference. When an organization has a unique, well-differentiated service or product, understanding value from the customer’s perspective becomes a crucial factor in profitable pricing. We must take the time to fully understand what our customers value - from the customer’s point of view. What is value? Why do brand, value, and customer focus matter? Developing a deep understanding of our customers is vital. Our most important customer might be someone we have not yet recognized. Understanding both external clients and internal stakeholders - including the evolving role of the finance department, is critical to long-term success. Using humorous video clips, memes, and vetted research, your understanding of customer bases will improve. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Expand Your Analytical Toolbox More Tools for Success
-
Online
4.00 Credits
Member Price: $149
Valuation techniques and cash management activities are two other tool categories that can round out your analytical toolbox. In this course we will initially discuss how to turn your financial plan into a powerful valuation engine. We then will discuss the formation of an efficient cash management program based on solid banker relationships. Finally, we will review Ten Steps for keeping your financial toolbox full. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Common Yellow Book & Single Audit Deficiencies
-
Online
4.00 Credits
Member Price: $149
Yellow Book and Single Audit engagements are routinely selected for peer review and continue to be areas of heightened scrutiny by peer reviewers and federal oversight agencies. This course examines common deficiencies identified in governmental and Single Audit engagements, with a focus on understanding why these issues arise and how they can be avoided. Participants will review frequent deficiencies related to Yellow Book requirements issued by the U.S. Government Accountability Office, including independence, CPE, and reporting considerations. The course also addresses common Single Audit deficiencies, including internal controls over compliance, compliance testing, and major program determination. Designed for auditors performing governmental and Single Audit engagements, this course helps participants recognize recurring problem areas and better understand the requirements that continue to drive peer review findings. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
K2’s Securing Your Data: Practical Tools For Protecting Information
-
Online
4.00 Credits
Member Price: $149
In today's digital landscape, security is non-negotiable. Yesterday's techniques cannot keep up with today's threats. It's time to elevate your knowledge and protect your sensitive data with our comprehensive security program. Join us to discover the latest tools and techniques for securing your data, including encryption, virus protection, safe communications, electronic signatures, secure authentication, and more. You'll also learn how to implement a practical, five-step approach to securing your PC and the critical questions to ask your staff to ensure server-based information remains protected. Security failures, such as client or customer data breaches, can be devastating and even drive your company out of business. So, what security tools do you need, and how should you use them to safeguard your sensitive data and systems? Can you afford to manage today's threats with outdated techniques? Participate in this valuable session to learn how to identify viable and practical solutions to mitigate today's security threats. Don't miss this opportunity to fortify your defenses and ensure your business's success. Sign up now and take the first step towards a more secure future! Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Like-Kind Exchanges
-
Online
2.20 Credits
Member Price: $89
Please join us for a discussion on like-kind exchanges (LKE), known as one of the last great tax legal “shelters” available to those buying and selling real property. We will be covering the basic structure of a LKE, and ways a taxpayer can utilize qualified third party intermediaries (QI), tenancy-in-common structures including Delaware Statutory Trusts (DST). We will also explore creative solutions to sticky situations a taxpayer may find itself in obtaining replacement property. **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 webcast CPE Credit: 2.2Program Level: Basic
Getting On Top of It All: How to Work Smarter, Not Harder - Part 2
-
Online
4.00 Credits
Member Price: $149
There is always too much to do and too little time to do it all. Fortunately, if you know the right ways to manage people, projects and your time, you can get on top of everything by working smarter. In Part 2 of this seminar we will go into more depth about how to get more done in less time, as well as how to not burnout from all the work you do. We will discuss additional methods for working smarter through technology, communication, stress reduction, and creating smart and helpful goals. Delivery Method: Individual webcast CPE Credit: 4Program Level: Update
Accommodation Requests - Substance Abuse - Contagious Infections
-
Online
1.00 Credits
Member Price: $39
Good judgment works well in handling most employee relations matters. However, there are special situations where legal requirements dictate specific handling to avoid significant personal and employer liability. This course provides practical knowledge and scripts for responding to requests for accommodation regarding religious practices or disabilities, confronting employees in substance-abuse situations, and handling disclosures of contagious infections so that individual is properly helped, and the health of your workforce is protected. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
What Is Your Brand Reputation?
-
Online
1.00 Credits
Member Price: $39
What do people say about you when you leave the room? Is it what you want them to say? How you show up in the room, get listened to, build trust, and are known amongst your colleagues are all critical components of your future success. In this workshop Michelle Tillis Lederman, CEO and Founder of Executive Essentials, will discuss how to determine you brand attributes, demonstrate the nuances of body language on your professional presence, and discuss how to strengthen trust and the lasting impressions you make on your network, expanding upon lessons from her books The Connectors; Advantage and The 11 Laws of Likability. Delivery Method: Individual webcast CPE Credit: 1Program Level: Basic
Global Internal Audit Standards (GIAS) Domain V - Part 2
-
Online
2.00 Credits
Member Price: $89
The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service Delivery Method: Individual webcast CPE Credit: 2Program Level: Update