Professional Development and Event Catalog

In 2026, automation isn't just about working faster—it's about building a practice that can scale, adapt, and compete in an increasingly technology-driven profession. This intensive one-day conference focuses squarely on how accounting professionals can implement practical automation solutions that genuinely transform daily workflows. We'll examine integration platform as a service (iPaaS) tools, showing you how these systems actually work under the hood and how to configure them for your specific needs. You'll see how AI fits into the automation puzzle (though this isn't an AI conference per se—it's about making your entire technology ecosystem work smarter). And we'll dig into the tools you already own, like Power Query in Excel, that might be sitting underutilized while you're manually manipulating data.If you're ready to stop spending hours on repetitive tasks and start building workflows that run themselves, this conference will give you the blueprint. We're talking about real efficiency gains—connecting systems that currently don't talk to each other, transforming how data moves through your organization, and freeing up your team to focus on analysis and advisory work instead of data entry. Whether you're running a small practice or managing technology for a larger firm, you'll walk away with specific strategies for implementing automation that actually sticks. Mark your calendar and get ready to build a future-ready business.

Transform business operations and reduce manual workload through powerful automation tools and strategies. This comprehensive course reveals how organizations can leverage QuickBooks Online Advanced's automation features for both workflow and advanced reporting, alongside integration platforms like Zapier and Microsoft Power Automate. Participants will discover practical solutions for automating bills, payments, invoices, scheduled reports, and vendor management while learning to implement custom workflows that streamline daily operations and enhance productivity. Business leaders and accounting professionals will gain hands-on experience with automation tools that revolutionize reporting processes and stakeholder communication. The course combines QuickBooks Online Advanced's native capabilities with broader integration strategies, demonstrating how to utilize Integration Platform as a Service (iPaaS) solutions and third-party tools to create seamless connections between accounting systems and other business applications. Participants will walk away with actionable strategies to reduce manual data entry, minimize errors, and create more efficient processes that save both time and resources. This practical approach to automation empowers organizations to scale operations without increasing overhead costs.

More Dates

Client Accounting Services (CAS) have become a cornerstone of modern CPA firms, offering opportunities for enhanced client relationships, recurring revenue streams, and streamlined operations. This course provides accounting professionals with practical guidance on implementing and optimizing CAS within their firms. Participants will explore the foundational elements of CAS, including service offerings, pricing models, and client communication strategies. The course delves into the technology tools essential for CAS, including accounting software, workflow automation, and reporting platforms. It offers insights into best practices for managing client expectations and delivering consistent, high-value services. In addition, participants will examine case studies of successful CAS implementations, review current trends impacting CAS, and identify critical steps to build a scalable CAS practice that aligns with their firm's goals. The course also addresses the importance of data security, governance, and compliance in providing CAS to ensure ethical and professional service delivery.

More Dates

Are you tired of struggling to create compelling charts and graphs? Join our session and transform your data into stunning visualizations that captivate and inform your audience. This isn't just another seminar on basic charts; it's a comprehensive guide to mastering advanced, interactive, and dynamic visualizations in Excel. In this session, you'll learn how to create visually appealing charts that are not only informative but also engaging. Discover the secrets to making your data come alive with interactive elements that ensure your audience understands and retains the information you present. Whether you're looking to enhance your communication skills or impress your stakeholders, this seminar is a must-attend. Don't miss out on the opportunity to take your Excel skills to the next level. Sign up now and start creating visualizations that make a lasting impact!

More Dates

In today's data-driven environment, financial professionals are expected not only to analyze numbers but to transform them into actionable insights. This course offers a deep dive into the practical applications of Power Query in both Excel and Power BI, tailored for those who already have a foothold in financial data analysis. Participants will learn how to streamline their data preparation process, saving time and reducing errors by automating the tedious tasks of connecting to various data sources, combining datasets, and cleaning up data for more efficient analysis. As the backbone of any insightful report or dashboard, clean and well-structured data is a must. This course goes beyond the basics, equipping attendees with the skills to create custom columns and perform advanced data transformations that lead to more meaningful financial reports. By the end of the sessions, participants will not only have sharpened their analytical capabilities but will also carry the confidence to tackle complex data challenges with ease. Don't miss the opportunity to refine your data skills and bring new levels of proficiency to your financial analysis.

