Professional Development and Event Catalog

The course will start with the Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. We will also review year 2 implications of the leases standard including modification accounting. We will then switch our attention to the items coming down the pike, including a look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The War for Talent is bad, and it's getting worse. In their efforts to win the war for talent, smart organizations have recognized the importance of fostering a great work culture. Many of these organizations are implementing Servant Leadership as their desired leadership style. In this session, learn what servant leadership is, as well as what it is not. Also, learn the benefits of having a great culture, the basics for assessing your culture, as well as how to coach your employees using a servant leadership style. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This session provides a refresher regarding the fundamentals of activity-based costing (ABC). We will examine theoretical concepts before exploring practical possibilities for implementing ABC. A major focus of the course will be factors to consider when determining whether this managerial accounting tool is an appropriate resource for an organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Although organizations are trying to create and manage diverse and inclusive workplaces, many are not aware of some of the best practices and simple strategies they can incorporate to promote such an environment. We are currently living in unprecedented times. Division, bias, and exclusion, based on factors associated with social injustice and a general lack of appreciation for diversity, seems to have become our current societal norm. With the high stress and anxiety created by these current trends in society, it is even more important for organizations to provide a safe space for their employees where there is a genuine sense of belonging and fair access to opportunity. The goal of this course is to outline the relationship between diversity and inclusion, while providing very practical strategies for HR Professionals in their role to promote a culture of diversity and inclusion in the workplace.  

The tools for managing performance and addressing misconduct are not identical. The failure to point this out to leaders has often resulted in the use of the wrong tool. Reinforcing good performance and securing improvements in performance requires skill in coaching employees, making effective requests, and providing effective feedback   This course provides practical knowledge and scripts for setting, communicating, and enforcing performance expectations, such that personal and employer liability is avoided.

Each year, more states legalize cannabis (i.e., marijuana) for medical or recreational purposes. As legalization grows, so too does the cannabis industry. While some financial professionals have stayed away from this growing sector of the economy, others have embraced the opportunities the cannabis industry has to offer. The legalization of cannabis brings with it a complex regulatory landscape, which includes strict compliance with federal and state regulations. However, the complexity of this emerging market provides opportunities for accountants and other financial professionals. Behind the cannabis dispensaries are scores of related business sectors including food production, retail, farming, and chemical production, as well as facilities, design, and construction. Simply stated, the commercialization of marijuana offers financial professionals an opportunity to participate in an industry expected to reach $73 billion worldwide within six years.

Everyone knows that Excel is the most widely used spreadsheet application in the world today. However, because it is ever-changing, many users are unable to keep up with the latest features and capabilities of this ubiquitous application. In this session, we look at some of the most helpful new features and tools that have been added to both the Desktop version of Excel and the Web version. Content like this is valuable to anyone that regularly works with Excel - We hope you will attend! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Security is not optional, and yesterday’s security techniques do not minimize today’s security threats. Therefore, now is the time for you to tune up what you know about protecting sensitive data. This program will teach you the latest tools and techniques for securing your data, including encryption, virus protection, safe communications, electronic signatures, secure authentication, and more. You will also learn how to implement a practical, five-step approach to securing your PC and the questions you should ask your staff to ensure server-based information remains protected. Security failures, such as a breach of client or customer data, are costly – they can even drive your company out of business. So, what security tools do you need, and how should you use them to secure your sensitive data and systems? Can you afford to risk attempting to manage today’s threats using yesterday’s techniques? Participate in this program to learn how to identify viable and practical solutions to mitigating today’s security threats.  

New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel’s “legacy” features, and you have significant new opportunities to improve your Excel-based reporting environments. In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to quickly and easily format your spreadsheets to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process.

The course explains why you need more than Google to search the Internet and highlights a rich constellation of alternative search engine applications. The session also explains how to set up your own customized online research management platform, and discusses dynamic search strategies (two-step, vertical and lateral searching) that can be used to gain an extra edge when using any search engine. Participants will walk away with scores of new knowledge sources and streams that will complement their use of Google and improve their online research power. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

