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...
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 exit planning, it is important to weigh various issues, including tax implications, to achieve an effective management and/or ownership change. Many envision tax-free reorganizations being the most preferable structure to avoid capital gains tax, but the opportunities come at a cost to the seller. This course will provide a well-rounded discussion of the various...
Partnerships and LLCs involve unique problems that require careful attention. This course covers selected critical tax issues that practitioners need to know when working with partnerships and limited liability companies, with a focus on planning opportunities and pitfalls.
This course is a two-lesson advanced level course that guides you through creating, formatting, and modifying PivotTables and PivotCharts in Excel using step-by-step hands-on activities.
The Inflation Reduction Act (IRA) and SECURE Act 2.0 both contained tax law changes that impact many individuals in 2023 and in later years. This program covers many of these changes as well as other tax topics that continue to impact individual income taxpayers.
Owners of S corporations and partnerships are subject to numerous limitations on pass-through losses, each with unique rules, applications, and complexities. With the increase in popularity of pass-through business entities, it is essential for CPAs to understand the complexities and interactions of these pass-through loss limitations.
As experienced staff members master the preparation intricacies of an 1120-S tax return, they are expected to understand and apply the underlying concepts, principles and laws governing S corporation status. This course is designed to illustrate in both theory and practice overarching principles that govern S corporations from formation to revocation, termination and liquidation. Experienced,...
Business tax changes that come from legislation, IRS pronouncements of various kinds, and court cases. This program analyzes the new opportunities that these tax changes offer to businesses and their owners.
Despite the fact that a client's tax matter may be taken directly to court, utilizing IRS Appeals usually results in saving your client both time and money. Join us as we discuss the misunderstood process of going to IRS Appeals.
This course is designed to help you proceed and succeed in preparing meaningful financial statements for nonprofit organizations. Learn the requirements and options allowed to nonprofits in conveying financial information to donors, creditors, grantors, and others.
While the effective date of Topic 606 has passed for companies, there will always be a need for a comprehensive review of the accounting related to revenue recognition, including recently issued changes to this guidance. Whether you are looking to improve your revenue recognition processes, benchmark your financial statement disclosures against your peer group, or...