Professional Development and Event Catalog

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.

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!

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

AI is reshaping audit, tax, and finance. This update surveys what’s real in 2026: core concepts, major tools, risks/controls, and practical CPA use cases. Leave with a clear vocabulary, a current landscape view, and actionable talking points for staff, clients, and vendors.

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.

This course provides a comprehensive review of §1202 qualified small business stock (QSBS) rules, from initial qualification through exit planning. Participants will examine entity eligibility, active business requirements, holding period issues, redemptions, and multi-year sales strategies. Case studies highlight common QSBS failures and planning techniques to preserve the exclusion.

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!

This course compares the tax consequences of stock and asset transactions from both buyer and seller perspectives. Participants will analyze basis step-ups, depreciation implications, allocation rules, and elections under §§338 and 336(e). Case studies illustrate negotiation considerations and after-tax outcomes.

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.

New to AI? Start here. This beginner-friendly course explains how generative AI works, what terms like “LLM” and “agentic AI” really mean, and how CPAs can safely put these tools to use. You’ll leave with a solid understanding of AI fundamentals and how they apply to accounting, tax, and finance.

More Dates

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.

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.

*IMPORTANT:  This is a virtual conference and is being run in partnership with the New York State Society of CPAs. The 2026 NYSSCPA Construction Contractors Conference brings together industry leaders, advisors, and subject matter experts to examine the most significant business, financial, regulatory, and operational issues facing contractors today. Through a series of timely presentations and discussions, attendees will gain practical insights into emerging technologies, economic trends, compliance requirements, tax planning opportunities, business growth strategies, and succession planning strategies. The conference is designed to help construction professionals make informed decisions and prepare their organizations for both current challenges and future opportunities.Please note that the Class Pass does not apply to this program.

This conference is being hosted by the Maryland Association of CPAs and will only be offered virtually. Are you ready to gain insights that will shape the future of financial planning? Join us for a transformative day filled with cutting-edge knowledge and invaluable networking opportunities.This conference is still being planned, so please check back for the full agenda.

Sales of partnership interests can trigger unexpected ordinary income when “hot assets” under IRC §751 are involved. Many practitioners focus on capital gain treatment under IRC §741, only to discover that unrealized receivables and inventory items require recharacterization of a portion of the gain as ordinary income. This focused 2-hour program provides a practical and technical review of IRC §751 and its application to partnership interest sales and certain distributions. Participants will examine the definition of hot assets, the mechanics of ordinary income recharacterization, and the calculation of a partner’s share of unrealized receivables and inventory. The course also addresses common pitfalls, planning considerations, and documentation strategies to avoid costly surprises for clients. Through examples and case-based discussion, attendees will gain clarity on how to identify §751 property, compute the ordinary income component of a sale, and properly report partnership interest transactions.

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