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
Excel Tips
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
Excel based personal expense tracker
Chandoo conducted an Excel challenge in July 2010 to make a dynamic dashboard for tracking one’s personal expenses. The trackers can be very useful for anyone managing a budget, be it for households or for small organisations. Tracker 1 Tracker 2 Tracker 3 Tracker 4 Tracker 5 Tracker 6 Tracker 7 Continue reading Excel based personal expense tracker
