CPE Catalog & Events

In this session, participants will delve into a comprehensive exploration of what Diversity, Equity, and Inclusion (DEI) truly entails. Often met with resistance due to its perceived condemnatory nature, this session aims to provide a more nuanced definition of DEI, fostering a better understanding among attendees. By demystifying the language surrounding DEI, participants will be equipped with straightforward approaches to seamlessly integrate these principles into their perspectives. This session will spotlight the distinctive features of our DEI model in comparison to other systems. Attendees will gain valuable insights into the model, understanding its unique perspective on achieving DEI success. At its core, our approach is grounded in the simple premise that we are all human beings sharing the common human experience. The goal is to convey to participants the importance of embracing DEI through this paradigm, effectively humanizing the DEI experience. One of the most remarkable DEI experiences unfolded during my son's 18th birthday celebration in our backyard. The event brought together individuals from diverse backgrounds, spanning various walks of life and races, who interacted in a profoundly humanistic manner— an encounter unlike any I had witnessed before. In this session, we will deconstruct this experience and draw parallels to its relevance in workplace dynamics.

Following on Part 1 of this course, in Part 2 you will learn advanced ways to solve problems without bruising egos, how to create profound trust quickly, and how to motivate clients and co-workers to do your bidding with a minimal amount of wasted time or hassles.    The bottom line will be better client and co-worker relationships, leading to increased enjoyment and productivity at work.

