| Office 2007 | Office 2010 |
| New look and feel with an intuitive interface | Results-oriented Office Fluent user interface is introduced to most applications with the Ribbon toolbar, making it easier to find commands needed most and uncover new ones.
| Ribbon toolbar is now in all applications, improving discoverability across the suite. The new Microsoft Office Backstage™ view gives everyone quick access to important operations such as viewing document information, saving, printing, and sharing. |
| Quickly preview content changes with Live Preview | Preview proposed changes to your document while you’re working on it without having to repeatedly search through layers of menus. | The new Paste with Live Preview feature shows options before you paste content between Office 2010 documents or from other applications. |
| Edit videos from within PowerPoint | | Photo and video editing tools in PowerPoint 2010 can trim a video clip, bookmark it, turn a color film into black & white, add artistic effects to photos, and more. Compress media to make file sizes smaller. |
| Turn a presentation into a movie | | PowerPoint 2010 makes it easy to share your presentation with those who missed the live event—or to create a presentation video for any purpose, such as recording your own video training course. Include narration, slide and animation timings, and even your laser pointer movements. |
| Edit pictures across several Office programs | Word 2007 and PowerPoint 2007 provide basic photo editing options to help you make pictures suited for a presentation or report. | Use new and improved picture editing tools in Word 2010 and PowerPoint 2010: Spectacular artistic effects and advanced correction, color and cropping tools, and more. |
| Analyze large volumes of data | Excel spreadsheets can now be up to 1 million rows by 16,000 columns in size so you can import and explore large amounts of information. | The PowerPivot for Excel 2010 add-in allows you to quickly calculate data sets of hundreds of millions of rows from multiple sources at surprising speed. |
| Identify key trends with data visualization | Use conditional formatting in Excel 2007 with new data bars and more colorful and gradual fills to format data based on specific rules. Create professional-looking charts and tables with greater ease by formatting with fewer clicks. | Sparklines save real estate on-screen by charting trends in a single cell right next to the corresponding data. New conditional formatting options provide enhanced ways to draw insights from data with Excel 2010—including more icon set flexibility, enhanced data bar length, gradient fills with borders, and more. |
| Utilize PivotTable views to draw insights from information | Summarize information and find the answers you need using PivotTable and PivotChart views that are now much easier to create using Excel 2007. | New Slicers can dynamically filter data in a PivotTable view or PivotChart view and display only the relevant details so that even people who are not familiar with PivotTables can manipulate the data. |
| Capture and search all types of information in one place | OneNote 2007 can capture text, images, audio, and video and provides advanced search capabilities. | The improved search experience in OneNote 2010 shows you search results as you type—and a new ranking system learns from past choices, prioritizing notes, pages, page titles, and recent picks. |
| File information where it belongs without interrupting your work flow | Send to OneNote allows you to move or copy e-mails to OneNote to easily file them with notes. | Quick Filing makes it easy to collect information while working in other programs by sending a copy of content from documents, Web pages, e-mail messages, or most any program to the exact location desired in a OneNote notebook with just a few clicks. |
| Add flair to text and tables | Save time by quickly formatting text and tables throughout Word 2007 documents. Take advantage of new fonts and better on-screen reading. | New OpenType typography available in Word 2010 and Publisher 2010 helps create the look of professional typesetting in just a few clicks, with support for ligatures, stylistic sets, and other typography features available in many OpenType fonts. |
| Start working with databases easily | Built-in templates and wizards make it easier to get started working with databases in Access 2007. | New features such as Application Parts and Quick Start fields enable users to build a database quickly. Select from common Access components and add groups of frequently used fields in just a few clicks. And, simplify database navigation by easily creating Navigation Forms — no code required. |
| Create reports from databases quickly | Easily create reports in Access 2007 with a single click, and use improved tools to filter, sort, group, and subtotal data. | Add data bars with gradient fills to your forms and reports and visually see how one value compares to the others or identify trends. |
| Work with forms online or offline | | Work online or offline with a native implementation of InfoPath 2010 forms in SharePoint Workspace 2010. |
| Create publications for print, e-mail, and the Web | Publisher 2007 helps you create and publish a wide range of marketing publications for print, e-mail, and the Web with your own brand elements, including logo, colors, fonts, and business information. | Add some flair to your text with new OpenType typography available in Publisher 2010. And select from galleries of built-in and community-submitted content, including borders, sidebars, graphics, and more, to help you easily build professional-quality publications. You can also save your customized content as additional building blocks for reuse whenever you need them or to share with the Publisher community. |
| Leverage templates to make effective marketing materials quickly | Publisher 2007 provides hundreds of customizable design templates and more than 100 blank publication types. More templates are available on Office Online. | Templates created by both businesses and the Publisher user community are hosted online and can be easily accessed from within Publisher 2010. Customize any template you find to accommodate your specific needs. |