Professional Development and Event Catalog

Have you ever opened a blank workbook in Excel and just stared at it, wondering where to begin? Or, do you spend most of your time just formatting cells to make your spreadsheet look pretty? Or, do you just wonder if there is a better way to create your spreadsheets? This course is designed to take you from a blank worksheet to a completed report. Our example will be a financial statement but you can use the knowledge gained in the course and apply it to your specific job function. You will learn to import data instead of manually entering it. Learn that you can use functions and formulas to build calculations that will eliminate the need to manually manipulate your data. Our goal is to make sure you have all the information needed to build reports without having to manually enter it every month. You will learn techniques to use your data to build your reports. This will include building formulas that are flexible with your changing data. You will learn techniques to validate your report calculations so you can improve the accuracy of your reports. You will also learn how to quickly format reports and techniques that allow you to efficiently change the format. Lastly, you will learn how PivotTables can provide a more dynamic reporting option instead of using pre-defined report formats. Obviously, we will be covering a lot of ground, so to enhance your learning experience all examples will be provided to each participant along with instructions. This will allow you to follow along and use as you apply your new knowledge to your spreadsheets. 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.

Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.

Navigating the challenges of estate and gift taxation can be overwhelming for practitioners, especially those lacking extensive experience in this field. In this comprehensive course, participants will undergo a practical exploration through the preparation of the Federal Forms 706 and 709 - line by line. Through hands-on instruction, attendees will gain invaluable insights into the complexities of tax compliance, equipping them with the skills and confidence needed to seamlessly integrate estate and gift tax preparation into their practice. With a focus on practical application, this course offers participants a unique opportunity to master the preparation of crucial tax returns, enhancing their professional expertise and strengthening client service offerings. From a detailed overview of the Federal Forms 706 and 709 to insights on complying with "Portability" and navigating postmortem estate planning issues, attendees will emerge with a newfound proficiency in estate and gift tax preparation, ready to excel in their practice. **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.

According to the Gallup Organization, only 10% of employees believe that their organization does a good job onboarding new employees. This means most organizations are overlooking this crucial phase of the employee lifecycle, which not only includes the often-neglected pre-boarding stage but also the continuous efforts to reduce uncertainty, bolster excitement, and foster connections for their new recruits. By streamlining these processes and crafting impactful moments from pre-boarding through the initial weeks, HR and Business leaders can significantly enhance efficiency, foster trust, and establish a foundation of psychological safety for years to come. In this session, attendees will discover strategies and resources that craft a holistic onboarding experience, mitigating risks like employee ghosting, and paving the way for heightened engagement and retention.

Overview of the most important labor and employment policies and practices that every business should have. The review will go over confidentiality agreements, arbitration agreements, restrictive covenants, training, and severance agreements, as well as compliance issues related to each of them. 

It's a whole new world for lessees under ASC topic 842. This program will dive into the new standard on leases and its impact on every size entity, review effective dates, and address what you need to know now. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Enterprise Risk Management for SMEs

Auditing Revenue Recognition - Grasping the Higher Risks and Special Audit Considerations will provide tips and techniques for obtaining sufficient and appropriate audit evidence to support conclusions related to accounting for revenues obtained from contracts with customers. Revenue recognition is presumed to be a significant risk for financial statement auditing purposes due to the increased risk of both fraud and error. Note: This course is recommended as a part of a 16-hour audit skills curriculum for supervisory or managerial auditors, while it is also appropriate for anyone who has responsibilities in auditing revenues. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In the world of work today, nothing is more critical than Culture.  If people are your competitive advantage, then culture is the best way to help your people realize a great destination. While many leaders and companies talk a lot about culture, few take the time to really plan, build, and invest in a great culture. Today, the world of work could not be more challenging, and the changes that we are seeing in the workforce, such as the rise of remote workers and increasing turnover, are adding to the complexity. Now more than ever, Culture must become your competitive advantage. In this course, you will learn about the key macro changes in the workforce and what some leading companies and leaders are doing to create amazing cultures and high-performing organizations. From LinkedIn to Patagonia to Eventbrite, you will learn from some top organizations ow they have successfully leveraged culture. You will learn what Culture is and can be, and you will learn what culture is not. As you set sail in 2024 and beyond as a leader, you will benefit from this class and learn how to make culture your competitive advantage. Your teacher for the class is Steve Cadigan, whom many credit for being the architect of LinkedIn's world-class and groundbreaking culture. 

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.  

