When real property is sold for a gain, we always try to find ways to defer recognizing income so it won't be necessary to send a check to Uncle Sam. There are two provisions within the Internal Revenue Code that allow the taxpayer to defer recognition of immediate taxable gain in the year of sale:...
Be the go-to person for financial statement compilation engagements. Specifically designed for compilation practitioners and their staff, this course will provide you with a hands-on application for performing compilation engagements under AR-C Section 80. You will learn the ins and outs of relevant sections of SSARS No. 21, Clarification and Recodification, the most significant change...
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 includes hands-on exercises to enable the user to demonstrate what they have learned.Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has...
This one-hour course will introduce users to table functions in Excel and Power BI. Users will demonstrate an ability to apply and utilize named ranges and naming conventions to data. Specific focus will be given to common formulas and functions within Excel. Common pitfalls in formula implementation will be discussed. Users will utilize exercises alongside...
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...
Fraud continues to be at record highs. According to NASDAQ's Global Financial Crime Report, fraud schemes and bank frauds led to global losses of over $485 billion. Four of the most cited frauds were customer fraud, cybercrime, asset misappropriation, and bribery and corruption. From global banking giants to local charities and mom-and-pop shops, no entities...
The effective date for ASU 2016-02, Leases (Topic 842) is finally here. The new standard eliminates one of the largest forms of off-balance sheet accounting and requires most leases to be brought onto the balance sheet irrespective of their classification as either financing or operating. The new guidance in ASC 842 also makes other changes...
In the ever-evolving world of data analysis and office productivity, Microsoft Excel remains at the forefront, continuously introducing new and powerful features. This comprehensive course is designed to familiarize participants with the most recent and significant updates in Excel as well as some old favorites. This course offers an in-depth exploration of these features, ensuring...
In the past, entrepreneurs who sought investment capital for their start-ups were subject to the preferences and expectations of a small set of wealthy investors. These venture capitalists and angel investors often played the role of highly selective gatekeepers, denying countless potential business leaders the opportunity to bring their well-thought ideas to market. Much has...
The most difficult concepts to master when dealing with flow-through business entities are the basis and distribution concepts. Major error and malpractice issues occur if the CPA does not fully understand the impact of these rules. This course is designed to focus on the practical applications of these rules.
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...
This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot that is applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how...