how can i be the master In MS Excel?
455573
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
406314
If you know Java, it is not hard to write code to do such task, it might be tedious though.\nIf you don't, Ms excel could handle the job too with reasonable time and effort.
242526
I don't have a real answer for you.\n\nBut you can either use formulas in each cell, or apply Visual Basic Macros. I have done a lot of VBA, but only with Word. VBA is pretty easy - except you need to know the names of the various objects. But sample macros are floating around and Microsoft is fairly good about having details on this sort of thing.\n\nIn fact, now that I think of it, you might be better off writing the whole thing in Visual Basic and skip Excel. (Which, of course, does you no good if you don't have VB.)
421773
MS access will do that, \n\nlookfor help in excel for JET or OBDC
778758
.\nI understand.  Am in the same boat...just getting back to work after many years.\n\n1.  Open Excel\n2.  Enter data in cells\n3.  You must highlight all cells you want totaled.\n4.  To highlight click the first cell you want added > then hold down keyboard SHIFT key >\nthen click below last cell, in an empty cell where total will appear.\nYou may total several columns at the same time.\nTo total a row, drag across the row.\nIn above tool bar click the "sum" button\n(it looks Greek like a backwards E\n\n5.  To see the formula Click in cell where the answer appears and look above  \n\n6.  You will see the "sum formula" in the long white  text box for "Insert Function"\nIn that text box you can type in and can change your formula for the area you want it to cover by changing the formula to\none column \n[example]         =SUM(A1:G1)\none row\n[example]         =SUM(A1:A8)\nseveral columns\n[example]          =SUM(A1:G8)  \nThe first number is the first column/cell\nthen a colon\nthen the last number is the last column/cell\n\nNow for other help remember the Office Assistant is totally cool.  It even helped me at exam time, hee hee.  Click on the question mark on the above tool bar, and when the "assistant" appears type in your question.\n\nGlad to help\nstw\n.
937773
Yes you can study the core ones first and then do the Specialist Course and individual Office Applications. I have just done Microsoft Word Expert. There are many sites offering courses on this www.microsoft.com/Learning. Good luck on your search on this. ☺
402788
I imagine there are places to do it, however they are all illegal, as Excel is a licensed software product made by Microsoft.  If you are a college student, they offer a special version at around $20 on campuses...
837908
click here:http://en.wikipedia.org/wiki/Microsoft_Excel
1005550
Use excel, somewhat easy and really organized
1089446
You can use a spreadsheet. Then resort.\n\nAnother way is to put things in a regular word processing document and cut and paste into another one. \n\nDepends on what you prefer to do.
419806
Take a look at this web site :\n\nhttp://www.fgcu.edu/support/office2000/a...\n\nThis should give you the start you need. Also the programming language of all office products is Visual Basic. If you want to write your own macros then you will have to learn this programming language first. \n\nMoreover, to get even better at MS Access read its help files. They give tons of information about forms, buttons etc. Also when using the help file use the contents tab which group all the topics very nicely and will allow you understand each aspect of MS Access\n\nHope this helps
868183
You don't need an expert to do this for you as someone has said. You do however need to steer away from Excel and start using a database. MySQL and PHP is probably the most user-friendly way of getting this done, but it will still require you to know a little of coding with MySQL and PHP...\n\nRawlyn.
862897
Go for MS-Excel or MS-Access.
872396
OK Maureen here are a couple of sites to get you started.\n\nhttp://netforbeginners.about.com/od/learnmsword/\nhttp://www.learnthat.com/computers/learn-420-free_microsoft_excel_tutorial.htm\n\nIf you have any questions you can email me jybevan@yahoo.com.au
250101
Plenty.  Look at:\n\nhttp://www.thekjs.essex.sch.uk/yates/excel_links.htm\n\nfor free tutorials on the Internet.\n\nIf you want a good course in the UK, I would recommend ECDL Advanced on Spreadsheets (www.ecdl.co.uk).
741069
you may want to try Microsoft ActiveX Data Objects 2.8 Library and the ADO 2.8 objects (very useful when it comes to connecting word to a database ie SQL) and Microsoft Excel Objects Library when you want to control Excel from Word.\n\nTo do so you need to reference it : from the visual basic editor (ALT+F11) click Tools and Reference and scroll down till you can find "Microsoft ActiveX Data " and tick it. Do the same for excel library.
348716
Can't do that in Excel. The best thing you can do is type your headings in row 1 in each column.