• Dave Foord
  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,637 other followers

  • Dave Foords Twitter

    Error: Twitter did not respond. Please wait a few minutes and refresh this page.

  • Advertisements

Adding a date picker to Excel

As a huge user of Excel, I am often entering dates into cells. Different versions of Microsoft have had date pickers as an optional add on, but they haven’t always worked for me with all versions or consistently.

I have however just discovered this free tool:
http://samradapps.com/datepicker/

Which is created by Sam Radakovitz , which does exactly what I want.

Once set up, if a cell in Excel is set as a date, clicking on that cell, will bring up a small calendar icon to the right of the cell:

Image showing the calendar icon to right of the selected cell

Which when clicked on, will bring up the calendar tool, making it easier to enter dates, and not have to worry about the correct format, or whether the spreadsheet has been set up in UK or USA format.

 

F

Full credit to Sam for this one, I am just blogging about this mainly for my own benefit so that I can relocate this in the future when I change computers.

Advertisements

Using Compfight to locate creative commons images

Compfight is an excellent little website, for locating images on flickr that have been released under a creative commons licence which means that we can use the images in resources etc, without having to gain explicit permission from the image owner.

I have posted about Compfight before at https://davefoord.wordpress.com/2010/05/18/finding-and-using-creative-commons-images/ and https://davefoord.wordpress.com/2011/01/11/finding-images-without-breaking-copyright/  but the interface has changed slightly, so I thought it was time to create a new screencast for this service.

Having located and used an image this way, I then use another service called ImageStamper which then records which images I have used and when, and most importantly what the licence agreement was at the time (in case someone on Flickr changes their licence agreement at a later date).

How to quickly upload lots of images to PowerPoint and then compress them

A few months back I ran a training session for some primary school teachers, on how to use PowerPoint within primary education, and they were very impressed with most of the ideas and techniques that I worked through with them, but the one that captured the imagination of even the slightly IT wary teacher was showing how we can quickly bring lots of photos from a camera into a PowerPoint presentation.

This is a very simple technique, but one that many people haven’t discovered yet.

A video showing how to do this, and how to compress the images in one go can be found here