# 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

# Interactive Calendar

Few posts ago, I referenced Chandoo’s dynamic calendar. Recently he made  made this interactive calendar using pivot tables in Excel and has even made a video showing us the process. Continue reading Interactive Calendar

# Dynamic Excel Calendar

Chandoo created this dynamic Excel calendar which I found extremely useful. Additional resources: Daniel Ferry’s Calendar Musings Excelisfun Counting work days Continue reading Dynamic Excel Calendar

# Dynamic Periodic Table of the Elements

Daniel Ferry (www.excelhero.com) created this dynamic periodic table in excel and it is very impressive. He conducts the Excelhero academy every year. The Image below is taken from Excelhero and you can download the Source file and play with it. Additional resources: Michael Dayah’s periodic table Elements iPad app Periodic Videos Continue reading Dynamic Periodic Table of the Elements