The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

We then present an algorithm ProgOfEx that takes an example input and output table, and infers a program in TableProg that implements the transformation described by the example. ... the module to ...