Guys, Take a look at my optimised page - http://www.camera-compare.com/canon-elph-digital-cameras.html I am ranked for the term 'canon elph digital camera' in Yahoo in position 69, but nowhere in Google.... However I have been indexed Google, does this mean I am not in the sandbox but need to wait for my links to pass value etc?
Website recently finished optimisation around 4 weeks ago, was indexed straight away and then waited for next index which took 2 weeks, now is indexed but poor rankings
in order to get that page in the top 10 for that keyword. You will at least need to be doing more than the page that is ranked 10th (http://www.dcresource.com/reviews/canon/powershot_sd500-review/). That page has a page rank of 3. Your page has a pagerank of 0. You need to build more links until you have at least a PR of 3. Its gonna take you several months. Good luck, keep working, and be patient.
As I can see, you have few links for your site. Gather more incoming links that points to your site using your targeted keyword as your anchor text. It ranks in Yahoo because your site is rich in content, unlike big G who focuses on both links and quality of content.
Your on page factors seem pretty decent. Since you are in a competitive niche then what you are missing is links, links, and more links (or at least a couple very high quality aged links). Build links slowly and don't forget about sculpting your internal page rank flow from other pages on your site too and you will start to rank eventually.