SILS iSchool

 09 April 2020 

preps | sorting | filtering | pivot tables



Value Added | daily

Class Schedule

Basics | sessions 01-03
  1. 09 Jan intro and clients | lecture | labs
  2. 16 Jan servers and command line | lecture | labs
  3. 23 Jan networks and protocols | lecture | labs
Web Development | sessions 04-07

  1. 30 Jan structural layer | lecture | labs
  2. 06 Feb presentational layer | lecture | labs
  3. 13 Feb using a structure | lecture | labs
  4. 20 Feb behavioral layer | lecture | labs
Document Markup | sessions 08-09
  1. 27 Feb control objects and display | lecture | labs
  2. 05 Mar tools that read markup | lecture | labs
Working with Data | sessions 10-13
  1.  26 Mar  formulas, functions, vectors | lecture | labs
  2.  02 Apr  data display | lecture | labs
  3.  09 Apr  manipulate data sets | lecture | labs
  4.  16 Apr  relational data bases | lecture | labs
Presentation | session 14
  1.  23 Apr  designing and delivering a presentation | lecture | labs


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

09 April lecture | preps | sorting | filtering | pivot tables