Professional Development and Event Catalog

This course investigates actual real-world fraud schemes and discusses what controls could have prevented the fraud from occurring, and what controls could detect and curtail the fraud scheme. The instructor speaks from experience, finding multiple frauds very early in her career leading to a career-long focus on fraud prevention and detection. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Unlock the full potential of your data with our specialized course, "Create Measures in Power BI that Define Your Metrics". Designed for professionals who aspire to excel in the dynamic world of data analysis, this 4-hour intensive training delves deep into the advanced functionalities of Microsoft Power BI. You'll embark on a journey to master the art of Data Analysis Expressions (DAX), a powerful tool in the Power BI suite to create metrics. This course is meticulously crafted to transform you into a proficient user, capable of harnessing complex DAX calculations to bring your data to life. The course content is thoughtfully structured to ensure a comprehensive learning experience. Starting with the foundational elements of DAX, you'll rapidly progress to tackle advanced formulas and time-intelligent functions, essential for nuanced data analysis. The highlight of the course is the emphasis on the DAX calculation process, a crucial aspect for validating measures in Power BI. Additionally, the practical application of PivotTables for measure validation will equip you with the skills to confirm the accuracy and effectiveness of your data measures. These advanced techniques are not just theoretical concepts but are presented through engaging, real-world scenarios, enabling you to apply your learning immediately to your daily tasks. This course is an invaluable step towards mastering Power BI and making data-driven decisions with confidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Substantive Analytic Procedures - Strengthening Evidence to Satisfy Audit Objectives will provide the tips and best practice techniques for strengthening substantive analytic procedures in order to reduce over-reliance on tests of details. One of the ways to perform a more effective and efficient audit is to maximize the use of substantive analytic procedures in the detailed audit plan. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for analytical procedures. 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 provides a complete framework for transforming the culture in your organization. Key topics covered include: - What is organizational culture - A self assessment - Why culture matters - How to change your culture This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

AI is an extremely popular topic these days, and for good reason! However, does AI present yet another threat to your privacy? Get answers to this question and more in this session.

This is a two-part series that discuss new trends and concepts the financial controller should begin to execute in order to truly become a valued member of the senior leadership team. The rapid pace of the evolving technological landscape has promoted changes in how accountants and financial professionals focus attention on strategy and modernize their roles to leverage digital technology. There is increased demand for enhancing flexibility into finance cycles and initiating real-time reporting and insights. These are the core attributes that will assist in transforming the work that controllership function performs. Is the financial controllership prepared to meet future business demands? The IMA® (Institute of Management Accountants) and Deloitte’s Center for Controllership aimed to better understand the current state of controllership and expectations of future demands for controllers and accounting professionals. They conducted a survey in late 2022 and identified several trends. The survey takes a look at how prepared controllership is to meet future business demands. It also highlights some insights for leaders to consider that may increase their preparedness. It also identified areas of additional insight and questions to answer on the controllership transformation journey. In this segment one, we go through numerous concepts in detail and the remaining concepts will be covered in segment two.

Quality management will have a big impact on CPA firms. This course will cover both SQMS 1 and 2 as well as the related engagement level standards (SAS 146 and SSARS 26). The new standards will require a risk-based approach to quality management as well as the documentation of an information & communication process. This two hour class will provide a deep dive into what you need to know to start your implementation process!

This course will start with a review of the impact of the 2024 Compliance Supplement on Single Audits as well as the changes to the Uniform Guidance. We will also review common audit deficiencies found in Single Audits.

The mad scramble to remote work and utilize apps like Teams has been trying for most organizations over the past couple of years. With a rush to install and no time to plan, most team members did their best, prioritizing remote meetings as the primary concern. Therefore, as a result, Teams is vastly misunderstood and underutilized in most organizations. Join us in this session to go beyond the remote meetings aspect of Teams and to learn how to optimize efficiency, communication, and workflow with Teams.

This is a two-part series that discuss new trends and concepts the financial controller should begin to execute in order to truly become a valued member of the senior leadership team. The rapid pace of the evolving technological landscape has promoted changes in how accountants and financial professionals focus attention on strategy and modernize their roles to leverage digital technology. There is increased demand for enhancing flexibility into finance cycles and initiating real-time reporting and insights. These are the core attributes that will assist in transforming the work that controllership function performs. Is the financial controllership prepared to meet future business demands? The IMA® (Institute of Management Accountants) and Deloitte’s Center for Controllership aimed to better understand the current state of controllership and expectations of future demands for controllers and accounting professionals. They conducted a survey in late 2022 and identified several trends. The survey takes a look at how prepared controllership is to meet future business demands. It also highlights some insights for leaders to consider that may increase their preparedness. It also identified areas of additional insight and questions to answer on the controllership transformation journey. In this segment, we will go through numerous concepts in detail.  

