Error loading player: No playable sources found
FVC2111
Power Excel - Power Applications for the Forensic Accountant
Date
November 8, 2021
$49
Standard Price
This product is also available as part of the following products:
This includes sessions from the conference: 2021 AICPA & CIMA Forensic & Valuation Services Conference
This hands-on session will focus on Excel-based "Power" tools! We will explore Power Query which supercharges Excel's ability to connect, transform, combine, and load data. Additionally, we will explore Power Pivot which allow us to analyze large volumes of data from various sources and quickly present findings through Pivot Tables and Pivot Charts. Participants will have the ability to work through multiple real-world FVS use-cases using financial and non-financial data during the session.
Learning Objectives
- Utilize Excel's Power Query tool to create an index of documents received from counsel.
- Utilize Power Query to un-pivot data tables.
- Explore Power Query tools to help import, clean, and transform data.
- Creating the link between external data and Excel's Power Pivot Data Model.
Speakers
Travis Armstrong, CPA, CFF
Partner, Hemming Morse, LLP
Alex Smith, CPA/CFF, CFE, MAFF
Senior Manager, Dixon Hughes Goodman LLP
General
Related Products
Use of Cash - Identification of Unreported Income
-Discussion on the places we most often see unreported income
Healthcare and Valuation: Current Trends and Implications to the Industry
Healthcare valuations require an appraiser to understand the various regulations that only impact healthcare valuation, the trends in the healthcare market, and other healthcare specific terminology and nuances…
Don’t miss the Bar: Standards and Ethics
For experts, it is critical to understand the interplay of the various standards and state statutes that impact our practice. Navigating these standards and professional ethics at times can be challenging…
Career & Business Development in Times of Disruption
In today's times, change is all around us - personally and in the workplace. How do you leverage your career and business development while learning and adapting to a new normal - or, rather, the evolving new normal…
