Sort & Filter: When you get handed an Excel spreadsheet with thousands of rows inside of it, and you realize the data is all out of order. You might need to sort it based on the names inside of a column, or by sorting data from large to small. On the surface, sorting data is a simple task in Excel, and the app certainly makes simple sorting easy. However, there's much more power in how you can sort and reorder the data in your worksheets. In addition to sorting, you may find that adding a filter allows you to better analyze your data. When data is filtered, only rows that meet the filter criteria will display, and other rows will be hidden. With data filtered, you can then copy, format, print, etc., your data, without having to sort or move it first. To use the filter: Click Home Ribbon => Click the arrow below the Sort & Filtering icon in the Editing Group => Choose Filter. You will notice that all of your column headings now have an arrow next to the heading name. Click on the arrow next to the heading by which you want to filter, and you will see a list of all the unique values in that column. Check the box next to the criteria you wish to match and click OK. Click on the arrow next to another heading to further filter the data. So you can continue as same for all other columns which you have in data worksheet. To clear the filter: Click on Filter icon next to the heading => Choose Clear Filter From “Name of Heading”. Let me give an example bit more about sorting with question and answer. How to sort the values to descending order in the selected cells? Select the cells that you want to sort them in order to your criteria => Select Home Menu => Click Sort & Filter Tool => Click Sort Largest to Smallest. For more understanding, look at the screenshot please: AutoSum: When you need to sum a single range of cells, whether a column, row or several adjacent columns or rows, you can have Excel AutoSum to automatically make an appropriate SUM formula for you. When you use AutoSum, in most cases, MS-Excel selects the correct range to total. In a rare case when a wrong range is selected, you can correct it manually by typing the desired range in the formula or by dragging the cursor through the cells you want to sum. The AutoSum is a function in Microsoft Excel and other spreadsheet programs that automatically enters the appropriate formula or function into your spreadsheet. For example, if you wanted to add the values of cells A1 through A4, highlight cells A1 through A4 and click the AutoSum button, as shown in the picture to the right. Clicking this button after highlighting the cells creates the formula =SUM(A1:A4) in cell A5 (first cell after last highlighted cell) and gives you the total of all those cells. The AutoSum feature makes entering formulas easy without the need to memorize the syntax for each formula. How to use AutoSum tool to calculate values from selected cells? Keep the cursor point in a cell that you want to get calculated value => Select Home Menu => Click AutoSum => Give the range of calculating area and press Enter key. For more understanding, look at the screenshot please:
0 Comments
|
Archives |