Seasoned CM admins should already understand the difference between SQL and WMI queries and how to write a subselect query. If you do, you should be able to skip ahead with just this one reminder—with CM12's ability to use exclude or include in a collection query, you won't have to make subselect queries as often.
Now for all of the rest of you, we're going to show you how to make a query to show all machines which have Office installed. Then we'll show how to find all machines which don't have Office 2010 installed (and for that we need a subselect). We'll do this first in SQL and then again in WMI. SQL is for reports where WMI is more commonly used for CM console queries and collections.