CPE Catalog & Events

This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The Secure Act 2.0 was passed in a flurry of year-end legislation. This one hour program will cover the important changes that employers need to know about company retirement plans. Employers will also need to consider how Secure Act 2.0 will the administration of existing plans or the creation of new ones.  This course will provide a concise look at these hot topics.   **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 course provides practical suggestions for improving leadership skills, including self-awareness, communication, delegation, empowerment, coaching, and counseling. 

Leaders have the right to exercise customary management functions. Employees have the right to be kept free from discrimination. Neither employer rights nor employee rights are absolute. The courts are equally protective of the rights of employees and employers. A courtroom is the wrong place for anyone to find this out. This course provides practical knowledge on how to effectively balancing these two sets of rights, such that employees and leaders stay out of court. Employers avoid lawsuits, rather than win lawsuits.

Whether a financial statement preparer or user is more familiar with IFRS or U.S. GAAP, it is important to be familiar with the important differences between the two financial reporting frameworks. This course will highlight some of the more significant differences between the standards.

The Uniform Guidance (2 CFR 200) pertains to the management of Federal Financial Assistance for grants and cooperative agreements.  The Biden Administration has performed a comprehensive update where the revised Uniform Guidance was released in April 2024. We will review all of the significant compliance and threshold changes. In addition, we will provide a brief presentation of the revised guidance as it pertains to Time and Effort reporting.

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.  

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.  

With over 50% of marriages ending in divorce, forensic accountants are frequently used in uncovering hidden income and assets. It is not uncommon for one spouse to hide money from another, sometimes for nefarious reasons. As a CPA, your services are valued by high-net-worth individuals who hire attorneys in their divorce proceedings. In this course, you will learn the art of financial investigations and how to uncover the truth in divorce cases, whether from offshore accounts to lifestyle analysis. Step by step, the course will teach you the valuable skills necessary in finding, analyzing, evaluating, and presenting your findings to your client and if needed, ultimately in divorce court. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Internal controls are more important than ever, and their importance increases daily. However, internal controls present a challenge for many smaller organizations. This program will teach you how to evaluate, develop, and implement an effective internal control structure in a small business environment. You will identify how to assess risk in smaller organizations and implement preventive, detective, deterrent, and compensating controls to mitigate these risks, even without proper segregation of duties. Additionally, participating in this program will teach you technology-focused techniques for preventing and detecting fraud and securing information systems and sensitive data. For small organizations, maintaining an effective system of internal controls presents a significant challenge. Realistically, implementing many theoretical concepts surrounding internal controls may not be possible in some cases. Consequently, many internal control structures foster an environment where too much risk exists. This factor and uncontrolled information systems can often lead to disastrous results. Participate in this program to learn the necessary insights and tools to design, implement, and monitor effective internal controls, security, and anti-fraud measures in small organizations.

If you or your clients are facing that stage of life where careers are passing into the background, and a new "to be determined" life is emerging, then you are entering what is called "retirement". Some people are excited, some are scared, and most are both. There are many issues and questions people face at this time - what to do with time, financial, relationships, health, identity and more. This program summarizes the key research studies, provides stories from those who have made this work, and offers thoughtful, practical exercises from my award winning book NEXT STAGE. It will help you (or your clients) address key issues and develop a Master Plan for the transition. If not now, when? This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Every organization today is facing an onslaught of pressure to master Artificial Intelligence “AI” strategies across their enterprises. Never before have we witnessed such a steep expectation for how a “technology” can transform a business, and never before have we been expected to leverage a technology so quickly and so completely.  There is no denying AI presents perhaps the opportunity of a lifetime to transform and improve operations, but to date few plans or roadmaps on how to unlock the promise of AI exist. In this class, Steve Cadigan, a globally renowned future of work expert, will present a practical plan for how you can build your own AI strategy, and how you can thrive in the AI revolution. Steve will show present a roadmap of how to build your confidence with AI to address this massive change management challenge.

