Goal Seek in Microsoft Excel. Goal Seek, data analysis




About this tutorial:

Video duration: 00:06:46
This video explains how to use Goal Seek in Microsoft Excel. Goal Seek. The tutorial explains how to use Goal Seek to work out loan repayments and how to use Goal Seek to work out potential profit. The tutor uses the PMT and NPER functions to demonstrate how to use Goal Seek to change repayments elements on loans. The tutor goes on to use a cafe and fish and chip shop example to demonstrate how to use Goal Seek to predict sales or profit. The video covers how to use Goal seek on the PMT function and how to use Gaol Seek on the NPER function. Goal Seek is part of the Data analysis feature…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads