You can never crack Office 2007. Sorry.

Microsoft Excel... | Answered on Nov 08, 2012

hiiiiiii

u know vlookup function,then piviot table

u know na tell short formula

genious...

u know vlookup function,then piviot table

u know na tell short formula

genious...

Microsoft Excel... | Answered on Nov 08, 2012

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 ??

Microsoft Excel... | Answered on Nov 08, 2012

In order to use Microsoft Excel you have to buy a license. You can always download a limited time trial. Trial programs contain the same functionality that you get when you buy the perpetual versions.

If you don’t want to pay for a license, you can use OpenOffice, the leading open-source office software suite for word processing, spreadsheets, presentations, graphics, databases and more. It is available in many languages and works on all common computers.

Great software, same functionalities as Microsoft Excel, easy to use, and it’s free:

http://www.openoffice.org/

If you don’t want to pay for a license, you can use OpenOffice, the leading open-source office software suite for word processing, spreadsheets, presentations, graphics, databases and more. It is available in many languages and works on all common computers.

Great software, same functionalities as Microsoft Excel, easy to use, and it’s free:

http://www.openoffice.org/

Microsoft Excel... | Answered on Nov 08, 2012

In Excel 03, I went to Help, typed in "column" and they had a "add or delete columns" topic. Did seem to answer your question. Very modestly submitted. I ain't no expert, just nosy.

Microsoft Excel... | Answered on Oct 24, 2012

Use the **test** function.

Formula in cell A1 would be**=text(a2,"dddd").**

This would pick up the date from cell A2 and return the day of the week in cell A1.

Formula in cell A1 would be

This would pick up the date from cell A2 and return the day of the week in cell A1.

Microsoft Excel... | Answered on Oct 23, 2012

My suggestion is to use a Pivot Table. Follow these instructions:

Click on column A1 - then in the menu bar click DATA > Pivot Table and Pivot Chart Report.

Click NEXT on step 1 of pivot table wizard.

For step two you will want to highlight all of the data on your sheet. then click next.

Choose NEW WORKSHEET for step 3 of the pivot table wizard and click finish.

Once the Pivot Table sheet opens, drag the STATUS field into the top left corner of the pivot table view, where "drop column fields" and "drop row fields" meet. Next drop another instance of the STATUS field into the "drop row fields here" column. And lastly drop the OWNER field into the "drop column fields here" section. You should now be viewing a report showing you exactly what you were looking for.

Regards,

Joe

Click on column A1 - then in the menu bar click DATA > Pivot Table and Pivot Chart Report.

Click NEXT on step 1 of pivot table wizard.

For step two you will want to highlight all of the data on your sheet. then click next.

Choose NEW WORKSHEET for step 3 of the pivot table wizard and click finish.

Once the Pivot Table sheet opens, drag the STATUS field into the top left corner of the pivot table view, where "drop column fields" and "drop row fields" meet. Next drop another instance of the STATUS field into the "drop row fields here" column. And lastly drop the OWNER field into the "drop column fields here" section. You should now be viewing a report showing you exactly what you were looking for.

Regards,

Joe

Microsoft Excel... | Answered on Oct 23, 2012

The formula for A1 is: =SUM(B4,B5)

A2 is: =SUM(C4,C5)

A3 is: =SUM(A1:A2)

To test this, put 25 in cell B4, 25 in cell B5, then 30 in cell C4, and 30 in cell C5.....the result in cell A3 is 110.

Hope this helps.

A2 is: =SUM(C4,C5)

A3 is: =SUM(A1:A2)

To test this, put 25 in cell B4, 25 in cell B5, then 30 in cell C4, and 30 in cell C5.....the result in cell A3 is 110.

Hope this helps.

Microsoft Excel... | Answered on Oct 22, 2012

Hi! It probably was created in Excel 2007. You need a converter to open the file.

Microsoft Excel... | Answered on Oct 19, 2012

Hi Sahil,

This can be difficult to resolve on the first pass because there is so many things to consider. I have no idea what your experience with excel or computer maintenance is. All my training in industry has told me is go for the "low hanging fruit" first (try the easiest stuff first).

1) When did you last defrag your computer. That can be a fast easy fix. I don't know what your operating system is but you may have a defrag program included as part of the system.

2) How much memory do you have installed and if you have added some did it match what you had installed because memory will run as fast as the slowest stick installed.

3) Any other programs running in the background? My antivirous program is scheduled to scann at specific times when I would normally not be trying to be productive with my favorite programs. I have all the memory installed that I can and if my antivirous program is running and I try to do something else my system tempts me to persue fishing instead of computing just so I could use my machine as a anchor.

4) Do you have an infection of malware to contend with? When has the last time been that you scanned your system for system leaches.

5) was there a specific time that the software slowed down and if so what was done to the system at that time. Can it be undone?

