Microsoft - Daily Tips and Tricks Special Delivery

Work on Large Documents In Microsoft Office Word and Microsoft Office Excel, you can split the screen to see two separate parts of a document at once. On the View tab, in the Window section, click Split, and then click the screen where you want the split to appear. You can then navigate parts of the document separately in each window. Excel adds both a horizontal and a vertical split to the screen. If you don't want one of them, drag the line up to the top or the left side and drop it at the edge of the screen, where it will disappear. To return to the single-screen view of the document in either Word or Excel, go back to the Window section and click Remove Split.

Applying Conditional Formatting Conditional formatting is a feature that enables users to apply formatting to cells automatically depending on the value of the cell or the value of a formula. By visualizing data in a graphical way, you can identify trends and exceptions more quickly. To visualize the value of a cell relative to other cells in the same range: 1. Select a range of cells. 2. On the Home tab, in the Style group, click Conditional Formatting, click Data Bars, and then select a data bar icon. To classify data into three to five categories separated by a threshold value, use icon sets: 1. Select a range of cells. 2. On the Home tab, in the Style group, click Conditional Formatting, click Icon Set, and then select an icon set.

---

RSS Feeds Really Simple Syndication (RSS) feeds are an easy way to subscribe to interesting information like world news, sports scores, or blogs. With Microsoft Office Outlook 2007, it’s easy to start adding and reading RSS subscriptions. 1. Click the mail folder called RSS Feeds. 2. Choose a feed that interests you from the RSS Feeds content directory. 3. Outlook prompts you to add this feed to your list. Click OK. 4. Outlook creates a specific RSS subscription folder for this feed below the main RSS Feeds folder. Note: When using Office Outlook 2007 with Windows Internet Explorer 7, you can keep a synchronized list of subscriptions between the two programs.

Access Information in One Click by Using Attachment Preview Accessing mail attachments is often a multistep process that provides no easy way to gain quick insight to that content. With Attachment Preview, you can preview your attachments in one click directly from within Microsoft Office Outlook, saving you time and effort. 1. Click the attachment in the e-mail message or reading pane. 2. Scroll through the document or presentation by using the scroll bar on the right. To return to the e-mail message, click the message box to the left of the attachment. Note: The presentation or document is a read-only copy. To make edits or comments, you need to save a local version on your computer.

2003 to 2007 Shared Charting Copying and pasting a Microsoft Office Excel 2003 chart into Microsoft Office PowerPoint 2003 is easy. The real challenge is editing the chart after it's part of your presentation, because the charting tools are different between the applications. With the shared charting engine in the 2007 Microsoft Office system, you can use the same charting tools to create and customize your charts in Microsoft Office Excel 2007, Microsoft Office PowerPoint 2007, and Microsoft Office Word 2007. To insert a chart in Excel 2007, click the Insert tab, and then select the type of chart you want from the Charts group. To customize an existing chart, click inside the chart, and then use the contextual Chart Tools command tabs that appear on the Ribbon.

---

Insert and Format Charts In Microsoft Office Excel 2007, you will find many new professional-looking charts to help you visualize your data and communicate it more effectively. To insert a chart: 1. On the worksheet, arrange the data that you want to use in a chart. 2. Select the cells that contain the data that you want to use for the chart. 3. On the Insert tab, in the Charts group, click the chart type, and then click a chart subtype that you want to use. To see all available chart types, click a chart type, and then click All Chart Types. Excel will select the default formatting layout, but you can quickly modify it: 1. On the contextual Design tab, select a chart layout from the gallery to display the legend, axis, and title the way you want. 2. Select a chart style to modify color and effects.

Multiple Level Undo, Change Highlighting, and Task Drivers In Microsoft Office Project Professional 2007, project managers can visualize the impact of changes and trace back their steps. To turn the Change Highlighting feature on or off, click the View menu, and then click Hide Change Highlighting or Show Change Highlighting. While the feature is enabled, all levels of tasks affected as a result of a change are highlighted with a color as a visual indicator. Using this feature together with the Multiple Level Undo feature, project managers can do "what-if analysis" by trying a set of changes and then reversing unwanted changes. If further analysis of a task's schedule is needed, the project manager can use Task Drivers on the Project menu to determine the factors (such as task dependency, calendar constraints, schedule date, or vacation time) that are driving a task's start date.

---

Organize Information with Color Categories Color categories give you a simple, visual way to distinguish items from one another, making it easy to organize your data and search for information. 1. Right-click the box next to an e-mail message. 2. Click All Categories. 3. Assign titles to your color categories, such as personal, work, finance, family, or birthdays. 4. Click OK. 5. Right-click the category box next to an e-mail message and assign a color category to it. 6. Arrange your e-mail list, or search by color categories.

---

Changing Table Styles To change table style: 1. Click inside the table you’d like to change. 2. On the contextual Design tab, pause on any table style for a live preview, and click when you want to confirm the change (click the arrows in the gallery to view more styles). 3. Make selections in the Table Style Options group to change formatting of the first and last column, to add a Totals Row, or to have banded rows or columns.