What can you do if Office product activation is refused? From time to time we get messages from readers who are having problems activating their copy of Microsoft Office. If you’re not getting what you think you paid for, ask Microsoft to explain. What you see on the screen isn’t
How to stop typing replacing or overwriting text. Daysha B writes “What I type replaces my existing text. How do I turn this off? Thank you.” As usual with Microsoft Office, nothing is as simple as it first appears. Most people probably know that the immediate answer is ‘Press the
A primer on measuring data variance in Excel. by David Goodmanson Let’s continue our look at the basic statistics functions in Excel. In our first article we looked at statistical functions that measured central tendency or averages. Most people understand Average or Mean though Median is often misused. Now lets
It’s too late for Christmas cards but not too late for a simple Xmas Email. We’re the first to admit that sending a Christmas email isn’t the most traditional method but it can be done with good cheer and grace. Here’s just one example from a friend and some tips
How to easily make appointments with other people using Outlook. Outlook has some great features for making appointments and sharing those details with others. The main features can be used by anyone to setup dinner, movies or any personal event. Outlook lets you create an appointment in your calendar then
What to watch for when making a place for your documents. Once you’re setup Office Live Workspace you have to create one or more workspaces to put documents in. Before creating a workspace it’s worth keeping in mind a big limitation of Office Live Workspaces – sharing permissions are only
How to get started with Office Live Workspace – assuming that you want to. Microsoft’s Office Live Workspace (OLW) is a free file sharing and online storage service. In the workspace you can create, save, access, edit and share documents with Microsoft Office Word, Excel, PowerPoint, PDF, etc. It is
VBA macros should migrate from Word 2003 to 2007 but don’t bet on it. Yes, VBA macros from Word 2003 should work in Word 2007. We always say ‘should’ because there are inevitably changes in VBA behaviors between versions of Office and “Murphy’s Law” says that one of these ‘minor’
or in Word 2010 for that matter? Select All will choose the entire contents of the Word document, text, images, the lot. It’s on the Home tab, Editing block, Select then choose ‘Select All’. Quite likely the Select All option is ‘buried’ because most users will use the keyboard shortcut ‘Ctrl
There’s lots more ways to use Powerpoint without standing in front of an audience. It’s easy to think of Powerpoint as only useful for people who have to give a speech, but there’s actually many other choices for saving slides and presentations that let you use Powerpoint in many other
Make great personal photo albums with Powerpoint. Creating a photo album in PowerPoint 2007 has become very interesting and convenient. The themes, layouts and Quick Styles make formatting the albums a cakewalk. PowerPoint slideshows aren’t just for projecting on a big screen in front of an audience. You can use
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
