CPE + Events Catalog

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.

You are likely familiar with and/or have experience with IRS summonses. BUT - Did you know there's a lot of procedure and decorum that goes into issuing a summons that you can leverage to help your client? This program will focus on the basics of an administrative summons, what the IRS can summons for, how you should comply with a summons, summons referral criteria, and common errors and misnomers the IRS can make in generating/serving a summons. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program will examine the key provisions of the Inflation Reduction Act of 2022 that was enacted to not only curb inflation, but reduce the deficit, promote clean energy solutions, and much more.  Learn how this new legislation can provide tax savings for both your individual and business clients.  **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.

Since its inception nearly 30 years ago, many have continued to struggle with applying the current model for accounting for income taxes, ASC 740. But this does not have to be you. This course will provide you with the basic knowledge necessary to understand the complexities of this challenging topic. Through discussions and use of exercises, this course will analyze the authoritative literature to provide a thorough understanding of such topics as deferred taxes, income tax expense, uncertain tax positions and other classification and disclosure requirements related to income taxes. We will also explore some specialized areas of income tax accounting, such as intra-period allocations of income tax expense and accounting for changes in tax laws and rates, and we will review proposed updates to ASC 740 disclosures on which the FASB is contemplating. In summary, this course is the place to be to enhance your accounting for income taxes IQ.

You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, “One day, I’ll learn how to write macros.” Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel’s Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don’t miss this unique opportunity to learn how to begin working with macros – one of Excel’s most powerful tools.

* This course is #3 in the Microsoft Power BI series of webinars. Click button in Program Content section below to see suggested viewing order. * Excel is a popular tool for data analysis, yet most users have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis. This session is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make data analyzation an easy task for all accountants. Participants will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, 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.

This webcast, part of the 2020 Power BI series, focuses on using the Power Pivot features to enhance data analysis including data modeling, using basic DAX and using the data model to create PivotTables.

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

This fast-paced course focuses on using Excel Power Pivot features to enhance data analysis. One of the strengths of Power Pivot is the formula language DAX (Data Analysis eXpressions). We will spend considerable time using the power of DAX to create meaningful calculations that add new dimensions to our data. 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 such as: month-to-date, quarter-to-date, year-to-date, last year same period, last year-to-date, etc. We will also demonstrate the hottest tips and tricks that will take your data analysis to the next level. Although our focus will be on using Power Pivot, we will review some of the other Power BI Tools including: Power Query (Get & Transform), Power BI Desktop and Power BI Services (PowerBI.com). NOTE: If you want to apply the concepts presented, you will need Excel 2013, 2016 or 2019/Office 365 AND the Power Pivot add-in pre-installed. To see our full prerequisite recommendations, see PROGRAM CONTENT section below. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, 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.

This course explores the FASB codification provisions and AICPA financial reporting framework for transaction with related parties, including business owners and special purpose entities. Real-life examples are used to illustrate the various authoritative standards and discuss the consequences of failing to comply. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This webcast is designed to equip individuals with essential skills and knowledge for making ethical decisions in both personal and professional settings. This webcast can help you to: Sharpen your ability to spot ethical pressures and dilemmas in any context Boost your moral courage and confidence to address these challenges head-on Master an actionable ethical decision-making framework to make principled choices. Elevate your ethical prowess and gain the confidence to navigate any professional or personal situation with unwavering integrity.

This course will review the Accounting Standard Updates issued by the FASB that impact nonprofit entities. We will also look at the work of the Not-for-Profit Advisory Committee (NAC) and the projects they are advising the FASB on. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.

A significant number of projects fail to achieve their initial goals and/or are not completed within budget and their original timetable. As a team member, a CMA has a unique skill set and experiences to assist in project management. In addition to their analytical training and knowledge of budgets and controls, they typically have ongoing contacts with other professionals from a variety of backgrounds. Familiar analytical tools/techniques can be applied to managing projects. This brief program is designed to aid both experienced and less experienced participants in increasing their knowledge of, and comfort with, the steps and skills needed for success.

This program will address recent legislation, rulings and developments affecting individual taxpayers and provide practitioners with a comprehensive update for the upcoming tax season. **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.

Isn’t it time you learned how to take advantage of critical features available in your Microsoft 365/Office 365 subscription? In this session, you will learn to use tools such as Teams, Planner, Power Automate, and others to enhance productivity and efficiency.

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 course is designed to provide learners with an understanding of the Internal Revenue Service (IRS) Cybersecurity Checklist and how it can be used to protect taxpayer data. The course will cover the basics of cybersecurity, including threats, risks, and vulnerabilities. Learners will be introduced to the IRS Cybersecurity Checklist, which provides a framework for organizations to assess and enhance their cybersecurity practices. The course will cover the various elements of the IRS Cybersecurity Checklist, including access control, data protection, and employee training. Learners will gain an understanding of the importance of each element and how it contributes to the overall security of taxpayer data. The course will also cover best practices for implementing each element of the IRS Cybersecurity Checklist. Throughout the course, learners will be presented with real-world examples of cybersecurity threats and breaches, highlighting the importance of effective cybersecurity practices. Learners will also be given practical exercises and assessments to reinforce their understanding of the IRS Cybersecurity Checklist. *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.

One of the biggest challenges, if not the most critical challenge in business, is attracting and keeping an engaged and productive workforce. Navigating the world of engagement and retention requires an understanding of human needs as well as deliberate and intentional actions to strengthen an employee's investment and connection to their place of work. For all the HGTV lovers out there, this session mirrors a television show where an individual/family must decide if they want to stay in their current home (after renovations and home improvements) or move to a new space. This webinar title seems apt in describing the current issues around engagement and retention. When an employee chooses to "love it" or stay with their current employer, it typically means they are engaged in their work and they feel seen, heard and valued- they are content. Conversely, the notion of "leaving it" typically symbolizes an employee who cannot wait to get out of their current job. These employees often have negative attitudes and/or behaviors at work. The purpose of this webinar is to recognize the significance of attracting and retaining employees, building your brand as an employer of choice and developing a culture where individual employees feel valued, cared for and ultimately engaged, all though an ethical lens. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program provides in-depth coverage of SAS 145, a major standard that helps auditors enhance risk assessment procedures through improved techniques for identifying and assessing risks of material misstatement. This session is essential for CPAs that perform audits. The discussion will also be insightful for auditees and other professionals who want to maintain awareness of current auditing guidance.