A new yuletide e-book for making cards, letters etc with Microsoft Office. Christmas Cheer with Office – PREMIUM Edition, is the new yuletidee-book from the makers of the Organizing Outlook Email, Eye-Catching Signs with Word and the Office Watch newsletters. Office Watch head honcho, Peter Deegan has teamed up with
More useful stats functions in Excel by David Goodmanson Continuing our series on Excel’s statistical functions … we started with Average/Mean and now move onto the misunderstood cousin Median plus also Mode. Median and Mode If we are looking for work and are told that the average salary is $45,000,
Sundry notes to round out our coverage of IMAP in Outlook. Flags With Outlook you can only set flags on IMAP messages that are in the Inbox or any other folder but you cannot send or receive messages which are flagged. The Quick click flag option where you can customize
Working with Gmail ‘starred’ messages in Outlook If you have used Gmail then you must be aware of the “Starred folder” (shown within the red circle in the below screenshot). In Gmail Stars are meant to give messages a special status to make them find easier when you search for
Speeding up the message sync between Outlook and your email host. Outlook’s default action for IMAP accounts is to download the message header only; you have to mark the message for full download. That was probably a good idea when dial-up modems ruled the earth but is more of a
Tricks for handling more than one email account in Outlook It’s NOT a good idea to have both POP and IMAP connections running to the same email host. That’s because the POP connection will usually delete messages on the host when they are moved to Outlook, once deleted they’ll be
With IMAP you can choose which folders on the email host to copy to Outlook. With IMAP you can choose which folders on the email host to copy to a local device. With Outlook you’ll probably want to replicate all folders so you can view anything you need when offline.
How to turn on IMAP on Google’s Gmail service. In order to make your email host connect with IMAP it may need to be configured in the host settings. This isn’t always necessary, in fact usually IMAP is turned on at the email host already. However Gmail requires you to
So you’d like to try IMAP? Here’s step-by-step instructions on how to setup Outlook for an IMAP connection. In this series we’ll look at how to setup IMAP. We’ll use Gmail as our host example because it’s free and well supported, however any IMAP host should work (most ISP based
Why you might prefer IMAP to get your email into Outlook. What are IMAP and POP? IMAP and POP are methods for retrieving email from an email host like your ISP, Hotmail, Yahoo, and Gmail so you can access it from your desktop through some of the common desktop email
Create the ultimate lookup or decision formula; a User Defined Function using Visual Basic for Applications. by David Goodmanson Following our recent theme of reference, decision and lookup functions, in this article we will go one step further and create the ultimate lookup or decision formula; a User Defined Function
Excel alternatives to nested IF’s from our readers. After David Goodmanson’s features on IF and nested IF’s we’ve received many messages from readers suggesting another alternative – CHOOSE() and here even more possiblities. Tony D writes: “ Small snippet for your “IF” library next time. I’m sure there will be hundreds
A look at nested IF statements and alternatives that are easier to make and understand later. by David Goodmanson In my last article I looked at a simple Excel IF statement plus their useful cousins CountIf and SumIF. I also touched on the nested IF statement, where there are many
PPT Handouts are a special rendering of your slides to be printed out for your audience. PowerPoint Handouts are a special rendering of your slides to be printed out for your audience. It’s one of the ‘PowerPoint support materials‘ including Notes. In this article we show how to make and
Three places to save password information in MS Office. Ideally each login to a computer or web site should have its own password but it’s a given that we all use the same passwords too often. Remembering all those passwords is hard enough but you also have to remember the
Some useful maps of Europe and some European countries as free PPT slides. Presentation Helper has some useful maps of Europe and some European countries as PowerPoint slides. The free download has: Map of Europe with pins Four example maps showing how to apply pins, lines, outlines and image fills
Speaker notes can have images and charts as well as printing options. In PowerPoint, Notes Pages show thumbnail images of the slide along with an area below for notes which would help the presenter during the presentation or it can be given to the audience as well. In PowerPoint 2003
The @ symbol was used back in 1536 – 473 years ago today. The Lede blog for the New York Times notes that today is the 473’d anniversary of the first recorded use of the @ symbol. It’s found in a letter from a Florentine merchant and, from the context,
Printed support materials that make your presentations better PowerPoint support materials come to the rescue of both the presenter and the attendees. PowerPoint has greatly advanced from being just a tool to prepare slides and organize it. It has come up with various support materials like handouts, notes which can
A trick for quickly printing part of a document, worksheet or slides plus when it does NOT work. Sometimes you just want to print part of a document, maybe a few paragraphs or many pages. One option available is to print the current selection. The basics are simple. In Word,
IF statement and some variatons – nested IF, CountIF and SumIF. by David Goodmanson IF a picture paints a thousand words, then how many words have 5 characters or more? The answer? Use the IF function. The IF function is a simple and easy-to-use function that can be widely applied
Why can’t Office open docs made by Office itself? When Microsoft was trying to gain market share over rivals like WordPerfect, they spent a lot of time and trouble making Office import other document formats easily and correctly. Times have changed, Microsoft Office has the overwhelming share of the office
Much as the Microsoft marketing people would like you to believe that – it’s not true. Much as the Microsoft marketing people would like you to believe that – it’s not true. Plenty of individuals and companies are sticking with earlier versions of Office – Office 2003 or Office XP
See what people are saying right now about your favorite Office software. It can be fascinating to see what people say about software as they work – many questions, some answers and plenty of anguish and outright anger. We’ve setup some pages that make it easy to see the very
