Question about Microsoft Excel for PC

Hi

I created a recording of my desktop to show you how to use the function option. Feel free to post another question if you need more details or add a comment to this thread.

http://www.utipu.com/app/tip/id/2064

Posted on May 02, 2008

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.

- All formulas begin with an equals sign
**(=)**. - 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. - 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. - 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. - 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

Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...

you can used the "input box" function to bring up a popup box that asks for an input.

Code is something along lines of (from memory - so you might want to check the help file)

a = inputbox("Title", optional bits like default and message)

a is returned as the value input

(sorry i can't be more specific and give exact code - don't have excel on this computer, else I could copy in examples).

There are also function which will pause the macro and allow other activities to occur - these generally pause for set time, to use these you would have to have a loop that had a pause and then checked to see if the input had been entered to decide whether to re-loop or whether to continue with the input value

Code is something along lines of (from memory - so you might want to check the help file)

a = inputbox("Title", optional bits like default and message)

a is returned as the value input

(sorry i can't be more specific and give exact code - don't have excel on this computer, else I could copy in examples).

There are also function which will pause the macro and allow other activities to occur - these generally pause for set time, to use these you would have to have a loop that had a pause and then checked to see if the input had been entered to decide whether to re-loop or whether to continue with the input value

Nov 11, 2009 | Microsoft Excel 2007 for PC

You will never find a fully comprehensive list anywhere because there are literally hundreds in the basic Excel application and thousands that can be added in as you go via macros. More are being added every time a new version of Office comes out.

But, the easiest way however to get a basic list of functions if your not printing is to hit the function button and simply scroll down the list. The syntax (an example of the method by which you should be formatting the formula) and a definition will list in the bottom of the dialog as you select each function.

That said, you are better solving individual problems as you learn Excel then trying to memorize all the functions themselves. Many, such as mathematical operations are common sense anyway.

But, the easiest way however to get a basic list of functions if your not printing is to hit the function button and simply scroll down the list. The syntax (an example of the method by which you should be formatting the formula) and a definition will list in the bottom of the dialog as you select each function.

That said, you are better solving individual problems as you learn Excel then trying to memorize all the functions themselves. Many, such as mathematical operations are common sense anyway.

Jun 19, 2009 | Microsoft Business & Productivity Software

www.google.com

Jan 14, 2009 | Microsoft Office Excel 2003 for PC

1024x768
Normal
0
false
false
false
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
These are Excel functions for Lookup tables. The purpose of
Lookup tables is to bring a value to the table, find the closest (or exact)
match, and then return another value.

An example is the federal income tax table. On your tax return you get your gross income and number of dependents, go to the Lookup table, and find your taxable income.

The V in VLOOKUP means that the table is vertical; HLOOKUP has a horizontal orientation.

If you use the Insert Function button in Excel and paste either function, the dialog box will explain each required field separately with examples.

An example is the federal income tax table. On your tax return you get your gross income and number of dependents, go to the Lookup table, and find your taxable income.

The V in VLOOKUP means that the table is vertical; HLOOKUP has a horizontal orientation.

If you use the Insert Function button in Excel and paste either function, the dialog box will explain each required field separately with examples.

Dec 02, 2008 | Microsoft Excel for PC

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)

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

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

Hi Chiquitta

Please click on below link you download training modules from this page.

http://Click on this link

Note- These downloads teaches about few topics of excel.

My suggestion for you to learn excel effectively would be buy a book called**BIBLE OF EXCEL, **even i wanted to learn excel completely and i bought this book , it teaches everything from basic to advanced in a user friendly manner, book is considerably cheap& effective compared to any E-modules available on net. Use can use net to find out problem for any specific issues but not to learn complete excel and master it.

Dont hesitate to get in touch with me if you need more help.

Hope this post was useful for you, kindly let me know by providing your valuable rating.

Thanks,

Robosoft.

Please click on below link you download training modules from this page.

http://Click on this link

Note- These downloads teaches about few topics of excel.

My suggestion for you to learn excel effectively would be buy a book called

Dont hesitate to get in touch with me if you need more help.

Hope this post was useful for you, kindly let me know by providing your valuable rating.

Thanks,

Robosoft.

Jan 06, 2008 | Microsoft Excel for PC

Their is not enough room to post all the functions of excel. Is their something specific you need to accomplish?

Oct 10, 2007 | Microsoft Office Standard for PC

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

Jan 28, 2016 | Microsoft Excel for PC

40 people viewed this question

Usually answered in minutes!

×