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

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.

Print Certificate
Completed on: token-completed_on
Print Transcript
Please select the appropriate credit type:
/
test_id: 
credits: 
completed on: 
rendered in: 
* - Indicates answer is required.
token-content

token-speaker-name
token-index
token-content
token-index
token-content
token-index
token-content
token-index
token-content
token-index
token-content
token-index
token-content
/
/
token-index
token-content
token-index
token-content