CPE + Events Catalog

Are you aware there are 470+ formula functions in Excel? Do you realize that they add new functions in every major version of Excel? Did you know that Microsoft adds new functions throughout the year in the Office 365 version of Excel? Are you stuck using old or simple functions like SUM or ROUND? Do you want to expand your knowledge of the extensive function library in Excel? If these questions peak your interest in becoming an Excel function expert, this course is right up your alley. This past-paced course digs into some of the most powerful functions in Excel. Although we cannot cover 470 functions, we will look at over 20 functions that will allow you to create advanced calculations in your spreadsheets. Some examples are: VLOOKUP, IF, IFS, FORECAST, RAND, SWITCH, TEXTJOIN, UNIQUE, SUBTOTAL, IS, TEXT and more! We will also provide example files that will include all the functions used during the class. It's time to take your Excel spreadsheets to the next level. This session is presented using Excel 2019/Office 365. Most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Presents the guidance found in the 2018 revision of Government Auditing Standards., Government Auditing Standards requirements and application guidance are examined for auditors who work with state and local governments, and for not-for-profits.

Our guidance on ethics comes from the AICPA and other groups, but it does not fully address the “why” behind ethics. This session will examine and define what ethics is and what it means to varying people in the workplace. Understanding what motivates people and understanding those people are key to both solving ethical dilemmas and workplace issues that can lead to greater job satisfaction and efficiency. To correct an issue, you need to delve into the root cause – the why?

Learn the five-step process for recognizing revenue under FASB ASC 606. Supported with practical examples and disclosure illustrations, this webcast addresses core principles that all CPAs need to know.

New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel's "legacy" features, and you have significant new opportunities to improve your Excel-based reporting environments.In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to format your spreadsheets quickly and efficiently to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process.

This course focuses on concluding a fraud examination and participating in court activity. You will learn how to draft an effective written report on a fraud investigation, including exhibits and visual aids that will help make your case. We will discuss common questions asked of financial experts and techniques for successfully testifying at deposition and trial. This is the most practical fraud investigation course you will ever take. Rather than learning only the theory of fraud, you will learn how a forensic accountant actually investigates fraud from the beginning to the end. We focus on forensic accounting techniques used in the field to prove what happened, who was involved, how much money was stolen, and where the money went. Reporting the Results of a Fraud Investigation is Part 4 of a series of four courses on fraud investigations. Each course is a stand-alone class that may be taken individually. For comprehensive instruction on completing a fraud investigation from start to finish, take all four. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Cover critical aspects, common problem areas and strategies for successful 1031 exchanges. Examine Form 8824 preparation, replacement property adjusted basis computations, advanced 1031 strategies and more. Study advanced 1031 exchange strategies such as reverse exchange, partners/TIC structures, and improvement exchanges (including "Bartell" parking arrangements). Bring questions and increase your expertise. Updated in 2018 for effects of the 2017 tax reform act.

What exactly is cryptocurrency and its cousin named blockchain? Are they here to stay? This session will provide a big picture examination of the technologies and currencies by explaining how we got here. We discuss the systems and technical aspects of cryptocurrencies and blockchain. What is the broad view of the technologies that currently do, and will continue to, impact our workplace and lives?

Do you find yourself challenged to achieve the results you want? While leading employees can be one of the most challenging activities, it is also one of the most impactful leadership skills few seem to master. Inspirational leadership looks like lifelong employees reaching their full potential AND impactful business results that are repeated year after year. Striking the balance between these two critical aspects does not have to be rocket science. In this power-packed course, the formula to be an Inspirational leader has been masterfully developed and covers the soft skills of Inspirational leadership and the Results Model: Goal Setting + Coaching + Follow Up with proven results from dozens of both large and small companies. These cornerstones are simple but can be hard to execute because it is HOW you do it first, then WHAT you do second. This exciting course is designed to ignite your leadership skills by putting theory into practice; drilling into real live examples and experiencing first-hand what excellence sounds like through role-playing and building your action plan. Get ready to become an inspirational leader and learn the steps required to get the results you really want. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The topic of ethics has seemed to permeate every aspect of today’s business including occupying a significant spot in today’s business, educational and professional curriculum. Yet with all the discussion and awareness on the topic, why is it that significant ethical dilemmas and incidents continue to impact our daily lives? The concept of ethics is based in moral philosophy. In part, that is why it is such a difficult issue to “manage”. We often get caught between our independent moral ethical duty, the legal or compliance viewpoint of an issue and management concerns around reputation and ramifications. This course is dedicated to examining a time-line of historical ethical issues that have plagued the business world, evaluating the moral and perceived concepts around ethics, and taking a practical look at how moral and ethical concepts impact the creation of an ethical culture.  

This 2-hour mini course is from our Level V course, which highlights leadership skills and situations that are common for managers and senior managers in CPA firms. Participants will be encouraged to examine and challenge their beliefs and approaches to managing and leading people.Leading Others - Coaching & Developing Staff - prioritizing the coaching and development of staff in a post-pandemic work environment, including delegation for development, effective feedback, and managing virtual employees.Building Leadership Communication Skills - strategies to influence and lead others through effective communication in both individual and group settings.Helping the Firm Grow - the three levels of helping the firm grow and how to involve the entire team in expanding services to existing clients and generating referrals to new 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 fillable PDF for online note-taking in the course material.

It is easy for us to get caught up in our work, but it is better to examine the ‘big picture’ by studying the outside factors that impact our business beyond our internal processes and day to day responsibilities. We are sometimes so busy with our tasks that we miss new developments until the developments have a profound impact on us and the organization. This session is designed to review many of these current trends, while thinking and discussing how these trends can impact our organizations and us. This is a fun and lively session that is intended to be interactive with participants either live, virtual or both. Our ever-changing world is evolving more than many realize.

This course explores the increasingly complex features of Excel that facilitate efficient data analysis.  We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information and dive into the powerful, but potentially under-utilized, capabilities of Microsoft Excel.  Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level.

A well-organized chart of accounts supports robust responsibility reporting, makes it easy to answer "what if?" questions and helps eliminate data entry errors. However, many organizations cling to the primitive practices of a half-century ago that impose barriers to developing budgets, holding people accountable, gathering useful data and keeping errors from creeping into their financial statements. Best practices today look little like the examples you may have seen in business school. If you sense that your general ledger could do far more, this session will show you how to fix your problems This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Payroll is among the most common tasks an employer undertakes in the course of running their business. At its most basic level, payroll consists of an agreement between an employer and employee related to compensation for services. Once you pull back the curtain, there is so much more to payroll, including various kinds of compensation, payroll taxes and required reporting on various government forms. This course will provide a general introduction to the payroll cycle of life, including real life examples of how to process payroll, the withholding and payroll tax deposit regime, common payroll forms, and tips and tricks for tying it all together. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

When auditors detect findings in Yellow Book and single audits, they do not just communicate them in some shabby little letter to management; they get reported! In this course, we will examine what types of findings get reported, how they get reported, and where they get reported! This course will take you from just checking a box and fulfilling a requirement to developing and delivering findings that make a meaningful difference to your clients.

Recall lessons learned and practical implementation challenges and complexities with the FASB's Accounting Standard Update for Leases (ASC Topic 842). Identify key differences between ASC Topic 842 and ASC Topic 840, Practical Expedients, remeasurement-triggering events. Session will go beyond the basics and will apply to specific examples. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In recent history, even the most prestigious CPA firms have had ethical lapses and oversights that have cost them both financially and, at that moment, clouded their brand. This course will review the AICPA code of ethics for both accounting and tax practitioners and encourage you to examine your firm's policies and choices relative to those standards and common sense through thought-provoking and sometimes humorous Q&A and case studies. This course fulfills the four-hour ethics education requirement.

This comprehensive training is designed to get the accountant up to speed quickly with the complex passive activity loss (PAL) rules that apply to certain investments in trades or businesses and rental activities. The cornerstone of the course is the in-depth coverage of the detailed tax law and regulations applicable to passive activities under IRC 469 and how and when the 3.8% net investment income tax under 1411 applies. Each attendee will receive the most comprehensive passive activity reference manual with numerous practice aids and real-world examples.

Part 1 of 2. You'll never think about fraud the same way again after this session examining the psychology of both investigators and perpetrators. This story-based presentation will use first-hand accounts and the latest research to show why some traditional investigational practices are more harmful than helpful. This two-part series will expose myths and dangers lurking in our assumptions about fraud. We will explore misunderstandings about skepticism and learn how auditors and investigators may unwittingly assist the same fraud schemes they are trying to thwart. We will challenge the "sacred cows" of the industry and help us develop more effective thinking approaches for fraud investigation, detection and deterrence.