The power of two’s
“Such magic the numbers possess, much try you as might, it shall be hard to resist its charm…” Continue reading The power of two’s
Tag: Excel
A tribute to Pi
this year, 14 of March shall remain etched in history,
and in our memories too… Continue reading A tribute to Pi
e for Euler’s…
e had been of much use
in banks and population growth models.
and employed by many
with a punch of a few buttons,
in our lofty calculators. Continue reading e for Euler’s…
Composers of Western Classical Music – Visualised
I was looking for a timeline of composers of western classical music right from Hildegaard Von Bingen but I could not find an interactive one on the web. However,I found the following: Classical.net lists the major composers in its timeline in PDF format Classicfm has a much nicer timeline but it does not show all the composers. Media and text on a particular composer is included in … Continue reading Composers of Western Classical Music – Visualised
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
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
