Risk is everywhere; volatile interest rates, commodity prices, and markets. The best business leaders excel at mitigating risks, but some risks can't be tamed while others can be. How did this happen? Why is market risk increasing and happening more frequently - despite governmental regulations?...
This fast-paced course focuses on using Excel Power Pivot features to enhance data analysis. One of the strengths of Power Pivot is the formula language DAX (Data Analysis eXpressions). We will spend considerable time using the power of DAX to create meaningful calculations that add new...
Don't let the title frighten you. Experienced staff can get bogged down in busy season with advanced practice and reporting issues. This course discusses the topics that experienced staff, managers, and partners should understand in depth while also assisting experienced staff in avoiding costly...
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...
From acquisition to disposition, capitalized costs and depreciation can be challenging to understand. Developed to help you gain significant tax savings for your clients, this self-study course offers a comprehensive and practical understanding of the IRS cost and repair regulations dealing...
This webinar will explore actual cases of CPAs behaving badly, resulting in the loss of their licenses. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. NOTE FOR OHIO CPAS: The Accountancy Board of Ohio has...
We will provide an overview of the various Power BI tools and discuss Microsoft's Power BI Strategy. We will begin by explaining the challenges faced by many accountants when it comes to analyzing data in Excel. You will learn how each Power BI tool reduces the challenges and improves your...
Unlike Schedule L's Part I which requires "turning in the sinner," Parts II-IV promote transparency and accountability when an exempt organization has "insider transactions" regardless of whether the transaction is routine and/or reasonable! These parts imply no value judgment, but filers who...
Over the years, Excel has added MANY new features and functionality, yet most people still use it in the same way they first learned. Part of the reason is new features were added when the newest version was announced approximately every 3 years. The list was so extensive, making it difficult to...
The first session of the series introduces the PivotTable feature and covers the basics. We start here to ensure that all participants, regardless of previous PivotTable experience, have the skills needed for the remaining sessions. We discuss the four report layout areas, rows, columns,...
Business literature often tells the stories of epic blunders, people who have attempted great achievements, yet failed spectacularly in the attempt. Study after study has shown that great successes rarely occur as the result of a giant leap, but rather from disciplined experimentation that...
Companies operating in today's business climate are weathering a storm of major FASB updates. Companies and their advisors may want to consider non-GAAP options as they develop strategies involving revenue recognition, leasing, credit losses, and other FASB pronouncements. This program provides...
Want to automatically update the date and time on your spreadsheet? Or pick text strings from other cells to automatically copy and update to a different cell? You will learn how to incorporate text, date and time functions in your spreadsheet that will make data entry a breeze. In this...
Before you can analyze data, you first must get the data. This webcast focuses on getting data into Excel using different data sources. Whether your data is text, comma delimited (CSV), reports, Excel, databases, web, applications and/or many others, Excel provides the ability to access that...
The IRS recently issued final regulations giving investors more guidance regarding Qualified Opportunity Funds. Qualified Opportunity Funds are complex investment vehicles that provide tax incentives to investors. Taxpayers investing in a Qualified Opportunity Fund can defer capital gains,...
The course provides general information on how to identify money laundering activities during the conduct of normal tax audits. Discover key resources and tools available for effective detection and deterrence. Explore the impact of money laundering on ethical decision-making, and how examiners...
The December Stimulus package has just been released and includes major tax provisions that will be effective for the 2020 tax year, things that CPAs and tax preparers need to know NOW! This presentation will include examples and case problems to illustrate and explain the law provisions. This...
Trusts are not cookie-cutter documents. In fact, they can be rather unwieldy, especially in explaining the functions to a client and then having the client comply with the trust terms. This course delves into best practices. Given common scenarios, what are the best trusts to use? What language...
This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes. Emphasis will be placed on partners "tax basis" capital accounts, now required for 2020 tax form reporting. This course qualifies...
The course provides a concise overview of how accountants can instantly and dramatically improve their Google search skills. Discover how to use the search service to spot opportunities and threats in your enterprise landscape earlier and faster, improve your research tactics as a trusted...
