Excel Functions
You are already familiar with Microsoft Excel software. You have learnt some interesting and useful things that can be done in MS-Excel. Microsoft Excel is an electronic spreadsheet software which allows you to enter, calculate, manipulate, organize and analyze data in the form of tabular form. Let us learn more about data tools provide in Microsoft Excel. * Data Tools * Text to Columns * Remove Duplicates * Data Validation * Consolidate
Data Tools
With the powerful data tools included within Microsoft Excel you have the ability to analyze large amounts of data that will influence decisions. Data Validation is a great way to limit what a user can enter into a worksheet cell. It may not stop a cell from being left empty, however. This tip explores why this is and how you can make sure that a cell contains a value. Microsoft Excel’s data consolidate capabilities allows you to summarize your data enhancing your ability to organize and structure your data. Remove Duplicates tool makes your data uniform by removing duplicate records.
Text To Column
If you copy data from another program and paste it into Microsoft Excel, Excel may summarize several columns of data to a single column. You can use the Text To Columns command on the Data menu to put each record in a separate column. The range that you convert may contain many rows, but you can only convert one column of data at a time.
Understanding with the help of example
To split a list of names into three columns, you don't have to do it manually.In this given worksheet, to split the students name into three columns the first name, middle name and the last name, follow the following steps:
1. Select the cells range B4:B7 where column B has full name of the students.
1
2. On the Data menu, click Text to Columns.
2
3. Of the Convert Text To Columns Wizard, make sure that the Delimited option is selected, and then click Next.
3
4. Of the Convert Text To
Data Tools
With the powerful data tools included within Microsoft Excel you have the ability to analyze large amounts of data that will influence decisions. Data Validation is a great way to limit what a user can enter into a worksheet cell. It may not stop a cell from being left empty, however. This tip explores why this is and how you can make sure that a cell contains a value. Microsoft Excel’s data consolidate capabilities allows you to summarize your data enhancing your ability to organize and structure your data. Remove Duplicates tool makes your data uniform by removing duplicate records.
Text To Column
If you copy data from another program and paste it into Microsoft Excel, Excel may summarize several columns of data to a single column. You can use the Text To Columns command on the Data menu to put each record in a separate column. The range that you convert may contain many rows, but you can only convert one column of data at a time.
Understanding with the help of example
To split a list of names into three columns, you don't have to do it manually.In this given worksheet, to split the students name into three columns the first name, middle name and the last name, follow the following steps:
1. Select the cells range B4:B7 where column B has full name of the students.
1
2. On the Data menu, click Text to Columns.
2
3. Of the Convert Text To Columns Wizard, make sure that the Delimited option is selected, and then click Next.
3
4. Of the Convert Text To