This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order. This webcast focuses on using the Power Pivot features to enhance data analysis. We will review the 4 features of Power Pivot (data model, calculations, hierarchies and KPI's) and you will learn how you can use each of these features. Although, the majority of the time will be spent on building the data model and using calculations. You will learn how to add data to your data model either directly into Power Pivot or from Power Query. We will discuss the benefits of the data model relationships versus using the VLOOKUP function to access data in different tables. One of the strengths of Power Pivot is the formula language called DAX (Data Analysis eXpressions). We will introduce DAX so that you can use basic DAX formulas to build various calculations in the data model. You will learn the difference between calculated columns and measures as we build these various calculations into our data model. This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel. (bold) *However, in order to follow along and apply concepts being taught during this session, you need to have the Power Pivot add-in installed. Explore the other webcasts in the 2020 Power BI Series: Power BI - Introduction to MS Power BI Tools Power BI - Prepare Your Data Efficiently for Excel Analysis Power BI - Analyze Your Data With Excel Pivot Tables Power BI - Create Excel Dashboards for Maximum Impact Power BI - Use Power Query to Transform Your Data Power BI - Use Advanced Calculations with DAX Formulas Power BI - Use PBI Desktop to Create Reports and Dashboards Power BI - Share Your Data Analysis using PowerBI.com

As spreadsheets evolve, so must your practices for creating, editing, and auditing them. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today’s best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this “must-see” CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel to its fullest potential.  

Analytical Procedures - Comprehending Financial Statement Audit Fundamentals will provide the tips and techniques necessary to gather sufficient appropriate audit evidence to support conclusions using analytic procedures common to financial statement audits. Properly designing, documenting and evaluating results of analytic review procedures is critical for performing an effective and efficient audit engagement. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has responsibilities for performing financial statement audit analytics. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The use of an S corporation election can dramatically affect the tax consequences of owning a corporate business. This course focuses on the requirements that must be satisfied to make and retain this tax election.

The course provides a concise overview of more than 200 data visualization tools which can be used by accountants to enhance the visual appeal of their financial work. All resources are easy-to-use web-based applications that require virtually no artistic or design skill - simply drag and drop, point and click, cut and paste, and/or edit text. You'll discover how to create new image content in a snap to better inform, persuade, and inspire action. Participants will walk away with a whole new creative toolkit and skillset that cuts through data clutter, improves analysis and sharpens decision-making. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Small businesses have better options now than ever before in the market of accounting solutions. Participate in this session to learn more about these options and which might be best for you or your clients.

In the course of legal actions, payments may be made pursuant to a final disposition of a court case or a mutually agreed-upon settlement.  This course will cover the tax implications for payments made for personal injury, emotional distress, lost wages, punitive awards, pre- and post-judgement interest, contract claims, among other damages. **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.  

Recent legislation in Congress has provided the IRS with substantially increased funding to bolster its human staff and purchase software that will allow the IRS to audit many more taxpayers in a more effective way. The IRS believes it can target the right kinds of taxpayers for audits so that it will not waste its time on audits that produce little, if any, revenue. The purpose of this program is to discuss the current state of IRS audits and the anticipated increases in the IRS's ability to audit wealthier taxpayers in an efficient way. Panelists will discuss the state of the IRS's current audits and where the IRS is headed with audits in the coming years. Tax practitioners should also be aware of the state of the IRS's efforts to target efficiencies so as to produce the most revenue.

Due to the constant stress of a fast paced life, overwork, and family demands, it’s easy to feel one’s life is out of balance. When this happens, all areas of your life can suffer. By learning key methods for setting priorities and goals, overcoming stress, and deciding what’s most important to you, you can achieve new levels of balance and greater results. Having more balance in your life will allow you to do less of what you don’t want and more of what is truly important to you.

A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans. How to use the Form 1120S, Schedule K-1 information for basis determination. An illustrative example demonstrates how the process works, as well as the many potential pitfalls. 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 will review the relevant considerations related to going concern, including assessing when substantial doubt concerning an entity's ability to continue as a going concern exists, management mitigation efforts, and required disclosures both when management, and the accountant, feel such efforts will be effective in mitigating the risk, as well as when they do not. Lastly, we'll consider the accountant's reporting responsibilities under various scopes of services in various scenarios and how to audit this often-contentious topic.

In this session, we will underscore the significance of adopting a growth mindset, as conceptualized by Dr. Carol Dweck, as a cornerstone for achieving success in Diversity, Equity, and Inclusion (DEI) initiatives. A common stumbling block in DEI efforts is the resistance to altering mindsets concerning the goals and objectives of DEI. Through interactive discussions, we will concentrate on dispelling fixed mindsets and cultivating an outlook of continuous growth in the realm of DEI. Achieving success in Diversity, Equity, and Inclusion (DEI) requires a blend of motivation, synergy, and energy. This session aims to dissect the often-overlooked role of motivation in the DEI landscape, demonstrating how it serves as a catalyst for individuals and leaders to surmount obstacles and attain success. Our model disrupts the conventional discourse by placing motivation at the forefront of DEI considerations, emphasizing the importance of understanding the underlying purpose as the true north. The ultimate aim of Diversity, Equity, and Inclusion (DEI) is cultural integration. In the context of our 3M framework, the final "Memorization" component is strategically designed to imprint the necessity of prioritizing DEI and seamlessly weaving it into the organizational culture. This element is pivotal in fortifying our DEI endeavors.

This is not your average CPE course! In this fun and practical course, you'll learn how to remember names, where you put things, what you read, or anything else 300% (or more) effectively than before. You will also learn how to prevent dementia, and halve your stress by using exercises that take under two minutes a day to do. Additionally, you'll receive information on ways to improve your memory by improving your overall health and wellness. This course will give you an overview of natural supplements to enhance your memory as well as share tips to improve your sleep. This course will change your life both now and in the future by making sure you know the best ways to remember information, handle stress and keep your mind sharp until the day you die. The information in this course to help increase your professional efficiency and improve your overall quality of life.

Charts and graphs are nothing new. However, many professionals struggle with building compelling visualizations. If that statement describes you, participate in this session to improve your skills in creating Excel charts and other visualizations. As a result, you will create visualizations to enhance your communication skills. This session is much more than just a seminar on fundamental charts. Instead, in this session, you will learn how to create advanced charts that are interactive, dynamic, and aesthetically pleasing – three qualities that will help to ensure that your readers and audience will understand the data you are presenting. This seminar is a must if you want to improve your communication skills.

This course will explore the use of ChatGPT and artificial intelligence chatbot technologies in the accounting profession. Participants will learn how to utilize ChatGPT to automate tasks, improve efficiency and accuracy, and provide real-time support to clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Technology continues to revolutionize our professional and personal lives. Stay up to date on key technologies that may affect you in the very near future so that you may position you and your organization for success.

Microsoft’s Power Platform – incorporated into many Microsoft 365 subscriptions – offers tools to automate common business processes. Learn how to take advantage of the Power Platform in this session.

When we verbally communicate with an individual, we must make a conscious decision as to whether we believe what we have heard.  Little do we realize that we are not making a decision based on what we have heard; rather we make a subconscious decision based primarily on what we have seen, or how the body was behaving when the subject was speaking.  We often walk away from a conversation with a gut feeling that the person was not telling the truth.  That gut feeling is your subconscious.  Yet we often have no idea as to why we have that feeling. This presentation is designed to provide the participant with the tools to identify those both verbal and nonverbal indicators that we all give off when we are under stress.  Normally, telling the truth does not create stress.  When we lie, we know that we are not supposed to and that creates stress, and it will manifest itself in some manner, and that is what a trained interviewer is looking to observe. When we observe indicators of deception, how do we deal with it?  How do we get the subject to admit to a wrong-doing when it is not in their best interest to do so?  That is one of the many things that will be addressed in this presentation.  Whether you are a parent dealing with you kids; an employer dealing with employees or and investigation interviewing a suspect, this presentation will provide you with the tools to assist you in finding the truth.