Recent Comments
Author Archives: dougaj4
Dealing with dates -1, date values and formats
Following a discussion at Eng-Tips, I have been having a closer look at how Excel handles the entry and display of dates. The Eng-Tips discussion concerned changes to data when csv files are opened in Excel. I will deal with that (together with … Continue reading
Posted in Excel
Tagged date formatting, date values, dates, Excel, language settings, regional settings
4 Comments
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
