Databases – retrieving records

Link to files used in my video. Excelisfun’s one of the several formula  based methods to retrieve records from a list based on a criteria – Video. It is much faster than the array formulas which can produce the same result. Cameron Crest’s video on query function in google spreadsheets is a missing manual for on query functions. His blog lists the spreadsheet employed in … Continue reading Databases – retrieving records

Individualised reports from Google forms

This video explains how one can create a mail merged document from form submissions. A simple mail merged document will give one report per record. This video employs excel formulas to accomplish individualised report per student when there are multiple records for the same student. The source files can be downloaded here. Videos on incrementing cells can be viewed in the two videos from Mike … Continue reading Individualised reports from Google forms

A Functional IMAGINARY Tale (reblogged)

Any one familiar with Microsoft Excel functions, will be able to appreciate this writing from the spreadsheet guru, John Walkenbach I’ve been sleeping on a COT for a MONTH NOW because I don’t have any CLEAN SHEETS LEFT. So TODAY I went looking for SHEETS — SUMPRODUCT that offers REAL VALUE for the DOLLAR. The MEDIAN cost varies in different AREAS, so I got on … Continue reading A Functional IMAGINARY Tale (reblogged)