Filtering Chart data in Kannada with MS Excel

Introduction

When huge amounts of data are to be used in the Excel framework, it sometimes becomes essential to be able to filter the data and categorize it on the basis of a prerequisite choice. For example, in the list of names of a class, one may want to group together all students with an average of 90. This tutorial aims to explain the procedure of filtering data. The tutorial will walk you through the process of entering data in Kannada in Microsoft Excel, and then being able to filter the fields to view the data to your requirement.

Entering the data The first step here is to create an MS Excel Worksheet and enter some data into it. To create a new MS Excel Worksheet: Right click anywhere on the desktop From the New tab, choose the "Microsoft Excel Worksheet" option A new icon will be created on your desktop, with the name "New Microsoft Excel Worksheet". Double click this icon to open the Worksheet In order to create a free e-mail account with Microsoft Hotmail, go to www.hotmail.com. You should now see something like this: MS Excel stores data in blocks known as cells. Each cell has a name composed of a letter and a number. As you can see above, the first cell above has the name A1. The name of the cell can be seen in the Name Box on the top left corner. You can now enter data in Kannada, directly into this worksheet. You can start Kannada input using the Kannada IME. Please see the tutorial on how to use the Kannada IME. After activating the Kannada IME, enter the data in the cells as shown below: As you can see the cells A1-13 and B1-13 contain text and the cells C1-13 contain numerical data.

Filtering data Now that we have made an Excel Spreadsheet, let us see how the filtering of data is done. Highlight the entered data in the spreadsheet, by clicking on the first cell and dragging the mouse till all the entered data is covered. Left-Click on the “DATA" tab in the toolbar. Scroll down to "Filters" which opens up a submenu. Left-click on the tab that reads “AutoFilter”. You will now see a small check mark next to the AutoFilter tab. You should now see something like this on your screen: The excel spreadsheet will now look like this. The difference now from the original is the drop down arrows in all the selected cells of the first row 1. Clicking on the drop down arrows will open up a drop down box with all the values present in the corresponding column. Now to filter the required data, click in the drop down box, on the required field and only the data with the corresponding filtered entry will be shown. In this example 20,000 has been selected from the drop down box. Voila! You have now filtered the data to only those that have 20,000. Happy Computing!