Home | About Us | Contact Us | Seminars | Get Listed | Subscribe | Hotlist | Online CPE


Microsoft Office 2007

After five long years, we are now close to seeing the next release of the world’s best selling application - Microsoft Office. This new version will be called Microsoft Office 2007 (previously code named Office 12). There will be eight (8) different versions of this product containing different mixtures of the following ten (10) Microsoft applications:

  1. Access
  2. Excel
  3. FrontPage
  4. OneNote  
  5. Outlook
  6. Project
  7. Publisher
  8. SharePoint 
  9. Visio
  10. Word

All together, Microsoft intends to offer 7 different editions of Office 2007 as follows:

  1. Microsoft Office Enterprise 2007 - New to this release, and available only to volume licensing customers. This version includes Word, Excel, PowerPoint, Outlook, Access, Publisher, Office Communicator (instant messaging), InfoPath, OneNote, Office Groove 2007 (peer-to-peer collaboration), and server-based content management, forms management, and information rights and policy capabilities.
     
  1. Microsoft Office Professional Plus 2007 - Available only to volume licensing customers. This version includes Word, Excel, PowerPoint, Outlook, Access, Publisher, Office Communicator, InfoPath, and server-based content management, forms management, and information rights and policy capabilities.
     
  1. Microsoft Office Professional 2007 - This version includes Word, Excel, PowerPoint, Outlook, Access, and Publisher.
     
  1. Microsoft Office Small Business 2007 - This version includes Word, Excel, PowerPoint, Outlook with Business Contact Manager, and Publisher.
     
  1. Microsoft Office Standard 2007 - This version includes Word, Excel, PowerPoint, and Outlook.
     
  1. Microsoft Office Basic 2007 - This version includes Word, Excel, and Outlook but is available only with a new PC purchase.
     
  1. Microsoft Office Home and Student 2007 - Replaces Student and Teacher Edition 2003, and is now available to all home users and can be installed on up to three PCs. This version includes Word, Excel, PowerPoint, and OneNote. (Note that the previous version included Outlook and not OneNote.)

Pricing for these editions of Office 2007 is as follows:

Microsoft Office Enterprise 2007

 Volume licensed

Microsoft Office Professional Plus 2007

 Volume licensed

Microsoft Office Professional 2007

 $499, upgrade is $329

Microsoft Office Small Business 2007

 $449, upgrade is $279

Microsoft Office Standard 2007

 $399, upgrade is $239

Microsoft Office Basic 2007

 Available only with new PC purchases, no upgrade pricing available

Microsoft Office Home and Student 2007

 $149 with 3 PC family license; cannot be upgraded from prior versions

What’s New in Microsoft Office 2007?

There are many new changes in Microsoft Office 2007 and listed below are those changes which I feel are most important:

  1. User Interface – Microsoft Office 2007 looks different. The menus, toolbars and icons have been removed and replaced with Ribbons. Here is what the new ribbons look like:

 

Over the years, the number of tool bars included in Microsoft Office products have grown from just two (2) toolbars in Word 6.0, to six(6) tool bars in Word 95, to eighteen (18) toolbars in Word 98, to thirty-one (31) toolbars in Word 2003. Obviously the complexity has been mounting and navigating these various toolbars has become more time consuming. Based on this, Microsoft has engineered a better way to navigate the Office suite called ribbons.

As a practical matter, the ribbons do work similar to the menus, toolbars and icons you are used to, however they are easier once you get used to them and underneath the technology is far better. Presented below is a screen shot of the new ribbon terminology.

File or Application Menu - The only remaining normal menu in Office 2007 is similar to the existing File menu and retains the short title for familiarity. Under that menu there are familiar options, New, Open, Save, Save As, Print etc but the ‘fly out’ menus have changed a lot.  They are now enclosed in a rectangle to the right of menu itself.  When you first open the File menu this extra space is used by the greatly expanded, Most Recently Used (MRU) file list.

