[Anonymous]

Hi Everyone,

In the midst of constantly tapping F5 waiting for my REG score, I saw my an open excel spreadsheet and thought about all the wonderous things that program has done for me. Then I thought it might be fun to here how other young accountants are finding great new ways to use the program. What is your favorite formula? Do you use macros to write your own mini programs? Anything you would like to share about your experiences and uses of this program would be interesting to hear. I know I know….. It sounds lame, but then agains we are all beating our heads against a keyboard waiting for scores that will tell us whether or not we can be accountants yet. Haha. Let’s hear what you have to say about excel?

[Maasman]

lockhartm2, the problem your are describing is eliminated if you use names instead of cell ranges. Moreover you may use the match function to automatically determine the column number!

Re sumif Using Office 2007 you may use several conditions by choosing sumifs instead of sumif

CHeers

[Anonymous]

I have also found the Randbetween formula very useful in making truly random testing selections for audits.

[Author]

Replies