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...
Designed to keep you up to date on recent activity of the Financial Accounting Standards Board (FASB), this course will summarize recently issued Accounting Standards Updates (ASUs) issued by the FASB in 2020 and 2021 year to date. The course will discuss the main provisions of the ASU, application guidance, and information on transition and...
This highly informative course comprehensively covers all the latest tax law developments. The focus is on individual taxation and discussion of the planning opportunities practitioners need to understand to help clients respond effectively. You will come away from the course with the up-to-date knowledge to educate your individual tax clients and implement tax-saving ideas that...
This course guides you through creating formulas using Financial, Date & Time, Math & Trig, Statistical, Lookup & Reference, Database, Text and Logical functions.
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...
When the first cohort of Baby Boomers turned age 65 several years ago, tax advisors began to be bombarded with questions concerning all facets of Medicare. How does Medicare work? How do I apply? How much does it cost? Is Medicare optional or required? This program provides a basic introduction to the Medicare program and...