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.

Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session explores these differences and provides best practices for planning, executing, documenting, and reporting the results of an HR investigation. Attendees will end the session with takeaways to immediately implement in future HR investigations. 

Unlike a traditional financial audit objective (Are the financial statements materially misstated), performance auditing can address a wide variety of objectives.  Is this program working? Can it be improved? Where can we save money? How can we operate more efficiently and effectively? Are management’s assertions supported? And so forth.  This session will explain what a performance audit is, describe the applicable standards, and provide examples that indicate the value of a performance audit.  Performance audits can add value to any entity and practitioners can profit from adding these assurance services to their practices.

Be the go-to person on financial statement compilation and preparation engagements. Specifically designed for those performing preparation and compilation engagements, this course will provide you with a hands-on application for performing preparation and compilation engagements under AR-C Section 70 and 80, respectively. You will learn the ins and outs of relevant sections of the SSARS related to preparation and compilation engagements with a focus on how recently issued updates to SSARS No. 21 impact these engagements. More importantly, you will be provided practical examples and illustrations to help you effectively and efficiently perform those engagements, including a detailed discussion of the reporting requirements under AR-C 80 related to compilation engagement. Lastly, the course will review recent peer review feedback on these types of engagements, highlighting areas where you can improve engagement quality.

Financial skills needed in many situations are constantly changing.  It is prudent to routinely look into your toolbox to restock or revise your tool set.  In this course we will examine three tool categories that form the foundation for many analytical processes.

Obligating Coronavirus State and Local Fiscal Recovery Funds (SLFRF) by December 31, 2024 is essential to ensure a recipient does not have to return funds to the Treasury. There are a number of requirements to properly obligate SLFRF funds and opportunities to make changes to projects after the obligation deadline. In this course, we will define what an obligation is under SLFRF, review guidance from the Treasury, learn how to meet the SLFRF obligation deadline in multiple areas, and identify when changes can be made to estimates, contracts, and subawards after the obligation deadline.

This session explores the importance of internal controls with an emphasis on best practices for small- and medium-sized entities.  We will examine the roles of both preventive and detective controls and practical, cost-effective suggestions for implementing effective internal controls will be addressed.

SAS 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was issued in October 2021. This audit standard amends AU-C 315, making many changes to address common audit deficiencies. This course will provide an overview of SAS 145 and its changes to AU-C 315.

In this two-hour course, accounting professionals and technology enthusiasts will explore advanced home networking concepts to support remote work and modern digital needs. Learn to select prosumer-grade hardware, configure multi-SSID networks, and integrate functionalities like VPNs, media servers, and remote file access to boost productivity and security. Discover cutting-edge technologies, including SPF+ (10G networking), to future-proof your setup for data-intensive workflows. With practical demonstrations and relevant use cases, this session equips you with the tools to optimize your home network for efficiency, security, and scalability.

What's new in Peer Review? During this quarterly webcast, we will update peer reviewers on key recent developments in the AICPA Peer Review program. Please be sure to submit your questions and suggested topics to Peer Review staff so it can be addressed during the presentation!

Cloud computing has become a source of cyber-crime. “Cloud forensics is the application of digital forensics in cloud computing as a subset of network forensics to gather and preserve evidence in a way that is suitable for presentation in a court of law.” Cloud forensics is a combination of the varied types of accounting forensics including: •    Digital forensics •    Network forensics. •    Hardware forensics In cloud crime, the cloud is considered the object when the target of the crime is the cloud service provider they are directly affected by the act. It is considered the subject of the crime when the criminal act is committed within the cloud environment. It is considered the tool when it is used to plan or conduct a crime. This course will delve into the many concepts involved in cloud forensics. The course complements other courses in the series of Becoming a Forensic Accountant.  

Following the ever-changing tax deprecation rules is not a game for the faint hearted! This course analyzes the current landscape of depreciating, capitalizing and disposing of business assets, with examples and illustrated case studies to enhance the CPAs understanding of the most current tax depreciation provisions. *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

Properly designed and effectively operating internal control over financial reporting is critical for preventing, or detecting and correcting, material misstatement. This course describes how to satisfy the audit requirements related to taking a control reliance strategy by testing the operating effectiveness of internal controls, while promoting an effective and efficient financial statement audit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The Family and Medical Leave Act (FMLA) and the Americans with Disabilities Act (ADA) were implemented to improve the lives of employees. FMLA allows eligible employees to take job-protected leave for their own serious health conditions or to care for sick family members. The ADA was intended to ensure "equality of opportunity" and "economic self-sufficiency" for individuals with disabilities. Yet both laws have proven challenging for employers. These laws are complex with rules that can be confusing and often misunderstood. This webinar is designed to provide information, guidelines, and examples of the key concepts under both laws.

Strategic Planning for SMEs

Cybersecurity protection is one of the most important responsibilities of every CPA professional to protect the confidentiality of sensitive client information. While there are many aspects of cybersecurity that need to be addressed, the biggest vulnerability to protect against is unauthorized access to your application login credentials. Once your login credentials are breached, the cybercriminal essentially has the keys to your data kingdom. John Higgins, a national leader in the CPA technology, will demonstrate the ease with which you can protect all of your login credentials with maximum security with minimal expense. You will leave this course prepared to deploy this state of the art security tool in your organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This session provides a refresher regarding the fundamentals of activity-based costing (ABC). We will examine theoretical concepts before exploring practical possibilities for implementing ABC. A major focus of the course will be factors to consider when determining whether this managerial accounting tool is an appropriate resource for an organization.

Nonprofit entities and governmental entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes.

GAAP is changing at an increasing rate. Every successful organization has a sound strategy. Financial leaders are faced with the dual challenge of navigating evolving accounting standards while strategically guiding their organizations toward sustainable growth and profitability. What are the newer accounting changes that will impact professional accounting? This seminar will equip finance professionals with the critical skills and practical insights needed to effectively manage the complexities of ever-changing accounting standards and upgrade your essential strategic planning skills. Strategic skills are mandatory today. Strategies that do not keep pace with the market are doomed to fail. If we do not keep up, our successor will.

You only have one chance to make a good first impression.  In the fast paced world we live in, being able to create immediate rapport and a sense of trust with people is more important than ever.  Fortunately, this is an easily learnable skill that can serve you in both business and in life.  People who can master the one minute relationship end up making more money, being better liked, and enjoying their clients more.