Professional Development and Event Catalog

This course provides a concise overview of how artificial intelligence (AI) is revolutionizing the construction industry and reshaping financial oversight, accounting practices, and regulatory compliance. From autonomous equipment to predictive risk analytics, construction firms are increasingly adopting AI to enhance safety, efficiency, and profitability. As this transformation unfolds, accountants and financial professionals must evolve their roles-leveraging AI for smarter budgeting, automated compliance, and real-time auditing. The course highlights the top 20 macro-level AI trends in construction and explores how accounting professionals can align financial systems with operational AI, uphold audit integrity, and prepare for emerging tax and compliance challenges. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

The Governmental Accounting and Auditing Committee meets to discuss developments, new regulations, and compliance issues in the field of governmental accounting and auditing. Group members include both public sector finance professionals and those who serve them in public accounting. Members also assist with planning the governmental accounting and auditing track at our MEGA Accounting and Auditing Conference held in June.  A meeting agenda will be sent one week prior to the meeting date.This will be a virtual meeting via Zoom meetings.  If you register for this meeting via our website, please see https://www.ctcpas.org/my-cpe/upcoming to launch the Zoom meeting.

More Dates

Ethical behavior is not a destination it is a journey with twists, turns, and bumps in the road. We are faced with ethical dilemmas every day. Do I speed to make it to a meeting? Do I call in sick because I need a break? When does "helping my child with their homework" become "doing it for them"? CPAs are ethical most of the time, but staying ethical is hard. It gets harder when we are under stress. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

All organizations are looking for ways to gain an advantage over the competition. This practical and interactive session will present a toolkit of ideas to help CFOs, controllers, and finance professionals better position their organizations for the future. We know change is occurring at an exponential rate, and that has proven to be the case in all areas of finance, management, and leadership over the past year. The course deals with these new issues and will continue to be updated as necessary throughout the year. This year, we will take a special interest in the opportunities and threats of AI for the finance professional. Become the "financial hero" of your organization and make a positive impact on the bottom line.

More Dates

Recent new auditing standards are designed to improve overall audit quality. The course will address the most common misapplied audit concepts in planning and performing effective and efficient financial statement audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

This course is a great foundation to introduce new preparers to tax rules related to business returns. The course covers tax areas affecting all business entities, providing a solid basis for staff to handle business entity returns. Such business tax topics include the sale of assets used in a trade or business (Form 4797), depreciation (Form 4562), deductible and nondeductible items, and the basics of uniform capitalization. The objective of this course is to train new staff accountants, data processing employees, paraprofessionals, and bookkeepers to prepare complicated federal corporate income tax returns. It is a hands-on and practical course, with extra emphasis on changes to forms under new tax law.

More Dates

In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.

More Dates

Part of the technical competence of most experienced accounting and finance professionals is the ability to advise owners of S corporations and partnerships or multiple-member LLCs treated as partnerships regarding the tax rules that apply when these entities liquidate. Entity liquidations do not occur every day; but they do occur, and often at very critical times in the business life of the entity and its owners. All accounting and finance professionals should be able to advise their clients about the tax issues associated with client businesses that go out of existence and liquidate. This program explains the tax consequences associated with liquidating S corporations, partnerships, and multiple-member limited liability companies treated as partnerships.

More Dates

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 and 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 you can keep your clients in compliance and be well-prepared for the questions that will come your way in these ever-changing times.

More Dates

The modern accounting firm is often held hostage by "software silos"—critical financial data trapped in disconnected applications that refuse to speak to one another. For years, the only solution was manual data entry or expensive custom development. This course introduces the "DIY Automation" movement, showing financial professionals how to use Integration Platform as a Service (iPaaS) tools like n8n, Zapier, and Power Automate to bridge these gaps. We move beyond basic triggers to explore how "localized innovation" allows practitioners to build bespoke connections between their favorite apps without writing a single line of code. Participants will gain a strategic framework for identifying automation opportunities, from client follow-ups to complex status reporting. We will explore the mechanics of the "wide ecosystem" of integration tools and demystify the role of Agentic AI, explaining how Retrieval-Augmented Generation (RAG) and the Model Context Protocol (MCP) are changing the way data is moved and interpreted. By the end of this session, you will be able to perform a clear cost-benefit analysis of your automation options and understand how to build resilient, error-aware workflows that keep your practice moving.

Fraud activities can be executed from within an organization, by parties outside an entity, or by both. Importantly, as the business world becomes more technological, the way fraud is carried out is changing. There must be an increased focus on understanding where new fraud vulnerabilities exist. In this session, we delve into the reasons that both internal and external intentional defalcations take place. The material discusses the new ways fraud is being actuated and looks at the factors driving those that undertake fraud. We spend time examining measures that can be implemented in order to stop fraud via the deployment of added security across the enterprise. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

