en deannareynolds@gmail.com Copyright 2009 2009-10-23T13:42:01+00:00 http://www.keystoneondemand.com/site/importing_e_mail_addresses_outlook_2007_training/ http://www.keystoneondemand.com/site/importing_e_mail_addresses_outlook_2007_training/#When:19:11:00Z Just like Exporting, the ability to pull in information such as e-mail addresses from other formats into Outlook can be a real timesaver. Note: If you’re importing from Microsoft Excel, be sure to name the range in the worksheet that you want Outlook to import. 1. Choose File: Import and Export from the Menu Bar 2. Choose Import from another program or file Subscribe to the KeyStone OnDemand blog to be the first to learn about future Microsoft Office 2010 and SharePoint Training news and special Subscriber offers. Tips & Tutorials 2009-08-11T19:11:00+00:00 http://www.keystoneondemand.com/site/duplicating_deleting_slides_powerpoint_2007_training/ http://www.keystoneondemand.com/site/duplicating_deleting_slides_powerpoint_2007_training/#When:18:42:00Z Earlier in this course, we talked about deleting slides in Outline View, but here, in addition to talking about deleting slides in both Normal View and Slide Sorter View, we’re also going to look duplicating slides. Duplicating Slides I know you know how to copy & paste text and you probably even know how to copy and paste entire slides. But, what we’re talking about is a QUICK way to duplicate an entire slide. Duplicating Slides Using the Shortcut Menu 1. Right-click the slide (or object) you want to duplicate in Normal View 2. Choose Duplicate Slide from the Shortcut Menu Duplicating Slides Using the Keyboard 1. Select the slide (or object) you want to duplicate (You can be in Normal View or Slide Sorter View) 2. Press [CTRL]+D REMEMBER – this technique works for more than just slides AND it works on all kinds of graphics in every Office program. Deleting Slides Just as with the previous topic – duplicating slides – there are several ways to delete slides. And, you can pick whichever is easiest for you. There is not “best” way to accomplish this task. Deleting Slides Using the Ribbon 1. Select the slide (or object) you want to delete in Normal View 2. Choose the Delete Slide command in the Slides group on the Home tab Deleting Slides Using the Shortcut Menu 1. Right-click the slide (or object) you want to duplicate (You can be in Normal View or Slide Sorter View) 2. Choose Delete Slide from the Shortcut Menu Deleting Slides Using the Keyboard 1. Select the slide (or object) you want to delete (You can be in Normal View or Slide Sorter View) 2. Press [Delete] Subscribe to the KeyStone OnDemand blog to be the first to learn about future Microsoft Office 2010 and SharePoint Training news and special subscriber offers. Tips & Tutorials 2009-08-04T18:42:00+00:00 http://www.keystoneondemand.com/site/windows_xp_to_windows_7_migration_step_by_step_instructions/ http://www.keystoneondemand.com/site/windows_xp_to_windows_7_migration_step_by_step_instructions/#When:12:51:00Z Serdar Yequlalp (InformationWeek) posted a great step-by-step guide with screenshots to demonstrate how to migrate from Windows XP to Windows 7 without loosing your settings. While Windows Vista to Windows 7 Migration can be achieved through the normal direct upgrade path, there are extra steps required for Windows XP to Windows 7 Migration. In summary, you cannot run Windows 7 installer in an existing Windows XP installation and upgrade that copy of XP to 7 with your installed programs and data intact. However, you do have some options. If you install the copy of Windows 7 on the same computer and replace your existing XP install, you will loose all programs and data saved on that computer. If you wish to keep your programs and data intact, you can either install a copy of Windows 7 on the same computer in parallel with your existing XP install, or migrate your XP data and application settings to a new computer that has Windows 7 installed. See screenshots and detailed instructions here Subscribe to the Keystone OnDemand blog to be the first to learn about future Windows 7 Training and Windows 7 news and special subscriber offers. IT News, Tips & Tutorials, Windows 2009-08-03T12:51:00+00:00 http://www.keystoneondemand.com/site/inserting_slides_from_other_presentations/ http://www.keystoneondemand.com/site/inserting_slides_from_other_presentations/#When:18:25:00Z While it may sound like a difficult task, inserting slides from other presentations is really as easy as copy & paste or even drag and drop. You just need to know how to arrange your windows for optimum performance. After all, if you’ve created something similar for one presentation, there’s no reason to re-create it just for another. Arranging your PowerPoint Windows 1. Open the presentation that contains the slide(s) you want to copy 2. Choose Slide Sorter view in the Presentation Views group on the View tab 3. Open the presentation that you will be copying to 4. Choose Slide Sorter view in the Presentation Views group on the View tab 5. Choose the Arrange All command in the Window group on the View tab Inserting Slides Using the Ribbon 1. Follow the steps above for arranging your PowerPoint Windows 2. Select any slides in the presentation that contains the slide(s) you want to copy (You can select multiple slides by holding the [SHIFT] key while selecting slides) 3. Choose the Copy command in the Clipboard group on the Home tab 4. Click the Title Bar of the presentation that you will be copying to 5. Choose the Paste command in the Clipboard group on the Home tab Inserting Slides Using the Shortcut Menu 1. Follow the steps above for arranging your PowerPoint Windows 2. Select any slides in the presentation that contains the slide(s) you want to copy (You can select multiple slides by holding the [SHIFT] key while selecting slides) 3. Right-click any of the selected slides 4. Choose Copy from the Shortcut Menu 5. Click the Title Bar of the presentation that you will be copying to 6. Right-click anywhere in Slide Sorter view 7. Choose Paste from the Shortcut Menu Inserting Slides Using Drag & Drop 1. Follow the steps above for arranging your PowerPoint Windows 2. Select any slides in the presentation that contains the slide(s) you want to copy (You can select multiple slides by holding the [SHIFT] key while selecting slides) 3. Using your left mouse button, drag and drop the slides from one presentation to the other Subscribe to the KeyStone OnDemand blog to be the first to learn about future Microsoft Office 2010 and SharePoint Training news and special subscriber offers. Tips & Tutorials 2009-07-28T18:25:00+00:00 http://www.keystoneondemand.com/site/using_conditional_formatting/ http://www.keystoneondemand.com/site/using_conditional_formatting/#When:17:40:00Z Using the Organize Pane, you can apply conditional formatting to messages in your Inbox (and other mail folders). You can also access the Rules and Alerts Dialog Box from the Organize Pane. Using Folders Using Folders in the Organize Pane is an easy way to move messages from the selected folder to another existing folder. 1. Select a message in your Inbox (or another folder) 2. Choose Tools from the Menu Bar 3. Choose Organize (to open the Organize Pane) 4. Select the folder to move the selected message to 5. Click Move 6. When finished, click the Close button to hide the Organize Pane Subscribe to the KeyStone OnDemand blog to be the frist to learn about future Microsoft Office 2010 and SharePoint Training news and special subscriber offers. Tips & Tutorials 2009-07-21T17:40:00+00:00 http://www.keystoneondemand.com/site/hiding_slides/ http://www.keystoneondemand.com/site/hiding_slides/#When:23:56:00Z Occasionally, you may have slides in your presentation that you won't show to certain groups, but you need to have in there for other groups. Or, you may want to be prepared for “unexpected” questions. Hiding slides is a good solution for this type of situation. When using hidden slides, you can choose mid-presentation if you'd like to display a particular slide. If not, your presentation runs as if a hidden slide doesn't even exist in your presentation. Hiding a Slide 1. Right-click the slide you want to hide (You can be in Normal View or Slide Sorter View) 2. Choose Hide Slide from the Shortcut menu Unhiding a Slide 1. Right-click a hidden slide (You can be in Normal View or Slide Sorter View) 2. Choose Hide Slide from the Shortcut menu Displaying a Hidden Slide During a Presentation 1. In Slide Show View, right-click any slide 2. Choose Go to slide 3. Choose the slide you want to view from the list Subscribe to the KeyStone OnDemand blog to be the first to learn about future Microsoft Office 2010 and SharePoint Training news and special subscriber offers. Tips & Tutorials 2009-07-14T23:56:00+00:00 http://www.keystoneondemand.com/site/sorting/ http://www.keystoneondemand.com/site/sorting/#When:00:11:00Z You can choose to sort your tables by one or more columns in either Ascending or Descending order. This command also works for sorting text not contained in a table. 1. Select the table 2. Click the Sort command in the Data group on the Table Tools Layout Contextual Tab 3. Set your sort options 4. Click OK Subscribe to the Keystone OnDemand blog to be the first to learn about future Microsoft Office 2010 and SharePoint Training news and special subscriber offers. Tips & Tutorials 2009-07-08T00:11:00+00:00 http://www.keystoneondemand.com/site/adding_a_hyperlink_to_a_slide/ http://www.keystoneondemand.com/site/adding_a_hyperlink_to_a_slide/#When:20:34:01Z I don’t think it’s a stretch to assume that you know what a hyperlink is. If you’re not sure…think Internet, web pages and blue text with a blue underline. See? You use hyperlinks all the time – you just may not have known the term. In PowerPoint 2007, you can create internal hyperlinks that allow you to jump from one slide to another and external hyperlinks that jump to other presentations, documents, or a web site. You can even create a hyperlink that addresses an e-mail. What’s more, you can create hyperlinks on text and graphics. Which means, you can create a hyperlink, for example, from a company logo that displays the company web page when clicked. And, you don’t even have to be a web designer to do it! Creating a Hyperlink to an Internal Slide 1. Select the text or object that you are using as a hyperlink 2. Choose the Hyperlink command in the Links group on the Insert tab 3. Click Place in This Document 4. Choose a slide 5. Click OK Creating a Hyperlink to an External Slide 1. Select the text or object that you are using as a hyperlink 2. Choose the Hyperlink command in the Links group on the Insert tab 3. Click Existing File or Web Page 4. Choose a file 5. Click Bookmark 6. Select a Slide 7. Click OK 8. Click OK Creating a Hyperlink to an E-Mail Address 1. Select the text or object that you are using as a hyperlink 2. Choose the Hyperlink command in the Links group on the Insert tab 3. Click E-mail Address 4. Enter the E-mail address 5. Enter a Subject (if desired) 6. Click OK Creating a Hyperlink to a Web Page 1. Select the text or object that you are using as a hyperlink 2. Choose the Hyperlink command in the Links group on the Insert tab 3. Click Existing File or Web Page 4. Type the web page in the Address box 5. Click OK Subscribe to the Keystone OnDemand blog to be the first to learn about future Microsoft Office 2010 and SharePoint Training news and special subscriber offers. Tips & Tutorials 2009-06-30T20:34:01+00:00 http://www.keystoneondemand.com/site/working_with_data_validation_rules/ http://www.keystoneondemand.com/site/working_with_data_validation_rules/#When:20:22:00Z Data Validation rules enable you, as the owner of the workbook, to set rules on what entries are allowed inside individual cells. For instance, you can set one Validation Rule that only allows whole numbers between 1 and 100 to be entered into a cell. And, on another cell in the same workbook, you can specify that only entries from a drop-down list that you’ve created can be entered into a cell. The possibilities are almost endless. Setting Data Validation Rules 1. Select the cells on which you want to enable Data Validation 2. Click the Data Validation command in the Data Tools group on the Data tab 3. Choose Data Validation 4. On the Settings tab, choose the value type that you will allow 5. Click the Input Message tab 6. Enter the title and Message to help your user understand what is required for input Subscribe to the Keystone OnDemand blog to be the first to learn about future Microsoft Office 2010 and SharePoint Training news and special subscriber offers. Tips & Tutorials 2009-06-23T20:22:00+00:00 http://www.keystoneondemand.com/site/three_dimensional_formulas/ http://www.keystoneondemand.com/site/three_dimensional_formulas/#When:20:12:00Z Three Dimensional Formulas are, by far, the most flexible of the three methods of data consolidation that we’re discussing in this post. With Three Dimensional Formulas, the placement of the data your are summarizing, or consolidating, has no bearing on the final outcome. Moreover, it doesn’t matter in which worksheet or workbook file the detail data is stored. And, you probably already know how to create formulas. Creating a Three Dimensional Formula is as simple as being able to point and click on the data you want to summarize. Let’s look at an example. I have a workbook that tracks the sales of Widgets, Ball Bearings and Hammers for each of four Regions (East, West, North & South). I already have the detail data by Region for each of the three products broken down by quarter. Each product already has their own worksheet tab (see sample below). Here’s what my formula might look like in Excel: =SUM ( Widgets!B6+‘Ball Bearings’!B6+Hammers!B6 ) In other words, on my summary tab, the above formula would total the sum for cell B6 on the Widgets worksheet, cell B6 on the Ball Bearings Worksheeet and cell B6 on the Hammers worksheet. The reason that the worksheet name “Ball Bearings” is surrounded by apostrophes is that there is a space in the worksheet name. Subscribe to the Keystone OnDemand blog to be the first to learn about future Microsoft Office 2010 and SharePoint Training news and special subscriber offers. Tips & Tutorials 2009-06-16T20:12:00+00:00