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:
Thumbnail for 2023 AICPA & CIMA Forensic & Valuation Services Conference
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

Speaker Image for Adam Karasick
Senior Manager, Forensic Accounting & Data Analytics, EisnerAmper
Speaker Image for Travis Armstrong
Partner, Hemming Morse, LLP

General
Session Categories

Related Products

Thumbnail for Litigation Talk Series - When Key Information or Data is Not Available (continued in #FVC2337)
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…
Thumbnail for Which Hat Am I Wearing - The Psychology of Client Management
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…
Thumbnail for Preparing for Tomorrow’s Workforce
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…
Thumbnail for FVS Forum
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…

This site uses cookies to store information on your computer. Some are essential to make our site work, others help us improve, the user experience. By using the site, you consent to the placement of these cookies. Visit our Privacy Center to learn more.