Professional Development and Event Catalog

Most business professionals have used Excel for years, often without the benefit of any formal training. Thus, they don't know about key features in the application and, therefore, don't use them. Of course, this leads to inefficiencies and errors. Isn't it time to stop this madness? This session is for you if you're ready to become more efficient and effective with Excel! You will learn ten critical features that can help you get more work done in less time and improve your accuracy. We encourage you to make plans to join us for this session to learn the best ways of working with Excel!

PowerPoint is a widely available resource that is potentially underutilized by accountants because many accountants do not stray beyond Excel and Word in the Microsoft Office suite. You will learn how to create and edit a professional PowerPoint slide deck. This session places particular emphasis on efficiency tips and tricks that will allow you to develop creative, professional visual aids while minimizing time and effort. The course’s author will share personal insights he has cultivated throughout more than two decades of public speaking. Although the session will focus on creating and editing slides, we will illustrate best practices for presentation delivery. We will also explain how PowerPoint can be used for purposes other than delivering presentations.

Are you comfortable giving presentations and feel good about your performance, or does the experience make you anxious and leave you feeling dissatisfied? In this session, learn how to let your best self shine during interactions with your staff, the auditee, and the governing board. Jim Comer is an accomplished speechwriter and presentations skill coach for executives. Leita Fanta has led over 1500 full-day seminars. Let Jim and Leita help you establish genuine and comfortable professional relationships and avoid mistakes that will detract from your message. *Qualifies for Yellowbook credit This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

There is no shortage of data, but relatively few organizations have an environment and process to isolate, capture, analyze, and convert data into actionable information. Too often, we collect as much data as possible, continue to use historic measurements, and communicate data using traditional vehicles. Good decisions are not the result of the amount of data gathered, but of the quality and understanding of the information. The goal of this program is to explore a number of analytical tools and techniques and identify applications for them within an organization. Analytical techniques will be introduced throughout the discussion, and a significant amount of time will be spent addressing the steps needed to establish a data-driven environment and identifying and discussing potential/specific applications. In this way, participants get experience they can begin to use in their organizations. An expanded list of reference books and next level software is also provided.

While ethics training is required by many states, the true value of the CPA license is in understanding how critically important ethical behavior is to our customers, our firms, and the public. This course will explore the basic tenets of ethical behavior and use case studies to explore ethical dilemmas in various companies and organizations with a focus on dilemmas that may face CPAs in the industry.

Nonprofit 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. Nonprofit 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. 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.

This course will provide overview of key cybersecurity security domains that CPA's should evaluate in an audit. It will provide an overview of each security domain, and an overview of how to evaluate and assess the sufficiency of the cybersecurity control. Examples of security domains that will be covered include: Change management Access management Data integrity 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 is a 'deep dive' into many aspects involving the taxation of real estate for the mid-level practitioner moving into this complex area. You will deepen your understanding of the complex considerations and strategies that individuals must navigate in acquiring, operating, and selling real estate. You will leave the course able to navigate critical issues associated with the relevant returns and plan strategically for your company or clients. We will discuss in detail the impact that recent tax changes have had on the real estate industry, as well as new credits that are available after the Inflation Reduction Act of 2022.

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.

Now more than ever, navigating loss, grief and crisis in the workplace is a skillset that leaders must possess. Keeping the heart in human resources is so important, especially in this post-pandemic state we are living in. We will explore ways that you can show empathy to your employees while also balancing your business needs. 

In the dynamic landscape of modern workplaces, the ability to retain top talent and foster employee engagement is a key determinant of organizational success. "The Education Advantage" is a one-hour program designed to help HR professionals, employers and employees understand: Turnover Costs Cost of Disengaged Employees Professional Development as a Strategic Imperative Employer Hesitations How to Embrace Professional Development Initiatives Types of Educational Opportunities This one-hour session is ideal for HR professionals, managers, and organizational leaders seeking tangible solutions to elevate employee engagement and retention through strategic professional development. Elevate your workforce and organizational success with "The Education Advantage."

