Professional Development and Event Catalog

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. 

This session will provide a basic overview of Employee Stock Ownership Plans (“ESOPs”). It will specifically address what companies are well suited for establishing an ESOP, how ESOPs are implemented, and how employees and departing owners alike can benefit from them. The session is intended to provide business and tax advisors with talking points about how an ESOP may be used as a succession planning strategy.

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.

Social media - it's a buzzword, but is it beneficial for your firm's brand? And more importantly, your bottom line? This course focuses on the latter and takes a deep dive into which social media platforms are best for accounting firm lead generation, recruitment, client retention and more. Attendees will take away a practical framework and actionable tactics for integrating social media into your firm's overall marketing and communications strategy to help you grow your revenue without having to spend hours on social media or even be on it personally if you don't wish to! This event may be a rebroadcast of a live event and the instructor will be available for questions during the event.

What were they thinking? Why do business leaders sometimes make horrible decisions that severely damage themselves and their organizations? It is tempting to assume that poor choices must be due to someone's incompetence, inexperience, bad character, or low intelligence. Yet, when we make a mistake ourselves, we someone rationalize it as a choice other people would make under the same circumstances. This session will discuss the common decision-making errors people make and to help you avoid making these blunders yourself. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The course provides a concise overview of cognitive biases - thinking errors and "brain bugs" that may distort perceptions, compromise ethics, trigger inaccurate judgments, and spark illogical interpretations in your accounting work. Discover the most common types of cognitive biases in the profession, and how to recognize and address these flaws and blindspots in your "mental firmware". This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The newest acronym in the business community is ESG (Environmental, Social and Governance) Investors’ demand enhanced information about how companies are approaching environmental sustainability. (Sustainability accounting) The foundation of sustainability reporting is for an organization to identify and prioritize its impacts on the economy, environment, and people - to be transparent about their impacts The foundation of sustainability reporting is for an organization to identify and prioritize its impacts on the economy, environment, and people - to be transparent about their impacts This session is an introduction to the topic of ESG and what accountants and management should know

This program focuses on two parts of Subchapter K, partnership distributions and sales of partnership interests - topics that tax practitioners are often asked about by clients. Tax practitioners are called upon to advise both the partnership which makes distributions and the partners receiving the distributions regarding the tax consequences of these transactions. Additionally, tax practitioners will be deeply involved in decisions regarding the sale and purchase of a partnership interest. These topics are thoroughly covered in this program. The presenters also discuss several types of partnership distributions and the tax rules relating to them, as well as analyze the tax rules relating to the sale of a partnership interest. Tax practitioners will be given an in-depth analysis of these complex topics, so that they can effectively answer their clients' questions.

This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many organizations are successful as they create a system of internal controls, however some fail to properly implement the measures that are established. Moreover, entities regularly neglect the important process of testing, monitoring, and updating control procedures, which weakens the entire internal control structure. This session provides an overview of control creation methods and discusses ways to successfully implement policies and procedures. Additionally, it includes an array of control maintenance checklists that participants can take and adapt to their organization as they work to improve policies and procedures. Finally, it provides an understanding of the need for dynamic, fluid controls that adapt to changes in business tools and methods. Participants that take this course will have a strengthened ability to implement and maintain an internal control system. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In order to prepare accurate and effective not-for-profit financial statements, professionals must have a strong working knowledge of the reporting requirements. Now is the time to obtain that knowledge! This course explains the requirements, illustrates how the requirements manifest in the financial statements, and clarifies options available to not-for-profits in applying the requirements. The course covers key accounting areas that affect not-for-profits, including revenue recognition, contributions, and leases. The course materials utilize a highly illustrative and innovative format, including over 30 focused exercises to provide an enhanced working knowledge of not-for-profit accounting and reporting.

This highly informative course comprehensively covers all the latest tax law developments. The focus is on individual taxation and discussion of the planning opportunities practitioners need to understand to help clients respond effectively. You will come away from the course with the up-to-date knowledge to educate your individual tax clients and implement tax-saving ideas that will serve their ever-evolving needs. This course is continually updated to reflect enacted legislation. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BFTU.

This course covers recently issued standards from the AICPA Auditing Standards Board and AICPA Accounting and Review Services Committee. The session will highlight projects in progress at the Public Company Accounting Oversight Board, and International Auditing and Assurance Standards Board. The course will also present common peer review findings and best practices to improve practice quality. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Our guidance on ethics comes from the AICPA and other groups, but it does not fully address the “why” behind ethics. This session will examine and define what ethics is and what it means to varying people in the workplace. Understanding what motivates people and understanding those people are key to both solving ethical dilemmas and workplace issues that can lead to greater job satisfaction and efficiency. To correct an issue, you need to delve into the root cause – the why?

Effective January 1, 2024, an estimated 32.6 million entities will be required to report information about their beneficial owners to FinCEN as part of the Corporate Transparency Act (CTA). In an effort to combat money laundering and other illegal activities, the law provides harsh penalties for the failure to report the required information. This reporting specifically targets small businesses and holding entities, creating opportunities for accountants, tax practitioners, and other business advisors to expand their service offerings. The reports require the listing of all "beneficial owners," and they are imprecisely defined, possibly requiring an exercise of judgement. Therefore, proper education of professionals and business owners is paramount for accurate reporting. The course includes an overview of the CTA and a detailed discussion of what information needs to be reported to FinCEN.

It's not about top-down management anymore - things have changed. For organizations to be successful today, everyone needs to contribute. Our success depends not just on how you manage those who report to you but also on those to whom you report. The world is too complex now for any one person to have all the answers. Sometimes those in charge need and want your support. Learn how to manage the managers in "Managing Up the Ladder." It takes a special finesse and approach. You'll learn strategies for acquiring buy-in from those above you in the organization and tools for more effective communications and building respect.

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 format your spreadsheets quickly and efficiently 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.

Modern technology solutions have enabled people to operate more effectively from home using cloud-based technologies and services. This course will cover cybersecurity best practices to help CPAs protect their data and devices while using internet-based cloud technologies. 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 addresses the many issues impacting CPA practice with a world in crisis.  The unique challenges facing practitioners are related through actual practice situations – and then analyzed for their ethical implications. Based on real life experiences. **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.

Could you imagine a drug dealer using a credit-card terminal to accept payment? How about someone paying for a television they bought off the back of a truck with a personal check? Hard to imagine, right? Most criminals conduct their business in cash. For years, criminals kept their ill-gotten gains in cash and used it to pay for everything from real estate to jewelry to things such as private school tuition. This prompted governments around the globe to pass laws prohibiting large cash payments or, at the least, requiring such payments to be reported. These laws created the need for criminals to conceal the true source of the money or to "launder" it. To combat these threats, laws, and regulations have been enacted in countries around the globe that make financial services firms, and in some cases individuals, responsible for preventing or stopping money laundering. Within this course, we explore AML warning signs and potential mitigation techniques companies and professionals can take to help eliminate money laundering.