Software

Ask something
Discussion Locked

Excel formulas and functions

0 helpful
9 replies

by overload

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm looking for a cheat sheet or a software program that will quickly formulate the sums, averages,IFs,etc... when I have all the data on the same page. I keep wasting time getting it right. Any ideas?

9 replies

by dklippert

Have you tried the Paste Function? It's the Fx button on the toolbar. It will walk you through the process.

by overload

The paste function is great, it's the order of operations (syntax)I always get mixed up. This is why I'd like to highlight all the items with column name and just press enter. KInda like a lookup, only less thinking. It's in our nature to be a little lazy. Thank you, can you think of anything else? Thanks overload

by c_m_s

Hi there,
Not totally sure what you are looking for but it sounds like a template might solve your problem.
First, create your worksheet with all the formulae, etc. that you want on it. Do not fill in the data, just the formulae.
Format itso it looks the way you would like.
Finally save it is a template. Do a "Save As" as you normally would and on the "Save as Type" drop down list select "Template (*.xlt)". give it a meaningful name, and save.
Once saved this way all you have to do is open Excel, select File/New, open your template, and enter the data. Since the formulae are already in place calculation will be virtually automatic. Because it is a template Excel will not let you save on top of the original unless you specifically instruct it to do so, so you can't accidently step on it.

Good Luck,
Mike

by overload

Mike thanks,let me see if I understand. Creating a template will let excel accept it. But I must first compile the exact formulas? As above my trouble is with the order of operations, the syntax. Please any ideas? overload

by dklippert

The Paste Function "Wizard" does just what you're looking for. For instance if you choose Average, it allows you to select the range of cells and constructs the formula. I suggest that you play with it and maybe look up Formula Palette in the Help file.

by estebandelatorre

HI OVERLOAD!
DON'T BE OVERLOADED BY EXCEL FORMULAS. TAKE TEN MINUTES WITH THE ONE WHO KNOWS BASIC EXCEL MANAGEMENT, AND YOU WILL SEE HOW EASY IS TO MAKE FORMULAS AND FUNCTIONS BY SIMPLE PAINTING A RANGE AND CLICKING AN ICON.

This discussion is closed to new replies.