Quick Something Toolbar - This is a customizable set of small icons that are intended to let you get fast access to the commands you want.  You can add items to this Toolbar by right-clicking and choosing the ‘Add to Quick Launch Toolbar’ option. This feature was, until recently, called the Quick Access Toolbar and is currently showing as QLT (Quick Launch Toolbar).  But it seems both names are placeholders for the eventual, undecided name.

Tabs - The tabs are the switches to let you see the main interface display.  Some tabs always show up and others appear as required.  For example a Table tab will appear when you click in a Word table.

Ribbon - The big long strip of icons and labels (chunks) is called a ribbon.  You can hide the entire ribbon by double-clicking on one of the tabs.

Chunks - Parts of the ribbon are currently called, chunks, with each chunk being a logical grouping of icons, labels, menus and other controls. Chunks are not fixed, for they expand depending on their position on the toolbar and the width of the Office window, however they cannot be manually re-sized. When there’s a wide window, a more detailed chunk is displayed with more options.  In a narrower display the same chunk can be reduced to a single button – click that button to see a list of the available controls – hence the official name ‘pop-up chunk’. Some other chunks are a single button leading to a dialog. Broadly speaking, chunks on the right are considered less important and will reduce in size before chunks on the left. But if you make a narrow enough window all you will see are pop-up chunks. Each chunk has a title at the top and a little wedge shape across on the top right – click on that wedge to go direct to the full options dialog for that topic. The chunk title cannot be hidden and the arrangement of icons within a chunk cannot be changed. It’s likely that the name ‘chunk’ will change to something like ‘tile’ or ‘pane’. 

Not everything is changing - Only Word 2007, Excel 2007 and PowerPoint 2007 will have the new user interface. In Outlook 2007 the main shell is menu-based, everything else (mail, contacts, meeting forms, tasks, etc.) will be Ribbon-based.  Most notably the email editing window, (which is Word running within Outlook anyway) but the main windows keep the menu/toolbars much as they are in Office 2003. OneNote 2007 is much improved but does not move to the new user interface (UI). Access is getting a major makeover in many ways and the new Ribbon UI is part of that. The ‘2007’ versions of FrontPage, Publisher, Project and InfoPath don not use the new UI either.

Officially the new user interface is intended primarily for use in authoring and feature laden programs like Word as opposed to simpler programs such as OneNote.  But that doesn’t explain why FrontPage 2007, InfoPath 2007 and especially Publisher 2007 aren’t moving to the new UI. 

  1. New File Formats – With Microsoft Office 2007, Microsoft has eliminated all of the old document formats such as DOC for Word files, XLS for excel files, and PUB files for Publisher files, etc. Instead all file formats will be XMLs formats based primarily on the newer eXtensible Markup Language called XML. There will be many advantages to these new file formats.

Distinct from the binary-based file format that has been a mainstay of past Microsoft Office releases, the new Office XML Formats are compact, robust file formats that enable better data integration between documents and back-end systems. An open, royalty-free file format specification enables any technology provider to integrate Microsoft Office documents into their solutions. There are four (4) primary benefits offered by the new Office XML Formats as follows:

1. Data Sources - For starters, this new approach enables the creation of documents from differing data sources, thereby accelerating document assembly, data mining, and content reuse. For example, the letterhead used by all company personnel could be linked to a single file. As this file is changed, all documents referring to that letterhead file change as well. Similar methods could be used to link data from a database to documents for faster integration of information. This also translates to easier integration because developers have direct access to specific contents within the file, like charts, comments, and document metadata.

2. Royalty-Free - Further, Office XML Formats are based on industry standard XML and ZIP technologies. They support full integration by any technology provider and are available via a royalty-free license.

3. Smaller - Another advantage is that this approach results in smaller file sizes (up to 75 percent smaller in some cases ) and there are improvements in the recovery of corrupted documents. Office XML Formats use ZIP and compression technologies to store documents offering potential cost savings as it reduces the disk space required to store files and decreases the bandwidth needed to transport files by e-mail, over networks, and across the Web.

