This course teaches the user how to perform data transformations in Power Query, using a hands-on approach. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables...
As financial and tax professionals well know, information overload is a constant struggle we face because things change quickly, and the sheer number of changes being made on a daily basis is enormous. Of great importance to small and medium tax and advisory firms is differentiating between changes that are relevant to our practice and...
Most of our clients are pass-through entities for which many of the general business strategies are subject to additional limitations. To provide the tax planning strategies for closely held business clients that will bring more revenue, this course focuses on the special concerns and techniques the practitioner needs to thrive in this market.
While risk assessment and planning lay the foundation for IA engagement programs, it is the effective execution of the program that ultimately determines the success of the IA activity in serving and adding value to its stakeholders. The results of IA engagements are derived from the critical fieldwork processes initiated and completed by audit teams...
With the AICPA's heightened focus on enhancing audit quality, increased oversight of the peer review process and the auditor's overall responsibility to provide high quality services, the focus on compliance with professional standards has never been greater. Recent peer reviews have indicated that auditors are often failing to perform and/or document certain critical components of...
As financial and tax professionals well know, information overload is a constant struggle we face because things change quickly, and the sheer number of changes being made on a daily basis is enormous. Of great importance to small and medium tax and advisory firms is differentiating between changes that are relevant to our practice and...
A data-driven culture can only occur when there is collaboration, communication, and cooperation between everyone in your organization.Collaboration can only occur in the Power BI ecosystem when your organization works in the cloud with Power BI.com, also known as the Power BI Service, a software as a service available on the Power Platform.This one-hour course...
As financial and tax professionals well know, information overload is a constant struggle we face because things change quickly, and the sheer number of changes being made on a daily basis is enormous. Of great importance to small and medium tax and advisory firms is differentiating between changes that are relevant to our practice and...
The Inflation Reduction Act (IRA) contains many changes to auto and energy-related credits as well as new credits and old credits that have been renamed. For instance, did you know that the IRA brings back a credit for installation of electric car chargers? Many if not most of these credits reduce the cost of individual-...
Many consider taxation of construction contractors to be the most complex area of the Internal Revenue Code. Probably no other industry has so many elections and considerations that need to be considered and made in order to reduce or defer amounts owed. In this course, we will highlight these areas and discuss potential opportunities for...
Knowing just a little about the Yellow Book can hurt you! It is important to have a thorough understanding of the standards. This course covers the Yellow Book financial auditing requirements and prepares you to excel in applying the standards. You will learn precisely what the Yellow Book does and does not require auditors to...
The past two years have ushered in an explosion of ransomware attacks affecting businesses and individuals. Many of us read or hear about these attacks, but there is little understanding of how they occur, how a response is undertaken, and how the chances of experiencing one can be reduced. Join us to learn about these...