WICPA CPE & Special Event Catalog
K2’s Mastering Advanced Excel Functions
-
Online
4.00 Credits
Member Price: $149
With approximately 500 functions now available in Excel, some newer & 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 & 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 & STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT & PPMT & how to retrieve summarized data easily using GETPIVOTDATA & CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power & 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 & effectively in Excel.
360 Budgeting: A Holistic Approach to Process & Solutions
-
Online
8.00 Credits
Member Price: $250
The budgeting process can be a time consuming & frustrating process for accountants. The constraints & pressures can lead to poor decisions in both the technical & human components. This series will offer solutions to the budgeting woes From both the big picture & in the details. Budget Mastery: Process, Problems & Solutions The budgeting process can be a mundane one for accountants. Let's be realistic & agree that even the word "budget" does not bring excitement to you & your departmental colleagues. The constraints & pressures can lead to poor decisions in both the technical & human components. This session is the first part of a four part series & will cover the big picture of keeping the process fresh, pragmatic & useful. We discuss these keys in an engaging manner by discussing both our flaws & 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 & Real World Calculations Towards Tying Budgets to Value This session takes a unique review of the fundamental budget issues faced by all & walks through a detailed modeling process intended to generate discussion & 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 & human component. We can resolve some of our budget issues by exploring the process' human aspect. Understanding what makes you & others operate can enhance your understanding of the entire organization & build upon the respect & influence needed to navigate & lead the budgeting cycle. This session includes a case study that measures an individual's personality type & then explores how to use our strengths & weaknesses to create a better budget process & quite frankly maybe a better you. This is a great & 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 & 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 & will identify key problems in how people often communicate financial plans. Presenting your budget & 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 & educational.
Revenue Recognition Topic 606 Contract With Customers: Identify the Contract Part II
-
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 & accounting treatment when a contract does not exist.
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 & they empathize. We discuss the steps to take so you can become a true leader: including, integrity, humility, communication, self-control & self-awareness. With diligence, you can become a better leader & we will discuss how.
Budget Mastery: Walkthroughs & 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 & walks through a detailed modeling process intended to generate discussion & 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.
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 & work-from anywhere environments virtually demand collaboration platforms. In this session, you will learn today's best tools & 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 & Zoho: & how these options are similar & differ. You will also learn about other collaboration options, including Slack, Zoom & Webex & you can incorporate these tools into your collaboration environments. Further, you will learn about some of the best practices & procedures that must be in place to optimize your collaborative environments & experiences.
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 & how a taxpayer can utilize the rules to potentially decrease an entities effective tax rate. Other issues, such as documentation & 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 & submit to leighanne.conroy@acpen.com.
Common Yellow Book & Single Audit Deficiencies
-
Online
4.00 Credits
Member Price: $149
Yellow Book & Single Audit engagements are routinely selected for peer review & continue to be areas of heightened scrutiny by peer reviewers & federal oversight agencies. This course examines common deficiencies identified in governmental & Single Audit engagements, with a focus on understanding why these issues arise & 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 & reporting considerations. The course also addresses common Single Audit deficiencies, including internal controls over compliance, compliance testing & major program determination. Designed for auditors performing governmental & Single Audit engagements, this course helps participants recognize recurring problem areas & better understand the requirements that continue to drive peer review findings.
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 & selling real property. We will be covering the basic structure of a LKE & 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 & submit to kori.herrera@acpen.com
Global Internal Audit Standards (GIAS) Domain V: Part II
-
Online
2.00 Credits
Member Price: $89
The new Global Internal Audit Standards were released on January 9, 2024 & 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 & elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation & examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics & Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service
K2’s CRM: The Ultimate Business Automation Tool
-
Online
2.00 Credits
Member Price: $89
This course provides an in-depth exploration of Customer Relationship Management (CRM) systems as a critical tool for business automation. Designed for accounting professionals, it emphasizes CRM's role in streamlining workflows, organizing communications, enhancing client relationships & improving efficiency. Participants will learn about key CRM features, integration with accounting software & best practices for successful implementation. We will highlight practical applications with actionable insights to help attendees optimize their processes. This two-hour session ensures you walk away with a basic understanding of CRM's transformative potential for business & financial management.
K2’s Top PDF Features You Should Know
-
Online
4.00 Credits
Member Price: $149
Are you tired of struggling with PDFs? Unlock the full potential of Adobe Acrobat & other PDF tools to make working with PDF files a breeze. Join our course & discover how to use powerful features such as PDF forms, redaction, converting PDFs to Word & Excel files & electronic signatures. You'll also learn how to create & apply tick marks, build indices, catalogs & portfolios & secure your PDF documents to the fullest. As the popularity & usefulness of PDFs continue to grow, many users still haven't learned how to manipulate these documents effectively. Don't let this be you! Join us for this timely session & learn the top features necessary to optimize your work with PDF documents. Say goodbye to frustration & hello to efficiency!
K2’s Advanced Topics In Power BI
-
Online
2.00 Credits
Member Price: $89
So, you've been using Power BI to create fundamental reports & dashboards & now you're ready for even more advanced reporting & if so, this session is for you. In this session, you will learn how to extend your Power BI environment by incorporating tools such as Data Analysis Expressions, Key Performance Indicators, Hierarchies & Apps & Content Packs, among others. By taking advantage of the tools & techniques covered in this session, you will be able to move beyond simple reports & dashboards in Power BI & truly leverage the power of this awesome reporting tool.
Devious Ethics: Avoiding Snakes in Suits
-
Online
2.00 Credits
Member Price: $89
Good people believe everyone else is just like them. They cannot imagine someone could con them or their company & have no guilt or remorse about what they have done. Lack of guilt & empathy are key traits of a psychopath. Most of us envision psychopaths to be cold-blooded serial killers who are locked away in prison. However, experts estimate that 4% of corporate executives are psychopaths who may initially appear to be more normal than the rest of us. Psychopaths may present a convincing picture of virtue while helping themselves to money, status & sex while leaving a path of shattered expectations, empty wallets & broken hearts in their wake. Learn how to recognize & deal with others who have no conscience.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Metrics Management: Measuring Performance in the Real World
-
Online
2.00 Credits
Member Price: $89
Designing metrics is only half the challenge-making them work in practice is where most organizations struggle. This session focuses on applying metrics in real-world environments, including responsibility centers, profit centers & service organizations. Participants will explore output measurements, controllable versus non-controllable costs, cost allocation challenges & benchmarking. Case discussions illustrate how better information leads to better decisions & improved performance. Humorous videos will be incorporated to drive home some key points & keep things entertaining.
Revenue Recognition Topic 606: Identify Performance Obligations Part II
-
Online
1.40 Credits
Member Price: $39
Properly identifying performance obligations is a critical step in the five-step revenue recognition model. It is a step that must be completed at the inception of the contract & prior to moving on to step three of the model. As discussed in segment one on performance obligations, there are many types & variations of obligations & as such, management will be required to utilize significant judgment when applying this step. However, it is important that the judgment be supported by considerations of the proper factors. The course further evaluates areas that impact performance obligations. We utilize multiple examples From various industries to illustrate the considerations that must be evaluated in line with both identifying performance obligations & allocating the transaction price appropriately.
What's Going on at the AICPA (2026/27)
-
Online
2.00 Credits
Member Price: $89
Stay current on key developments affecting audit & attestation engagements with this comprehensive update on what's happening at the AICPA. This course begins with the next phase of quality management, with a particular focus on firms' monitoring & remediation responsibilities & what those requirements mean in practice. Participants will also review recent & upcoming standards impacting audit, attestation & consulting engagements, including SSAE No. 24 & SSARS No. 26, along with high-impact exposure drafts related to confirmations & fraud. The course concludes with an overview of SAS No. 149 & its implications for group audits. Designed as a timely update for practitioners, this course helps participants understand how recent & proposed changes may affect engagement planning, execution & compliance in the years ahead.
The Controller Function: Inventory Part I
-
Online
1.80 Credits
Member Price: $79
This course is one of the courses dedicated to our Controllership series. This series of courses is dedicated to exploring the traditional controller role & stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we will discuss the area of inventory. This specific segment in the first part of a two-part series on inventory. We explore how the controller can move these responsibilities into more of a strategic role. This course takes a look at some of the typical concepts & duties involved in the inventory function that is sometimes viewed as operational roles. We explore how these areas are strongly tied to the importance of the controllership role & how the controller can add value in each area.
Metrics Management: Dashboards, Performance Tools & Open-Book Management
-
Online
2.00 Credits
Member Price: $89
Metrics only add value when they are communicated clearly & used consistently. This session focuses on dashboards, performance management tools & open-book management as ways to turn metrics into action. Participants will learn how dashboards support decision-making, why many reporting projects fail & how transparency & trust improve performance. The session emphasizes visualization, communication & using metrics to answer the most important management questions. Humorous videos will be incorporated to drive home some key points & keep things entertaining.
K2’s Best Word, Outlook, And PowerPoint Features
-
Online
4.00 Credits
Member Price: $149
Are you using Word, Outlook & PowerPoint to their full potential? Many professionals rely on these essential tools but often overlook their best features. If you find yourself using "brute force" methods & spending too much time on tasks, it's time to upgrade your skills. Join our four-hour session designed to transform how you work with Microsoft Office. You'll learn how to harness the power of Word, Outlook & PowerPoint to achieve better results in less time. Our expert instructors will guide you through the most efficient techniques, ensuring you gain practical skills that you can apply immediately. Don't miss this opportunity to enhance your productivity & streamline your workflow. Sign up now & take the first step towards mastering Microsoft Office!
