0      0

2021 AICPA & CIMA Forensic & Valuation Services Conference

FVC2111 - Power Excel - Power Applications for the Forensic Accountant


Nov 8, 2021 11:30am ‐ Nov 8, 2021 12:45pm


Standard: $49.00

Description

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.

Speaker(s):

You must be logged in and own this session in order to post comments.