SmartArt graphics add color, shape, and emphasis to your text and data. See which one works best for getting your point across. An organization chart? A time line? A process with sequential tasks? Non-sequential items? Pick one, and optionally customize it with colors, animation, effects such as shadows, bevels, and glows, and more.

Need to produce a report or form quickly? Using control layouts in Microsoft Office Access 2007 can save you lots of manual steps as you prepare your report. A control layout is like a table where you can align and format your data more easily.

Microsoft Office Access 2007 brings you a new look and new features designed to help you get your work done more easily than ever. You'll see differences right away, starting with the Getting Started with Microsoft Office Access page where you can open a blank or existing database, download a pre-built database template, and check out the offerings on Microsoft Office Online.

In Microsoft Office Access 2007, the Navigation Pane replaces the Database Window as the main way to get around in a database. This demo shows you how to use the Navigation Pane to organize the objects in a database into categories and groups. Categories help you arrange the items in the Navigation Pane, and groups are used to filter the categorized items.

In Office Excel 2007, you just select data in your worksheet, choose a chart type that best suits your purpose, and click. Want to try a different chart type? Just click again and select a new chart type from a huge range of possibilities. Then work with the new Chart Tools to customize the design, layout, and formatting of your chart. You can see how various options would look just by pointing at them.

Microsoft Office Excel 2007 has a new design that makes your work easier, faster, and more efficient. The new Ribbon puts the commands you use most often in plain sight on your work surface instead of hidden in menus or dialog boxes. Ready-made cell styles let you quickly format your worksheet to make it easier to read and interpret. The new Page Layout view shows how your printed worksheet will look as you're creating it.

See how data bars, gradient colors, icon sets, and other conditional formatting make it easier to compare data

With PivotTable reports in Microsoft Office Excel 2007, your sales report will sparkle with power, flair, and functionality. Show the big picture, show all the details, or show anything in between. Easily create multiple worksheets to switch back and forth between the various versions of your report. Sort, filter, and summarize your data any way you like. Show the details of any summary value in your report

In Microsoft Office Excel 2007, you can quickly insert new rows, columns, cells, and worksheets and just as easily delete them — with a few clicks. Watch the demo to see how fast you can insert and delete individual or multiple rows, columns, cells, and worksheets

Using the Merge feature in Microsoft Office Excel 2007, you can quickly turn that worksheet into an easy-to-scan, appealing report. When you merge cells, you join several adjacent cells into one larger cell. The demo also shows you how to adjust the position of the contents of the merged cell and add borders and background colors.