Professional Development and Event Catalog

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.

Manage distractions, decrease stress and improve productivity. This training is designed to help business professionals improve their productivity and work performance by learning how to prioritize time, decrease distractions and lower stress. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The adage, “what gets measured, gets managed,” has never been more true than it is today. Organizations of all kinds and sizes are creating systems and processes to categorize, track, and report on many of their operations by creating reports featuring key performance indicators (KPIs). This session will teach you about many different kinds of KPIs. Further, you will learn how to find data and use tools like Microsoft Excel and Power BI to measure performance. You will also identify the benefits and drawbacks of using KPIs in management philosophies like holacracy to make it easier for employees to know in real time where they stand.

This session explores tools and techniques that can enhance the efficiency and effectiveness of client engagements and business processes using data analysis tools. We will introduce some of today’s popular and software tools and examine the AICPA’s Five-step approach to incorporating data analytics into public accounting engagements.

The walking dead aren't the only threat to your business. So are several dangerous, even terrifying myths about what ethical leadership is and is not. This fun and distinctive webinar will present what Forbes contributor Bruce Weinstein, The Ethics Guy, calls "zombie ethics"-myths about accounting that hinder your ability to serve your clients and enjoy a thriving business. Taking a page from Nobel laureate Paul Krugman's recent work, zombie ethics are ideas about ethical leadership that deserve to remain buried but keep resurfacing from time to time. They walk the earth and wreak havoc. In this engaging webinar, The Ethics Guy will show you how to send them back to the cemetery for good. You can then fearlessly bring in new business--and watch your practice soar! 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.

With the constant churning of governmental accounting standards, now is the time to know more than just what the standards say; we need to know what they mean and how they will affect governmental entities. This course is designed to do just that! The course materials utilize a highly illustrative and innovative format. Over 15 focused exercises are included to provide an enhanced working knowledge of the most critical challenges in governmental accounting today.

This session explores the nature of analytical procedures, with significant emphasis placed upon professional standards involving the use of analytical procedures in audit and review engagements. Practical examples to illustrate the application process will also be given. 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 identify the factors in the choice of entity decision while considering the impact of various recent tax act provisions. 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. 

CPAs get a bad rep regarding bookkeeping services. Walk through how to overhaul your offering by reviewing your client expectations, tech stack, and workflows.

What exactly is cryptocurrency and its cousin named blockchain? Are they here to stay? This session will provide a big picture examination of the technologies and currencies by explaining how we got here. We discuss the systems and technical aspects of cryptocurrencies and blockchain. What is the broad view of the technologies that currently do, and will continue to, impact our workplace and lives?

This course examines the critical issues and special opportunities facing partnerships and their partners, with a focus on reporting tax basis capital accounts.  **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.

Analytical Procedures - Comprehending Financial Statement Audit Fundamentals will provide the tips and techniques necessary to gather sufficient appropriate audit evidence to support conclusions using analytic procedures common to financial statement audits. Properly designing, documenting and evaluating results of analytic review procedures is critical for performing an effective and efficient audit engagement. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has responsibilities for performing financial statement audit analytics. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Today's workforce looks a lot different than it used to. With more people working from home and across state lines, employers must examine withholding and unemployment laws in a new light. In this course, we will examine tried and true rules in this area, but also examine statutes that are still developing. Using real-life examples and discussion, we will examine state laws on reciprocity and residency requirements. We will also look at what to do when state laws are silent or conflict on a particular issue, so that you can keep your clients in compliance and be well-prepared for the questions that will come your way in these ever-changing times.

Required minimum distributions (RMDs) must begin for the year in which the account owner reaches age 72 - later if they were born in 1951. RMDs must also be taken from inherited accounts, and the process for determining RMDs for these accounts is more complex than those that apply to RMDs for non-inherited accounts. Failure to comply with the RMD rules will result in the account owner owing the IRS an excess accumulation penalty on any RMD shortfall. Interested parties must understand the compliance requirements that apply to RMDs to be able to assist in ensuring that penalties are avoided. Additionally, the recent changes that affect RMDs must be considered when advising clients about their RMD obligations.

This program provides an update to the latest tax developments, rules and regulations affecting individual taxpayers, including a review and integration of late 2023 -24 legislation.   **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.

How good are you with the technology you use daily?  What new technology tools are available that could save you time and make you more effective?  Technology continues to accelerate rapidly, and the need to keep pace is essential. If you are not an information technology (IT) expert but need a technology update to maintain and improve your skills to serve your companies or clients more efficiently and effectively, this course is for you! In this fast-paced, update-style course, you will survey today’s IT environment, learning about computer hardware, software (including Microsoft Office), operating systems (including Windows 10), and what they mean for you, and peripheral devices. You will also learn about significant trends in information technology and how to take advantage of the opportunities presented by these trends.  Examples include the latest Excel features, working with PDF files, and security and privacy issues. Additionally, you will learn how to improve the overall performance of your IT investment, thereby increasing your return on investment. Throughout this program, you will learn from real-time demonstrations of practical applications of the latest tools, which can provide you with the knowledge you need to harness the power of technology, both now and in the future. Register now for this “don’t miss” opportunity to get the skills required to enhance the value of your IT investment.  

Conflict is as natural as breathing air. For many, the thought of dealing with conflict is difficult and horrifying, and yet unresolved conflict can damage relationships, cause pain and suffering as well as hinder workplace productivity. When addressed, however, conflict has the power to be transformative in strengthening workplace relationships, shared understanding, and increased productivity. This workshop will provide an intimate understanding of how to deal with conflict in collaborative and constructive ways. Using ethical values and principles, we will explore how to move conflict from an obstacle to an opportunity. This workshop is geared toward individuals who are wanting to improve their conflict management skills and create more harmonious and positive working environments. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

According to the FBI, “white-collar crime is … synonymous with the full range of frauds committed by business and government professionals … characterized by deceit, concealment, or violation of trust …. The motivation behind these crimes is financial—to obtain or avoid losing money, property, or services or to secure a personal or business advantage.”  CPAs can and should play a crucial role in preventing and detecting white-collar crime, as well as in prosecuting the perpetrators.  This session will explore whether we are up to this challenge, heighten awareness regarding the CPA’s role as a front-line defender of the public interest, and assess whether we are deserving of the public trust we enjoy.