Error loading player: No playable sources found
FVC2315
Data Modeling Made Easy: Supercharge Your Excel Spreadsheets
Date
November 6, 2023
$49
Standard Price
This product is also available as part of the following products:
This includes sessions from the conference: 2023 AICPA & CIMA Forensic & Valuation Services Conference
You don’t need a computer science degree to build a database for a complex data analysis. In this hands-on session, learn how to unlock Excel’s under-utilized data transformation and data analysis capabilities. With Excel’s Power Query and Power Pivot, you can perform more advanced tasks including data modeling, automation and business intelligence. Unlock Excel’s big data capabilities, where millions of lines of data can be loaded into a single spreadsheet.
Learning Objectives
- Analyze when and why to leverage Excel’s Power Query and Power Pivot for data analysis
- Distinguish among the many capabilities of these tools, and determine what resources you can leverage to learn more
- Apply use cases for these tools and what differentiates them from the other methods of data analysis
Speakers
Senior Manager, Forensic Accounting & Data Analytics, EisnerAmper
Travis Armstrong, CPA, CFF
Partner, Hemming Morse, LLP
General
Session Categories
Related Products
Litigation Talk Series - When Key Information or Data is Not Available (continued in #FVC2337)
This session will explore the perspectives of both experts and counsel in situations when key information or data needed for a forensic accounting or damages analysis is either not available or unreliable. Panelists will discuss case examples, court opinions and practical experiences…
Which Hat Am I Wearing - The Psychology of Client Management
As experts, we are responsible for complex accounting analyses , but we often find ourselves in a position of managing the human and emotional element of a stressful situation…
Preparing for Tomorrow’s Workforce
This session will focus on strategies related to building the workforce of tomorrow. Specifically, the panel will address the current state of the talent pipeline in valuation and forensic specialties and the evolution of today’s workface…
FVS Forum
In alignment with our 5-year strategic plan, this forum will highlight the key projects, initiatives and advocacy efforts that the FVS Executive Committee, FLS Committee, BV Committee, CFF Committee and ABV Committee have accomplished this past year…