This course examines actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters' ability to accomplish their nefarious acts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

This course concisely explains the latest "see, hear, speak" multi-modal updates to ChatGPT and how they can be used in an accounting context. New features include vision processing, voice conversation, image generation, real-time Internet access, advanced data analysis, plugins and more. Discover how this technology can be used in mind-blowing ways to analyze financial data, optimize processes, and solve problems in the accounting domain. Through the lens of ChatGPT, practitioners can explore innovative solutions, automate routine tasks, and generate deeper insights and value to their clients and organizations in previously unimaginable workflows. You'll walk away with scores of advanced ChatGPT strategies and tips that can be immediately applied and deliver instant results to elevate the efficiency and effectiveness of your accounting projects and tasks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

Effective risk assessment is foundational to designing an appropriate audit response. This course introduces the audit risk model and provides an overview of the risk assessment procedures performed during engagements. Participants will review the components of the audit risk model and examine common risk assessment procedures, including inquiries, analytical procedures, and observation and inspection techniques. Emphasis is placed on understanding how risk assessment drives engagement planning and supports the development of appropriate audit responses. Designed for auditors seeking a structured introduction or refresher, this course builds foundational knowledge necessary for effective engagement planning and execution. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

In today's challenging talent market, accounting firms face unprecedented pressure to retain their best performers. This course provides actionable, research-backed strategies to help firms keep their top talent from leaving. Based on comprehensive surveys of both current accounting professionals and those who have recently left the profession, participants will learn the real reasons employees stay or go-and what firms can do about it. The course goes beyond simple solutions like "pay more, expect less" to explore comprehensive retention strategies including whole-person compensation, work-life balance improvements, career development pathways, and necessary business model transformations. Participants will discover why 73% of surveyed professionals want to stay with their current firm, yet many still leave-and how to bridge that gap. Key topics include understanding the true cost of turnover versus retention, implementing flexible work arrangements that actually work, creating meaningful career paths for non-partner track professionals, and transforming firm operations to support both profitability and employee satisfaction. Special attention is given to retaining diverse talent and adapting to the expectations of younger professionals who will comprise 27% of the workforce by 2025. Whether you're a firm leader, HR professional, or manager responsible for team retention, this course provides the insights and tools needed to build a sustainable talent strategy in an evolving profession. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

We have passed the 15 year anniversary of the start of the cryptocurrency market with the release of Bitcoin in 2010. It is estimated today that 1 in 5 people in the U.S. trade in cryptocurrency. With the recent changes in the legislative landscape, this number is poised for substantial growth. In addition, there will be natural evolution towards "smart contracts" powered by AI and the integration of cryptocurrency as the payment mechanism. For these reasons, it is important for every CPA to have a baseline understanding of the cryptocurrency marketplace and the technology it is built on. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates

The role of the financial professional has shifted from reporting on the past to predicting the future, yet many practitioners still rely on manual, static workflows that fail to capture the full story within their data. This course bridges the gap between traditional accounting and modern data science by utilizing Excel's most powerful analytical engines to turn raw numbers into defensible business intelligence. We will move beyond simple averages, exploring how to use the Analysis ToolPak for deep statistical dives and leveraging Dynamic Arrays to build fluid, auto-updating models that respond to changing business conditions in real time. Participants will explore a modern analytics workflow that balances classic statistical rigor with cutting-edge efficiency. We will examine how to implement regression analysis for more accurate budgeting, utilize advanced forecasting functions to anticipate market shifts, and even leverage AI-assisted insights to find hidden patterns in sprawling datasets. By the end of this session, you will be able to distinguish between mere "data entry" and "data discovery," providing your firm or organization with the high-level analysis required to navigate an increasingly complex economic landscape.

More Dates

U.S. Department of Treasury's Financial Crimes Enforcement Network (FinCEN) imposed a new reporting requirement that went into effect on January 1, 2024. Millions of businesses may have to file a Beneficial Ownership Information (BOI) Report. In a surprise turn of events, the Federal District Court from the Northern District of Alabama ruled on March 1, 2024 in National Small Business United v. Yellen ("NSB") that the CTA is unconstitutional. This course will discuss the CTA's provisions and the court's decision in NSB. Also covered will be future implications for business entities and steps to consider given the recent ruling. We will also discuss recent proposed rulemaking by FinCen with respect to nonfinanced purchases of residential real estate and gratuitous transfers so that businesses can prepare for any additional reporting burdens that might arise. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More Dates