# 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

# Calculating Subtotals

Recently, I came across three videos on calculating sub totals in Excel. According to Mr Excel, “You have random chunks of data and need to add a total to each chunk”. The first one is a VBA based solution by Bob Umlas, an Excel MVP. The second one is from Kevin Lehrbrass, a former EFL teacher. In his own words: “Teaching English as a foreign language has taught me … Continue reading Calculating Subtotals

# 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)

# New Year gifts from an Excel blog

Chandoo, an Excel specialist, has shared the ‘Excel based Calendar’ as well a ‘To Do’ list. To-do List with Priorities using Excel *** 2013 Calendar – Excel Template Continue reading New Year gifts from an Excel blog