This course presents five use cases for specific data issues a user may encounter in Power Query (Excel version). Through hands-on examples, users are guided through the process of overcoming each of these issues.Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel...
As finance professionals we often have dual responsibilities, to use our technical skills and also to exercise our leadership skills to lead a department. But we are often not sufficiently trained in the second, and sometimes most important, skill set. This short program takes an in-depth look at a proven model designed to help us...
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...
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 course will take an in-depth look at the largest municipal fraud in U.S. history. What red flags did the auditors miss? What red flags did the bank miss? This course includes a conversation with former U.S. Marshal Jason Wojdylo, who was an integral part of this case.This is the fourth of five 2-hour courses...
When putting together a financial plan, it is important to remember that the tax situation of the business and the individual are often intertwined. Therefore, decisions about entity type are vitally important. Practitioners need to understand not only how different entities are taxed, but also which taxes will have the greatest impact on the individual...
While the effective date of Topic 606 has passed for most entities, there will always be a need for a comprehensive review of the accounting related to revenue recognition. Also, if you are taking advantage of the FASB deferral of Topic 606's effective date, you are still completing your implementation plan. Whether you are looking...
New accountants, whether coming right out of school or from industry will find that the accounting profession is heavily governed by technical and ethical standards. In addition, the new accounting professional will need to understand new terminology as well as what their team members and clients expect of them by way of job performance and...
This course will discuss what to do if you suspect fraud within your organization. The HealthSouth fraud case is presented as a means of understanding how the fraud was committed, and ways in which it could have been prevented. This is the second of five 2-hour courses in Surgent's Fraud Certificate Program. This program includes...
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 course is designed to help you proceed and succeed in applying the requirements found in ASU No. 2018-08, Clarifying the Scope and the Accounting Guidance for Contributions Received and Contributions Made. Learn the thought process used in evaluating and recording contribution transactions.
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, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access...