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...
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...
The "permanent" changes from the TCJA may stand like a lion in the pathway of change, but Washington has its own definition of permanent. Inflation adjustments and technical corrections are included within this deep analysis of the complex maze of rules dealing with depreciation, amortization, and sale of property. This course contains many examples and...
Today's workforce looks a lot different than it used to. With more people working from home and across state lines, employers must examine withholding and unemployment laws in a new light. In this course, we will examine tried and true rules in this area, but also examine statutes that are still developing. Using real-life examples...
Clients think that estate planning only applies to the very rich. In truth, there are many issues of critical concern for which the middle-income client needs to plan. This course is a must-attend for all Accounting and Financial Professionals who work with middle-income clients and are looking for ways to provide additional quality services. Updated...
With the leasing standard and other standards looming, now is the time to know more than just what the standards say; we need to know what they mean and how they will affect governmental entities. This course is designed to do just that! The course materials utilize a highly illustrative and innovative format. Over 15...
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...
This final course in the series covers advanced features in Power Query (Excel version), including functions and parameters and basics of data modeling in Power BI and Power Pivot. Multiple hands-on examples help to reinforce these concepts.Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that...
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...
As they gain more experience, staff are expected to take on more complex assignments with minimal supervision. The course is designed to be a stepping stone for staff interested in pursuing more advanced partnership and LLC issues than mere preparation, via deeper life-cycle study into critical areas of formation, special allocations of income and deductions,...