I want to know Advanced feature of ms-excel
205459
Use the 'Help' menu of MSExcel. There is no other resource material better than the help menu of any application, especially when it is a MS application.\nAlong with it follow the article from the site www.mrexcel.com
657274
Insider Volume 1: Issue 3  June 28, 2006  \n \n\n \nAnalyze data quickly with new charting tools. \n\n\n      \nIt can be challenging to sift through all of the facts and figures that cross your desk. But Microsoft® Office Excel® 2007 makes it easier for you to find, analyze, and share information--and make informed business decisions.\n\nExcel 2007 has powerful new visualization tools, such as data bars, three-color gradients, and key performance indicator icons. You can present the results of your analysis in professional-looking charts, spreadsheets, and PivotTable® views. Plus, you can link directly to corporate data sources to automatically update information as it changes.\n\nWith Excel 2007, you get a host of new innovations to help you get more done. You can:\n• Work with much bigger spreadsheets that can accommodate up to 1 million rows and 16,000 columns, so you can import, organize, and explore massive amounts of data. \n• Build well designed charts faster with visual enhancements such as 3-D, soft shadowing, and transparency. \n• Share spreadsheets more securely with Excel Services, which dynamically renders a spreadsheet as HTML so others can access it with any Web browser.  \n\nView an Excel 2007 demo. \nCheck out a demo that shows you all the cool features of Excel 2007.
619792
Microsoft word processing software used in the creation of text documents.\nThrough Excel, we can \nCreate a new workbook. \nEnter text and numbers. \nEdit text and numbers. \nInsert and delete columns and rows
276192
Here you go:\n\nhttp://www.usd.edu/trio/tut/excel/index.html
529893
That is a good question needs a GOOD answer.\nYou have some tools in Excel to do this.\nTry:\n1- View > Toolbars > Forms\nand draw the object you want (Use Checkbox and OptionBox will help you alot)\nRight click on each of these boxes and go to Properties > Control where you can select the way this control controls the action.\nYou can alos use ListBox or ComboBoxes.\n2- You may need some VBA macros to complete the job\n\nI can do alot of these for you, need you to send me more info here in Y! Answers and I can promise I will help\n\nEnjoy my profile, I am the VBAXLMan
602113
http://mrexcel.com/\n yep this the one only guy who knows how to make excel do anything he wants and you've dreamed of, as seen on G4/tech tv. he gves free info on site and free weekly email with tons of info. or go buy his many books they are easy to follow and wow never knew excel could do that will be said many times...
226853
sure u have \nand try crystal reports\n\ni dont have to tell u the steps .. cause i dont remember really .. but try with msdn
622160
search for it from the microsoft site .. its visualbasic 6 runtime files
465866
The best alternative to MS Office, OpenOffice.Org http://www.openoffice.org/\n\nAlternative to MS Excel \nGnumeric http://www.gnome.org/projects/gnumeric/\nKSpread http://www.koffice.org/kspread/\nScheme In A Grid http://siag.nu/siag/
257563
There are a lot of software libraries that do that:\n\nhttp://tinyurl.com/k9zah\n\nincluding some for Excel:\n\nhttp://tinyurl.com/hrda7
457924
MS Excel has tons of great formulas.  Have you thought about using that.  Also, not sure what sort of database application you're using but formulas can usually be programmed into them.
462540
********************************************\n\nI have Office 2000, so these instructions may or may not be the same for your version.\nThe easiest way for me is to first know how many rows and columns I need. Then I right click and hold the button down while moving the mouse over the rows and columns I want included in the table. For example: If i want a table that is 4 columns wide, I would select A through D. Then, while still holding the right click down, I select the rows that I want. If I want 10 rows down, I select 1 through 10. After they are all selected in blue, I release the right button on the mouse. The rows and columns selected should remain highlighted.\n\nNext at the top of the page there should be a grid of squares button to select. If there isn't, you can find the little arrows button to find more buttons. It will be in there. Click it or the little arrow pointing down beside it for more selections. This will give you a grid and different types of line thicknesses.\n\nIf you can't find it this way, then after highlighting the areas you want included, right click again in the middle of a highlighted square and another window will open. Click 'Format Cells' in the box that opens. Next click the 'Border' tab. Then choose the formatting you want. You can do this more than once to get more than one effect on your table.\n\nIf none of this is what you want to do, then go to Microsoft Templates at this link: http://office.microsoft.com/en-us/templates/default.aspx\nThere are as many templates there as there are hours that you have to look through them. You can do a search for the specific type of table you want. After you download the template (these are small files) you can customize it how you want it after you open it.\n\nHope this helps. Good luck.\n\n****************************************************
562908
use the Macro Recorder to code the procedure you want...then you can convert it to VBA (Visual BASIC for Applications) and edit it.
203373
Read about them in the Help files. Find out how to record a macro. Start recording. Do a few simple things. Type words in a cell. Bold something. Insert a row, etc. Stop recording. Open up the macro and read what was recorded.\n\nNote: In the macro window, the Help file is completely different that the normal Excel help. The Macro help will give you much more macro oriented information.
340180
Go to Tools>Options. Under save, check compatability options for Excel 2000
150036
Can't do that in Excel. The best thing you can do is type your headings in row 1 in each column.
194365
In MS Excel, go to the cell where you want your answer displayed.\n\nPress =\n\nYou then enter your formula, clicking different cells on different sheets as required.  eg go to sheet1 and select a cell with the mouse.  You'll see sheet1!A4\n\nthen key the rest of your formula.  example:\n\nsheet1!A4+sheet2!B7+sheet3!G1\n\nIf your sheets are named differently, replace sheet1 wit the name of your sheet.