US President Barack Obama describes the Queen as a "source of inspiration for me" and "truly one of my favourite people".