Recent Comments
Author Archives: dougaj4
Reversing Bob
Following our look at Weird Al Jankovic’s palindromic song, Bob, I have written two short VBA User Defined Functions (UDFs) to help writing palindromes (and possibly with other tasks as well). Reverse() will, as the name suggests, reverse any text entered as … Continue reading
Posted in Excel, Link to Python, UDFs, VBA
Tagged Excel, Palindromes, Python, Reverse strings, UDF, VBA
Leave a comment
Two exceptional musicians
On Saturday night we were treated to fine performances from two exceptional young musicians. The first was Stefan Jackiw, performing with The Australian Chamber Orchestra at Angel Place. Here he is playing a Beethoven piece in 2009: Then after the … Continue reading
Baby Names and Pivot Tables
Baby Boom: An Excel Tutorial on Analyzing Large Data Sets is a comprehensive (and free) tutorial looking at analysing public databases of baby names, using Excel: There are professional data analysts out there who tackle “big data” with complex software, … Continue reading
Posted in Charts, Excel
Tagged Analysing data, Excel, large data sets, Pivot charts, pivot tables, tutorial
Leave a comment
Managing Data Using Excel …
… is a new book by Mark Gardener, published by Pelagic Publishing.* It is subtitled “Organising, summarising and visualising scientific data”. The publishers say of the book: Microsoft Excel is a powerful tool that can transform the way you use … Continue reading
Posted in Charts, Excel, Newton
Tagged Charts, pivot tables, Scientific data analysis
Leave a comment
Avoid si Aibohphobia is di ova …
… which loosely translated means, if you have inherited the rare but debilitating condition known as aibohphobia, or fear of palindromes, then read no further, and don’t even think about clicking on the Vimeo video below. Since today (for those of … Continue reading