Whether your organization is developing a new control framework or seeking to strengthen its current controls, practical development and implementation is critical. This course will review the intersectionality of controls and provide real-world examples and best practices from people to technology and process.  

Balancing the demands of a career and family life is a challenge faced by many working parents. The pressure to excel at work while being fully present at home can leave little room for self-care, often leading to burnout and mental fatigue. This course is designed to address these challenges head-on by providing actionable strategies to prioritize your mental health and overall well-being. The course emphasizes practical, easy-to-implement techniques tailored for busy working parents. From setting boundaries to prioritizing sleep and physical activity, you'll learn how to create sustainable habits that enhance your well-being. You'll also explore how to recognize the signs that additional support -whether from friends, family, therapy, or other resources- is necessary, and how to seek help without guilt or hesitation. Ultimately, this course will help you regain a sense of balance and control in your life by equipping you with tools to manage stress, build resilience, and rediscover joy in both your professional and personal roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Budgets are the vehicle for allocating resources, measuring activities, and identifying needed changes and improvements. An organization's strategy is the primary driver of costs. To be effective, the budget must be linked to strategy and long-term plans. Numerous organizations have achieved a series of short-term targets (budgets) but failed longer term, demonstrating the lack of this necessary linkage. Forecasting, a critical part of any successful budgeting process, can be flawed by technical errors, organizational structure, or emotional forces. The establishment of a system to collect, process, and analyze big data can provide significant insights into the budgeting and forecasting process. An efficient system of incorporating big data and analytics into normal activities will improve management's decision-making. This brief program offers specific actions to improve your forecasting and budgeting activities. In addition, more advanced techniques are identified for the participant's further review, which can be applied throughout an organization. Good budgets effectively allocate resources, provide information for decision-making and serve as an early warning system for unforeseen events. A poor budgeting process fosters a false sense of security, provides inappropriate or inaccurate data, and reinforces the status quo. Budgets are about the organization's story, not just the raw numbers!

As part of the Tax Cuts and Jobs Act (TCJA), IRC § 199A was added.  This Internal Revenue Code section allows certain pass-through entities the ability to has made it deduct up to 20% of their qualified business. Although practitioners have had over three years of “experience” utilizing IRC § 100A, many practitioners still do not feel comfortable with this part of the Internal Revenue Code.  The purpose of this presentation is to provide the practitioner with an understanding of the rules of IRC § 199A as well as an understanding of the IRC § 199A regulations. **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.

Good managers know how to delegate, but it can be a challenge to manage employees who are more interested in passing the buck than being responsible. Lack of ownership and responsibility can bog down processes and shut down projects. This workshop will help you create a game plan for building a culture of accountability with your team.

Generative AI tools such as ChatGPT, Microsoft Copilot, Google Gemini and many others are transforming the digital landscape of virtually every business, including CPA firms. We will demystify the complex world of generative AI in this informative session designed specifically for CPAs. We will break down the nuts and bolts of how generative AI works, making the technical aspects accessible and relevant. Equip yourself with the foundational knowledge to leverage AI in your practice or business. You will learn multiple examples of how you can apply generative AI tools in accounting, finance and tax to boost your team's productivity and improve the quality of your work product. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

A harmonious working environment is one in which people feel safe, seen, heard, and respected. Critical to maintaining it are that employees have high self-esteem, are treated with respect, and work in a safe, non-violent setting. This course provides practical knowledge and scripts on how to take appropriate action and deal effectively with discriminatory comments, sexual harassment, and threats and acts of violence, such that personal and employer liability is avoided.

You have more to do than time to do it. When you finally find the time, distractions steal it away again. As a leader with multiple layers of demands on your time, how can you possibly get it all done? In this course, I will help you learn practical productivity strategies so you can tame your to do list and multiply your time. It’s just wrong for a to-do list to rule your life. Learn how to take back your time…and your life.