Sunday, 14 October 2012

Calculate Smallest Number(s) - Excel

Type =SMALL(range,#)

# = #th smallest number in the range. E.G. to determine the 3rd smallest number enter 3:

Type =SMALL(range,3)
  
Calculate Minimum Number - Excel

Type =MIN(range)

To calculate the minimum number from a range.

Wednesday, 3 October 2012


Charts - Stock - Excel





 Insert – Charts – Other Options - Stock


   

Example Stock Chart





Example Stock Chart Data Source



Monday, 1 October 2012

Charts - Doughnut - Excel





 Insert – Charts – Other Options - Doughnut



Example Doughnut Chart



Example Doughnut Chart Source Data