CPE + Events Catalog

This webcast, part of the 2020 Power BI series, focuses on using DAX (Data Analysis eXpressions) to create advanced calculations in Power Pivot data models.

This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order. This webcast focuses on using DAX (Data Analysis eXpressions) to create advanced calculations in Power Pivot data models. We will review what you learned in "Power BI - Go Beyond PivotTables with Power Pivot" and take your calculations to the next level using advanced DAX formulas. You will learn over 20 DAX functions that will allow you to perform calculations that were not possible with standard Excel. We will also review the use of a date or calendar table that allows us to perform date analysis that was never possible before. This will allow us to use the new time-intelligent functions to perform complex calculations on our data like: month-to-date, quarter-to-date, year-to-date, last year same period, last year-to-date, etc. You will also learn the DAX calculation process in order to proof and validate your calculations. We will be using Power Pivot to create our DAX calculations, however, the process is very similar in Power BI Desktop and the functions and formulas are identical. If you are using Power BI Desktop, you should be able to follow along and learn how to create advanced calculations. 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. (bold) 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 - Go Beyond PivotTables with Power Pivot Power BI - Use PBI Desktop to Create Reports and Dashboards Power BI - Share Your Data Analysis using PowerBI.com

Retaining Talent in a Competitive Marketplace -Creating a Benefits Program Employees Care About In today's competitive marketplace, retaining talented employees is becoming increasingly difficult. A solid benefits program can make a difference in the fight for talent - but only if those benefits matter to the employees you are trying to hire! Through statistics and case studies, this course will explore what benefits are most valuable to employees. We will also explore the basic types of retirement and health insurance plans and discuss what financial leaders should consider before adopting a benefits package. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Are you ready to expand your practice and offer comprehensive retirement planning services? Look no further! Delve deeper into the realm of IRAs and qualified retirement plans with this comprehensive eight-hour course tailored for financial practitioners. Understanding the intricate tax implications, design options, and strategic considerations of these plans is essential for meeting your clients' diverse retirement needs effectively. By the end of the program, practitioners will emerge equipped to confidently advise clients on a myriad of retirement planning strategies, enhancing their expertise and credibility in the field. Explore the intricacies of different IRAs, ranging from traditional to Roth, and gain valuable insights into SEPs, qualified plans, and contribution plans. Navigate through the complexities of 401(k) plans, including Roth 401(k)s, and master the art of seamlessly navigating minimum distribution rules. Through practical highlights, case studies, and real-world scenarios, this course empowers practitioners to not only select the optimal retirement plans for their clients' unique financial goals but also to provide personalized retirement solutions tailored to individual needs. Don't miss out on this opportunity to elevate your practice and establish yourself as a trusted advisor in retirement planning. Enroll today and embark on a journey towards maximizing your clients' financial future! **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.

The Not-for-Profit Advisory Committee (NAC) has been meeting with FASB to discuss the impact of various standards on the nonprofit community. We'll look at the work of the NAC and the impact they've had. We'll then transition to the Accounting Standards Updates (ASUs) issued by the FASB that impact nonprofit entities. We'll review year 2 considerations of the leases standard. We'll also review common nonprofit deficiencies identified in peer review. Once we've wrapped up the accounting update, the course shifts to the audit side of the house with a look at what's going on at the AICPA. We'll review the impact of the changes to group audits as the changes coming down the pike for quality management. This course will keep auditors up to date on the work of the ASB. 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 enable practitioners to understand and apply the AICPA "clarification" auditing standards to audits of Small- and Medium-Sized Entities (SMEs). Further, this course will provide guidance on how to perform an effective, efficient and profitable audit engagement. The course is loaded with practical practice aids to help enable participants to comply with the standards. Troublesome areas as identified in peer reviews and litigation will be covered. Participants who take this course will enjoy smooth sailing in their peer reviews, guaranteed! 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 allows you to get reacquainted with the statement of cash flows. We will refresh your skills regarding both the preparation and utilization of the statement of cash flows. Significant emphasis will be placed on the informational role of the statement of cash flows and insights that can be obtained using the statement of cash flows in concert with the other elements of a company's accrual-basis financial statements. 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 explores the tests used to determine whether a worker is properly characterized as an employee or an independent contractor for tax purposes, with a focus on the cost of getting it wrong and possible Section 530 relief.  The game changing impact of the Dynamex case and AB5 will also be discussed.  **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.

