Excel Video 331 Introducing Goal Seek from pivot table what if analysis is greyed out Watch Video
Preview(s):
Gallery
Play Video: (Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
Description: Now that you’re a Pivot Table Master, Excel Video 331 introduces an Excel feature I’ve been waiting to show you, What-If tools.Excel is great tool for data analysis and there are several Excel tools to make that analysis even more powerful.We’ll start with Goal Seek, a way to get Excel to set the result of a formula to be a certain value by changing the value in another cell.In today’s example, we’re purchasing a piece of equipment.If the equipment costs $58,000 and the average
Play Video: (Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)