Implementing the Datamining add-on

Parts of the Excel 2007 Screen

Active Cell In an Excel 2007 worksheet, the cell with the black outline. Data is always entered into the active cell.
Column Letter Columns run vertically on a worksheet and each one is identified by a letter in the column header.
Formula Bar Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.
Name Box Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.
Row Number Rows run horizontally in an Excel 2007 worksheet and are identified by a number in therow header.
Sheet Tab Switching between worksheets in an Excel 2007 file is done by clicking on the sheet tab at the bottom of the screen.
Quick Access Toolbar This customizable toolbar allows you to add frequently used commands. Click on the down arrow at the end of the toolbar to display the toolbar's options.
Office Button Clicking on the Office Button displays a drop down menu containing a number of options, such as open, save, and print. The options in the Office Button menu are very similar to those found under the File menu in previous versions of Excel.
Ribbon The Ribbon is the strip of buttons and icons located above the work area in Excel 2007. The Ribbon replaces the menus and toolbars found in earlier versions of Excel.
Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

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.

Hope that helps!

Rgds

David

If you search on google for "excel tutorial" there is lots of free help there.
http://www.google.co.uk/search?hl=en&q=excel+tutorial&meta=

hi friend see you cant view excel 2003 data in 2007 excel as it is latest version and you will need to install 2007 office in your computer.

Join a best classroom training institute for excel learning institute for basic or advanced level ! ! https://www.slaconsultantsindia.com/advanced-excel-vba-mis-practical-training-course.aspx

The best way is to contribute in Learning class outdoors, because beeing between other studens and masters could growth your knowledge well, you can ask your questions easily and get the answers clearly and useful.Also, other studens will ask other useful questions which help you to increase your knowledge,infact, people there, share their idea and it's good for you. ---- The other way is to use books, learning books about Excell,  and of course you should not stand just on one book, you have to study many books about it. ----- Other useful thing is to travel between websites about excell and forum.Websites are full about excell 2007, they are updating soon and you can get your answers through these websites, and you could learn many tricks and notes about excell 2007. -------- the other thing is Media files about excel, but i guess they aren't enough quality to teaching! -------- Don't forget the practise, and do some real projects to get enough exprienss.
I provide some usefull links about excel 2007 bellow. Check them, I hope they could help you.
www.baycongroup.com/el0.htm

www.gcflearnfree.org/computer/topic.aspx?id=143

www.computer-training-software.com/excel-2007.htm

www.topshareware.com/Quic-Excel-2007-tutorial-Packs-download-58139. htm

www.cbtplanet.com/microsoft-desktop-training/microsoft-excel-2007.ht

www.totaltraining.com/prod/microsoft/excel2007_ess.asp

www.netwind.com/html/microsoft-excel-2007-training.html

office.microsoft.com/exce

------ Good luck

Nowadays, with the development of the technology, you are able to remove excel password so as to access your files again safely and very easily with excel password reset programs. And Excel password recovery is a popular tool that can reset Excel password from Excel 97 to Excel 2007. Meanwhile, it can open your file again without any damage or data loss at all.
To recover your password, you can follow a step-by-step guide on how to recover Excel password for 2007 edition.
Step 1:Download Excel Password Recovery and install it.
Step 2:Click Open and select the file you need.
Step 3: Choose an attack type to recover Excel 2007 password.
Step 4: Attack settings.
Step 5: Click Start on the taskbar, and when the operation finished, you will recover the lost Excel 2007 password

Instead of me teaching u. i would suggest u learn it by following the simple steps.

1. Click Tools > Macros > record
2. do some common operation like copying data, creating graphs, etc.
3. press alt+F11 to go to vb editor, to see ur macro recorded
4. study it ... u will learn easily

or

try the book 'Microsoft Excel Visual Basic Macros Examples' at http://www.add-ins.com/vbexamplestopics.htm


bye

have a nice day

Select ASCII. Give output file name Eg:d:/exp Open the file using EXcel.Select Delimite  nexxt comma finish.Export is completed

Dear Madiha35,

 

I would recommend the use of the Table Function in Excel.

 

Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.

 

Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.

 

Excel 2007 had a budget format workbook

New workbook, Select Budgets in the last hand navigation, Select Personal Budget.

 

Step 1:  Enter your data into the worksheet.

 

Step 2:  Create Table

             Highlight the relevant data

             On the insert tab, click on Table

             

Step 3:  Verify Table range is correct, Click OK

 

Step 4:  Select the cell you where you wish to Sum Data.

         Click on Autosum.

 

Step 5:  To Insert new data

         Click on the sum row in the table, (Not the entire worksheet row)

         Right click, Insert, Insert Table rows from above

 

Step 6:  Enter new data in row

 

Step 7:  Data is automatically calculated in formula.