20 Most Recent Microsoft Excel for PC - Page 7 Questions & Answers


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

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

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/

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.

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


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.

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


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


www.tutorialized.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.

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

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

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


change the regional setting in control pannel for number format.
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

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

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

Not finding what you are looking for?
Microsoft Excel for PC Logo

670 questions posted

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

ThaMp3Doctor
ThaMp3Doctor

Level 3 Expert

8597 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

View Most Popular

Excel Microsoft

  • Excel Microsoft

Most Popular Question

excel 2007 document recovery repeating

  • Computers & Internet
Loading...