More Dates

Every business professional today needs to know how to work with data. We are all generating more and more data every day. However, only some of us know how it can be effectively leveraged. There are many new opportunities for people who can effectively work with data. From helping their organizations make better decisions to working more effectively on projects to creating integration between applications and automating workflows. This course will take a longer and more in-depth look at how to use databases, structure data for optimum workflow, and share data between applications. This course teaches you how to effectively use Excel, Power BI, SQL, and other data-related technologies. You'll also discover how to integrate and share data between different applications. By the end of this course, you'll be able to utilize databases more effectively and make better decisions based on data analytics. We will go beyond the basics to give you the knowledge you need to start.

More Dates

Staff accountants often face unique challenges when working with Excel, and their existing knowledge might not always meet their needs. This comprehensive eight-hour session is designed to bridge that gap and empower you with the essential skills to maximize efficiency and accuracy. Participate in this dynamic and engaging session, and you will learn how to: • Summarize data quickly and accurately • Generate stunning, professional reports • Create essential accounting calculations for depreciation, amortization, and interest We start with a quick overview of Excel best practices and dive into advanced topics like PivotTables, sophisticated formulas, Tables, formatting, and working with dates. Our course is packed with accounting-centric examples to reinforce key learning points. Plus, you'll enjoy a "laptop-friendly" environment with access to all demonstration files. This seminar is a must for all staff accountants eager to enhance their Excel skills and transform their workflow. Don't miss out on this opportunity to elevate your Excel expertise and take the first step towards mastering Excel today!

More Dates

Many organizations have implemented Microsoft 365/Office 365 at a basic level, but few have truly explored the breadth and depth of tools included with their subscriptions. Some less commonly known apps help you manage shared email boxes, create and use web forms, schedule appointments, trade shifts, create real-time closed captions, and translate presentations. Attend this session and learn more about the hidden features in Microsoft 365 that you can use to level up your productivity.

More Dates

More Dates

Part one of a five-course series, address common issues new staff members face. Focus on strategies to improve efficiency and quality control, build technical skills, and make valuable contributions to a company. Dive into the fundamentals: workpaper techniques, analytical procedures, compilation and review services, tax recognition and research techniques, understanding audit objectives, and auditing and reviewing selected accounts. Per NASBA's rules effective January 1, 2024, participants are required to be on camera and participate in the full and small group discussions to earn CPE credits for this Group Live - Virtual course. As such, please make sure you are set up properly with reliable internet (hard wired is best), a working camera, and a working microphone.

More Dates

This comprehensive course empowers professionals to revolutionize their organization's communication and collaboration strategies using Microsoft 365's powerhouse tools: Outlook and Teams. Participants will dive deep into the major features and functions of Microsoft Teams, including chat, meetings, webinars, and seamless integration with SharePoint for storage and real-time collaboration. They'll discover how to leverage Teams effectively for in-office, hybrid, and remote work environments, maximizing productivity and streamlining communication across their organization. Beyond Teams, the course delves into Outlook's advanced capabilities, offering practical tips and tricks to enhance email management, calendar organization, and contact sharing. Attendees will also explore other essential Microsoft 365 applications, such as SharePoint, Planner, To Do, Whiteboard, and OneDrive, to create a unified and efficient digital workspace. These tools will help professionals organize tasks, visualize ideas, and securely store and share files. By the end of this course, participants will be equipped with the skills to transform their organization's collaboration efforts, boost productivity, and harness the full potential of Microsoft 365's communication and productivity tools.

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

Join us for our monthly Town Hall Meetings – a must-attend event for anyone looking to stay ahead of the latest hot topics impacting the profession. This is your chance to hear directly from Executive Director & CEO Bonnie Stewart and engage with leading voices in the finance and accounting industry. Gain insights, ask questions, and connect with experts who are shaping the future of our field. Don’t miss this opportunity to be informed and involved! You must register to attend and receive CPE credit.