4. Safer - Finally these new file formats are safer to work with because embedded code (such as OLE objects or Microsoft Visual Basic for Applications code) is stored in a separate section within the file, so it can be easily identified for special processing. IT Administrators can block the documents that contain unwanted macros or controls, making documents safer for users when they are opened. Also, documents can be shared confidentially because personally identifiable information and business sensitive information—user names, comments, tracked changes, file paths—can be easily identified and removed.

The good news is that these new formats are backward compatible with the old formats. Users of Microsoft Office 2000, Microsoft Office XP, and Office 2003 Editions can open, edit, and save documents in one of the Office XML Formats.

  1. Super Tool Tips – As before, every tooltip contains the feature name and keyboard shortcut if it has one. Additionally, now every tooltip provides a short text description letting the user know what that feature is for.  Further, they say "a picture is worth a thousand words" and often times that's true when trying to explain what a feature is for.  The next enhancement is the inclusion of an explanatory image in the tooltip itself.  A good example of why this is useful is "Insert Caption" in Word.  Someone might not know what a "caption" is, but when they see the little picture with a line of text saying "Figure 7: Three Year Trend" under it, they may better understand what a caption is.  The following screen shots depict examples of the new Super Tool Tips.

  

  1. XPS Documents - XPS, or the XML Paper Specification, is Microsoft’s new electronic paper format for exchanging documents in their final forms. This Office feature provides a one-way export from Office client applications to an application- and platform-independent, paginated format. Unlike the Office Open XML Formats, XPS does not attempt to capture the full structured richness of an Office document. As an electronic paper format, it is all about a high fidelity representation of the output only. Because of this, creation of an XPS document from Office is a one-way, export operation.

XPS is an electronic paper format built around the same Open Packaging Conventions document structure as the new Office file formats. This means a Zip container and XML content. As such it plays well with other technologies like Microsoft Information Rights Management (IRM) and is open to developers to read and write, using the Application Programmer Interface (APIs) in the Windows Presentation Foundation or any other tools capable of working with XML and Zip. This openness makes XPS convenient for a range of scenarios in which it is useful to inspect or modify the contents of the “paper” programmatically.

The Windows Digital Documents team is delivering a print driver with Windows Presentation Foundation that will enable all applications that can print to create XPS files. The support for XPS output in Office 2007 goes beyond what is typically passed to a printer, including the supporting information to enable, for example, working hyperlinks, searching, efficient representation of transparency and gradients, accessible documents, and document rights when the source document has restricted IRM rights.

  1. Windows® Workflow Foundation (WWF) – This is a workflow engine, programming model and set of tools for developers for building workflow-enabled applications. Microsoft plans to use Windows Workflow Foundation to workflow-enable the next version of Microsoft® Office 2007, Windows Vista™, BizTalk® Server and Microsoft Dynamics™.

WWF technology brings together document management, records management and Web content management for unified, integrated, scalable enterprise content management (ECM). The goal is to provide every information worker in an organization with a simple way to create, share, manage, archive and find a diverse spectrum of content, and to do that in a way that is extensible for developers. Solutions built using Microsoft Office 2007 will be able to effectively harness the information that flows through companies, regardless of where the content resides or in what format it appears. Independent software vendors (ISVs) will also have the freedom to build specific vertical workflow solutions and surface them to customers directly inside Office 2007.

For example, Word documents and Excel reports that are based upon information contained in the companies’ accounting system can be updated automatically as information changes in the accounting system. Imagine if you will that a company produces a 30-page Word document each month summarizing the results of operations. Previously users had to extract and manipulate data the following month from the accounting system and enter that new information in the 30 page Word document effectively replacing the older data. With WWF, the document can keep itself up to date by pulling and manipuilating the accounting data directly from the accounting system.

  1. Document Look and Feel – Microsoft examined many examples of “professional” output, drawn from textbooks, business journals, scientific journals, and professional design firms. Based on this examination they concluded that there are still many capabilities needed in Office 2007 to enable users to produce these modern looking documents. As a result, Microsoft has added the following enhancements for controlling the look and feel of a document:
     
    1. Microsoft has changed the number of unique colors allowed a single workbook from 56 to 4.3 billion (32-bit color) as well as adding some new visual effects, like gradient fill.
       
    1. Improved charting. Rather than explain it, below examples of these improvements for you to see.



 

 



 



 

 

    1. Improvements to Excel’s existing cell styles feature, and the addition of styles for Tables, PivotTables, and Charts.
       
    1. Galleries of professionally-designed styles.
       
    1. A new Page Layout View - to supplement Normal and Page Break Preview.
       
    1. "Live preview" of formatting.
       
    1. Click-and-type headers and footers.
       
    1. New print-related features.
       
    1. Document Themes (color, font, and effect variations that can be shared between Office applications).
       
    1. Updates to Office shapes (think Drawing toolbar) and WordArt.
       
    1. 25 great-looking templates available out-of-the-box.
       
  1. Workspace Sharing, including P2P capabilities – Updated versions of Microsoft's SharePoint Portal Server and Windows SharePoint Services are included in Office 2007, furthering the company's enterprise collaboration initiative. While SharePoint is rather basic, compared to other offerings out there, it will be ubiquitous within a few years. The suite is ushering in what Microsoft is calling a "new world of work," in which information technology allows workers to collaborate in new ways. According to Bill Gates, “In a new world of work, where collaboration, business intelligence and prioritizing scarce time and attention are critical factors for success, the tools that information workers use must evolve in ways that do not add new complexity for people who already feel the pressure of an 'always-on' world and ever-rising expectations for productivity." SharePoint is expected to incorporate some of the peer-to-peer technologies acquired with the purchase of Groove Networks Inc. Groove founder and Lotus Notes creator Ray Ozzie is likely to play a key role, now that he's joined Microsoft as a chief technology officer.

Exchange administrators in particular could see great benefit in the SharePoint update because SharePoint Portal Services provides a built-in enterprise search engine. For example, one of the things Microsoft supports out of the box is the ability to capture e-mails in Exchange public folders. The folders allow both e-mail and documents to be shared. SharePoint gives users the ability to index and search that content. Moving away from public folders and to use SharePoint sites is exactly what Microsoft intends for it’s users. One of the reasons that SharePoint works so well in a collaborative environment is that it provides the capability for check-in and check-out and maintaining revision control. SharePoint also gives IT administrators a break from doing one-off projects as it allows end-users to create portals themselves.

SharePoint is the market leader among collaboration offerings but it does have its flaws. One of the major shortcomings of the product is that there is no capability for doing ad hoc approval writing. It isn't possible to track who contributed what to a document. SharePoint also doesn't allow for inter-enterprise collaboration because it requires Active Directory, a typically internal system. However, Bill Gates told a gathering of executives at the CEO Summit that Microsoft is making steps to resolve those issues in Office 2007 products.

  1. Other Improvements – There are plenty of other improvements in general to look for in Office 2007 such as smaller file sizes, Tasks & Time Management options, PDF Support, Document Services, RSS/Search/Sharing, Outlook Programmability, etc. However, the individual programs have been enhanced as well. As an example, consider the enhancements to Excel 2007 presented below.

- END -
 


Copyright © 1999-2007   

ACCOUNTING SOFTWARE advisor
All rights reserved 
No part of this web site may be used for commercial purposes of any kind without our express written consent.

______________


The following web sites are owned and maintained by Accounting Software Advisor, LLC: Accounting Software Advisor, Accounting Software NewsASA Research, Technology Advisor, CPA Advisor, Accounting Software Answers, Accounting Software Reports, Accounting Software Consulting, QuickBooks Advisor, Excel Advisor, Carlton Collins, and The CPA's Hotlist.

 

About Us

Read our Mission Statement
Read our Disclosure Statement
Read our Disclaimer Statement

Contact the Editor - J. Carlton Collins, CPA
REPRINT PERMISSIONS

______________

 

Click Here If You Need Help SELECTING ACCOUNTING SOFTWARE
 We would be happy to help you as little, or as much, as you need

 

Click Here TO FIND A TOP ACCOUNTING SOFTWARE RESELLER IN YOUR AREA
 THESE RESELLERS HAVE PASSED A RIGOROUS BACKGROUND CHECK AND MEET OUR TOUGH CRITERIA