With capacity challenges on the mind of many tax and accounting leaders, finding ways for their teams to work more efficiently is crucial. They need their teams to not be busy, but deliver value, and continue to develop their skills and knowledge. Project Management techniques help uncover inefficiencies and gaps in current processes, as well as, manage the planning and forecasting needed to drive necessary changes for future success. In this session, learn when to incorporate project management best practices that can help you get the best out of your team.

This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Cybercrime is on the rise and CPAs that handle sensitive client data are often the target of cybercrimes.  By attending this session you'll learn what the eight biggest threats are to your business and uncover the three pillars of cybersecurity that you can build your firm's defense around.

This session will focus on the most common types of fraud in the procurement and contracting arena, with a focus on fraud in construction.  The session will examine fraud vulnerabilities in the four key phases of the procurement process: Presolicitation. Negotiation. Performance. Closeout and Claims.  Within each phase, “red flags” will be discussed.  These are the indicia of possible fraud that managers should be alert for.  Also, within each phase, the most common fraud schemes will be highlighted and discussed.  Finally, the session will describe the generally accepted safeguards or controls that should be established to prevent the various fraud schemes that can occur.  This part of the program will make extensive use of actual fraud case studies designed to demonstrate fraud risks and fraud detection strategies.

This is a continuing part of our series on forensic accounting. Within this segment we discuss the concepts that are part of computer forensics known as cryptology. The term cryptography is from Ancient Greek and means “hidden secret”. It is the practice and study of techniques for secure communications in the presence of adversarial behavior. Cryptography is about constructing and analyzing protocols that prevent third parties or the public from reading private messages. Cryptography starts with secrets. Various aspects in information security such as data confidentiality, data integrity, authentication and non-repudiation (where a statement’s author cannot successfully dispute its authorship) are central to modern cryptography.

Penalty abatement is a technique that tax practitioners can utilize to help their clients reduce penalties and interest they owe to the IRS if the taxpayer can prove "reasonable cause". This informative and insightful webinar will provide you with some insider tips, practical steps and effective strategies to help your client manage IRS tax penalties and interest. Learn about various types of penalties that you may face, and the various forms and procedures used for requesting penalty and interest abatement, including First Time and Reasonable Cause abatement. Plus, learn about the procedure to follow when requesting refund of paid penalties. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

How to pay for the cost of long-term care remains a primary concern for most clients over the age of 50. Explore clients' motivations, misconceptions and objections to purchasing long-term care insurance, and a look at the latest long-term care solutions, including hybrids. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Please join us for a discussion on Treasury Circular 230 and other ethical issues faced by enrolled agents and other tax preparers.  In addition to covering the practice standards espoused by Treasury Circular 230, there will also be an overview of the applicable provisions in the Internal Revenue Code (IRC) and common law which will affect tax preparers.  The discussion will conclude with other ethical issues, such as avoiding conflicts of interest, proper fee structure and maintaining competency.  Also included will be case studies illustrating dilemmas faced by tax practitioners.   **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.  

Pro forma statements are used by businesses to make decisions on planning and control, as well as for external reporting to owners, investors, and creditors. For example, giving financial estimates for a given period in a standardized manner is known as “presenting pro forma,” a Latin phrase that means “as a matter of form.” Pro forma statements can be helpful tools for business owners, investors, creditors, or decision-makers to analyze various scenarios of future events based on certain financial assumptions. It might aid in making predictions performance of the company. A pro forma income statement displays a firm’s anticipated sales and revenue. It also highlights anticipated fixed or variable operational expenses and, in the end, displays the potential profits and retained earnings for a future financial quarter. There are various types of pro-forma statements and methods to develop them. The responsibilities/competencies of the Financial Controller position (FC) has changed in recent years. However, the creation of pro forma financial statements is still a core part of their responsibility.