Professional Development and Event Catalog

Purchase your professional development program credits in advance (as either a 40-hour Class Pass or 80-hour Class Pass) and enjoy significant savings! This year’s pass applies to seminars, CTCPA developed conferences, webinars, and livestream programs now through March 31, 2025. Class Pass is also a great way to get your staff the training they need at a discounted price. Note: Class Pass is for individuals - credits are not transferable to other employees within a firm or company.   

The mad scramble to remote work and utilize apps like Teams has been trying for most organizations over the past couple of years. With a rush to install and no time to plan, most team members did their best, prioritizing remote meetings as the primary concern. Therefore, as a result, Teams is vastly misunderstood and underutilized in most organizations. Join us in this session to go beyond the remote meetings aspect of Teams and to learn how to optimize efficiency, communication, and workflow with Teams.

In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Key factors and considerations for organizations seeking to implement a cryptocurrency-based payment system. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Tax Season can be a daunting time for tax preparers, but it doesn’t have to be with the help of tax automation software tools and other innovative technology. This session will provide an overview of the latest technologies and tools that can help automate your workflow and make the entire tax return preparation process smoother and more efficient. From client portals, workflow management, and e-signatures to robotic process automation, you’ll learn about all the options available to help streamline your tax preparation process. So don’t dread Tax Season - attend this session and arm yourself with the tools you need to succeed!

The Tax Cuts and Jobs Act of 2017 has made significant changes to the Internal Revenue Code.  This, in turn, has created a need to make changes in a client’s planning needs.  In addition to traditional issues faced by a business owner regarding the operation of his or her business, business ownership creates complexities in the tax, estate, and financial planning arenas. By focusing on the development of many unique business planning tools, this course explores the entrance and exit strategies available to business owners.   **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 leighanne.conroy@acpen.com.

Privacy should be everywhere, yet every day seemingly brings a new story about a privacy violation. While it can be frustrating and sometimes scary to think about mishandling our personal information, it’s important to remember that we can take steps to protect our privacy. This session will teach you where your critical threats are and what information you may already have at risk. More importantly, you will learn how to manage and mitigate privacy risks. In an era of increasing connectivity – and by extension, risk – this session should be high on your list to take as soon as possible.

Many businesses are being held back by legacy solutions. The old way of doing things just doesn’t work anymore. Instead, Software as a Service (SaaS) has transformed many mid-market companies. In this new world of cloud-based, workflow-enabled, data-centric, and connected solutions, you can solve existing and future business problems in new ways without being bogged down by paper-centric environments. This session covers integrated and ERP solutions that should work for businesses in the $10 Million to $1 Billion range. If your existing system has been in place for seven or more years, it is time to consider upgrading or replacing it. Leverage your instructor’s knowledge of the market to minimize your risk.

Combatting today’s cybercriminals takes all of us working together. The Internal Revenue Service works with state tax agencies and the tax industry to fight these 21st-century identity thieves. Unfortunately, data thefts at tax professionals’ offices are on the rise. Online providers also must follow the six security and privacy standards in Publication 1345, Handbook for Authorized IRS e-file Providers of Individual Income Tax Returns. In addition, you fall under the PTIN and 4557 considerations if you prepare tax returns. Learn how to fulfill your obligations by participating in this session.  

Collaboration is a key to productivity and success. But remote work can make collaboration more challenging, including collaborating on spreadsheets. Fortunately, tools such as portals with check-in/check-out capabilities, version control, comment tracking, and co-authoring can enable online spreadsheet collaboration. Further, Excel’s Inquire tool can facilitate spreadsheet collaboration in offline environments. Don’t let remote work hamper your spreadsheet collaboration needs! Participate in this session to learn how to collaborate on spreadsheets effectively from anywhere using tools you already own or license.

Data Loss Prevention (DLP) is a means of creating and enforcing security policies in an organization. For example, you can create DLP rules that programmatically block all outbound email messages containing Social Security or credit card numbers. Unfortunately, most business professionals have yet to discover DLP and how it improves security. In this session, you will learn the fundamentals of DLP and, through demonstrations, see how you can use DLP to enhance organizational security. You do not want to miss this chance to learn how to take advantage of one of the most innovative security options available to you!

