A list of Microsoft Office versions and their latest Service Packs. If you don’t have Office 2013, don’t worry, you’re not alone. Here’s a list of the latest service packs for each version of Microsoft Office going back more than a decade. For the recent versions of Office, at least
How to update Microsoft Office with the new name, OneDrive, and remove the old SkyDrive name. Recent versions of Office have the name SkyDrive (with the extra capital letter) in the supplied dictionary. However the new OneDrive name hasn’t made it to the Office dictionary yet. Here’s what you’ll see
How to find your pictures to insert into an Office document. Even a simple thing like adding a picture to an Office document or email has subtleties and annoyances. When you choose Insert | Picture in recent versions of Office, it opens, by default, in the Picture Library. That seems
How to get a message when certain RSS feeds are updated As you probably know, it’s possible to get an alert or an action when certain email messages arrive into Outlook using the Rules feature. Office-Watch.com shows how to do the same thing for an RSS feed. It will let
What it really means for Office 2003 users plus a better countdown to the ‘end’ of Office 2003 and Windows XP Microsoft has a countdown to the end of support for Office 2003 and Windows XP in months, days and hours. We could not resist making our own … Microsoft
2014 looks like the year of long movie titles with colons – here’s how to save yourself some typing. More and more movies are sequels and that means longer and longer movie titles. Most have colons because the studios don’t trust us to figure out that a movie is a
An industrial dispute involving CAPS has ended. One of the most interesting industrial disputes of 2013 has now ended with a new agreement between staff and management of the Melbourne Fire Brigade in Australia. Being an emergency service, the administrative staff didn’t feel that a full ‘stop work’ strike was
Among the December 2013 patches is a fix for the latest TIFF image bug. The most recent ‘zero day’ exploit for TIFF images has now been patched by Microsoft. The security lapse is the latest in a long line of problems with the Windows system for handling images. There seems
Examine US public health data in Excel. One of the great things about the recent Internet is the availability of previously hidden data. Large blocks of information have been collected, checked and published online. Combine that with a tool like Excel and you can do your own analysis! Here’s just
An example of web scraping from BestBuy.com into Excel. We’ve already talked about getting prices from the Amazon.com web site into Excel with automatic updates. Now let’s look at how to do it for BestBuy.com prices.Excel has had a method of web scraping for many versions you can find it
How to check Amazon product prices automatically in Excel. With Black Friday coming in the USA, it’s time to carefully check prices and look out for bargains. Ideally get those prices automatically and put them into Excel for comparison. To do that for Amazon means ‘scraping’ or trying to grab
How to copy an image from the web into an Office document. Getting an image from your web browser to a Word document is quite easy, though easier with some browsers than others. In your browser, right-click over the image you want and look at the options available. At the
The Vatican’s latest mistake can be blamed on Microsoft … if you try hard enough. A good laugh can be had with this news from the Vatican: “A commemorative coins issued by the Vatican has been withdrawn because it spells the word ‘Jesus’ incorrectly”. You’d think that knowing how to
How to use Office for Windows on the Mac. Sometimes Office for Mac isn’t enough, you need its big brother, Office for Windows to run on a Macintosh computer. That’s certainly possible in various ways. It’s done using virtual machines, in effect running Windows ‘inside’ Apple’s operating system. VM’s, as
How accurate is Excel compared to universal needs. On page 45 of the Sept/Oct 2013 Mental Floss magazine is a small item ‘Why do we care so much about the digits if Pi’ which includes this trivia: “The computers that keep the International Space Station humming round off pi at
Does Microsoft have a list of blocked words like Apple does on the iPhone? One of the more amazing examples of over-control by a software maker is the news that Apple has a ‘Kill List’ of words that it won’t spell-check. It seems that iOS v6 devices have a list
A quick look at your dictionary options in Word Even if you, like me, only speak one language there are still some powerful language and dictionary options in Word to keep in mind. All copies of Microsoft Office (recent versions anyway) come with English dictionaries. ‘Dictionaries’ plural because there’s many
There’s SUM and then there are all the useful SUM variations to choose from. Excel’s SUM() function is probably the first one we learn but there’s a lot more to it than simply clicking on the button to add up a list of numbers. In this article we’ll look at
The new Wikidata site should provide hours of Excel ‘fun’. The WikiMedia foundation, operators of Wikipedia among others, is developing a new site called Wikidata. It will be a home for public ‘structured data’ in other words, lists. There are plenty of lists already in Wikipedia. Wikidata will link with
Just one example of VBA users being shortchanged in Microsoft Office An obvious way to apply watermarks in Microsoft Word would be via VBA. For example some code to print a document multiple times – once with an ‘Office Copy’ watermark and other showing a ‘Customer Copy’ watermark. Or using
Control your Facebook photo as displayed to others via Outlook. Are you aware that your Facebook photo shows up for anyone with Outlook? We ask because at Office-Watch.com we see a lot of readers emails and some of the photos make us wonder is the sender realizes the Facebook shot
A little Excel quirk to mention using LEN() with large numbers. A little Excel quirk to mention. For as long as we can remember you could get the number of digits in a number by simply using =LEN() even though the input is a number, not text. But have a
Make the famous WW2 poster yourself, and countless variations, in Microsoft Office. Make the famous WW2 poster yourself, and countless variations, in Microsoft Office Keep Calm with Microsoft Office is the latest in our series of practical ebooks for Microsoft Office users. We don’t just tell you how
Add better multi-monitor support for Windows As you put your Office applications across more than one monitor, you’ll find the need for better controls than the ones in Windows. That’s where UltraMon comes in. These days it’s common to see two monitors with Office programs and browser windows open across
