- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
A corrupt excel spreadsheet can be repaired by using Open and Repair technique. It is a built-in repair function that opens a corrupt excel file forcefully.
*OpenMS Excel >pressCtrl+O >locate corrupt excel spreadsheet and select it.
*Click on the arrow shown besideOpenbutton>selectOpen and Repair.
It will take just a few seconds to be completed and selected file will be opened, if possible.
Or if this doesn't work, one may take help of a third-party
Microsoft Excel is a commercial spreadsheet application . It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.
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.
You need to create subtotals so that it looks like something like this:
Prod/units Amt. Level Total
xxxx 10.00 1 yyyy 20.00 1 30.00
dddd 40.00 2 ffff 30.00 2 70.00
To do this I would suggest using the Pivot Table feature of Excel. It is not too hard to use but you do have to know what you want and also have to be sure you are getting results as expected. Like any tool, it has to be used right. You can also use sub-total functions supplied in VBA as well in your cells.
If you want to avoid using VBA functions in cell and deal with ranges, etc., use the Pivot Table Wizard.
Some reading: http://www.ehow.com/how_13020_pivot-table-wizard.html http://www.microsoft.com/dynamics/using/excel_pivot_tables_collins.mspx http://www.ozgrid.com/Excel/excel-pivot-tables.htm
Also Google "Excel pivot table wizard" to get more.
Microsoft Excel is an application used for building spreadsheets. It has many built in calculation and graphics tools. Some people use it to track expenses while other use it to graph numbers for charting process.
As far as data analyzing it all depends on the data. Whether is sales figures or budget information. It all can be done inside of excel using it built in formulas and functions.