Professional Development and Event Catalog

Artificial Intelligence (AI) is no longer just a theoretical concept! Instead, AI is a practical tool available today to help you address and solve real-world problems. In this course, you will learn about the fundamentals of AI and how you can put this amazing technology to work today to help you and your team work more efficiently and effectively. Participate in this course to learn about the fundamentals of AI and specific types of problems AI can help you address. You will learn about AI features available in everyday applications – including Excel – and how you can use these features in situations such as detecting fraud and identifying potential errors in transactions. You will also learn how AI is changing how accounting and financial professionals work, both today and in the future.  

Technology is a business-critical business capability in today’s day and age. Any interruption to an organization’s ability to use its information system poses a significant risk to its viability. Data breaches, cyber-attacks, and ransomware are examples of the most significant existential risks facing businesses today. There are threat actors worldwide that entirely focus on stealing organizational data, stealing economic resources, and disrupting commerce. They use complex social engineering attacks, pervasive phishing messages, intricate malware, and other highly effective techniques. For example, publically reported data breaches now exceed 100k annually. These breaches resulted in releasing the personal information of millions of people worldwide, billions of dollars of compromised organizational assets, and putting countless people in harm’s way. This course covers recent major security breaches, including Solarwinds, Ubiquity, Colonial Pipeline, Tecnimont SpA, Citrix, and LabCorp. It will discuss how these breaches occurred, why they occurred, and how organizations can prevent similar incidents from impacting them. Each case study examines a different form of security vulnerability and how to avoid it. The topics will include social engineering, auditing processes for IT Security systems, forensic accounting, password, two-factor authentication, and improvements for managerial oversight. Participants will gain real-world knowledge from the mistakes of other organizations and, from that experience, develop their own security best practices for their organizations.  

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.

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.

OneNote is a fantastic application included in your Microsoft 365 subscription. Yet, it is underutilized and misunderstood most of the time. If you genuinely want to change how you work, embrace OneNote. Stop using Outlook as a filing cabinet for essential emails and move them to OneNote instead. If you share a OneNote notebook with others, you can stop emailing altogether within your group and use OneNote as your collaboration and reference platform.

Blockchain is one of the most-watched emerging technologies. Yet, few accountants understand how to use this technology to make existing ledger-based systems more efficient, effective, and tamper-resistant. In this session, you will learn the basics of blockchain-based ledgers. You will also learn about the fundamentals of cryptocurrencies such as Bitcoin and Ripple. Additionally, you will learn about emerging issues in these fields, such as stablecoins, central bank-issued digital currencies, smart contracts, and sovereign identity management. By attending this session, you will see how blockchain-based technologies will change your work with others.

Are you looking to take your PivotTables to the next level? Many experts consider PivotTables to be Excel’s most powerful feature. Yet, most who create and work with them barely scratch the surface of all that PivotTables can do. In this session, you’ll learn eight powerful features you may have missed. From user-defined calculations to consolidating reports and adding KPIs, we’ll show you how to get the most out of your PivotTables. These are just some examples of the great things you can do with PivotTables, and in this session, you will learn these and other techniques to make your PivotTables even more powerful.

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.

Google is one of the largest, most widely used and vital technology companies on the planet. Their name has become synonymous with search, knowledge, and cutting-edge technology. Google developed and maintains a wide range of products that have changed how we learn, find things in our community, and communicate with the world. Further, Google offers a business-ready cloud productivity suite used by a growing number of businesses worldwide. Google brings together a wide range of communication and business tools under one roof to serve as the backbone of an organization’s technology infrastructure. Most users are familiar with Google’s search service or Gmail but are unaware of the other services they provide. Additionally, most users barely scratch the surface of the functionality of Google’s tools and services. This course looks at the most valuable features, apps, and services of Google that the busy working professional could better utilize. Course participants will learn to find better web results using search operators and tools. Further, they will understand Workspace and use it as an organization’s back office. They will learn to create dynamic, creative, and useful business documents using Google tools. They will learn to back up and sync their electronic documents to the Cloud using Google Drive. Finally, they will learn to grow their business and expand their marketing using Google’s marketing and website tools. This session finishes with a top-five list of Google's best-hidden secrets and functionalities. Beginners to advanced users of Google products will leave this course with a much deeper understanding of the services, time-saving tips to use the products more effectively, and practical advice on how to best leverage their incredible technology.  

Automating the tax practice is – or should be – a major initiative of almost all public accounting firms today. From ingesting data, processing returns, distributing draft and final copies, and billing and collecting fees, practitioners have outstanding opportunities to automate their tax practice. Those that choose to automate will experience the benefits of reduced staff turnover, increased productivity and efficiency, fewer errors, and improved cash flow. Participate in this session to learn the “how’s and why’s” of automating your tax practice. This session includes critical topics such as hardware and software options, workflows, and security and privacy issues. Plan to join us in this session to position your tax practice for greater success! 

