This course introduces you to the Excel 2016 software and then guides you through basic Excel features using step-by-step hands-on activities.
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...
Designed for accounting and attestation practitioners at all levels in both public accounting and business and industry, this course provides a comprehensive review of recent standard-setting activities of the FASB and AICPA. In addition to providing a detailed review of SAS No. 145, this course will bring you up to date on FASB and AICPA...
The most difficult concepts to master when dealing with flow-through business entities are the basis and distribution concepts. Major error and malpractice issues occur if the CPA does not fully understand the impact of these rules. This course is designed to focus on the practical applications of these rules.
One of the major transactions CPA clients are faced with is the purchase or disposition of a business. To help tax professionals advise those clients, this course offers a comprehensive analysis of the business and tax aspects of buying and selling a business. It is a practical guide to help practitioners and industry CPAs understand...
This course covers a number of useful transformations using Power Query (Excel version) to clean, enrich, and shape data. Coverage includes pivoting and unpivoting, filtering and grouping, fuzzy matching, and more, with hands-on exercises for users to practice these skills.Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a...
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 "name of the game" in virtually any business (or profession), and most certainly for Internal Auditors, is adding the greatest possible value to and for all stakeholders of that business/profession. Internal Auditors serve a wide variety of stakeholders who place major reliance on their work. Maximizing IA value in terms of assurance levels expected...
2021 will be a very impactful year for audits, as SASs 134-140 become effective for audits for year-ends after December 15, 2021. In this course, we'll review the key changes coming to financial statement audits as a result of these new standards, including the format of the new auditor's report and consideration of key audit...
This course will take new and administrative staff from the most basic concepts to a full understanding of individual tax return preparation - just in time for the crunch of busy season! Updated for impacts of recent legislation, including the SECURE Act 2.0, the Inflation Reduction Act, American Rescue Plan Act, the Consolidated Appropriations Act...
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...
Employment taxes are often overlooked as an area where more planning may be effective. Payroll taxes have become an increasing burden for the average business and IRS penalties for noncompliance have risen dramatically in recent years. As a result, they have also been subject to employer incentives. The Service has announced that uncovering noncompliance by...