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 Best Practices for Preventing Business Valuation, Forensic, and Litigation Support Claims
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…
Thumbnail for Forensic Practitioners in Arbitration:  Witnesses, Consultants and Neutrals
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…
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…
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…

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.