Do you ever get tired of other people's complaining and negativity? How can you stay calm, upbeat, and motivated despite other people’s grumpiness, rudeness, or pessimism? This program is all about helping you be your best. Even though you may not be able to change your colleagues, customers, or even your boss, you can reduce your stress and frustration by changing how you respond. Staying positive and calm is easier when you learn how to build your immunity. This course teaches you Tina’s proprietary five-step “Immunity to Negativity Formula™”. You’ll learn simple techniques for staying calm and choosing to respond as your best self. This is a key skill you can build for yourself so you can enjoy less stress and frustration. You can even teach others so they can improve customer service, teamwork, and relationships within your company.   

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.

A discussion of the latest 2021/222 tax developments impacting business taxpayers, with a focus on important provisions, rules and concepts. 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 ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work.

Blockchain technology offers the promise of digital truth. It provides a transparent, permanent, immutable, and high-speed record-keeping system when appropriately implemented. The possibilities are endless, from managing the logistics of supply chain networks to facilitating international commerce. The adoption of this technology is growing, with millions of new users every year. Organizations adopt this technology every day to help improve their existing operations through its ledger capabilities or executing smart contracts. Cryptocurrency is one example of blockchain technology. Its growth and value have exploded to over $2 trillion in the last few years. This growth has helped to fuel widespread adoption amongst Wall Street and regular investors alike. While more popular than ever, few business professionals understand these technologies, their capabilities, risks, and potential impacts on business operations and processes, such as contract execution, recording and maintaining real estate ownership records, and supply chains. In fact, this incredible technology is a mystery for most accounting professionals. This course will provide a detailed and in-depth look at this technology, including a detailed overview of the underlying technology, the benefits, the risks, the major players, and many practical applications. By participating in this session, you will gain a deeper understanding of the inner workings of this technology and recommendations on getting started.  

How does a forensic accountant calculate financial losses? Federal courts have approved various ways to calculate losses ranging from net worth method of proof to the expenditures method. Each method of proof depends on the available facts to the forensic accountant. This presentation will focus on the various court approved methods of proof, when to use them, and how to calculate the total loss. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Making Rain - Improving Success with Retaining Clients and Attracting Prospects provides tips and techniques for ensuring that your firm has the capacity to grow and expand its book of business in a healthy way. It costs more money to develop a new client than to simply retain an existing one. While a CPA firm with longevity needs to continuously develop new business to replace departing clients, a proper balance of marketing efforts should be divided between existing clients and prospects. Note: This course is recommended as a part of a 8-hour audit skills curriculum for managers, while it is also appropriate for anyone who has client relationship or prospecting responsibilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In today's rapidly evolving business landscape, accounting professionals are expected to be more than just number crunchers, they are expected to be insightful interpreters of data. In an era where data is king, this course is your gateway to becoming a savvy data analyst, giving you a competitive edge in your field. We will guide you through the intricacies of making complex data analysis approachable and engaging. You will learn the all important Data Analysis Process Flow that will take you from collecting data all the way to making insightful decisions based upon your data. We will explore the basics of data modeling that will allow you to access data from multiple sources and use sophisticated calculations to create our data metrics. You will learn how to create interactive dashboards, perform sophisticated reporting, and uncover deep insights from your data. Whether you're looking to streamline your reporting process, enhance your data visualization skills, or make more data-driven decisions, this course is tailored to meet those needs. It's not just about learning a tool; it's about enhancing your professional identity as a forward-thinking accounting professional. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The objective of corrective action is to change conduct through teaching.  Corrective action may be sequential, out of order, repetitive, or not appropriate to take at all.  The action selected should reflect the type, frequency, and severity of the misconduct.  Changing conduct through teaching requires effective employee relations skills. This course provides practical knowledge and scripts for handling a wide array of sensitive misconduct situations with good judgment, such that personal and employer liability is avoided.