Many organizations have implemented Microsoft 365/Office 365 at a basic level, but few have truly explored the breadth and depth of tools included with their subscriptions. Some less commonly known apps help you manage shared email boxes, create and use web forms, schedule appointments, trade shifts, create real-time closed captions, and translate presentations. Attend this session and learn more about the hidden features in Microsoft 365 that you can use to level up your productivity.

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.

It’s a whole new world for lessees under ASC topic 842.  Soon nearly all leases will need to be disclosed as a liability on the balance sheet – from buildings right down to autos and copiers.  Although the greatest impact will be on large entities, this will affect the financial statements of small and mid-size entities as well.  This program will dive into the new standard on leases, effective dates, and address what you need to know now.

Are you aware there are 470+ formula functions in Excel? Do you realize that they add new functions in every major version of Excel? Did you know that Microsoft adds new functions throughout the year in the Office 365 version of Excel? Are you stuck using old or simple functions like SUM or ROUND? Do you want to expand your knowledge of the extensive function library in Excel? If these questions peak your interest in becoming an Excel function expert, this course is right up your alley. This past-paced course digs into some of the most powerful functions in Excel. Although we cannot cover 470 functions, we will look at over 20 functions that will allow you to create advanced calculations in your spreadsheets. Some examples are: VLOOKUP, IF, IFS, FORECAST, RAND, SWITCH, TEXTJOIN, UNIQUE, SUBTOTAL, IS, TEXT and more! We will also provide example files that will include all the functions used during the class. It's time to take your Excel spreadsheets to the next level. This session is presented using Excel 2019/Office 365. Most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Resilience training was originally developed to strengthen individuals in high-risk groups like law enforcement, firefighters, and the military. This course also speaks to accounting and finance experts in a very challenging discipline. Resilience training is based on the intriguing assumption that resilience can be learned. A resilience leader possesses mental toughness, competence, and confidence. A confident accounting or finance person makes better decisions and thinks in deliberate ways to meet adversity and pressure. Resilience is the ability to exercise tenacity, bounce back from tough times, or even triumph in the face of adversity. Today's accounting professionals will experience challenges but are able to reframe then as learning opportunities. Resilient accounting and finance professionals push their limits, learn from their mistakes, and are able to transform an organization and themselves.

Since the early 2000s, the estate tax burden on taxpayers has gradually decreased along with the number of practitioners specializing in the field. Nevertheless, some of your most wealthy clients will have a taxable estate. For these select clients, making large gifts before death can be extremely tax efficient for the client and profitable for the practitioner filing the gift tax return. Learning how to file a basic gift tax return can help you attract and retain clients, increase your value-add, and generate revenue.

ChatGPT is the fastest growing application in the history of technology with over 100 million users adopting it in within two months. It is a revolutionary technology that boosts the quality and efficiency of business processes in every industry. As "knowledge workers", CPAs and CFOs are positioned to be prime beneficiaries of this technology. This half day hands-on course will get you well on your way to becoming a ChatGPT expert. John Higgins, a nationally recognized advisor and educator on CPA technology, will guide you through the process of accessing ChatGPT and applying it to a variety of practical accounting, finance and tax scenarios. This course will catapult you to the top of the pyramid of CPAs who are knowledgeable in ChatGPT and you will be ready to put it to use in your day-to-day tasks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

During this presentation, the most common mistakes made by employee benefit plan auditors, as well as plan sponsors will be identified. Best practices for handling specific issues that arise during the course of the engagement will also be explored. This discussion will help auditors recognize potential pitfalls in audit procedures/documentation and assist plan sponsors with compliance issues. 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 using Excel to keep track of progress and task completion for your engagements? Or, are you using a sophisticated engagement management app that takes too much time or requires too much information to keep your task completion progress up to date? Worst of all, are you relying primarily on email communications to keep track of your engagement task completion progress? If any of these scenarios apply to your practice, this course will show you a better way to manage engagements from simple 1040 tax preparation to comprehensive audits. The Microsoft 365 Planner app, which you are likely already paying for as part of your Microsoft 365 subscription, provides a comprehensive, yet simple solution for all of your client engagements and internal projects. John Higgins, a nationally recognized strategic accounting technology advisor will guide you through the process of how to deploy this app to effectively manage all your projects. This app is effective for sole practitioners and firms of all sizes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Due to IRS issue focused examinations, Accounting and Finance Professionals need to understand what types of returns are selected for examination and ways to help clients survive an IRS audit with little or no change. As a result of issue focused examinations, Accounting and Finance Professionals must understand what the high audit risk area issues are and what the IRS is focusing on when a return is examined. In addition, because tax-related identity theft is a common issue for many taxpayers, it is critical for Accounting and Finance Professionals to understand the procedures necessary to resolve this matter for their clients.