For many business professionals, accessing and managing data in Excel is one of the biggest stumbling blocks when creating reports and analyses. Common practices include far too many manual processes and formulas, including never-ending manual processes needed to update your data and related reports. Make plans now to join us in this session to learn best practices for accessing and managing data using Excel. In this session, you will learn how you can use Power Query and other Excel tools to quickly access and manipulate your data and generate reports in record time! This is a “must-see” session for any business professional working with Excel!    

Part one of a five-course series, Level I addresses common issues new staff members face. Learn to focus on strategies to improve efficiency and quality control, build technical skills, and make valuable contributions to a company. We will 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.

Microsoft 365/Office 365 continues to grow and evolve, yet most utilize only a fraction of the tools available in their subscription. For example, powerful resources such as SharePoint Online and audio and video conferencing can change how your organization communicates and collaborates. In contrast, more personal apps such as Teams, Planner, Flow, and Sway allow individuals to work more efficiently and effectively in virtually all facets of their jobs. Further, security enhancements to Office 365 mean that your organization can take advantage of all these features in a highly secure environment. Isn't it time you learned how to move beyond the traditional Microsoft 365/Office 365 applications such as Excel, Word, and Outlook and unleash all your subscription offers? Join us in this fast-paced and highly interactive seminar where you will learn what you need to know to succeed with Microsoft 365/Office 365.

Join us for this opportunity to gather with CTCPA Executive Director and CEO Bonnie Stewart to discuss issues affecting the profession.

Internal controls are more important than ever, and their importance increases daily. However, internal controls present a challenge for many smaller organizations. This program will teach you how to evaluate, develop, and implement an effective internal control structure in a small business environment. You will identify how to assess risk in smaller organizations and implement preventive, detective, deterrent, and compensating controls to mitigate these risks, even without proper segregation of duties. Additionally, participating in this program will teach you technology-focused techniques for preventing and detecting fraud and securing information systems and sensitive data. For small organizations, maintaining an effective system of internal controls presents a significant challenge. Realistically, implementing many theoretical concepts surrounding internal controls may sometimes be impossible. Consequently, many internal control structures foster an environment where too much risk exists. This factor and uncontrolled information systems can often lead to disastrous results. Participate in this program to learn the necessary insights and tools to design, implement, and monitor small organizations' internal controls, security, and anti-fraud measures.

Charts and graphs are nothing new. However, many professionals struggle with building compelling visualizations. If that statement describes you, participate in this session to improve your skills in creating Excel charts and other visualizations. As a result, you will create visualizations to enhance your communication skills. This session is much more than just a seminar on fundamental charts. Instead, in this session, you will learn how to create advanced charts that are interactive, dynamic, and aesthetically pleasing - three qualities that will help to ensure that your readers and audience will understand the data you are presenting. This seminar is a must if you want to improve your communication skills.

Most professionals routinely use Word, Outlook, and PowerPoint, but many are self-taught and, as a result, have not used many of the best features of these three applications. Consequently, they often use "brute force," inefficient means when working with these three components of Microsoft Office. If that describes you, carve time out of your schedule to participate in this four-hour session. In it, you will learn how to work much more efficiently when using these tools to get better results in less time.

For many business professionals, accessing and managing data in Excel is one of the biggest stumbling blocks when creating reports and analyses. Common practices include far too many manual processes and formulas, including never-ending manual processes needed to update your data and related reports. Make plans now to join us in this session to learn best practices for accessing and managing data using Excel. In this session, you will learn how you can use Power Query and other Excel tools to quickly access and manipulate your data and generate reports in record time! This is a “must-see” session for any business professional working with Excel!    

Automating the tax practice is – or should be – a major initiative of almost all public accounting firms today. From ingesting data, processing returns, distributing draft and final copies, and billing and collecting fees, practitioners have outstanding opportunities to automate their tax practice. Those that choose to automate will experience the benefits of reduced staff turnover, increased productivity and efficiency, fewer errors, and improved cash flow. Participate in this session to learn the “how’s and why’s” of automating your tax practice. This session includes critical topics such as hardware and software options, workflows, and security and privacy issues. Plan to join us in this session to position your tax practice for greater success! 

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 courses rely heavily on participant interaction and these virtual programs have co-opted many of Zoom's features to preserve the same strengths of the in-person training: visual interaction between the instructor and all participants (plan to be "on screen" throughout the program); breakout rooms to ensure small group engagement; and instructor interaction screen share for small group presentations, easy delivery of video presentations, and fillable PDF for online note-taking in the course materials.