Most small and mid-sized businesses are at least considering cloud-based suites for business management, performance management, and productivity. Unfortunately, many owners and accounting professionals need to learn the difference between using cloud-native tools, employing a managed service provider, and utilizing a desktop hosting provider. This session helps participants understand the differences in the levels of service provided by these offerings and will also highlight some of the regulatory barriers which could create problems for your organization. Attend this session and learn what you need to know before saying “see ya” to your servers.

It is imperative for public companies to produce quality financial reporting. This course will share insights into the latest SEC and PCAOB areas of emphasis and concern. 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 dread that annoying ERROR! message popping up on your spreadsheets? Tired of using the same long, elaborate formulas when you could be using the ones that are already built into Excel? Then this class is for you! In this webinar, we will focus on Debugging and Troubleshooting complex formulas. You will learn various techniques that will assist you in creating complex compound formulas. You will also learn techniques to resolve issues when you receive errors. This session will also discuss the 9 built-in error checking options and demonstrate resolution techniques. We will also review techniques to resolve rounding errors. This session is presented using Excel 2013. Regardless of the version you are using, ALL 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.

Think about how much time you spend reviewing and creating PDF files. This course teaches you how to take advantage of a multitude of features and functions available in Adobe Acrobat to create, review, organize, edit and secure your PDF files more effectively and efficiently. Like many personal productivity software applications, it is very likely that you are using only a fraction of the potential of Adobe Acrobat when working with your PDF files. For many CPAs, a PDF file is the final presentation of your work product, whether it is a tax return, financial statement, audit report or other financial reports. This course will teach you how improve the quality of those report presentations. The tips you learn in this course will save you time on a daily basis. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This fast-paced course focuses on using Excel Power Pivot features to enhance data analysis. One of the strengths of Power Pivot is the formula language DAX (Data Analysis eXpressions). We will spend considerable time using the power of DAX to create meaningful calculations that add new dimensions to our data. We will also review the use of a date or calendar table that allows us to perform date analysis that was never possible before. This will allow us to use the new time-intelligent functions to perform complex calculations on our data such as: month-to-date, quarter-to-date, year-to-date, last year same period, last year-to-date, etc. We will also demonstrate the hottest tips and tricks that will take your data analysis to the next level. Although our focus will be on using Power Pivot, we will review some of the other Power BI Tools including: Power Query (Get & Transform), Power BI Desktop and Power BI Services (PowerBI.com). NOTE: If you want to apply the concepts presented, you will need Excel 2013, 2016 or 2019/Office 365 AND the Power Pivot add-in pre-installed. To see our full prerequisite recommendations, see PROGRAM CONTENT section below. 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.

How grateful are you? In this critically important webinar, we will explore exactly what gratitude is and why it is a crucial component of your work as a CPA. Even if you believe you're already a deeply grateful person, you'll still learn some new strategies for expressing gratitude effectively. Forbes Contributor Bruce Weinstein, The Ethics Guy, will show you how to use LinkedIn in a novel way to say "thank you." You'll also find better and worse ways of letting clients, team members, family members and friends know that you care about them. You'll understand why gratitude is a matter of ethics and not merely etiquette. Finally, you'll discover how to use questions about gratitude in job interviews and performance reviews. Why not hire and promote people who are not only knowledgeable and skilled but also grateful? You will be thankful for having taken this valuable webinar! 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 like-kind exchanges (LKE), known as one of the last great tax legal "shelters" available to those buying and selling real property. We cover the basic structure of a LKE, and ways a taxpayer can utilize qualified third-party intermediaries (QI), and tenancy-in-common structures including Delaware Statutory Trusts (DST). We also explore creative solutions to sticky situations a taxpayer may find itself in obtaining replacement property. This course is ideal for CPAs, EAs, lawyers, real estate professionals, accountants or other tax professionals. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The term “automate” has been an industry buzzword for at least a decade. Yet, few organizations have embarked on successful automation journeys, leading to greater efficiencies, reduced errors, and happier team members. In this session, you will learn how to crank up your automation projects and see first-hand how easy and effective automation can be. More specifically, this session shows you exactly how you can work with tools from Zoho, Zapier, and Microsoft to enable powerful routines that will allow you and your team to get more done in less time.

Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.