SILS iSchool

13 April 2021

Value Added | daily

Class Schedule

Basics | sessions 01-03
  1. 19 Jan intro and clients | lecture | labs
  2. 26 Jan servers and command line | lecture | labs
  3. 02 Feb networks and protocols | lecture | labs
Web Development | sessions 04-08

  1. 09 Feb structural layer | lecture | labs
  2. 16 Feb presentational layer | lecture | labs
  3. 23 Feb using a structure | lecture | labs
  4. 02 Mar behavioral layer | lecture | labs
  5. 09 Mar design thoughts | lecture | labs
Dealing with Markup | sessions 09-10
  1. 16 Mar control objects and display | lecture | labs
  2. 23 Mar tools that read markup | lecture | labs
Working with data | sessions 11-14
  1. 30 Mar formulas, functions, vectors | lecture | labs
  2. 06 Apr data display | lecture | labs
  3. 13 Apr manipulate data sets | lecture | labs
  4. 20 Apr relational data bases | lecture | labs
Presentations | sessions 15-16
  1. 27 Apr designing a presentation | lecture | labs
  2. 04 May delivering a presentation | lecture | labs

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

image of a sign about pivot tables

back to top

According to Microsoft

A PivotTable is an interactive way to quickly summarize large amounts of data. You can use a PivotTable to analyze numerical data in detail, and answer unanticipated questions about your data.

back to top

Pivot Tables

Another observer put it even more succinctly.

Pivot tables are summaries of your data based on categories that you select.

A PivotTable is especially designed for:

  1. Querying large amounts of data in many user-friendly ways.
  2. Subtotaling and aggregating numeric data, summarizing data by categories and subcategories, and creating custom calculations and formulas.
  3. Expanding and collapsing levels of data to focus your results, and drilling down to details from the summary data for areas of interest to you.
  4. Moving rows to columns or columns to rows (or "pivoting") to see different summaries of the source data.
  5. Filtering, sorting, grouping, and conditionally formatting the most useful and interesting subset of data enabling you to focus on just the information you want.
  6. Presenting concise, attractive, and annotated online or printed reports.

But why?

A pivot table is a table of statistics that summarizes the data of a more extensive table (such as from a database, spreadsheet, or business intelligence program). This summary might include sums, averages, or other statistics, which the pivot table groups together in a meaningful way.
Pivot tables are a technique in data processing. They enable a person to arrange and rearrange (or "pivot") statistics in order to draw attention to useful information.

back to top

It begins with deciding what to display.

Microsoft video on creating pivot tables
  1. Select the cells you want to create a PivotTable from.

Your data shouldn't have any empty rows or columns. It must have only a single-row heading.

  1. From the ribbon, insert the pivot table.
insert pivot table snippet
  1. Under Choose the data that you want to analyze select Select a table or range.
select data for pivot table snippet
  1. In Table/Range, verify the cell range.
  2. Under Choose where you want the PivotTable report to be placed, select New worksheet to place the PivotTable in a new worksheet or Existing worksheet and then select the location you want the PivotTable to appear.

back to top

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