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...
Power Query (Excel version) offers a wide range of transformation options. This course uses hands-on exercises to explore the data transformation process, focusing on data cleaning...
Append queries combine two or more queries into one output query that is a combination of the originals. This course discusses best practices for creating append queries using...
A merge query combines two queries that have a common column or columns. This course discusses best practices for creating merge queries using Power Query (Excel version) and...
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...
Health savings account optimization allows individuals with a high deductible health plan to contribute money into a tax-advantaged medical savings account. Individuals receive the...
Gerald Ford once said that "[n]othing in life is more important that the ability to communicate effectively." Public speaking remains a centuries-old skill that allows individuals...
How debt is allocated to the partners in a partnership is important. It dictates how much money may be taken tax-free as a distribution, the losses that flow down to the partners...
Partnership tax law is always difficult. However, when certain transactions come up, not knowing how to handle them can be costly to clients and practitioners. In this course, we...
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...
The best way to ensure engagement quality is through consistent application of a firm's system of quality control. In this course, we will review the key components of such a...
Knowing just a little about the Yellow Book can hurt you! It is important to have a thorough understanding of the standards. This course covers the Yellow Book financial auditing...