General discussion

Locked

Excel formulas and functions

By overload ·
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?

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel formulas and functions

by DKlippert In reply to Excel formulas and functi ...

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

Collapse -

Excel formulas and functions

by overload In reply to Excel formulas and functi ...

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

Collapse -

Excel formulas and functions

by C_M_S In reply to Excel formulas and functi ...

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

Collapse -

Excel formulas and functions

by overload In reply to Excel formulas and functi ...

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

Collapse -

Excel formulas and functions

by DKlippert In reply to Excel formulas and functi ...

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.

Collapse -

Excel formulas and functions

by overload In reply to Excel formulas and functi ...

The question was auto-closed by TechRepublic

Collapse -

Excel formulas and functions

by estebandelatorre In reply to Excel formulas and functi ...

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.

Collapse -

Excel formulas and functions

by overload In reply to Excel formulas and functi ...

The question was auto-closed by TechRepublic

Collapse -

Excel formulas and functions

by overload In reply to Excel formulas and functi ...

This question was auto closed due to inactivity

Back to Software Forum
9 total posts (Page 1 of 1)  

Related Forums