We look at the most popular of the tools for MS Office users – Google Desktop Search In part one of this special Office Watch series we looked at the possibilities of the new range of desktop searching tools, how the work, what to look for, security implications and pitfalls.
We address the problems related to certain types of searches that the AutoFilter in Excel won’t perform. By Helen Bradley In a recent article of Office for Mere Mortals I showed you how to extract data from a list using the AutoFilter tool. At the time I suggested there were
Excel worksheets are great tools for recording data. By Helen Bradley Excel worksheets are great tools for recording data. While some people use worksheets to record thousands of entries at a time, all some of us need is help recording and organizing the sort of day to day stuff that
We look at the interface and performance of some of the major desktop search contenders. In part one of this Office Watch series we looked at the possibilities of the new range of desktop searching tools, how the work, what to look for, security implications and pitfalls. This issue will
We look at a few Excel functions that are beyond the basic level of the =SUM function. We see how they work and tell you when they can be applied. By Helen Bradley If you’re fairly new to Excel you’ve probably cranked out a few Sum functions and added and
When an Excel list gets big and complex, the issue of finding data in it, and extracting information from it, becomes important. We look at how to filter an Excel list to extract information from it. By Helen Bradley Excel is a great place to store lists and one reason
Even if you only search email or documents once a week, one of these Desktop Search tools will make life a lot easier as they are much faster than anything supplied by Microsoft at present. Everyone’s talking about fast searching of your documents and email these days. What was a
While Access or a database program is undoubtedly the best place to store complex data, Excel is great for simple lists and even more so if you’re using Excel 2003. By Helen Bradley You and I use lists for everything from Christmas shopping to packing for a trip. We also
We look at some more interesting Small Business Server 2003 features, web sites and some alternatives to SBS that are out there. Our look at Small Business Server concludes this week with a look at some more interesting features, as well as some useful SBS books and web sites, and some
You might have thought that the once dominant word processor, WordPerfect has long since gone but it’s still out there. You might have thought that the once dominant word processor, WordPerfect has long since gone but it’s still out there. Corel have just released WordPerfect Office 12 Home Edition which
If you want to seem really wizardly with Word then try turning on the function key display. If you want to seem really wizardly with Word then try turning on the function key display. This is an extra bar at the bottom of the Word window. It shows all the
PowerPoint Action buttons are a handy tool for creating side trips within your presentation. By Helen Bradley While you might think of PowerPoint presentations as proceeding from the first slide to the last without interruption, that’s not always the best solution for your presentation needs. Just like traveling on side
We’ll tell you about some of the features in Small Business Server 2003 that we really like and which, in some cases, don’t get the attention that they deserve. NEAT STUFF TO DO WITH SBS There are plenty of things that you can do with Windows Server 2003 and the
The Data table tool in Excel has been around for years and makes data tables very quickly and easily. By Helen Bradley Consider this situation, you’re about to borrow money for a house and you need a quick reference of loan amounts, interest rates and payments. You want it on
Microsoft’s Small Business Server has been around for many years but we’ve been pleasantly surprised with the Small Business Server 2003 release. SBS ROCKS Microsoft’s Small Business Server (SBS) has been around for many years but we’ve been pleasantly surprised with the Small Business Server 2003 release. We’ve been trying
Collaborating with Word documents has become much easier over the years, it is a great way for someone to review, edit and comment on a document without altering the original text. Collaborating with Word documents has become much easier over the years, it is a great way for someone to
With more and more people using LCD screens on the desktop and on portable computers there are more people who would benefit from the Windows ClearType Tuner option now rather than when it first came out. With more and more people using LCD screens on the desktop and on portable
Even poor old Microsoft Word can’t miss getting involved in the US election. Even poor old Microsoft Word can’t miss getting involved in the US election. First there was ‘Rathergate’ with documents supposedly from the 70’s being produced on more modern software. We didn’t cover that here in Office Watch
We’ve had a spate of messages from Outlook users who report that they cannot turn off their Junk Mail filter. These people have switched the filter off and yet messages still go to their Junk Mail folder. We’ve had a spate of messages from Outlook users who report that they
We explain what the “Student and Teacher” edition of Office 2003 is and why it’s a good choice and great value for many people. One of the cute marketing tricks of recent years has been Microsoft’s bundling of some Office components into a ‘Student and Teacher’ edition. We’ve mentioned this
Microsoft has released its monthly batch of security updates for September 2004 and there are some that affect Office as well as Windows generally. Microsoft has released its monthly batch of security updates and there are some that affect Office as well as Windows generally. In this issue we’ll try to
The dust has settled around Office 2003 Service Pack 1 and now its possible to make some informed judgments about updating Office 2003. The dust has settled around Office 2003 Service Pack 1 and now its possible to make some informed judgments about updating Office 2003. For all the basic
Many of you will remember the Copernic web search program from years past. Well now they’ve entered the market for finding documents and emails on your computer with Copernic Desktop Search. Many of you will remember the Copernic web search program from years past. Well now they’ve entered the market
With the release of the Windows XP Service Pack 2 it makes updating to Office 2003 Service Pack 1 even more worrying than usual. With all the talk about the Windows XP update there’s almost no talk about the other large update from Microsoft – for Office 2003. The last