More Dates

In today's world of "Big Data," every business professional is a data analyst to some extent. This is especially true for auditors, who increasingly rely on data analytics to identify situations that require follow-up and investigation. Those who master the tools and techniques for thorough data analysis can achieve superior results in less time. Join our dynamic session to unlock the full potential of data analytics! You'll explore various tools and techniques, including Excel, multiple Excel add-ins, and Microsoft's Power BI application. Whether you're looking to enhance your skills or dive deeper into the world of data analytics, this course is designed for you. Our expert instructors will guide you through practical, real-world examples, ensuring you grasp the key concepts and apply them effectively. Don't miss this opportunity to elevate your data analysis skills and stay ahead in your field. Enroll now and transform your approach to data analytics!

More Dates

Protecting yourself from ransomware requires more than just anti-virus software. Additional technology protections are necessary. Further, business continuity, legal and regulatory, and cybersecurity insurance considerations should all be a part of your risk abatement strategy. Attend this session to determine if your current level of ransomware protection reduces your risk to an acceptable and identify ways to ensure that you are protected.

Survey says... You'll have a blast at our version of the classic game show! "FIRM"ly Feud is a fast-paced, survey-based showdown where accounting, law, and architecture firms compete head-to-head with peer firms to see who knows their profession best. The best part – no calculators, briefs, or T-squares needed! Teams consist of up to four players. $20/team. Make it fun and come up with a team name that incorporates your profession! Contact aprild@ctcpas.org if you have any questions.

Improve your planning, review, audit and other engagement skills. Master techniques for effective communication with clients and colleagues in part three of this five-course series. Discover the secrets to planning and efficiently completing engagements, explore methods for assuming higher levels of responsibility, and develop your ability to assess risk and materiality. Learn how AI can be used on engagements to enhance efficiency and quality. Designed to offer audit staff members extensive training in crucial procedural, evaluative and supervisory areas. Per NASBA's rules effective January 1, 2024, participants are required to be on camera and participate in the full and small group discussions to earn CPE credits for this Group Live - Virtual course. As such, please make sure you are set up properly with reliable internet (hard wired is best), a working camera, and a working microphone.

More Dates

Excel is the default program for many financial professionals-and highly effective-if used correctly. It can be used for everything from simple tabular analysis to creating in-depth aggregate pivot tables. This course will give participants the necessary tools to turn data into meaningful information and will examine cutting edge ways to store, retrieve, report, and analyze data using Excel and plugins. It will provide recommendations on how to more efficiently use Excel and potential traps to avoid.Participants are encouraged to bring their technology devices to follow along with the interactive discussions, technology demonstrations, sample spreadsheets, and demo tools. Financial professionals will walk away from this course with valuable tools and insights into understanding, managing, and utilizing data in an organized and meaningful manner inside their organizations.

More Dates

This course is designed for firm partners and managers to explore ways to incorporate data analytics and related technologies in their audit practices. Participants explore how small and mid-size firms are using these tools to improve engagement efficiency and quality while providing opportunities for value-added services to clients. All of AHI's multi-day courses rely on live participant engagement. For this 2-hr. course, we encourage you to have a working webcam and microphone to take advantage of a live discussion leader and participant interaction.

More Dates

Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge, then this course is for you! In this dynamic and engaging session, you'll master how to: • Build PivotTables from scratch • Group data inside PivotTables, including options for fiscal periods • Create user-defined calculations in your PivotTables We start with the fundamentals and quickly move to advanced techniques, including: • Building PivotTables that consolidate data from multiple ranges • Connecting PivotTables dynamically to external databases and financial accounting systems • Leveraging other Excel features associated with PivotTables, such as Slicers, Power Query, and Power Pivot This seminar is a must for anyone eager to enhance their Excel skills and transform their workflow. With guidance and coaching from your K2 instructor, you'll be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.

More Dates