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
Best Practices for Preventing Business Valuation, Forensic, and Litigation Support Claims
This presentation focuses on risk management best practices when conducting forensic accounting, business valuation and litigation support services…
Forensic Practitioners in Arbitration: Witnesses, Consultants and Neutrals
Forensic practitioners sometimes appear before arbitrators, sometimes provide consulting services and sometimes serve as neutrals. Experienced panelists will share their experiences with each role, and how those experiences have shaped their work in dispute services…
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…
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…
