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.
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.