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