Why do for profit organizations exist??? To make money!!!!! What a great concept. But if the organization does not have the proper collections and credit procedures in place, they may not be able to access that money. Hence the importance of the credit and collection process. Credit and collections are critical areas for the financial statement controllers. Customer credit is a form of payment that allows small business customers to purchase a product or service before paying for it in full. The process works similarly to the way a credit card does - you procure something and pay it back later. Collections is a term used by a business when referring to money owed to that business by a customer. When a customer does not pay within the terms specified, the amount of the bill becomes past due and is sometimes submitted to a collection agency. The sales and collection process includes business activities related to selling products and services, maintaining customer records, billing customers, and recording payments from customers. It also includes activities necessary to manage accounts receivable, such as aging accounts and authorizing credit.  This course delves into the topics that impact the sales, credit and collections process for management. We discuss strategic steps management can take to ensure their processes are efficient and that they are able to actually collect their revenue.  

This course is a complement to our series on Becoming a Forensic Accountant and the focus of the course is on steganography techniques. Steganography is the art and science of embedding secret messages in a cover message in such a way that no one, apart from the sender and intended recipient, suspects the existence of the message. The first use of steganography can be traced to 440 BC when ancient Greece, people wrote messages on wood and covered it with wax, that acted as a covering medium Romans used forms of Invisible Inks, to decipher those hidden messages light or heat were used. During World War II the Germans introduced microdots, which were complete documents, pictures, and plans reduced in size to the size of a dot and were attached to normal paperwork. Null Ciphers were also used to hide unencrypted secret messages in an innocent looking message. Given the amount of data being generated and transmitted electronically, it’s no surprise that numerous methods of protecting that data have evolved. There are various types of steganography: Text Steganography - Hiding information inside the text files. This involves changing format of existing text, changing words in a text, generating random character sequences or using context-free grammars to generate readable texts. Image Steganography - Process of hiding text in an image without distorting the picture. Video Steganography - Technique to hide any kind of files into a cover video file. Audio Steganography - The secret message is embedded into an audio signal which alters the binary sequence of the corresponding audio file. Network Steganography - The process of utilizing active network protocols as carriers to transmit a covert message, undetectable by an uninformed party, from a host to its destination. This session will review these methods and also discuss relevant software.  

Sampling is often identified as a common audit deficiency in peer review. This course will review when is sampling applicable and basics of planning a sample. We'll then focus on the application of sampling in financial statement audits with a look at sampling for substantive procedures. We'll look at the use of monetary unit sampling and tools that can be leveraged to reduce bias in sampling.

This course will serve as an introduction to conducting effective walkthroughs to gain an understanding of the client's transaction processes as well as identify internal controls within each process. This course will review the procedures, questions to ask, and documentation requirements of walkthroughs. It will also include real-world examples of the red flags that may arise while executing a walkthrough. 

This presentation will provide a detailed analysis of the Circular 230 rules for conduct of a tax practice, with a review of the political, legislative and regulatory rules impacting every accounting and tax professional. Best practices and guidance provided by the AICPA’s Code of Professional Conduct will 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.

Reviewing Workpapers - Embracing Responsibilities for Quality Control will provide the tips and tools for satisfying important workpaper reviewer responsibilities. Audit documentation provides the principal support for an auditor's report. Therefore, it is critical for workpaper reviewers to perform quality control procedures to ensure that technical, professional, and regulatory standards are met. In addition, the workpaper review process should be used as a tool for professional development and promoting efficient audits. 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 workpaper review responsibilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Power Query and Power BI offer great opportunities for accessing your data and making it more useful in reporting scenarios. Learn how to benefit from these tools in this session.

Globalization continues to make it easier for taxpayers to live abroad, do business in other countries, or invest in foreign enterprises. This creates significant complications and tax planning opportunities when it comes to filing U.S. tax returns. This course provides an overview of the unique tax challenges and solutions presented to U.S. expats or investors living or investing abroad. It examines how foreign-source income is taxed in the U.S. and how the tax consequences could be mitigated by applying the tax treaties, claiming credit for foreign taxes paid, or excluding foreign-earned income. Additionally, the course discusses the numerous foreign informational form reporting requirements and the significant penalties that could be imposed by the IRS. Examples from real-life client scenarios are included.