Excel Sensitivity Tools

We also have Free training videos on this site ( visit the Home page or the Training Page)

By making use of Excel sensitivity tools it is possible to assess what the consequences will be if values are changed in a model. In short the Excel sensitivity tools can be used to make projections based on possible changes to a scenario. For instance, how changes in the cost of production will affect the profit margin.

The Excel sensitivity tools allow you to make an analysis by making use of the Table commands in Data. Select Data then the table command and build a relevant table through the use of a multi-cell formula.

To understand how the features work and how to best use them, you can make use of our training options. We offer free training tips at our website through easy to follow tutorials and audio to help you follow instructions without getting lost in the process. In addition we also offer online courses, CD-Rom based courses and on-site training which can focus specifically on the above or can deal with a wide range of advanced functions in Excel.

Rather than making incorrect projections because you did not cater for possible changes which could affect the outcomes of a model, get the knowledge you need to ensure maximum usage of the functions available in the spreadsheet program to ensure accuracy. Make use of our free and or fee based courses to become an expert user. Our expert team comes from a financial and business background and as such understands the applications for which you may need the Excel sensitivity tools.