CPE Catalog & Events

Transform your data presentation skills with our comprehensive course on creating impactful dashboards and reports using Excel. This workshop is tailored for professionals who: Regularly produce or update dashboards and reports Struggle with confusing or overly complex reporting tools Seek to streamline varied reporting styles across their organization Aim to establish a consistent, replicable "house style" for reporting Want to impress stakeholders with clear, user-friendly data presentations Through a combination of theory and hands-on practice, you'll learn the fundamental principles that make reports and dashboards easy to understand. We'll distill these concepts into a set of practical rules and guide you through their application in Excel.

Many Microsoft 365/Office 365 subscriptions include robust Cloud services for improving productivity. Foundational services, such as SharePoint Online, OneDrive for Business, and Exchange Online, join with other powerful tools such as Teams, Planner, Power Automate, Forms, and Power Apps to provide a productivity platform second to none. Unfortunately, most users will never benefit from working with these tools simply because they remain unaware of these features. Plan to attend this session to learn about the “rest of 365” and how these Cloud-based applications can enhance personal and team productivity while simultaneously facilitating remote working arrangements. Don’t miss this opportunity to get all the knowledge and guidance necessary to leverage your investment in Microsoft 365/Office 365 fully.

Many small to medium sized companies do not properly address the risk that arises related to fraud because these organizations do not have the resources needed to mitigate this risk or because owners or those in top level management underestimate the scope of the issue. All organizations, regardless of size, must be aware of the risks associated with intentional fraudulent acts and know that a significant and effective fraud scheme could even create going concern issues for some entities. In this session, we delve into the reasons that fraud takes place. The material discusses the types of defalcations that are often executed against smaller entities and then explores measures that organizations can implement to help stop fraud activities and add security. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Staff accountants have specific needs when working with Excel – needs that are often not met by their existing Excel knowledge. Chief among these are the needs to quickly summarize data, prepare accurate and aesthetically pleasing reports, and create accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills they need to maximize their efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a “laptop-friendly” environment, and participants will have access to all the demonstration files used in the session. In sum, this seminar is a “must” for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.  

Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge of PivotTables, then plan to participate in this course. You will learn how to build PivotTables, group data inside PivotTables – including grouping options for fiscal periods – and create user-defined calculations in your PivotTables. You will also learn advanced PivotTable techniques, including building PivotTables that consolidate data from multiple data ranges and PivotTables that connect dynamically to external databases and financial accounting systems. Additionally, you will learn to take advantage of other Excel features associated with PivotTables, including Slicers, Power Query, and Power Pivot. You will be a master of Excel PivotTables at the end of the day! This course is for you if you have been leery of working with PivotTables or have struggled to realize their many benefits. With some information, guidance, and coaching from your K2 instructor, you will be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.

This course equips practitioners with the knowledge to help clients navigate complex tax and financial challenges. Covering a range of difficult situations—such as divorce, bankruptcy, and other personal and business matters—this course provides key tax insights and strategic planning considerations. Participants will gain practical strategies to support clients in making informed decisions while understanding the tax implications of these situations.

Award winning discussion leader Mark Hugh discusses how to create and capture value with consulting services. Whether you want to consult a little or full time, this valuable course reviews identifying a specialty, growing a practice, capturing value, creating deliverables, and effective marketplace marketing strategies.  

This course addresses the most recent legislative developments impacting business taxpayers, with a focus on important provisions, rules and concepts to apply when preparing client returns.    *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

Schedules K-2 and K-3 are promulgated by the IRS in order to standardize the reporting of foreign-related tax information for pass-through entities. Even pass-through entities that have no foreign activities, investments, or partners may have a reporting requirement. Schedules K-2 and K-3 for reporting partners' income, deductions, and credits from foreign activity are now required for passthrough returns (Form 1065, 1120-S and 8858). This requirement starts with returns with a tax year that ends in 2021. This course discusses each part of these schedules and explain these new reporting obligations in detail. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Trusts are not cookie-cutter documents. In fact, they can be rather unwieldy, especially in explaining the functions to a client and then having the client comply with the trust terms. This course delves into best practices. Given common scenarios, what are the best trusts to use? And how can the client be best protected?

In recent years, not-for-profits have applied critical new standards related to contributions of nonfinancial assets, leases, and more. However, with all the focus on the new stuff, have we forgotten any of the old stuff? FASB ASC 958 has a great deal to say about various accounting and reporting issues in the form of its implementation guidance and illustrations. Not knowing this guidance can result in lost time and erroneous applications of GAAP. In this course, we will review some of the most critical illustrative not-for-profit guidance issued by the FASB.

Calculating partnership basis is one of the most important things that we do as practitioners. However, it is also one of the most confusing. When we use the term "basis," we really could be referring to one of three different things. This course will explore the differences between inside basis, outside basis, and 704(b) basis. Through several examples and practice problems, we will show you how to easily distinguish among these terms. We will also explore the tax implications of initial contributions of property to a partnership as well as the different types of partnership distributions.

Preparation, compilation and review engagements continue to be a hot topic for peer review despite SSARS 21 having been around for nearly a decade. This course will concentrate on the most common peer review findings with a focus on how to comply in an efficient but practical perspective. This course will discuss the root cause of noncompliance so that overall engagement quality increases.

Business Intelligence (BI) is perhaps the hottest topic in most professional circles in today’s business climate. Increasingly, organizations of all sizes seek to take advantage of the data available to them to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools – from Excel add-ins to dedicated solutions such as Power BI – now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyzes unthinkable until recently. This program will teach you to implement “do-it-yourself business intelligence” using various techniques and tools. First, you will learn to use advanced Excel data query and summarization features to create Excel-based dashboards. You will then learn how to leverage that knowledge to build even more powerful BI objects using Microsoft’s Power BI tools. If gaining better insights into your data to make better decisions interests you, then join us for a fast-paced look at how you can take advantage of these fantastic tools. 

In today's rapidly evolving digital landscape, understanding the interplay between generative AI and data protection is not just an asset, but a necessity. This transformative course is designed to delve deep into the crucial privacy, security, and compliance aspects of working with Generative AI (GenAI) technologies. As accountants increasingly integrate AI tools into their workflows, the stakes for safeguarding sensitive information and ensuring ethical AI practices have never been higher. Our masterclass is tailored to meet the unique needs of modern accountants, providing a thorough and practical exploration of how to navigate the complexities of secure data sharing with GPT models, implement robust AI policies, and master the intricacies of AI copyright compliance. With a focus on real-world applications and emerging threats, such as deepfakes and their implications for fraud and misinformation, this course is your gateway to becoming a trusted expert in the field. Join us to future-proof your career and lead with confidence in the digital age. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Anyone can "crunch numbers" but it takes special skills to make them meaningful to the user. Financial statements and ratios need to be interpreted correctly using a process that sets the context, identifies the right analysis tools, and makes recommendations in an understandable format. This course will help you present your insights in a way that is insightful and impactful to your client.

Documenting internal controls Familiarize yourself with commonly used documentation tools, such as narratives, flowcharts, internal control questionnaires and control matrixes. Walk through COSO's internal control template used to document an assessment of a system on internal control.

ProActive Response Group's Active Shooter Response Training course educates participants in current trends of active shooter incidents, how to recognize early warning signs of violence, appropriate actions to increase chances of survival in an active shooter event, and how to use basic medical equipment to save the lives of victims.   *****(Warning: This video contains simulated graphic scenes that some viewers may find disturbing)*****

Applying Topic 606 in an environment of uncertainty can be especially challenging. This course will discuss the proper application of the revenue recognition model when facts and circumstances are changing.

Buying and selling a business can be a complex transaction with many tax issues. These issues include whether the transaction is or should be a stock or an asset sale when the business involved is a corporation, as well as the tax consequences associated with the sale of a partnership or a C or S corporation. Tax practitioners who advise clients who are buying or selling a business primarily focus on the tax issues that apply. This program explains and analyzes the tax issues practitioners must address in order to properly advise clients who are either buyers or sellers of businesses.