In this one-hour course, users will apply Excel and Power BI tools and skills directly to tables in Excel. Users will work alongside the instructor to create named tables, create structured references, enter formulas, and prepare the tables for input into Power Query. Users will be introduced to the preparation of the first level of...
All organizations are looking for ways to gain an advantage over the competition. This practical and interactive session will present a toolkit of ideas to help CFOs, controllers and finance professionals better position their organizations for the future. We know change is occurring at an exponential rate, and that has proven to be the case...
Employee turnover has always been expensive, and experts warn that the cost of employee attrition keeps rising. Tight labor markets, a strong economy, and increasingly collaborative jobs are just some of the explanations given for the high price of losing employees. While some of these "macro" factors are beyond an employer's control, there is substantial...
Participants play the role of an auditor collecting information, making inquiries, and documenting findings around the audit of Home D‚cor and More. They develop professional skepticism skills as they analyze data obtained from an interview with Courtney the Controller, comparing, confirming, and corroborating it against information provided by the CFO. Some things aren't matching up...
A commitment to excellence requires dedication toward self-improvement in whatever endeavor we choose, including being Internal Audit (IA) professionals. Legendary football coach Vince Lombardi once said: "The quality of a person's life is in direct proportion to their commitment to excellence, regardless of their field of endeavor." And Aristotle, speaking some 2,500 years earlier, has...
The course provides a comprehensive, hands-on, pencil pushing understanding of the preparation of both S corporation and partnership/LLC tax returns, along with the underlying laws, regulations, etc. The course uses the basic concepts underlying the two main types of business returns: 1120S and 1065 as building blocks for more complex concepts tax preparers should be...
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...