Apr 2018

2017

Calculating a discount factor using Excel

Excel has a built in function to perform to the power of (see prior post), which can used to calculate discount factors:

Power function - Excel

Excel has a built in function to perform to the power of:

= POWER ( # number , # power)

For example, 5 to the power of 10 would be:

= POWER ( 5 , 10 )

This can be abbreviated using the following symbol  ^

For example, 5 to the power of 10 would be:

= 5 ^ 10   

Add a number of working days to a date - workdays formula - Excel

You can calculate a date in excel relative to a starting date +/- a number of working days

= workdays ( Date , +/- number of working days )

Example table



Add a number days to a date - Excel

Alternatively if you need to determine the figure based on all days (not working days) you can simply +/- a number of days from a starting date

= Date  +/- number of working days

Discriptive Statistic, Data Analysis Tool - Excel

Excel has an in built discriptive statistics tool providing the following information on a data set:

To run this analysis choose   Data Analysis  ¬  Descriptive Statics  ¬  then set the parameter (example below)

Make a worksheet very hidden - Excel

Excel has a function called "Very Hidden", this hides the worksheet to a greater degree than the stadard hide fiunction.

To make a worksheet very hidden right click on the worksheet and select view code