This course is a one-lesson intermediate level course that guides you through creating formulas using Financial, Date & Time, Math & Trig, Statistical, Lookup & Reference, Database, Text, and Logical functions.
During a financial statement audit the auditor obtains an understanding of the entity and its environment (including its internal control), performs a risk assessment and from that work designs substantive procedures that will be responsive to the level of risk assessed. At the end of the audit, the auditor assesses the sufficiency and appropriateness of...
This year is indeed another year of significant change in the world of governmental accounting and auditing. Time is valuable, and it's hard to stay current in today's rapidly changing environment. Let us save you time and effort in staying current through this informative update course. The course materials utilize a highly illustrative and innovative...
In this one-hour course, users will learn to apply Power Query to extract, transform, and load data for analysis. Users will learn how to manipulate data once it is loaded into the platform and will practice the manipulation during the course. Using the same data as the instructor, users will perform an exercise to clean...
The one constant in life is change. This is true in the A&A world as well. 2021 will continue to challenge the accounting profession in many areas, including accounting for the impact of the COVID-19 pandemic, working in a virtual environment, and implementing new AICPA and FASB pronouncements. In this monthly series, we will explore...
Cryptocurrency is heading mainstream. According to a recent study conducted by New York Digital Investment Group, there are 46 million bitcoin holders in the US, and institutions have also shown increased interest in this space. The rising popularity of cryptocurrency and the inclusion of the virtual currency question on the front and center of Form...
Using a variety of hands-on exercises, this course enables users to learn how to add columns using Power Query (Excel version). 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...
Participants must use their expertise to assist a new client who just received Letter 6173 from the IRS. The client didn't share any crypto-related transactions or events with the tax accountant who filed the original return. It's up to the participants to meet with the client and uncover details of the activities so an accurate,...
As a byproduct of the audit, the auditor has a responsibility to communicate certain information to management and those charged with governance, primarily related to risk and internal control deficiencies. In some cases the auditor may be required to report outside the entity, for example, when fraud is identified. Some of these communications to management...
The objective of this course is to train new staff accountants, data processing employees, paraprofessionals, and bookkeepers to prepare a moderately complex federal individual income tax return (Form 1040). Over the years, thousands of new staff have received practical, hands-on experience to become familiar with tax forms. This course covers the latest tax law changes,...
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...
Participants play the role of an auditor collecting information, making inquiries, and documenting findings around the audit of Home D‚cor and More. They develop professional skepticism skills as they analyze data obtained from an interview with Courtney the Controller, comparing, confirming, and corroborating it against information provided by the CFO. Some things aren't matching up...