Microsoft Office: Page 27

See the demo to learn how to take advantage of some of the advanced features of Office Communicator 2007, including rich-text formatting, transferring files, and escalating to a Live Meeting. If you use Office Communicator at your office for video conference calls or chatting, then this tutorial will explain some very useful advanced features.

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.So if you haven't used Excel 2007 yet, get up to speed with all the new...

Storing information, such as a full address, in one column can limit what you can do with that information. For example, you can't easily filter or sort by part of the address, such as country/region or city. However, if you break up the address into its parts — street address, city, state/province, postal code, country/region — one for each column, you can remove those limits. Watch this instructional video to see how to use the Convert Text to Columns Wizard to automatically break up a single...

Even if you don't have Microsoft Office Word 2007, you can open Word documents with Word Viewer. In this instructional video, a Microsoft employee shows how you and your coworkers can download Word Viewer and the Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats. With these 2 downloads, you can open, print, or copy and paste from Word documents without having to install Word on your computer.

If you're baffled about how to get your own photographs into your Microsoft Office Word 2007 documents, watch this instructional video. A Microsoft employee who uses Word himself shows you how to insert your picture or digital photo into a document and format it the way you want. He addresses questions about terms like "inline" and "floating," and explains how easy it is to set up a watermark.

With watermarks, you can add a new layer of information to your Microsoft Office Word 2007 documents. This tutorial shows you how to add a watermark to whatever section of your document you want and position it on the page where you want it. It demonstrates how to use graphics and text to create a custom watermark, such as your company logo.

You don't have to be a professional designer to create a professional-looking slide show. Check out this tutorial and learn how to grab the audience's attention by adding a background to your slides. Microsoft Office PowerPoint 2007 design themes include an array of coordinated choices for background colors and textures. You can even use a picture as a background. See your choices displayed instantly in a live preview, so no guesswork involved!

Did you know the views in your Microsoft Office Outlook calendar are fully customizable? View days and weeks in increments of 5 minutes, 60 minutes, or periods in between. Take a look into instructional video and learn how to adjust the view according to your work week and work day -- you can display Sunday-Thursday and show a normal day as 11 a.m.-7 p.m. Use different color schemes, and show more or less detail.

If you're new to Microsoft Office PowerPoint 2007 and just want to pick up the basics, watch this tutorial and learn how to get started fast. You'll see how to create your own slides for a show and add headings, bulleted lists, and pictures. Use built-in layouts to organize your slide content. And see how the new Preview feature helps you choose theme colors and background design, minimizing the guesswork and giving you a polished result.

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.Take a look at this instructional video and learn how to insert and delete individual or multiple rows, columns, cells, and worksheets.

Take a look at this instructional video and learn how to use simple formulas in Microsoft Office Excel 2007 to add, subtract, multiply, and divide. For example, you can use a prewritten formula called the SUM function to find totals, such as your total monthly expenses. Excel updates the results if the numbers change later.

You don't have to check the settings for every control individually — you can use the Logic Inspector to see a form's business logic displayed in a single window, grouped by features such as data validation, calculated data values, rules, and programming. Take a look at this instructional video and learn how to view the logic in a form template with Microsoft InfoPath.

Take a look at this instructional video and learn how to analyze how a process or other area is actually performing by connecting data to the shapes in your diagram with Microsoft Visio 2007. You can also add different visual effects based on the data values. For example, you can link sales data from an Excel workbook to the shapes it relates to. When a phase of the sales process takes longer than guidelines recommend, the shape for that phase changes color or shows an icon that alerts you to...

Take a look at this instructional video and learn how to use a Microsoft Office Excel worksheet that contains employee data to create shapes, connect them according to your organization's structure, and add data to each shape in your drawing automatically.

Check out this tutorial and see how to add a library to an existing Record Center site, apply policies to the library, and configure the Records Center site so that submitted documents are routed to the right library.

Take a look at this instructional video and learn how to create space in your note containers and move pages in Microsoft Office OneNote 2007. See how much control you have over how your notebook is set up, from a few words on a page to entire pages to whole sections. You'll also see the many ways you can find information in your notebook. Search for keywords, which OneNote will find no matter where they are — in text, in hand-written ink, in URLs, in graphics, even spoken in audio files. Or,...

Learn how to add color, shape, and emphasis to your text and data in Microsoft SmartArt graphics in this tutorial. 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.

This MS Office software tutorial shows you how to use some tips and tricks for the coolest features of Microsoft One Note. OneNote 2007 is great for notetaking during meetings or as a project communication tool at the office. Whatever you may need to keep track of, the tips and tricks in this OneNote tutorial will help you get started.

This is a tips and tricks video on how to use Microsoft Outlook's calendar function. Outlook is the email software provided by Microsoft Office suite. If you are new to Outlook or Outlook 2007, check out this video and learn some tips and tricks for working with the calenddar.

Tired of writing addresses on your outgoing letter mail? Well, you can start printing them out instead! But how!?! If you have Microsoft Word, it's a cinch, and it's not just about making envelope address labels, it's about adding your own personal, creative touch to each one.