# Wanted to learn "ALL" formulas of MS Office Excel - please guide

I am interested in learing as how to use the Formulas that are
predefined in MS office Excel. Please guide me. My knowledge
in maths is very poor. By learning these formulas i want to be a
better worker and more productive

Posted by on

• ansharmaaa Jan 14, 2009

Sir,

1)They are listed under the head of "Logic" and "Finance"

2) some are general maths such as sum of total to be

written in words eg. Rs.105 ( Rupees one hundred five only)

I was provided with 2007 MS office.

If one simple example for one formula would ease me to learn fast.

I shall be ever grateful and treat you as my guru

regards

ansharma

• anil_chintu1 Apr 26, 2009

Respected Sir! I am also having same kind of problem. So please solve it. And tellme some main formulas and macros in that software. Please sir.
Thanking You Sir,
Anil kIllamsetti, vizag

• Anonymous Apr 27, 2009

pmt

• shujat_hussa Nov 08, 2012

please visit to learn all excel functions and formulas All-in-One Excel Functions and Excel Formulashttp://atips4pc.blogspot.com

×

• Level 2:

An expert who has achieved level 2 by getting 100 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

• Expert

Hi ansharmaaa

Once you are in the Excel Worksheet,

• In maths you would type 24+6; 3*4 etc. In Excel you do almost the same. If you type 4 in a cell A1 and type 5 in cell B1, and type A1+B1 preceded by an = sign in C1 you will get the answer in C1. Use the same principle for multiplication, =a1*b1 for division =a1/b1
• From the Tool bar, click on the Autosum (written as SIGMA, you will see few most commonly used functions, click each one of them and see an example of how to use it.
• Press F1 for help. Type in the search box formulas and click on the search button. Select various formulas and you will get examples of how to use them.
luciana44

Posted on Oct 14, 2009

• Level 1:

An expert who has achieved level 1.

• Contributor

Ist I want to know what type of formulas u use in works

Posted on Jan 13, 2009

Hi,
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### What are the formulas in grading the grades uisng microsoft excel

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

1. All formulas begin with an equals sign (=).
2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
3. Other formulas refer to different functions such as SUM, AVERAGE and others.
For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
4. Formulas can be combined with operands.
For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
5. Functions can be nested within each other.
For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

### Ms-office

Subtraction can be done in two ways in Office using the following formulas in the formula (fx) bar:
1. =A1-A2
2. =SUM(A1,-A2)
The above formulas refer to cell reference A2 subtracted from A1. As usual, you can use number values instead of cell references.

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

Jul 08, 2009 | Microsoft Office Excel 2003 for PC

### Excel

Step1. Start Microsoft Excel and open the file you want to change. Step2. Double-click on the cell where you want the total to appear. Step3. Press the = key on the keyboard. This tells Excel that you are entering a formula into the cell. Step4. Enter the formula, then press Enter. Follow the steps below for an example. Step5. Enter an opening parenthesis character: (. Step6. Enter a cell name. For example: =(E2. Step7. Press the + key. Step8. Enter another cell name and a closing parenthesis character: ). For example: =(E2+E3). Step9. Enter a minus sign and a third cell name. For example: =(E2+E3)-E4. Step10. Press the Enter key to accept the formula. The cell will display the sum of the first two cells minus the third cell. \$('.Article .Steps .Image').each(function(i,e){ e = \$(e); e.find('img').error(function(){ \$(this).unbind(); e.remove(); }); });
Tips & Warnings
• Formulas are just equations. Instead of adding or subtracting numbers you are adding and subtracting the contents of a cell.
• Excel includes a number of predefined functions to use as well. You can combine the predefined functions into your own formula. (See "How to Use Provided Excel Formulas.")
I hope it helps!!!

Dec 03, 2008 | Microsoft Office Professional 2007 Full...

### Print source code of an Access Database

Hello cbw@netzero.com,

The source code request would be for a program code, appropriate if you actually wrote the code for the Excel program, but if you are copywriting a set of formulas or an excel execution sequence, then you want to print your formula view for copywriting.Excel has a Formula View that shows the formulas on your worksheet rather than the results of those formulas. You toggle between Formula View and Normal View by pressing CTRL ~ on your keyboard. Just toggle to formula view and print your worksheet to see all of your formulas.

Oct 06, 2008 | Microsoft Office Professional 2007 Full...

### I need Excel's Furmula's

I found some excellent links to excel formulas for you:

This link lists excel formulas by category:

http://www.techonthenet.com/excel/formulas/

http://www.ozgrid.com/VBA/Functions.htm

Sep 20, 2008 | Microsoft Computers & Internet

### Formula for calculating the days beween months

for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

### Formmulas are not appling in the excel of office xp

Dear chidambar, thats usually because you've mistakenly tampered with a file or because you're putting an inapplicable value. Can you tell me what error is it exactly ?

you might like to re-install your MS excel after backing up your files. You might also like to repaire your ms office from your cd.

if that has helped you plz press fixya.

Dec 13, 2007 | Computers & Internet

### Ms excel

Try clicking the down arrow beside the autosum button in your Excel Standard toolbar. Then click More FUNCTIONS. An Insert Function dialog box appears. There use can explore all MS Excel functions.

Oct 10, 2007 | Microsoft Office Standard for PC

## Open Questions:

#### Related Topics:

239 people viewed this question

Level 3 Expert

Level 3 Expert