Suggestions for Improvements to Excel

I use Excel for technical stuff.

  1. First, could you PLEASE make it so that if I type

A1 = avg(range); Excel knows what I mean? You don't make me type out "StandardDeviation", Excel knows what "stdev(range)" means, please let us use "avg" as an abbreviation for "average"!

  2. Suppose I have a discontinuous range of cells that I want to average, e.g.

cell A1=average(B1,C1,D1)

If I want the standard deviation as far as I know I have to either retype the range OR select and copy the range from A1 and then paste it in to my formula. Both these option are a pain.

Make Excel smart! If 

A1=average(range)

then if I type

A2=stdev(A1)

Excel should pop up a dialog box that says "Did you want me to use the range that was used in A1?" Then I can answer YES or NO. This could be generalized to any function that wants a range - if a single cell is entered as the range Excel asks if I want to use the range that is in that single cell. Simple but effective!

Bob



June 25th, 2015 1:10pm

Re:  more stuff




'---
Jim Cone
Portland, Oregon USA
free & commercial excel programs  (n/a xl2013)
http://jmp.sh/K95N3ee

Free Windows Admin Tool Kit Click here and download it now
June 25th, 2015 2:03pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics