August 1, 2010

Review of Free Antivirus Software - from PC World

Free Antivirus Software Review from PC World 08-24-2009

You can find lots of free software made to stop worms, viruses, and other malware. We tested several such programs to find the free antivirus you can depend on. Edited by Nick Mediati.
Aug 24, 2009 8:30 pm


1. Avira AntiVir Personal

Avira Antivir Personal offers great, thorough protection and top-notch scan speed, but some 
nontechies might find its interface frustrating.
Full ReviewTest Report


2. Alwil Avast Antivirus Home Edition

Avast Antivirus Home Edition provides solid antimalware protection and a good set of features, 
but its outdated interface needs a makeover.
Full ReviewTest Report


3. AVG 8.5 Free

Though AVG 8.5 Free has a good, straightforward interface and useful blocking of Web-based 
attacks, its malware blocking is below average.
Full ReviewTest Report


4. Microsoft Security Essentials Beta

An effective but somewhat slow utility, Microsoft Security Essentials will be a solid contender 
when it comes out of beta around the end of 2009.
Full ReviewTest Report


5. PC Tools Antivirus Free Edition

PC Tools Antivirus, which neglects to detect spyware, allows far too many pieces of malware 
through for it to realistically protect any PC.
Full ReviewTest Report


Avira AntiVir Personal
Pros

Excellent detection and disinfection

Top-notch scan speed
Cons

Interface is unfriendly to novices

Daily pop-up ads for paid version
Bottom Line

Avira Antivir Personal offers great, thorough protection and top-notch scan speed, but some nontechies might find its interface frustrating.

Avira AntiVir Personal Free Antivirus Software

AntiVir Personal Review, by Erik Larkin August 24, 2009

Avira AntiVir Personal's excellent malware detection, disinfection, and scan speed earned it the top spot in our ranking of free antivirus software. Its interface could be better, though, and using the app means putting up with daily pop-up ads.

In AV-Test.org tests, AntiVir's 98.9 percent overall malware detection rate was the best among the software on our chart (the unranked Panda Cloud Antivirus outperformed it). AntiVir was also tops in proactive-protection tests that use two- and four-week-old signature databases to simulate the detection of new, unknown malware, with rates of 52.7 percent and 45.5 percent, respectively.

The strong performance continued in disinfection tests. AntiVir found and disarmed all of the rootkits and other malware infections tossed at it, though (like all the free antivirus software we tested) it tended to leave some remnants, such as relatively harmless Registry changes, in place.

Avira's program was not just the most thorough tool of the group, but also the fastest. It led in speed tests for both on-demand scans (which you schedule or start manually) and on-access scans (which happen automatically during tasks such as copying files).

If AntiVir's interface were as polished as its malware-fighting ability, it would be a no-brainer recommendation. But its daily pop-up ads for Avira's paid ID-theft protection software could easily annoy many users, and at times its interface feels better suited to advanced users. For example, the program's installer prompts you to select among ‘extended threat categories'. Some are obvious, such as games or jokes, but you might be forgiven for not knowing whether to pick ‘unusual runtime compression' (listed in Avira's online help as ‘Files that have been compressed using an unusual tool and are therefore suspicious').

In a similar vein, its detection pop-ups offer too many choices and don't suggest the option most appropriate for the average user. It checks the ‘Deny access' option by default, but that choice would leave the discovered malware sitting on your PC; you would continue to receive warnings until you opted to delete or quarantine the discovery (you can also choose to rename or ignore the file).

Such less-than-friendly default behaviors make Avira AntiVir Personal a better choice for tech-savvy users who know how to muck about in the settings. If you're willing to put up with a somewhat clumsy interface and the recurring pop-up ads, in return you'll enjoy top-notch, free protection against malware. It's not a bad trade-off by any means.

Alwil Avast Antivirus Home Edition
Pros

Capable malware detection

Fast scan speed
Cons

Outdated, confusing interface
Bottom Line

Avast Antivirus Home Edition provides solid antimalware protection and a good set of features, but its outdated interface needs a makeover.

Alwil Avast Antivirus Home Edition Free Antivirus Software

Avast Antivirus Home Edition Review, by Erik Larkin August 24, 2009

Avast Antivirus Home Edition, developed in the Czech Republic, offers capable malware detection and faster-than-average scan speed, both of which helped propel the app to the number two spot in our rankings of free antivirus software. Its clunky interface badly needs updating, however.

In AV-Test.org malware-detection tests, the program blocked a respectable 98.2 percent of samples out of a malware "zoo" consisting of about a half-million files. That wasn't enough for Avast to top the best performers, Avira AntiVir Personal and the unranked Panda Cloud Antivirus, but it's still a good showing. Avast didn't do quite as well in proactive-detection tests, which simulate how well a program would fare against new and unknown malware: Its catch rates of 46.1 percent (two-week-old signatures) and 41 percent (four-week-old signatures) put it in fourth place.

The app was relatively nimble at on-demand scans (which you start manually) and on-access scans (which occur automatically when you save or use a file), placing second in each test (behind Avira in both cases). It issued just one false positive (labeling harmless software as malicious).

In disinfection, Avast nearly matched the top performers (Avira and Microsoft Security Essentials), detecting and disabling 90 percent of the rootkits used in our tests. All three apps, however, also left behind Registry entries and failed to reverse all of the changes that the malware had made.

While Avast does well as a malware blocker and remover, it fares poorly as a program that people have to interact with. Its outdated interface has sections that look entirely different depending on whether you're running a scan, checking status, or changing settings. The scanning interface mimics a music player, but you probably won't be singing its praises. Be sure to read the how-to guide that pops up the first time you use the program, unless you enjoy scratching your head and growling at your monitor.

The Avast product is the only free antivirus software in our test group that requires you to register within 60 days to receive a free license key. It's also the only app that scans Web traffic for malware (AVG 8.5 Free's LinkScanner scans Web traffic for the attacks that can presage malware, but not for the malware itself), and it scans e-mail traffic as well.

Avast Antivirus will do a decent job protecting a PC from malware, but if you're willing to put up with a less-than-perfect interface (and some ads), you're better off going with Avira's top-notch blocking.

AVG 8.5 Free

Pros

Good at PC disinfection

Ability to scan Web traffic and e-mail
Cons

Middling malware detection

Slow on-demand scans
Bottom Line

Though AVG 8.5 Free has a good, straightforward interface and useful blocking of Web-based attacks, its malware blocking is below average.

AVG 8.5 Free Antivirus Software

8.5 Free Review, by Erik Larkin August 24, 2009

AVG Technology's AVG 8.5 Free antivirus app has solid features and a generally polished interface, but its relatively lackluster showing at malware detection pulled it down to third place in our rankings of free antivirus software.

AVG detected 95.8 percent of AV-Test.org's malware zoo of about half a million Trojan horses, worms, spyware, and other nasties. Though that isn't a terrible result, it doesn't stand up well against the detection rates of the top performers, Avira AntiVir Personal and the unranked Panda Cloud Antivirus. Hampering AVG's overall score was its 95.3 percent detection rate for Trojan horses, the most common type of malware in the set, as well as its surprisingly poor 88.8 percent detection rate for spyware that tries to steal financial-account passwords.

AVG's proactive detection and scan speed were both in the middle of the pack. The software was third in tests that evaluate the program's ability to block new and unknown malware. It ranked the same for on-access scan speed, which comes into play when you open or save a file. For on-demand scans it was a lot pokier (sixth out of nine), but since you can schedule the scans for when you're not around, a slower speed isn't as problematic here.

This long-standing program performed well in system disinfection. In one test, it detected and disabled all ten malware infections. It tended to miss less-critical things such as Registry changes or blocked access to the Windows Task Manager, but so did all the other free antivirus software we tried. AVG also did well in avoiding false positives, making only one boy-who-cried-wolf mistake.

The AVG package offers a good set of features. Its LinkScanner component will try to detect and stop attacks on Web pages while you surf, and it will provide safety ratings for search results (you can download LinkScanner by itself).

The program can scan e-mail, too, something only Avast Antivirus Home Edition and ClamWin Free Antivirus also offer. But while that is a beneficial extra, the program's AVG toolbar with search options doesn't afford any additional protection; you can safely skip it during installation. You'll likely find most of the default settings appropriate, except for the daily full scan at noon. You can choose another time of day in the installation wizard, but to change it to a weekly scan you'll have to adjust the settings after installation.

AVG displays an ad for its paid product at the bottom of the main program window, along with an occasional pop-up ad. Neither is especially intrusive, and the interface is generally straightforward enough for use on a daily basis.

AVG 8.5 Free is well-rounded overall, but its second-tier malware detection rate should make you consider one of the better-performing programs first.

Microsoft Security Essentials Beta

Pros

Nearly perfect in disabling infections

Good proactive detection
Cons

Slow on-access scans

Merely decent malware detection
Bottom Line

An effective but somewhat slow utility, Microsoft Security Essentials will be a solid contender when it comes out of beta around the end of 2009.

Microsoft Security Essentials (Beta) Free Antivirus Software

Security Essentials Beta Review, by Erik Larkin August 24, 2009

Microsoft has a new free antivirus utility coming to replace its now-defunct OneCare suite. And while it was still in beta as of this writing, Microsoft Security Essentials shows much promise: In our tests it was decent at detecting malware, particularly in proactive tests that simulate the handling of new, unknown malware. It took fourth place in our rankings of free antivirus software. The main drawback of the tool, which will launch by year's end, seemed to be its slow scan speed.

Since Microsoft says the beta tool is feature-complete and simply undergoing fine-tuning now (and since it had a limited public beta release in early summer), we decided to evaluate it alongside other free antivirus software for our recent roundup. Keep in mind, though, that its performance may change before its final release.

One thing we hope will change is its relatively poky scan speed. It was the slowest in our on-access scan test, which judges how quickly scans run when you copy, open, or save files. The app's Dynamic Signature Service may account for some of that: When Security Essentials sees a potentially malicious file that doesn't match known malware, it contacts Microsoft servers for additional analysis. The feature likely affords greater protection owing to the use of the latest signatures online, but it may also introduce some delay if Security Essentials has to wait for a response.

The app's ability to detect and block malware was neither especially good nor particularly bad. Its 97.8 percent overall detection rate put it in fourth; but it did well in proactive tests, which use two- and four-week-old signature databases to simulate how well a program detects new, unknown malware. Its results of 52 percent and 43.8 percent, respectively, were second only to those of the top-ranked Avira AntiVir Personal, our overall winner.

Microsoft's program put up no false positives (flagging of benign software), and it got a near-perfect score overall in detecting and cleaning rootkits and malware infections. It detected and disabled every infection, and although it left behind several changes to the Registry and other areas (as every free app did), they couldn't cause further harm.

Security Essentials has a pleasing interface, is simple to use, and has appropriate defaults. Its warning pop-ups let you deal with an issue quickly or dig in for details. If Microsoft can improve the detection rate a bit--and rev up the scan speed more than a bit--before the program's final release, Security Essentials could turn out to be a real contender in the free antivirus arena.

PC Tools Antivirus Free Edition

Pros

Good worm detection

Decent malware-infection cleanup
Cons

Purposely neglects to detect spyware

Poor heuristic detection
Bottom Line

PC Tools Antivirus, which neglects to detect spyware, allows far too many pieces of malware through for it to realistically protect any PC.

PC Tools Antivirus Free Edition Software

Antivirus Free Edition Review, by Erik Larkin August 24, 2009

PC Tools Antivirus Free Edition does a remarkably poor job of keeping a PC safe, largely because it holds to a now-archaic distinction between spyware and other forms of malware. It came in at number five (out of six contenders) in our rankings of free antivirus software.

In an age when a single baddie might spread like a worm, steal passwords like spyware, and allow backdoor-style remote control of an infected PC, most security vendors recognize that labels such as "Trojan horse" or "spyware" are secondary to the idea of keeping everything bad off PCs. Hence today's use of malware as a catch-all term for attack software.

