Question about Microsoft Excel for PC

Hello kwilshusen,
If you pull up excel and type in the format 8/12/2008 it will read mm/dd/yyyy, you should be able to right click and format cells to your liking.

I hope that was what you were looking for, if not post again and i'll try to help.

Thanks and i look forward to your post.

Posted on Nov 12, 2008

Excel 2007 has a rather elaborate formula pull down menu.it out,

Loringh

Posted on Nov 12, 2008

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:...

check this link it will help you to learn excel

http://people.usd.edu/~bwjames/tut/excel/

dont forget to rate ^^

http://people.usd.edu/~bwjames/tut/excel/

dont forget to rate ^^

Jun 08, 2010 | Microsoft Office Professional 2007 Full...

With data in A1 to C1:
A2 =IF(A1>0,1,0)
B2 =IF(B1>0,1,0)
C2 =IF(C1>0,1,0)
A3 =SUM(A2:C2)

Jun 04, 2009 | Microsoft Office Excel 2007

format the cells that contains times and net time worked as time format you using
Enter the simple formula =if(c14<=0,Int(0),(c14-c13))

Feb 04, 2009 | Microsoft Excel for PC

The formula in both versions is the same:

=countif(range,value)

i.e. The below formula will increase its count by one if any of the 18 cells it's checking are equal to 1.

=countif(A1:B9,1)

=countif(range,value)

i.e. The below formula will increase its count by one if any of the 18 cells it's checking are equal to 1.

=countif(A1:B9,1)

Jan 21, 2009 | Microsoft Office Excel 2003 for PC

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

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.")

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

Hi,

Just re-install the excel only using your ms office 2007. Once you put the installer on the drive it will give an option on what office you want to install, just select excel.

Thanks

Just re-install the excel only using your ms office 2007. Once you put the installer on the drive it will give an option on what office you want to install, just select excel.

Thanks

Nov 25, 2008 | Microsoft Office Professional 2007 Full...

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:...

The OS should not impact on the performance of Excel..

Have you upgraded excel from 2000 to 2007 ??

Power formulas are tricky to manage at the best of times.

The formulas that you have wrote for years may have been on the knife edge ... i.e. just less than 256 characters.

Have you exceeded this limit ??

Have you upgraded excel from 2000 to 2007 ??

Power formulas are tricky to manage at the best of times.

The formulas that you have wrote for years may have been on the knife edge ... i.e. just less than 256 characters.

Have you exceeded this limit ??

Aug 06, 2008 | Microsoft Excel for PC

That depends on which version of Excel you are using.

Excel 2003 supports up to 65,335 formulas

Excel 2007 has no limit.

you can communicate between the worksheets which are contained by one workbook (one excel-file).

Communicating between files cannot be done with formula's.

Excel 2003 supports up to 65,335 formulas

Excel 2007 has no limit.

you can communicate between the worksheets which are contained by one workbook (one excel-file).

Communicating between files cannot be done with formula's.

Apr 04, 2008 | Microsoft Excel for PC

Jan 28, 2016 | Microsoft Excel for PC

102 people viewed this question

Usually answered in minutes!

I am trying to get excel to recognize that a certain date range.. such as 12/29/08 - 1/4/09 would be equal to week 1 in the year. (and so on)

what specific formulas are you looking for?

×