This one-hour course will focus primarily on Power Query, Power Pivot, and VLOOKUP skills. Users will learn how to join tables using various techniques and add-ons in Excel. Users will understand how to utilize the tools while maintaining data integrity. The majority of the course will focus on hands-on data exercises. Users will apply skills...
As experienced staff members master the preparation intricacies of an 1120-S tax return, they are expected to understand and apply the underlying concepts, principles and laws governing S corporation status. This course is designed to illustrate in both theory and practice overarching principles that govern S corporations from formation to revocation, termination and liquidation. Experienced,...
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...
Property, plant, and equipment is present, at least to some extent, in virtually all audit clients. Auditing the area can be straight forward but when an entity is building machinery or equipment, complexities arise. Property and equipment can also include right of use assets under lease agreements. This module will address assessing the risk of...
The information technology component of the COSO Framework's Information and Communication element is a very important part of an entity's business processes. Controls over information technology (IT) are effective when they maintain the integrity of information and the security of the data the systems process and when they include effective general IT controls (GITC) and...
2020 taught us that major risks can come at us from any direction and with barely a warning. All organizations operate in a risk environment, but all too often, they either don't realize it or they don't develop a strategy to deal with the risks. In this session, we will explore how risks work in...
Both businesses and individual clients face major changes as a result of new legislation, and tax professionals face the considerable challenge of delivering effective planning advice and services to address this myriad of recent developments. This course addresses this challenge and also encompasses the latest cases and rulings applicable to individual and business clients. Continually...
Excel provides a variety of tools you can use to create, format and enhance charts: contextual Ribbon tab buttons, menus and galleries, shortcut menus, keyboard shortcuts, task panes, and more. This course allows you to explore using these tools to create and format common chart types.
Designed for accounting and attestation practitioners at all levels in both public accounting and business and industry, this course provides a comprehensive review of recent standard-setting activities of the FASB and AICPA. In addition to providing a detailed review of SAS No. 145, this course will bring you up to date on FASB and AICPA...
Implementing ASU No. 2016-02, Leases (Topic 842) is sure to have a major impact on your balance sheet and potentially on your business as well. This course is a one-stop shop for what you need to know about the now-effective changes to the lease accounting guidance. In this course, we will review how to measure...
With the effective date of ASC 842, Leases, right around the corner, companies are running out of time develop their implementation plans. In this one-hour overview course, we'll review the key accounting aspects of ASC 842, primarily from a lessee's perspective. The course will review lease classification, measuring and recording lease liabilities and related assets,...
Most review techniques developed by professionals are self-taught and fine-tuned via experience. Yet how does one start? The purpose of this course is to give both new and seasoned reviewers additional and advanced procedures via a multitude of checklists to more thoroughly review S corporation and partnership tax returns. Its emphasis is not planning; rather,...