Professional Development and Event Catalog

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

More Dates

With the explosion of technology over the past thirty years, one fair question is, "what are the ethical considerations and impacts related to this technology?" Of course, practical technology issues such as data privacy and security undoubtedly carry ethical considerations. However, technology also affects the ethics associated with work-life balance, the digital divide, training needs, copyrights, and fraud, to name a few. This course will teach you about "technoethics" and its implications for individuals and organizations. To that end, you will explore many current and emerging issues associated with ethics and technology, such as copyrights, cybercrimes, privacy versus security, and geo-tracking technologies. Given the profound implications of ethics and technology, this could be the most impactful session you will ever attend.

More Dates

This course equips accounting and finance professionals with practical methods to strengthen spreadsheet accuracy in environments where reliability directly affects reporting, analysis, and decision support. The content emphasizes modern Microsoft 365 capabilities, including dynamic arrays, data types, structured references, version history, and collaborative features that reduce formula risk and manual intervention. Participants see how sound workbook design, thoughtful data organization, and targeted validation rules reduce the likelihood of downstream errors and create spreadsheets that stand up to real-world pressures. The session also highlights common failure points found in finance teams—such as fragile formulas, inconsistent structures, and user-driven overrides—and demonstrates how to avoid them through protective controls, guided templates, and streamlined calculation flows. By combining updated Excel tools with practical design principles, participants leave with techniques that improve accuracy, enhance efficiency, and support higher-confidence financial outputs across their organizations.

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 course provides a clear, practical comparison of Google Workspace and Microsoft 365, giving financial professionals the insight required to determine which platform best fits their organization's operational needs. Building on the foundational distinctions outlined in the source material, such as collaboration features, file-sharing structures, email tools, and real-time editing capabilities, the course now incorporates the latest advances in AI-powered productivity tools, including Microsoft Copilot and Google Gemini. Participants examine how these enhancements influence daily workflow, team communication, document creation, and small-business scalability. By the end of the program, attendees will be equipped to make a confident, well-supported technology decision. The course emphasizes practical evaluation, including pricing considerations, usability, cloud-storage behavior, security fundamentals, and the strengths and limitations of each suite for small and mid-sized organizations. The focus remains on real-world business requirements—helping teams choose the platform that delivers the best blend of productivity, collaboration, and long-term value.

Transform your daily Excel workflows and eliminate hours of manual data processing with powerful automation techniques designed for business professionals. This comprehensive course reveals the full potential of Excel Tables and Power Query, showing participants how to turn complex data challenges into streamlined, automated solutions. Business professionals will discover how to leverage seven key table functions that dramatically reduce formatting time, eliminate formula errors, and create dynamic reports that update automatically. Organizations today need efficient ways to handle increasing amounts of data from multiple sources. This course demonstrates how Power Query serves as the ultimate tool for extracting, transforming, and loading data into Excel with minimal effort. Participants will develop practical skills to automate repetitive tasks, create robust data models, and build reliable reporting systems that save hours of work each week. These time-tested techniques have helped countless professionals reduce their manual data entry by up to 80%, allowing them to focus on higher-value analysis and decision-making activities.

More Dates

QuickBooks Online's (QBO) reporting capabilities represent the gold standard in financial software, yet most professionals only scratch the surface of its potential. This course reveals how to transform QBO into a reporting powerhouse, making any organization more efficient and accountants more valuable to their clients. Participants will discover how to customize standard reports, build sophisticated management reports that automatically update, and create tailored solutions that deliver exactly what clients need. The course demonstrates how professionals can automate routine reporting tasks, saving hours of manual work while delivering more insightful financial analysis. Beyond core functionality, participants will master advanced features like Spreadsheet Sync, QBO's powerful Excel integration tool that brings QuickBooks data directly into spreadsheets for unlimited analysis and data management. The course also covers various third-party tools and ODBC connections that extend QBO's capabilities. This knowledge transforms accountants into indispensable advisors, equipped to deliver precise, professional reports that meet any client's needs while streamlining their own workflow. Perfect for professionals ready to leverage QBO's full potential and provide exceptional value to their clients through advanced reporting solutions.