6) Are you the only person on the machine?

7) Just how slow is slow? My machine takes 2 sec to load excel - 5 sec to load a spread sheet that I have been collecting data on stocks for 3 years but is a rocket processing the data and developing the individual graphs that is responding to the macros commands.

So is your expectations of the program realistic?

Investigate your issue and try to reason out what could be going on. Collect more data about your system so I can better guess from wayover here.

Normal 0 false false false MicrosoftInternetExplorer4 /* 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;}

Evenif this is not what you wanted to hear please don't forget to rate the answer. I can always learn from your opinion of the service provided.

Thanks

Glad to be of assistance

This can be difficult to resolve on the first pass because there is so many things to consider. I have no idea what your experience with excel or computer maintenance is. All my training in industry has told me is go for the "low hanging fruit" first (try the easiest stuff first).

1) When did you last defrag your computer. That can be a fast easy fix. I don't know what your operating system is but you may have a defrag program included as part of the system.

2) How much memory do you have installed and if you have added some did it match what you had installed because memory will run as fast as the slowest stick installed.

3) Any other programs running in the background? My antivirous program is scheduled to scann at specific times when I would normally not be trying to be productive with my favorite programs. I have all the memory installed that I can and if my antivirous program is running and I try to do something else my system tempts me to persue fishing instead of computing just so I could use my machine as a anchor.

4) Do you have an infection of malware to contend with? When has the last time been that you scanned your system for system leaches.

5) was there a specific time that the software slowed down and if so what was done to the system at that time. Can it be undone?

6) Are you the only person on the machine?

7) Just how slow is slow? My machine takes 2 sec to load excel - 5 sec to load a spread sheet that I have been collecting data on stocks for 3 years but is a rocket processing the data and developing the individual graphs that is responding to the macros commands.

So is your expectations of the program realistic?

Investigate your issue and try to reason out what could be going on. Collect more data about your system so I can better guess from wayover here.

Normal 0 false false false MicrosoftInternetExplorer4 /* 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;}

Evenif this is not what you wanted to hear please don't forget to rate the answer. I can always learn from your opinion of the service provided.

Thanks

Glad to be of assistance

Microsoft Excel... | Answered on Oct 19, 2012

www.**tutorial**ized.com/**tutorials**/MS-**Excel**/**Functions**/1 - 92k - 6 hours ago

Microsoft Excel... | Answered on Oct 19, 2012

Creating Macros does not require programming. The only suggestion I would make if you are new to macros - break down your task to very small sub tasks, in order to avoid confusion.

Microsoft Excel... | Answered on Oct 19, 2012

Open up your Excel and hit ALT + F11. This opens up the VBA editor.

You can then right click and click New Module and write your macro in there.

You can then right click and click New Module and write your macro in there.

Microsoft Excel... | Answered on Oct 19, 2012

if the gram is in cell A1 then

=A1/1000

will give you how many kilograms A1 is

=A1/1000

will give you how many kilograms A1 is

Microsoft Excel... | Answered on Oct 19, 2012

Try using conditional formatting

Microsoft Excel... | Answered on Oct 19, 2012

The inverse tan, or arctan in excel is

=ATAN(A1)

Change A1 to number or cell you want the inverse tan of

=ATAN(A1)

Change A1 to number or cell you want the inverse tan of

Microsoft Excel... | Answered on Oct 19, 2012

change the regional setting in control pannel for number format.

Please rate this post if found useful

Please rate this post if found useful

Microsoft Excel... | Answered on Oct 19, 2012

Right click on the cells that you want to change and click "Format Cells".

Then in the Number tab, click "General" in the left hand pane. Click ok

Then in the Number tab, click "General" in the left hand pane. Click ok

Microsoft Excel... | Answered on Oct 19, 2012

This can be found using the Pythagorean Theorem:a^2 + b^2 = c^2Where a and b are the 2 legs and c is the hypotenuse.Plug the values of a and be to get:(5.45)^2 + (3.18)^2 = c^239.8149 = c^2sqrt(39.8149) = sqrt(c^2)6.309905 = c

In Excel, if the two sides of the triangle were in cells A1 and B1, then you could place the formula:

=SQRT(A1^2 +B1 ^2)

In any cell

In Excel, if the two sides of the triangle were in cells A1 and B1, then you could place the formula:

=SQRT(A1^2 +B1 ^2)

In any cell

Microsoft Excel... | Answered on Oct 19, 2012

if you could use this:

=IF($C$4=0,0,$C$4*0.000927+1.3*4*$D$2)

=IF($C$4=0,0,$C$4*0.000927+1.3*4*$D$2)

Microsoft Excel... | Answered on Oct 19, 2012

670 questions posted

Usually answered in minutes!

41 Questions

-5 Questions

11 Questions

2 Questions