- 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 the video.
- Excelhero academy is up and running. Link to Daniel Ferry’s blog.