SILS iSchool

22 October 2020

preps | sorting | filtering | pivot tables



Value Added | daily

Class Schedule

Basics | sessions 01-03
  1. 13 Aug intro and clients | lecture | labs
  2. 20 Aug servers and command line | lecture | labs
  3. 27 Aug networks and protocols | lecture | labs
Web Development | sessions 04-07

  1. 03 Sep structural layer | lecture | labs
  2. 10 Sep presentational layer | lecture | labs
  3. 17 Sep using a structure | lecture | labs
  4. 24 Sep behavioral layer | lecture | labs
Dealing with Markup | sessions 08-09
  1. 01 Oct control objects and display | lecture | labs
  2. 08 Oct tools that read markup | lecture | labs
Working with Data | sessions 10-13
  1. 15 Oct formulas, functions, vectors | lecture | labs
  2. 22 Oct data display | lecture | labs
  3. 29 Oct manipulate data sets | lecture | labs
  4. 05 Nov relational data bases | lecture | labs
Presentation | session 14
  1. 12 Nov designing and delivering a presentation | lecture | labs



The image below is a hyperlink to slides for the lecture
slides for session 12

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.

home & schedule | syllabus | contact | grades
Spreadsheets can be flat file databases.
The tools in Excel can manipulate such databases to array the data exactly as needed.

Using spreadsheets as databases

Dilbert cartoon, 20070809, by Scott Adams

back to top

According to Microsoft

Sorting data is an integral part of data analysis. ... Sorting data helps you quickly visualize and understand your data better, organize and find the data that you want, and ultimately make more effective decisions.

back to top

Sorting

Your data is entered into your database, row by row, in any order. Should you wish to re-order the rows to better portray some aspect of the database, you may wish to sort the data. There are multiple ways to do it (use this example).

  • Sort list in alphabetical, numerical, or chronological order
  • Order can be ascending or descending

How to sort

Select the column or array you wish to sort, then choose Data > Sort & Filter > Sort from the ribbon

[select the array to be sorted, then select the sort tool from the ribbon]

The same is true in Excel for Mac

[select the array to be sorted, then select the sort tool from the ribbon]

Or use the sort tools from the right click option.

sort by right click

The ribbon option and the Custom Sort option both will reveal the dialog box.

[MSExcel 2007+ sort dialog box]

Check that the data sorted correctly. To undo, use the undo icon or CTRL-Z or "Edit, Undo" or just redo the sort.

back to top

29 October lecture | preps | sorting | filtering | pivot tables