CPE Catalog & Events

Understanding your own and the people style of others whom you are dealing with which can establish rapport more easily, help you become more persuasive, and avoid miscommunication with the possibility of rubbing someone the wrong way.  In our session, you will gain insights into your people style, ways to improve communication connectivity and how to understand your team's functionality (or more likely dysfunctionality).  

In today's data-driven world, spreadsheets serve as the backbone of business and personal productivity. However, creating complex and error-prone spreadsheets can lead to critical mistakes and inefficiencies. This course aims to equip you with the knowledge and tools to build robust spreadsheets, implementing a range of controls and safeguards to ensure data integrity, streamline processes, and maximize accuracy. 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. 

Learn how to enhance your Excel workflows with AI in this course, "AI-Powered Excel: Leveraging AI and ChatGPT for Supercharged Productivity." Discover the various AI features built into Excel and how to use ChatGPT to create, understand and troubleshoot Excel functions and formulas. Imagine turning two-hour Excel tasks into two minutes of effort! This course will help you streamline your Excel work, research and documentation, saving you time and effort in your day-to-day tasks.

Various legal tests are used to evaluate whether a worker should be classified as an employee or an independent contractor. There is no uniform standard or bright-line rule for determining whether an individual is properly classified as an independent contractor. Instead, the inquiry is always fact-intensive, and the analysis can vary based what body is performing it, i.e. the Internal Revenue Service (“IRS”), Department of Labor (“DOL”), various state agencies, or the courts. This presentation will review the various tests and highlight some of the common, most important factors for consideration.   

The annual budgeting process is often criticized as an accounting exercise that is obsolete soon after it is published, prone to gamesmanship, cumbersome, not volume sensitive, and disconnected from the organization's strategy and risk management processes. You can resolve these deficiencies using capacity-sensitive driver-based projections. Driver-based budgeting allows for quick scenario planning and far easier analysis of a growing organization whose future may look nothing like today. The driver-based budgets can be periodically refreshed to create rolling financial forecasts extending well beyond the fiscal year end. Learn how managerial accounting can become managerial economics.

Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session provides best practices for interviewing to gather accurate information, such as creating and asking open ended questions, effective listening, and understanding verbal and non-verbal communication. Attendees will end the session with takeaways to immediately implement in future HR investigations. Two of three Episodes in the series.

Many public accountants desire to have a quick overview of only the most current changes to professional and ethical requirements. This course will provide an executive summary of the major changes in audit and other attest requirements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Are you looking to take your PivotTables to the next level? Many experts consider PivotTables to be Excel’s most powerful feature. Yet, most who create and work with them barely scratch the surface of all that PivotTables can do. In this session, you’ll learn eight powerful features you may have missed. From user-defined calculations to consolidating reports and adding KPIs, we’ll show you how to get the most out of your PivotTables. These are just some examples of the great things you can do with PivotTables, and in this session, you will learn these and other techniques to make your PivotTables even more powerful.

When exit planning, it is important to weigh various issues, including tax implications, to achieve an effective management and/or ownership change. Many envision tax-free reorganizations being the most preferable structure to avoid capital gains tax, but the opportunities come at a cost to the seller. This course will provide a well-rounded discussion of the various strategies to consider when advising on exiting a business.

It is no secret that accounting firms, like many other organizations, have begun launching operations in the metaverse. For those unsure, the metaverse is a digital or virtual space where participants simulate a host of activities ranging from shopping to entertainment and business transactions. Why wouldn't accounting firms and other professionals want to get in early on this new frontier? All types of businesses have begun purchasing and setting up shop in this new virtual world. These are no small endeavors - professionals are creating business plans to operate successfully in the virtual world that started off originally as a niche format for gamers. Accounting firms are starting to announce their acquisition of virtual real estate, and some are paying a premium to obtain prime locations. To operate successfully in the metaverse, professionals need to understand the environment and the rules of the game. This course provides an introduction to the metaverse and an overview of opportunities, risks and rewards for professionals who wish to stay relevant in the ever-expanding virtual world. Participants will walk away with an understanding of where we are in this rapidly developing space, plus gain insights on how to establish a presence or advise clients who wish to explore metaverse opportunities.

One of the most challenging skills for a manager or supervisor to master is delegation. This course will cover a variety of delegation-related topics and provide participants with the necessary knowledge and skills to delegate work and authority effectively.

Transform your data presentation skills with our comprehensive course on creating impactful dashboards and reports using Excel. This workshop is tailored for professionals who: Regularly produce or update dashboards and reports Struggle with confusing or overly complex reporting tools Seek to streamline varied reporting styles across their organization Aim to establish a consistent, replicable "house style" for reporting Want to impress stakeholders with clear, user-friendly data presentations Through a combination of theory and hands-on practice, you'll learn the fundamental principles that make reports and dashboards easy to understand. We'll distill these concepts into a set of practical rules and guide you through their application in Excel.

People skills are the most significant skills that professionals need to develop and yet are often the last skills perfected. This course will help participants understand personality types and the successful interactions with clients, peers and family. In addition, participants will learn Neuro-linguistic programming and develop the ability to better understand nonverbal language, which is key to communication. Participants will also learn techniques to enhance memory and to improve the ability to recall key facts.

This program examines the critical issues, rules, and special opportunities when preparing your clients' Form 1041 US Income Tax Return for Estates and Trusts. Learn what is considered taxable income; filing requirements and deadlines; impact of the 3.8 percent Medicare surtax on net investment income; and the 10 principles of tax accounting for trust income. **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.

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.  

This course examines the critical issues and special opportunities facing partnerships and their partners, as well as the relationship between limited liability companies and partnerships, 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.

By far, the biggest contributing factor that leads to a profitable, yet high quality, financial statement audit is the proper identification, evaluation, and response to assessed risk of material misstatement. When designing your detailed audit plan, how and where you decide to spend your time is largely a matter of professional judgment. The proven tips and techniques for critically rethinking how you plan and design your audit taught in this course will help auditors enhance audit quality and manage profitability in all engagements.

As spreadsheets evolve, so must your practices for creating, editing, and auditing them. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today’s best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this “must-see” CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel to its fullest potential.  

The Tax Cuts and Jobs Act (TCJA) was a major overhaul of our tax system that lowered the income tax rates for individual and corporate taxpayers and introduced the new 20% qualified business income (QBI) deduction for sole proprietors and pass-through entities. The cornerstone of this course is the comprehensive discussion of the 20% QBI deduction final regulations under IRC §199A.    **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