Lesson 7Rajendra Bandi, CIS, FGCU 1Rajendra Bandi, CIS, FGCU 1Lesson 7Sorting and Subtotalingto Organize Your DataRajendra Bandi, CIS, FGCU 2Learn how to:F Sort a list by several categoriesF Subtotal an entire list of data at one timeF Use a subtotal outline to show only the level ofdetail you wantLesson 7Rajendra Bandi, CIS, FGCU 2Rajendra Bandi, CIS, FGCU 3Sorting a List of InformationF So often we need to see data in a sorted mannerü Eg. Sorted by price, sorted by date, sorted by product etc.or any column (field)ü Click on any cell in the worksheet dataü Click Sort in the Data menu optionü Click the Sort by down arrowu notice all the column headings listedu Choose column which should be the basis for sortingu Decide if sorting should be in ascending ordescending orderu Click OKu You can choose multiple columns for sorting byselecting additional columns in the Then by boxRajendra Bandi, CIS, FGCU 4Summarizing Data with SubtotalsF We have previously discussed summarizingusing the “Consolidate” commandF Another option is to use the SubtotalcommandConsolidateF Summarizes frommultiple listsF works with singlecolumn of numbersF Doesn’t show detailsSubtotalF Summarizes fromsingle listF works with multiplecolumns of numbersF Can show or hidedetailsLesson 7Rajendra Bandi, CIS, FGCU 3Rajendra Bandi, CIS, FGCU 5Calculate SubtotalsF Click on any cell in the worksheet data(assuming working with Lesson 7 Inventory file)F Click on subtotals under the Data menuF In “At each change in” box select column, todefine when subtotal is to be computedF In “Use function” box define the type offunction: sum, average etc.F In “Add subtotal to” box define the columnswhich need to be sub-totalledF Click OK (you can also create multiple levelsof subtotals. Refer page 113 of textbook)Rajendra Bandi, CIS, FGCU 6Calculate SubtotalsF Notice that in additional to creatingsubtotals, Excel also has created outlines, tomanipulate the amount of details to beshownü Very similar to outlines concept in MS Wordü Outline buttons appear to the left of the