This course introduces users to the Power Query Editor, using the Excel version of Power Query, and includes a hands-on transformation exercise using the editor. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously...
Obtaining an understanding of the entity and its environment is critical part of assessing the risk of material misstatement. The auditor obtains an understanding of internal controls by evaluating the design and implementation of key controls over relevant systems as well as entity level and financial reporting controls. This module will provide the participant with...
This course is designed for the Excel user to begin their data analytics journey with an introduction to a product created for their skill set: Power Query, using the Excel version. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to...
Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through...
This course guides you through creating, copying and pasting, reviewing, and correcting basic and complex formulas in Excel 2019 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...
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. They have also been subject to employer incentives. The Service has announced that uncovering noncompliance by employers ranks high...
This year, not-for-profit entities are preparing to apply critical new standards related to contributions of nonfinancial assets, leases, and more. 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 not-for-profit entities. This course is designed to do just...
The cost of fraud, dearly paid by governments and nonprofits, is too severe not to learn from. In this course, we will look back on real-world government and nonprofit frauds and derive useful controls to stop them.
You just received an email from Roni, a prospective new client. He owns several properties under the business name Roni's Real Rentals LLC and wants help minimizing rental income and maximizing deductions that offset the rental income. You will interview Roni and visit his two properties to gain a better understanding of his situation. Advise...
This past year has shown us the need for numerous projects and the need to manage those projects in a unique way. Project management is a way of thinking highly recognized and practiced by large organizations, but often neglected by the smallest companies and entrepreneurs. This course quickly discusses the basics of project management thought...
Cash and cash equivalents tend to be one of the first areas assigned to new auditors since it tends to be straightforward with less complexity and risk as other areas. In addition, there is little subjectivity involved and persuasive audit evidence from a third-party is generally available. Interestingly enough, this is an area that can...