Tax Security Essentials: Implementing a WISP for Tax Professionals Tax practices face a critical responsibility: safeguarding client data against cyber threats. This course is tailored for professionals in the tax industry, offering a deep dive into the essentials of creating and maintaining a Written Information Security Plan (WISP) as mandated by IRS regulations and the FTC Safeguards Rule. With a focus on IRS Publications 4557, 5293, and 5708, along with insights from NISTIR 7621, participants will learn not just the theory but the practical steps needed to enhance their practice's security posture. The course content is designed to be direct and engaging, ensuring that attendees can easily translate knowledge into action. The curriculum covers a broad spectrum of critical topics, from developing a compliant WISP to recognizing and responding to cyber threats, and from implementing strong access controls to effective data protection measures. Special emphasis is placed on real-world strategies for preventing data breaches, including the use of encryption, backup procedures, and secure data disposal methods. Participants will also explore the importance of employee training and the continuous monitoring and improvement of security practices to address new cyber threats and business changes. For tax professionals committed to upholding the highest standards of data security and building a trust-based relationship with their clients, this course is a vital resource. Attendees will not only gain the knowledge to protect their clients' data but also the confidence to implement best practices within their organization.

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

Some estimates indicate that business professionals spend almost half their time in Excel applying formats. If you want better formatting results in less time, participate in this session to learn the best practices for formatting your Excel spreadsheets. In this session, you will learn best practices for applying formats in your workbooks. More specifically, you will learn about features such as Custom Format Codes, Templates, Styles, the Accounting Format, Precision as Displayed, date formats, and many others, all of which can save you substantial time when working in Excel.

More Dates

Presently, over seven million businesses use QuickBooks Online. However, these businesses often struggle to get the reports they need. In some cases, they are limited because of their chosen subscription. However, necessary reports are available in other cases, yet users do not know how to access them. Join us in this session to learn about better reporting options in QuickBooks Online. In this session, you will learn how to create and customize your reports in QuickBooks Online. You will learn about Standard, Custom, and Management reports. You will also learn about the new Spreadsheet Sync tool that allows you to create customized reports, including multi-company reports in Excel. If you use QuickBooks Online and want to improve reporting, this session is for you!

Business Intelligence (BI) is perhaps the hottest topic in most professional circles in today's business climate. Increasingly, organizations of all sizes are seeking to take advantage of the data available to them to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools - from Excel add-ins to dedicated solutions such as Power BI - now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyses unthinkable until recently. This program will teach you to implement "do-it-yourself business intelligence" using a variety of techniques and tools. First, you will learn to use advanced Excel data query and summarization features to create Excel-based dashboards. You will then learn how to leverage that knowledge to build even more powerful BI objects using Microsoft's Power BI tools. If gaining better insights into your data to make better decisions interests you, then join us for a fast-paced look at how you can take advantage of these fantastic tools.

More Dates

Excel is ubiquitous in the accounting and financial professionals' workplace, but some of the best functions and features for accounting and financial professionals are unknown or underutilized. Leverage Tables, shortcuts, and best practices to increase efficiency. Master the functions such as VLOOKUP, INDEX & MATCH, Dynamic Array Formulas. As well as Formulas and uses such as Depreciation, Amortization, Interest, Payment, and more. In this course, we will even take you deeper into statistical analysis with formulas for everything from median, most, and standard deviation and regression analysis.

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

Elevate your Excel expertise with K2's Advanced Excel program! This laptop-friendly course is designed for experienced Excel users who are ready to take their skills to the next level. In this session, you will master critical advanced Excel skills in six key areas: 1. Collaborating seamlessly with other users and securing your workbooks 2. Utilizing tables to analyze and report data efficiently 3. Integrating and manipulating data from external sources with ease 4. Creating and auditing complex formulas 5. Harnessing advanced data analysis tools for deeper insights 6. Employing visualization techniques to communicate information effectively Drawing from over thirty years of experience in delivering Excel training to accountants and business professionals, this program is packed with relevant, real-world examples that reinforce the topics presented. Don't miss this opportunity to become more efficient and proficient in Microsoft Excel, the go-to tool for accounting and financial professionals. This course covers advanced Excel topics that are essential for business success. Participate in this session to elevate and transform your Excel skills!

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

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.

This course provides financial professionals with practical guidance on creating clear, persuasive, and visually strong business presentations using Microsoft PowerPoint. Participants examine how structured storytelling, purposeful slide design, and message alignment improve communication in both internal and client-facing scenarios. The session highlights the realities of today's business communication landscape, where data-heavy content, hybrid audiences, and expectations for visual clarity demand more thoughtful presentation development. Attendees also review updated Microsoft 365 capabilities that streamline presentation creation, including AI-supported design tools and new productivity features that help professionals research, refine, and organize content more efficiently. By combining foundational PowerPoint functions with current best practices in narrative development, the course equips learners to produce presentations that enhance understanding, support decision-making, and elevate organizational communication.

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