With the functionality provided to use negative keywords with Adwords, I wonder if there is any way it would be possible to avoid a page ranking for a specific keyword?
E.g. I have a page which targets a very specific phrase, but mentions in the text the main keyword for my site. However I don't want this page ranking (at all) for that keyword... only my target phrase! In specific Google TLDs, it makes the 1st page, which is undesirable.
So, I'm wondering if there is any magic to be weaved to get Google to ignore a particular term?
There is no technical approach that blocks a page from showing up for one particular query term but still allows it to show up for another phrase. There is not even an organic search parallel to the Adsense tagging that says "ignore this section".
Try making the main keyword for your site anchor text which points to your homepage. Try linking to your desired page with the proper anchor text from other pages on your site. Send whatever signals you can to Google that will help them learn what the content is about.
If you can get another page on your site to rank for the keywords you don't want this page to rank for, you may get the results you are looking for.
Review all the basics, including meta tags, to be sure you do not include that keyword anywhere that it shouldn't be.
Other things that have worked in the past are the use of block quotes and iframes, but I'm not sure if either of these would be useful for your situation.
Alternatively, you could rewrite that piece of content.