Category Archives: Excel

Dealing with dates 2: Getting cell data type and format code

Posted on 08/06/2015 by dougaj4

When working with imported data, or data from an opened csv file, it is often important to know the data type that has been used to store the data.  This may not be obvious, for instance in the previous post we … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , , , , | 6 Comments

Dealing with dates -1, date values and formats

Posted on 06/06/2015 by dougaj4

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 , , , , , | 4 Comments

Reversing Bob

Posted on 31/05/2015 by dougaj4

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 , , , , , | Leave a comment

Baby Names and Pivot Tables

Posted on 17/05/2015 by dougaj4

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 , , , , , | Leave a comment

Managing Data Using Excel …

Posted on 10/05/2015 by dougaj4

… 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 , , | Leave a comment