Getting ready for busy season involves not only knowing the tax rules for 2024, but also knowing how those rules are incorporated into the IRS tax forms practitioners will be using to prepare 2024 tax returns. This course provides tax return preparer attendees with an up-to-date review of important new tax forms, key tax developments, and tax law changes as they are reflected in IRS forms for 2024 and IRS filing issues and deadlines as they relate to 2024.

This course is designed to provide accountants with a comprehensive understanding of the subscription pricing model. As the business world increasingly shifts toward subscription-based models, it's crucial for accountants to understand the financial implications and strategies associated with this pricing approach. This course will cover the basics of subscription pricing, how to set prices, and how to analyze the financial impacts of these decisions, as well as the specific impacts to your business. By the end of this course, participants will be equipped with the knowledge and skills to effectively manage the implementation of subscription pricing to their practice.

This course uses the lives of the rich and famous as a template to better understand the realm of estate planning. With stories ripped from the headlines, we will examine pitfalls and best practices. Did you know that Prince died without a will, opening the door for 45 people claiming to be his beneficiaries? Or that Michael Jackson was not careful in properly funding his trust, leading to delays and legal battles in the administration of his estate? Even Abraham Lincoln, it turns out, did not have a will. In discussing an array of celebrities, from Jackie Kennedy, Joan Rivers, Jimi Hendrix, and Whitney Houston to Aretha Franklin, Barry White, Leona Helmsley, and Florence Griffith Joyner, the course is designed as an enjoyable learning experience with tips for all levels of expertise. We may not have their fame or fortune, but we can certainly walk the red carpet when it comes to estate planning.

Practitioners that provide non-audit services must strike the right balance between complying with relevant professional and regulatory standards, providing value-added client service, and mitigating litigation and other practice management risks. This course contains many case studies to reinforce best practices for managing the accounting, reporting, and performance issues associated with the attest services of compilations and reviews where reports are issued, as well as the SSARS  preparation of financial statements service and other nonattest engagements.

Business intelligence efforts continue to grow, and Microsoft’s Power BI platform is central to many of these efforts. Participate in this session to learn more about business intelligence and how to create dashboards using Power BI.

This session features the latest behavioral science, demonstrations of experiments, and compelling real-life stories to disrupt everything you thought you knew about fraud. It will spur you to challenge "sacred cows" of the industry and help you develop better thinking approaches to detect, deter, or investigate fraud, waste and abuse. Learn why many of our basic assumptions about fraud are flawed, why some widely accepted investigative practices are more harmful than helpful, and how auditors and investigators sometimes unwittingly assist fraud schemes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Sampling - Avoiding Common Mistakes on Financial Statement and Compliance Audits will describe the proper process for both attribute testing and variable sampling in financial statement and compliance audits. Sampling is an important method for determining the extent of testing controls, testing compliance, and tests of substantive details. It allows the auditor to apply procedures to less than 100% of the population yet extend results to project likely conclusions about the entire population. 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 sampling responsibilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Get familiar with SAS No. 145 (bold) In October 2021, the AICPA Auditing Standards Board issued Statement on Auditing Standards (SAS) No. 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement. SAS No. 145 does not fundamentally change the key concepts underpinning audit risk. Rather, it clarifies and enhances certain aspects of the identification and assessment of the risks of material misstatement to drive better risk assessments and, therefore, enhance your audit quality. Hear from members of the Auditing Standards Board's risk assessment task force as they help you learn to navigate SAS No. 145 and examine new and updated concepts including: A new definition of significant risk New guidance on maintaining professional skepticism Revised requirements to evaluate the design of certain controls Separately assessing inherent risk and control risk Revised requirements regarding audit documentation New guidance on scalability

The Financial Accounting Standards Board (FASB) has issued a new accounting standard for leases. This new standard-ASC Topic 842-replaces the existing ASC Topic 840, changes the accounting for operating leases (requiring capitalization in the financial statements), and upgrades many other lease accounting and reporting aspects.

External auditors only detect 3-5% of all fraud incidences. Get pragmatic guidance on detecting fraud. Discuss where fraud is most likely to occur. Learn to conduct inquiries and direct the audit in the areas of greatest concern, those most likely to be abused by perpetrators.

Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in SAS Nos. 134-145. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many professionals, including corporate management, loan officers, investors, suppliers, customers and auditors, use financial statement analysis to perform their daily responsibilities. This program focuses on financial statements and the analysis of financial statements utilizing cases to assess profitability, liquidity, and resource management efficiency. We conclude with discussions of non-GAAP performance measurements, forecasting, and valuation.