However, PC Tools says that its free program will not detect what it deems spyware (a critical point not emphasized on the company's Web site). And that limitation may account for its awful detection and blocking results: The app left the door wide open for about half of the malware in our tests.

And while the app purports to protect against Trojan horses, a common malware type, it detected only 46 percent of such software in AV-Test.org tests. It did better in detecting worms, but its catch rate of 83 percent for the self-spreading malware still didn't compare with the detection results we saw from Avira AntiVir Personal, the overall leader among the free antivirus software we tested.

Unsurprisingly, the poor performance carried over to AV-Test.org's heuristic tests, which use two- and four-week-old signature databases to simulate how an app will handle new and unknown malware. PC Tools Antivirus came in last, with respective results of 33 percent and 36 percent (in contrast, Avira, the best app we tested, scored 52 percent and 45 percent, respectively). It was decent in detecting and removing existing infections, missing only one out of ten--but most of the tested antivirus apps got them all.

While the program installs smoothly and looks relatively good, it doesn't schedule a scan by default, nor does it automatically update. The software will notify you once a day (by default) if an update is available, but to make it do the updating by itself, you will need to turn on the Smart Update feature.

In short, there's no reason to choose PC Tools Antivirus when other free apps can truly keep your PC safe. Fortunately, the behavior-based PC Tools Threatfire supplemental utility is as good as Antivirus Free Edition is bad.

Source:
http://www.pcworld.com/reviews/collection/1597/free_antivirus_software.html

July 16, 2010

Five Reasons You Don't Need Microsoft Office 2010

By Julie Sartain, PC World, July 15, 2010

Have you looked at the new Microsoft Office 2010 yet? How many of its few, new features does your company really need? And are these features worth the investment? Here are five reasons your company doesn't need to purchase Office 2010.


1. No More Upgrades
You can access the Microsoft Web site right now and purchase one of three versions of Office 2010. Office Professional is $499, Home & Business is $279.95, and Home & Student is $149.95. However, if you are looking for an upgrade price, forget it. Microsoft has decided not to offer upgrade pricing anymore.

After searching thoroughly for information about upgrades, I finally found the answer on a Microsoft FAQ page, and it plainly states that in order to "simplify" things, they are no longer providing version upgrades. You can still find better list prices from various independent vendors if you search the Internet. For companies that have access to academic pricing, vendors such as JourneyEd provide better discounts than Microsoft. 

Nonprofits can find steep discounts through Tech Soup.
Next to Windows Millennium, Vista, the Office 2007 Ribbon, and the Kin bombshell, this is the worst marketing decision Microsoft has ever made. If these other four major blunders have not already soured you on Microsoft, this new upgrade policy will surely make you sick. Maybe this is a good time to dump the software king and start looking for other options.

2. Free Alternative Programs
Speaking of other options, there are always alternatives, such as OpenOffice from OpenOffice.org, a Microsoft Office semi-clone that's free to download for anyone who wants it. There are some areas that could use improvement, and a feature by feature comparison shows some differences in the visuals such as graphics, animations, and special effects. But Microsoft has never been strong on graphic capabilities either, so you won't miss much by switching to OpenOffice.

Other alternative programs include IBM's Lotus Symphony, Google Docs, and Zoho--all free--and ThinkFree, which has both a free and a fee-based version. All of these programs offer similar features and functionality to Microsoft Office; some are actually better, some are just okay. However, since they are free, it won't cost anything but your time to download and review them as possible replacements to Office 2010.

3. Few New Features, Nothing Impressive
Microsoft redesigned the big, round Office button. They added an Ignore button in Outlook that deletes selected messages and all messages currently in your Inbox, plus all future messages related to that message thread--or you can just tag the unwanted messages as junk mail. They also added a new button called Screenshot that lets you take screen shots from within the program--or you can press Alt-Tab to exit out and use the Alt-Print Screen button on your keyboard.

You can save Word docs to SharePoint--or just copy and paste them in. You can add miniature line charts to individual cells in Excel--or just shrink the normal charts and place them on the screen anywhere you want them. And OneNote now has color coding. For graphics, the new photo-editing tools provide some simple artistic effects that you can add to images in Word, Excel, and PowerPoint--similar to Photoshop, Paint Shop Pro, and Corel Paint's stock effects, but nowhere near as versatile or powerful.

Other new features include paste preview, so you can preview the page before you paste items into your document--or you could just go ahead and paste the items in, then select undo if you don't like how it looks. In Word, there's a new drag-and-drop navigation pane, but it only works if you use the Word Styles to define headers and subheads and so forth. And you can now create videos or convert presentations to videos in PowerPoint--this one feature might be useful if MS has also upgraded the graphic size limitations.
There are a few other minor features. However, I still don't think these are anything to get excited about, and they're certainly not worth the new ‘non-upgradable' price tag.

4. The Ribbon Changed, but It's Still a Bomb
The Ribbon toolbar has been added to all the other Office Suite programs, including Outlook and OneNote. Well, that's just great. I hated it in Office 2007 and I still hate it. After using it for weeks and cursing it daily, I finally purchased a program from AddIn Tools that, when installed, redesigns the Ribbon bar menus back to the old Office 2003 menus. Then I created two identical spreadsheets and performed the same tasks on each, one with the Ribbon bar menus and one with the old 2003 menus. The Ribbon bar spreadsheet took almost twice as long to complete. However, since one trial test isn't really fair, I created four more spreadsheets and half a dozen Word documents, all with the same results.

The only real change worth mentioning on the Ribbon bar is its capability to customize the menus. If I am forced to use this program as a result of some job I take on, the first thing I will do is customize the entire Ribbon to resemble, as closely as possible, the 2003 drop-down menus, which were more efficient in my tests.

5. Simultaneous Editing
Last, Microsoft and several reviews I have read all tout this new capability to perform simultaneous editing, which is nothing more than a shared document feature. If you leave a document open on one computer, then try to open it on another, you get the "file in use" message with options to read only, create a copy, or notify when available. With Office 2010, you can edit the original or allow multiple users to edit the same document simultaneously. The 2010 status bar informs you of the other users on board and the changes they are making. 
You can also synchronize documents on your hard drive with the originals on a server.
This not a cool function. It actually creates a lot more confusion than it's worth, especially if you have ever used Adobe Acrobat to perform these same tasks. Every time I have ever used sharing and collaboration in Acrobat, it has resulted in chaos with one user changing what another just wrote or edited causing conflict between all participants because the original is no longer available unless someone had the foresight to make a backup copy. And the option to synchronize documents is no big deal either. Almost every program out there will synchronize files among devices, including your servers.

Bottom Line
So, the bottom line is this: forget Microsoft Office 2010. It's not worth the money, the few updated features, the prolonged learning curves, the decreased efficiency, or the headaches.
Try one of the free alternatives or give Corel's WordPerfect Suite a second look. On the Corel Web site, the professional, full version of Office X5 costs $399.99, $100 less than Office 2010, and the upgrade version is only $259.99.

Besides that, Microsoft has always been lousy with graphic options and programs; that is, they are slow, memory intensive, and crash your computer if you use too many or attempt to use high resolution images. Corel and Adobe have always been superior to Microsoft in the graphics arena. Hey, we can dream that Adobe will create an office suite to complement its Creative Suite.


July 15, 2010

Closer Look At Office 2010

By Ed Bott, April 29, 2010 from his Blog Office 2010: a deeper dive at:
http://www.zdnet.com/blog/bott/office-2010-a-deeper-dive/2042?tag=mantle_skin;content

In every sense of the word, Microsoft Office is huge. Hundreds of millions of people use at least one of the programs in the Office family every day—in enterprises, small and medium-size businesses, homes, and schools. When Microsoft released Office 2010 to manufacturing on April 15, it kicked off an upgrade cycle that will last for several years.


I’ve got a unique perspective on Office. I’ve written at least one book about every version of Office since 1994 (that’s eight releases and 10 books in 16 years, for those who are keeping score). I’ve also written countless magazine articles and blog posts, all of them based on extensive, hands-on experience with the individual Office products. This time around is no exception. I’ve spent the last six months immersed in Office 2010, using all the core programs day in and day out, digging in to see what’s new, what works, and what’s still annoying after all these years. In this post (first of a series), my goal is to give you a wide-ranging overview of what’s in Office 2010, so you can decide whether it matters to you.

Judging by the Talkback comments I’ve seen in various posts here and in quick-and-dirty reviews elsewhere, I know there’s a lot of misconception about what’s in Office 2010. I’ve read a few comments that dismissed the changes in this edition as superficial eye candy, hardly worth the upgrade. And I understand how easy it would be to come to that conclusion if you simply poke at Word and Outlook for a couple hours (or even a couple days), and then fire up the other Office apps for a quick lap around the track. With that sort of superficial look, it’s easy to pass judgment on Office as too big, too complicated, too expensive, too old. (Amusingly, most reviewers I’ve read find some pet feature that doesn’t work exactly as they would have designed it and then harp on that for the bulk of the review. It’s as predictable as the sunrise.)

Honestly, I wish Office 2010 was a minor upgrade. If it were, I would have been done with this book about six weeks ago and I’d be sitting on a tropical beach sipping mai tais right now. But the reality is different: Office 2010 is a surprisingly deep, thoughtfully designed, well-engineered collection of software programs. The more I dig, the more I like the small but useful touches that the Office design team has wrought. That’s not just my opinion, either. I’ve heard variations on that sentiment from dozens of correspondents, including a few who are Office skeptics.

It is true that the core programs in Office—Word, Excel, Outlook, and PowerPoint—are mature, as befits their age. There are only a handful of truly new features to be found, which I point out in the balance of this post. Much of the work in Office 2010 is cleanup and polishing, smoothing over rough edges, making common features work the same across apps, improving performance. In some striking ways, Office 2010 is to its predecessor as Windows 7 is to Windows Vista. And that’s not a bad thing.

Microsoft has made a substantial investment in online features for this edition. With Office Web Apps, it’s delivered a version 1.0 release of Word, Excel, PowerPoint, and OneNote, with a common feature set that works on Windows Live SkyDrive for consumers (or will, in a few months when the retail version is released) and as part of SharePoint servers in big corporations. It’s not a competitor to Google Docs—and it might never be, because Microsoft is still in the business of selling shrink-wrapped software. But Office Web Apps offer a decent feature set and fairly significant promise. I’ll look at those web-based pieces in a follow-up post. Today I’m focusing exclusively on the desktop version of Office.

If you were hoping to see a simpler lineup of Office editions in 2010 than in its predecessors, I have only a little good news. The lineup is more logical and consistent, but the number of available combinations is still confusing, and the licensing story has, sadly, become more complex than ever. If you have questions about the details of what’s in each edition, what they’ll cost, and when they’ll be available for sale, see the last page in this package, Prices, packaging, dates, and other details.

As part of my research for this post, I fired up copies of Office 2003 and Office 2007 in virtual machines and used them alongside the new edition for a few days. If you’ve already deployed Office 2007, at least some of these features will be old news. But for anyone who has stuck with Office 2003 for all these years and still uses it heavily, the cumulative changes are overwhelmingly positive, and it’s hard to imagine an objective reason for not upgrading.

Here’s what I cover in this post:

Page 2: The Ribbon, finished Every program now has been ribbonized, including Outlook, OneNote, and Publisher. But that’s not the only interesting UI change.

Page 3: What’s new in Word, Excel, and Outlook? These are the programs everyone uses, in the office and at home. Are there any new killer features?

Page 4: Prices, packaging, dates, and other details You’ve got questions, I’ve got the answers you’re looking for.
Page 2: The Ribbon, finished

In Office 2007, Microsoft delivered the most sweeping change to its user interface ever with the introduction of the Ribbon. Well, perhaps I should say partial introduction. In Office 2007, three major Office programs—Outlook, Publisher, and OneNote—stuck with the old-style menus and toolbars, giving Office 2007 a distinctly unfinished feeling.


That schizophrenic feeling is gone in Office 2010. All of the Office programs now fully support the Ribbon interface. The changes are especially welcome in Outlook, where many previously buried options are now much easier to discover.








Compared to the Office 2007 interface, this iteration is also cleaner. The ribbon menus are flatter, and overall there’s more white and less color, making everything a bit easier on the eyes. But the single biggest change is the return of the File menu. The design in Office 2007 took many functions that had been on the File menu in previous versions (Open and Save dialog boxes, Print functions, and so on) and buried them on the Office menu, which only appeared when you clicked the Office orb in the upper left corner. That was a usability gaffe, and it’s been fixed in Office 2010. At the far left edge of the ribbon menu in every Office app is a File option. It’s brightly colored, and unlike the other tab headings it opens a full-page informational display called Backstage view. Here are two examples, from Word 2010 and Outlook 2010.






When I first saw a demo of Backstage view last summer, I didn’t exactly yawn, but I also don’t remember being particularly impressed. In six months of daily usage, though, it’s really proven to be a smart design. Most of the actions that are now in Backstage view used to be on menus, which led to dialog boxes filled with tabs. (Office 2003 carried this design philosophy well past the breaking point.) Now, you can view information about the current file or e-mail message, manage a list of recent menus and recent places, convert documents, handle printing tasks, and more, without leaving the program window. Interface innovations from Office usually show up a few years later in Windows—ribbon menus, for example, are in many of the built-in apps in Windows 7. I will not be surprised to see some of the Backstage view concepts appear in Windows 8.

One of my biggest complaints about the Office 2007 Ribbon was its lack of customization options. Developers could build Add-in tabs, and a few enterprising third-party developers came up with tools that offered some minor tweakability options, but none of those options were particularly satisfying. By contrast, all Office 2010 apps include a complete set of customization tools for the Ribbon. Here’s the dialog box for Excel:






You can hide built-in tabs, move tabs and groups of commands up and down, rename tabs and groups, and create custom tabs with your own arrangement of favorite commands. You can also export those changes for use on a second PC. One nit: The export option creates a single file that includes changes for the ribbon and the Quick Access Toolbar. You can’t back up those elements separately, and you can’t merge changes between two Office installations. Maybe in Office 15.

The level of consistency between apps in the core Office programs is impressive, especially in terms of how each handles graphics and pictures. The nuts and bolts of creating and editing a particular type of graphic object—pictures, screenshots, SmartArt, charts, and so on—are remarkably similar in different programs. This is in sharp contrast to text-handling features, unfortunately, where the baggage of legacy features is particularly apparent. There are numerous trivial and pointless variations in the way similar text-editing tasks are handled, depending on which program you’re using. Keyboard shortcuts are filled with exceptions (especially in Outlook), and the path to common dialog boxes from different programs can be just different enough to be annoying.

Page 3: What’s new in Word, Excel, and Outlook?
The programs that most reviewers will look at are the big three of business: Word, Excel, and Outlook. Here’s a checklist of some of the new features you’ll see in each of these programs. Is any one of them a killer feature? You be the judge. (I’ll look at the rest of the Office family, including OneNote and PowerPoint, in the next installment. OneNote in particular deserves more space than a few paragraphs.)

Word 2010
One feature I’ve found absolutely indispensable while working on this book is Word’s new Navigation pane, which replaces the old Document Map from previous versions. It sits along the left side of the document (if you choose to make it visible), and shows one of three views, selectable via tabs at the top of the pane. The screenshot here shows the Word 2010 version on the left, with the Word 2007 version on the right (for the record, that Word 2007 view is almost identical to the Word 2003 version). Not only is the Word 2010 version easier to read, but the headings are live, which allows you to drag section headings up or down to rearrange the document quickly. You can’t do that in earlier versions of Word.




The third tab in the Navigation pane actually incorporates most of the search functions that previously required opening the Find dialog box. When you type a word or phrase in the Search box, every match is highlighted in the document itself, and snippets from around each match are displayed in the Navigation pane. Instead of having to page through the document or click the Next button repeatedly to find the reference you’re looking for, you can scan quickly through the list. This is one of many features where a subtle design change actually makes a huge difference in productivity.






Excel 2010
Most of what’s new in Excel is strictly for numbers geeks. One thing I was surprised to discover when I dug deeply into Excel was the very long list of old functions that have been completely rewritten, reportedly to be faster and more accurate. There are 38 functions in all on this list, and you can find them in the Function Library, under the Compatibility category, where they remain for use with Excel 2007 and earlier. Most are engineering and statistical functions and have been replaced with functions that have slightly different names (T.TEST instead of TTEST, for example).


For anyone who works with very large data sets from external databases—millions of rows, which is more than will fit in an Excel worksheet—the new PowerPivot add-in is essential. It pulls data (from multiple sources, if necessary) into Excel, where it can be analyzed quickly. A sexier new feature for non-math geeks is the Sparklines feature, which allows you to add miniature visualizations directly into a table to show trends, as shown here.






Outlook 2010
The Ribbon makes an enormous difference in the usability of Outlook and is certainly the most obvious change. I want to highlight two interesting new features here. The first is a quick-and-easy macro-building tool called Quick Steps. The idea behind a Quick Step is that you string together a group of commands (picking them from a list) and apply the finished product to a button on the Home tab and, optionally, to a keyboard shortcut. You can then apply that entire sequence of commands with a single click. The screenshot here shows details of a Quick Step. This one is a classic “tickler file” macro, ideal for any message that demands follow-up in a week or a month. The Defer Till Next Month command I created appears on the Home tab; clicking it moves the selected message to a folder I created called Follow Up, and then applies a follow-up flag to the message with a reminder date of the end of next month.




Outlook also has many performance improvements, offers support for multiple Exchange accounts, and optionally groups messages into conversations. The latter is a good idea, but in practice it has one flaw that makes it less than perfect and even a little dangerous. Conversation grouping in Outlook 2010 is based on the message subject. There’s a very welcome Ignore option that automatically sends the selected conversation and all future messages to the Deleted Items folder automatically—it’s tailor-made for scenarios where you’ve been cc’d on a long message thread that you’re not the least bit interested in. Everything works fine when the subject is detailed and unique, but if your correspondents send messages with more generic subjects, you could end up with a new, important message being automatically deleted because it had the same subject as a conversation you ignored weeks or months ago. Oops!


Page 4: Prices, packaging, dates, and other details

You’ve got Office questions, I’ve got answers.

What’s in each Office edition?

Consumers have three choices, and so do businesses. You can see the official lineup here. I also wrote about this subject when the versions were announced last year. For Office 2010, Microsoft has cut the Ultimate and Enterprise editions as well as the OEM-only Basic edition.

All editions include Word, Excel, PowerPoint, and OneNote and are available in 32-bit and 64-bit versions. Some editions include additional apps beyond the four core programs, as I’ve noted in the list below.

The home editions:

    * Microsoft Office Home and Student 2010 The full retail version can be installed on up to three PCs in a single home. It includes the four core apps only, and the license agreement specifically prohibits its use “in any commercial, nonprofit or revenue-generating activities, or by any government organization.”
    * Microsoft Office Home and Business 2010 Targeted at small businesses and power users, it adds Outlook to the core apps.
    * Microsoft Office Professional Academic 2010 Adds Outlook, Publisher, and Access. Available to anyone with an @__.edu address, it is sold only through authorized academic resellers.

The business editions:

    * Microsoft Office Standard 2010 Adds Outlook and Publisher to the core apps. Available via volume licensing only.
    * Microsoft Office Professional 2010 Adds Outlook, Publisher, and Access. Sold through Retail channels only.
    * Microsoft Office Professional Plus 2010 Includes Outlook, Publisher, Access, SharePoint Workspace (formerly Groove), Communicate, and InfoPath. Available via volume licensing only.

What are the system requirements?

Office 2010 runs on Windows XP (SP3 required), Windows Vista with SP1 or later (32-bit or 64-bit), Windows 7 (32-bit or 64-bit), Windows Server 2003 R2 (32-bit or 64-bit) with MSXML 6.0 installed, Windows Server 2008 (32-bit or 64-bit), and Windows Server 2008 R2. As for hardware requirements, you’ll need at least 3 GB of hard disk space; beyond that, any modern PC will work acceptably. The official list from Microsoft is here.

Are there any notable changes in licensing terms?

As always, every version of Office is licensed for installation on one PC. In the case of retail versions, the license says, “You may install another copy of the software on a portable device for use by the single primary user of the licensed device.” That extra installation is not provided with OEM copies, which are sold with new PCs.

Update: As in previous versions, the Home and Student edition is licensed for installation on three PCs in a single household and may not be used for commercial purposes. If you purchase this edition using a product key card, however, you get only one installation.

How much will each edition cost?

Microsoft has abandoned upgrade pricing for Office 2010. For retail full packaged products, the estimated retail prices (typically discounted by resellers) are as follows:

    * Office Home and Student: $149
    * Office Home and Business: $279
    * Office Professional: $499
    * Office Professional Academic: $99

For volume licensing editions, you’ll have to talk to a reseller.

Didn’t you leave out Office 2010 Starter Edition?

Yes, deliberately. On new PCs, OEMs have the option to install Office 2010 Starter edition. You cannot buy it at retail outlets. It’s not a trial copy, and it has no “time bomb” that causes it to stop working after a few months. It includes only two programs, Word Starter and Excel Starter, both of which allow you to create, edit, and save documents but lack access to advanced features. Because Starter Edition also contains the full installation code for all three retail editions, it can be converted to a full version by purchasing a product key card.

How do Office product key cards work?

For the first time, Microsoft is selling Office in a “product key card” format. That package, which is discounted approximately 20-30% compared to a full retail packaged copy, has the following restrictions:

    * It includes the 25-character product key only and does not include installation media.
    * It is designed to activate Office on a single PC preloaded with Office 2010. (After Office 2010 is available for retail sale, Microsoft promises to offer downloads of the software “for a limited time.”)
    * This product is licensed for a single installation on a single PC. It does not include the right to install the software on a second, portable device.
    * The license cannot be transferred to another PC.

Estimated retail prices for product key cards are as follows: Office Home and Student: $119; Office Home and Business: $199; Office Professional: $349

If I am running a 64-bit Windows version, should I install 64-bit Office?

The short answer is, probably not. I know that sounds counterintuitive. In the great tradition of Spinal Tap, 64 is bigger than 32, so it must be better. Right? The problem is that for most people there’s no compelling advantage to a 64-bit Office version unless you want to open spreadsheets or database files bigger than 2GB in size. If you do install a 64-bit Office edition, you’ll find that most add-ins don’t work, because they were written for a 32-bit environment. Even Microsoft cautions against blindly answering yes to the 64-bit question:

    Microsoft Office 2010 introduces native 64-bit versions of Microsoft Office products to take advantage of this larger capacity. For example, this additional capacity is needed only by those Microsoft Excel users who require Excel spreadsheets that are larger than 2 gigabytes (GB). The 32-bit version of Office 2010 provides the same functionality and is also compatible with 32-bit add-ins. Therefore, the 32-bit version of Office 2010 is installed by default.

Are there any changes to file formats?

If you’re currently using Office 2003, the answer is yes, across the board. Office 2010 uses the XML-based default formats introduced in Office 2007, which makes the upgrade from Office 2007 much easier. The only noteworthy format that is unique to Office 2010 is the new format for OneNote, which supports backups and a built-in Recycle Bin. If you use the Office 2007 OneNote format, you lose those new features but can share notebooks with PCs running OneNote 2007.

When will Office 2010 be available for sale?

Microsoft TechNet and MSDN subscribers can download the product now. The official launch event for businesses is May 12. Consumers will be able to buy shrink-wrapped product in June; Microsoft is still being coy about the specific date.


Ed Bott is an award-winning technology writer with more than two decades' experience writing for mainstream media outlets and online publications.



July 14, 2010

Microsoft Office 2010 Starter Is Not Worth The Price

June 22nd, 2010 by K. T. Bradford from www.blog.laptopmag.com

We’ve known for a while that this was coming and that Starter would have some limitations. I myself predicted that this “choice” would send consumers running for free alternatives like OpenOffice. After having used Starter, I’m sure of it.

Office 2010’s Starter Edition is meant to give users a taste of the new suite while taking away enough features to ensure they’ll want to upgrade. The moving ad in the corner, the even more annoying ribbon on top (I know, I didn’t think it could get more annoying, either), and the sidebar taking up way too much space in my work window are definitely enough to annoy me away from the program. Then there are these lists of all the things Word Starter and Excel Starter won’t do. My favorites:
  • No Ribbon customizations
  • No footnotes/endnotes
  • No citations or bibliography
  • No comments
  • No Track Changes
  • No document protection
  • No PivotTables/Pivot Charts
  • No connections to external data
  • No changing column and row headings
There are a few other differences to note here. Users can still open documents with these and other features, but Starter won’t create or modify any of them. It’s like Microsoft took a list of things students were most likely to need and made sure to hamper or disable them all.
The most annoying aspect in my eyes is the sidebar on the right. It takes up a lot of pixels. So many that, when on a standard 1024 x 600 netbook screen, there isn’t always enough room to see a full page horizontally at 100 percent zoom. You have to take it down to 90 percent unless you like wider margins.


This sidebar is persistent because that’s where the ad unit is. Right now it appears to only run Microsoft ads, though that will change soon, I’m sure. Thing is, the MS ads are bad enough — they won’t stop moving. The animation is limited to slides that change too often right now, but it doesn’t fill me with confidence for the company’s ad quality control. Are we going to get animated ads next? Will random music start playing?

Excel Starter (below)







This, of course, distracts from whatever you’re trying to do. In a word processor, it’s a safe bet you’re likely writing. Try concentrating on that with an ever changing image in the corner annoying you for attention every 3 seconds.

Via this ad I learned that right now Microsoft Office 2010 Home and Student is only $119, down from $149. That’s nice to know. However, if I’m a college kid on a budget, or the parent of a college kid on a budget, or just a person in the world on a budget, and I’ve just paid hundreds of dollars for a computer, I might not have $119 for an office suite. Especially if the computer in question is a secondary device, like a netbook.

If I were the people behind OpenOffice.org I would find some way to scrounge up the money to advertise the fact that your product offers far, far more functionality than Office 2010 Starter but is just as free. And doesn’t come with ads! There’s a huge opportunity here, especially with the Back to School season around the corner.

I’d offer the same advice to Mozilla, who really hasn’t done enough to promote Thunderbird 3.0 as a viable alternative to Outlook for consumers and businesses.
My advice? Don’t even bother with Starter if you don’t intend to buy the full version of Office 2010. Just download OpenOffice and get on with life. If you’re not a fan of OpenOffice, you’d still be better off finding inexpensive (and unopened) older versions of Office still lingering on the Internet then settling for this free alternative.