Who is better? Larry King or Piers Morgan – do your own analysis in Excel. Data is now available to analyze the CNN ratings of Larry King and his successor Pier Morgan (aka Piers Moron as he’s known to readers of Private Eye). We really don’t care about the ratings
How to get a list of files in a folder into Microsoft Word. As long as there have been word processors, we’ve seen the question of how to get a list of files into a document. It should be simple bit it isn’t. Here’s how … You could write or
How can you get more languages for Office – or maybe you already have them? Following our look at Which languages come with Office in the last issue we received quite a few questions from Office Watch readers about language support in Office; this and related articles will attempt to
When you buy Microsoft Office, what language proofing tools do you get ‘in the box’? Each language version of Office sold is called a ‘localized version’ by Microsoft. The most common is the ‘English’ version of Office sold in North America, UK, Australia, New Zealand and many other places. Though,
Excel’s method of converting measurements is good but could be so much better. Once you start looking into the CONVERT function in Excel, you realize that it’s really an incomplete function. Excel has been around for a long time and yet this important feature has lapses that would make it
There is a possibility of getting a replacement Product Key from Microsoft. A Knowledge Base article from Microsoft suggests they can help recover a lost Office Product Key. If you’re trying to install Microsoft Office, perhaps on a replacement computer, you need installation disk and also the Product Key. That’s
Why can’t you get the right key from a pre-installed copy of Office? Buying a pre-installed copy of Microsoft Office has some pitfalls and one of them is trouble recovering the Product Key. If you’ve lost your copy of the Office Product Key (essential for installing Office) then usually you
When you buy Office there are several languages you can use with your documents. Office has two levels of language support. There’s the language used on the menus, ribbon and dialog (called ‘Language Interface’) and then there are the languages supported in documents by the spell checker, grammar analysis and
A tool for syncing your Outlook data with online services. gSyncit is an option for pushing your Outlook data, calendar, contacts, tasks and notes to online services. This is important because it lets you access that Outlook info on other devices like the iPhone or Android smartphones with updates copied
How to get table or other information from the net into Excel (or Word). Ever seen some data on the Internet and want to copy it for yourself? From small tables to large data chunks, there’s several ways to do it. Simple copying Almost any table or grid on a
An iCloud link with Outlook sounds great, a pity it doesn’t work in the real world. Lots of iPhone and iPad users got excited when they learned about iCloud and its ability to sync mail, calendar, contacts and tasks with Outlook via the Internet. Hold the applause, if you actually
How to sync Outlook to your Apple devices with iCloud and why it sucks. Apple’s iCloud service provides a way to synchronize some parts of Outlook with your Apple iPhone, iTouch or iPad but it doesn’t work as most people would like. Before iCloud, you could synchronize your Outlook Contacts,
Word’s spell check has a serious bug when it comes to symbols. Some time back we looked at the ‘Word ampersand mystery’, that’s where the spell-checker behaves strangely when there’s an ampersand in the text. It turns out to be a bigger problem involving many symbol characters. An ampersand at
At last, an easy way to find Word 2007 commands. We’re delighted to release a Word 2007 Command Finder to help you search through all 1,580 commands. Just like our Word 2010 Command Finder, we’ve taken the All Commands dialog and put them into a single, searchable list. This makes
What is there for Office users in the new Kindle Touch and Kindle Fire? Because there has been no mention of Office document compatibility on the new Kindles, we decided to take a look. There’s a little good news but things mostly stay the same. Document compatibility is important. Devices
Can you have a vertical ribbon in Microsoft Office? Is it possible to make the ribbon go vertically down the side of a document instead of horizontally? Back in Office 2003, it was possible to move the toolbar from the top row to any side of the Office window –
How you can protect yourself against mail being intercepted by a fake domain The Godai Group have made a big splash with their report on ‘doppleganger domains’ that can spy on emails to and from an organization, but what can Outlook users do about it? What is a Doppleganger domain?
The Nook Color tablet/ereader supports an impressive list of Microsoft Office documents. Office Watch reader, Dale M writes: ” for the NookColor …. it reads natively, office documents in Office 2003 and in Office 2007 format. Works for Word, Excel and PowerPoint and maybe others. Also, PDFs display quite nicely
Word 2007/2010 Text Box is also in Excel and PowerPoint. We’ve talked a lot about the Text Box feature in Word 2007 and Word 2010. Both Excel 2007 / 2010 and PowerPoint 2007/2010 have Text Box features similar to Word. There’s no gallery to choose from, so you have to click
The full list of Word 2010 Text Box Gallery items Here’s the full list from the Text Box built-in gallery in Word 2010 and Word 2007. Insert Tab | Text | Text Box. Some people find it easier to see the entire list on a single page rather than scrolling up and
More tips and details about putting one Word document inside another. Following our article on Word linking and embedding in Office for Mere Mortals, here’s some additional tips and help to do things not allowing in the Word dialog boxes. Making it permanent For future reference you’ll want the main
How to make one Word document appear in another document by linking or embedding. A Word document can be placed inside another so it appears in the second document. This can be done as a ‘one-off’ insertion or a linking where changes to the source document automatically appear elsewhere. For
If you get Office 365, should you subscribe or buy. An in-depth look at whether the Office 365 software subscription is worth considering. Office 365 comes with the option to rent Office 2010 software – is that a good choice? For the most part, Office 365 is a collection of
Where is the Select All command and why you don’t need to find it. “As software changes so do the tool bars. A simple change for the location of the “select all” button is frustrating’ – Anthony C. We assume Anthony is asking about the ribbon in Office 2007 and
