Office for Mere Mortals
From our famous newsletter for Microsoft Office beginners.
Outlook’s alternative to Gmail’s Priority Inbox
Some options for making a Gmail like ‘Priority Inbox’ in Outlook.
click here for more ...
Office Web Apps - dive in and try 'em
The free browser version of Office is worth trying out.
click here for more ...
Blue Beauty - a nice PowerPoint presentation
A nice and informative PowerPoint presentation we made a little smaller and safer.
click here for more ...
Office for Mac non-existent price cuts
Microsoft isn’t really cutting the prices of Office for Mac - it just looks that way.
click here for more ...
Manage Audio Clips in PowerPoint 2010
Improved features related to inserting audio clips in PowerPoint 2010.
click here for more ...
‘Summary of Payments’ infected ‘Excel’ email
A new spam email, ignored by Outlook’s spam filter, is supposed to have a spreadsheet file for Excel.
click here for more ...
How we made the ‘Adjust your monitor’ sign
Some comments on re-creating the " Don't be a Spock " sign.
click here for more ...
Don't be a Spock - Adjust your monitor height
A great sign about positioning your monitor - now available for download.
click here for more ...
Versions in Word 2010
In Word 2010 there is a ‘version’ feature but it’s quite different from the feature of the same name in Word 97 to Word 2007.
click here for more ...
Office Watch on the Kindle
Office-Watch.com titles are now available on the Kindle
click here for more ...
Live Sync for Office users
Live Sync is a useful tool for sharing files and Office settings between different computers.
click here for more ...
More Text Effects in Word 2010
Text effects in Word 2010 have wide range of options like applying shadow, reflection or glow to transform the appearance of text and give it an altogether new look.
click here for more ...
Text Effects in Word 2003 and Word 2007
Making ordinary texts look extraordinary has been possible for many versions of Word. Alas, the features can make ordinary text look awful – if you’re not careful.
click here for more ...
Image Correction in Office 2010
Some new image changing options in Office 2010.
click here for more ...
Background Removal Tool in Office 2010
In Office 2010 there’s Background Removal tool which suggests you can neatly remove the background of images with just one click. It’s really more than that. It’s a powerful editing tool that lets you grab segments of a photo.
click here for more ...
Editing pictures inside Office
Office 2007 and Office 2010 has tools to edit photos and pictures in your document.
click here for more ...
Put the World Cup calendar into Outlook
Outlook’s Internet Calendar feature can be used to follow the round ball game or interesting things.
click here for more ...
Fake emails missed by Outlook
There has been a rush of fake emails that are being missed by Outlook Junk email filters even in Outlook 2010 with the latest updates.
click here for more ...
Office 2010 document compatibility
Can Office 2010 read documents made in earlier versions of MS Office - yes, of course.
click here for more ...
OpenType Ligatures in Office 2010
An easy way to make headings with extra style and flourish in Word 2010.
click here for more ...
Delaying email in Outlook
How to write an email now and send it later.
click here for more ...
Virtual Keyboard for Office
Type in many languages from one keyboard.
click here for more ...
Nudge, nudge PowerPoint
Moving objects around your PowerPoint slides in tiny, tiny little jumps.
click here for more ...
Master your PowerPoint slides
Make a base for all your slides, then later global changes are easy.
click here for more ...
PowerPoint 2007 photo albums
The fast way to make a photo album presentation in Powerpoint 2007 and 2010.
click here for more ...
Excel – about rows and columns
Moving and counting rows or columns
click here for more ...
Master Document Tips
Wrapping up our look at Master Documents in Word with some extra tips.
click here for more ...
Opening a Master Document
Opening a master document doesn't display as you'd expect.
click here for more ...
Master Documents without pain
Don't be afraid - Word's Master Documents is stable and worth using.
click here for more ...
Quick and easy statistics in Excel
We bring together earlier articles to create a quick and simple Excel data analysis.
click here for more ...
Status Bar stats in Excel
Excel 2007 and 2010 have a quick way to see basic stats on a list of numbers.
click here for more ...
Fixing Product Activation problems
What can you do if Office product activation is refused?
click here for more ...
Stopping Overtype
How to stop typing replacing or overwriting text.
click here for more ...
Saving Sort Criteria in Word
How to save a special sort order for your Word tables.
click here for more ...
Variability in Excel
A primer on measuring data variance in Excel.
click here for more ...
Sending a Christmas email
It’s too late for Christmas cards but not too late for a simple Xmas Email.
click here for more ...
Easy invitations in Outlook
How to easily make appointments with other people using Outlook.
click here for more ...
Making a Workspace in Office Live workspace
What to watch for when making a place for your documents.
click here for more ...
Office Live Workspace - the setup
How to get started with Office Live Workspace - assuming that you want to.
click here for more ...
Outlook essential shortcuts
Fast access to important Outlook features.
click here for more ...
Can Word 2003 macros be copied & pasted into Word 2007?
VBA macros should migrate from Word 2003 to 2007 but don't bet on it.
click here for more ...
Where do I find 'Select all' in Word 2007?
or in Word 2010 for that matter?
click here for more ...
Powerpoint save and publishing options
There's lots more ways to use Powerpoint without standing in front of an audience.
click here for more ...
Photo Albums in PowerPoint
Make great personal photo albums with Powerpoint.
click here for more ...
Christmas Cheer with Office - Premium edition out now
A new yuletide e-book for making cards, letters etc with Microsoft Office.
click here for more ...
Outlook Signatures
Personalize emails in style with signatures on your emails.
click here for more ...
Median and Mode functions in Excel
More useful stats functions in Excel
click here for more ...
Average / Mean options in Excel
A new series on Excel statistical functions starting with the many Average options.
click here for more ...
IMAP in Outlook - extra notes
Sundry notes to round out our coverage of IMAP in Outlook.
click here for more ...
Gmail stars and Outlook
Working with Gmail 'starred' messages in Outlook
click here for more ...
Fix IMAP message downloading in Outlook
Speeding up the message sync between Outlook and your email host.
click here for more ...
Using IMAP with other accounts in Outlook
Tricks for handling more than one email account in Outlook
click here for more ...
IMAP Subscribed Folders in Outlook
With IMAP you can choose which folders on the email host to copy to Outlook.
click here for more ...
Activating IMAP in Gmail
How to turn on IMAP on Google's Gmail service.
click here for more ...
Setting up IMAP in Outlook
So you’d like to try IMAP? Here’s step-by-step instructions on how to setup Outlook for an IMAP connection.
click here for more ...
Using IMAP with Outlook
Why you might prefer IMAP to get your email into Outlook.
click here for more ...
Making a complex Excel cell easy to use
Create the ultimate lookup or decision formula; a User Defined Function using Visual Basic for Applications.
click here for more ...
The CHOOSE option in Excel
Readers suggest an alternative to nested IF – the Choose() function
click here for more ...
More nested IF options
Excel alternatives to nested IF's from our readers.
click here for more ...
Excel - Nested IF's and alternatives
A look at nested IF statements and alternatives that are easier to make and understand later.
click here for more ...
PowerPoint Handouts - making and printing
PPT Handouts are a special rendering of your slides to be printed out for your audience.
click here for more ...
How to remember your passwords
Three places to save password information in MS Office.
click here for more ...
Maps of Europe for PowerPoint
Some useful maps of Europe and some European countries as free PPT slides.
click here for more ...
How to copy a picture from an Outlook email
Like an image in an email? Here’s how to save it.
click here for more ...
PowerPoint - Notes options and views
Speaker notes can have images and charts as well as printing options.
click here for more ...
Happy Birthday @
The @ symbol was used back in 1536 - 473 years ago today.
click here for more ...
Powerpoint – beyond slides
Printed support materials that make your presentations better
click here for more ...
Printing a selection in Office
A trick for quickly printing part of a document, worksheet or slides plus when it does NOT work.
click here for more ...
Excel’s IF function
IF statement and some variatons - nested IF, CountIF and SumIF.
click here for more ...
Problems opening 'old' documents
Why can't Office open docs made by Office itself?
click here for more ...
Everyone is moving to Office 2007 except me!
Much as the Microsoft marketing people would like you to believe that – it’s not true.
click here for more ...
Why does the document look different?
Reasons why a document or email can look different on one computer than another.
click here for more ...
Why doesn’t an Outlook change of address stick?
Stop Outlook remembering an old email address.
click here for more ...
Office chatter on Twitter
See what people are saying right now about your favorite Office software.
click here for more ...
Match and Index lookup in Excel
Let’s have some INDEX() and MATCH() fun in our Lookup function series.
click here for more ...
Cross Referencing in Word
Cross-referencing is an imposing name for something we're all familiar with in books, especially reference books. Microsoft Word makes it much easier to do.
click here for more ...
Fitting a Word or Excel doc to your printer
How to print a document when the paper sizes are different.
click here for more ...
Calculating with Vlookup
Using Vlookup in Excel to work out tax, fees or commission from a table by David Goodmanson
click here for more ...
Paper sizes on another computer
How to format a Word or Excel document to print on someone else’s computer.
click here for more ...
Fake HR emails with virus
A new wave of fake job applications and responses isn’t caught by Outlook.
click here for more ...
Controlling the recently used document list
How to configure the list of recently used documents in Office and the glaring omission.
click here for more ...
Where did my numbers go?
Office Watch explains what can happen with Show Formulas in Excel and the simple fix. A slip of the fingers can make all your numbers disappear!
click here for more ...
Understanding Sections in Word
Sections are in every Word document - here's how to use them to make Word do what you need.
click here for more ...
Lookup from a list in Excel
Vlookup scares too many Excel users but it should not. David Goodmanson shows how easy and incredibly useful it can be.
click here for more ...
Omitting page numbers in Word
How do you omit the page number on the final page of a Microsoft Word document?
click here for more ...
Reorganising monthly information in Word
It's a simple question about ordering monthly data in Word - there's many answers which give a glimpse into what you can do with Office.
click here for more ...
Insert the Ghana Cedi character
The Ghana Cedi currency character isn't supported in Windows or Office - so how can you enter it?
click here for more ...
Typing Numero and other symbols
How to type the 'Numero' symbol and other special characters - there's many ways to do it.
click here for more ...
How to save a PDF from Office
There are plenty of ways to make an Adobe Acrobat PDF files from Microsoft Office programs. Here's a quick guide to some of the options including free downloads.
click here for more ...
Easy switching between color and B&W printing
How can you toggle between costly color printing and cheaper Black & White or Grayscale quickly without delving into the print properties each time you want to switch?
click here for more ...
Get the Office Watch newsletters!
since 1996 thousands of people receive the latest independent news and tips from us -- join them today - FREE!
