Office Tips and Tricks

Office Tips and Tricks
Lisa Short Technology Specialist Summer 2013

Overview of Microsoft Shortcuts to Desktop Pins to Task Bar Templates Shortcut Keys—handout Split Screen –2 apps Hide task bar Trash --Restore Windows Explorer Folders Move/copy Options in Office Apps General Spell Check

Quick Reference Card 1 Open Word really fast Press the Windows Key+R, type winword, and then press Enter. Use a template from Office.com On the File tab, click New, and then under Office.com Templates, choose a template. Convert text into a table Select several lines of text. On the Insert tab, click Table, and then click Convert Text to Table. Word 2010 tips and tricks

Quick Reference Card 2 Make a bulleted list more interesting Select your bulleted list. Press CTRL+X. On the Insert tab, click SmartArt. Choose a layout, and then click OK. After the SmartArt is inserted, select all of the bullets in the text pane on the left. Press CTRL+V. Word 2010 tips and tricks

Quick Reference Card 3 Crop a picture to a shape Select the picture or pictures that you want to crop to a specific shape. Under Picture Tools, on the Format tab, in the Size group, click the arrow under Crop. Click Crop to Shape and then click the shape you want to crop to. Put documents on SkyDrive Go to http://office.live.com and obtain a Windows Live ID, if you don’t have one already. After you have a Windows Live ID, go to http://office.live.com. Click Add files and then upload documents from your computer. Word 2010 tips and tricks

Quick Reference Card 4 Find and replace text On the Home tab, Replace. Type what you want to find in the Find what box Type what you want to replace it with in the Replace with box Click Replace All. Tips for selecting things To select a word, double click. To select a paragraph, triple click. Place your cursor in the left margin. Click once for a line, double click to select all lines in a paragraph. Word 2010 tips and tricks

Quick Reference Card 5 Show or hide the ribbon CTRL+F1 Use the Quick Access Toolbar Right-click a button, and then click Add to Quick Access Toolbar. Word 2010 tips and tricks

Course goals Open PowerPoint fast. Use a template from Office.com. Make a slide from a single bullet. Crop a picture to a shape. Zoom with your mouse. Reuse a slide from another presentation. Use Slide Sorter view. Insert a screenshot. Insert a screen clipping. Show or hide the ribbon. Use the Quick Access Toolbar. PowerPoint tips and tricks

Quick Reference Card 1 Open PowerPoint fast Press Windows Key+R, type winword, and then press Enter. Use an Office.com template On the File tab, click New, and then under Office.com templates, choose a template. Make a slide from a bullet On the left, above the slide thumbnails, click the Outline tab. Select the text you want on its own slide. Press SHIFT+TAB. PowerPoint tips and tricks

Quick Reference Card 2 Crop a picture to a shape Select the picture or pictures that you want to crop to a specific shape. Under Picture Tools, on the Format tab, in the Size group, click the arrow under Crop. Click Crop to Shape and then click the shape you want to crop to. Zoom with your mouse If your mouse has a wheel, hold down the CTRL key, and then rotate the wheel forward to zoom in. Rotate the wheel backward to zoom out PowerPoint tips and tricks

Quick Reference Card 3 Reuse slides from another presentation Open the presentation that you want to add a slide to. In the pane that contains the Outline and Slides tabs, click Slides, and then click where you want to add a slide. On the Home tab, in the Slides group, click the arrow below New Slide, and then select Reuse Slides. In the Reuse Slides pane, click Open a PowerPoint File. In the Browse dialog box, locate and click the presentation file that contains the slide that you want, and then click Open. Tip In the Reuse Slides pane, PowerPoint displays thumbnails of the slides from the presentation that you selected. Rest the pointer on a thumbnail to see a larger version of the slide's contents. In the Reuse Slides pane, do one of the following:• To add a single slide, click the slide.• To add all of the slides, right click any slide, and then select Insert All Slides.Note If you want the slide that you are adding to the destination presentation to maintain the formatting of the original presentation, select the Keep source formatting check box before you add the slide to the destination presentation.• To add a single slide, click the slide.• To add all of the slides, right-click any slide, and then click Insert All Slides on the shortcut menu. PowerPoint tips and tricks

Quick Reference Card 4 Slide Sorter view In the lower-right corner of the screen, press the Slide Sorter button. Insert a screenshot or screen clipping Click the slide that you want to add the screenshot to. On the Insert tab, in the Images group, click Screenshot. Do one of the following:• To add the whole window, click the thumbnail in the Available Windows gallery.• To add part of the window, click Screen Clipping, and when the pointer becomes a cross, press and hold the left mouse button to select the area of your screen that you want to capture. PowerPoint tips and tricks

Quick Reference Card 5 Show or hide the ribbon Press CTRL+F1. Use the Quick Access Toolbar Right click a button, and then click Add to Quick Access Toolbar. PowerPoint tips and tricks

Test question 1 To start Key Tips, you press which of the following keys? (Pick one answer.) The CTRL key. The SHIFT key. The ALT key. The TAB key. Make the switch to Excel 2010

Test question 1 To start Key Tips, you press which of the following keys? Answer: Press ALT, and then the key or keys that start the command you want to use. The ALT key. Make the switch to Excel 2010

Test question 2 On the ribbon, which tabs have the commands for basic functions such as SUM and AVG? (Pick one answer.) The Home and Functions tabs. The Insert and Data tabs. The Quick Access Toolbar and the Data tab. Make the switch to Excel 2010

Test question 2 On the ribbon, which tabs have the commands for basic functions such as SUM and AVG? Answer: You can also enter the functions in the Formula Bar regardless of the ribbon tab you’re using. The Home and Functions tabs. Make the switch to Excel 2010

Test question 3 How to you get to Backstage view? (Pick one answer.) Click the Home tab. Click Backstage on the View tab. Click the Filetab. Make the switch to Excel 2010

Test question 3 How to you get to Backstage view? Answer: You can also start Backstage view by using Key Tips. Click the File tab. Make the switch to Excel 2010

Test question 4 To view Excel 2010 files in Excel 2003, you must do which of the following? (Pick one answer.) You can’t view 2010 files in 2003. You have to convert them all to the 2010 file format. Download and install free converters. You don’t need to do anything. Just open the files. Make the switch to Excel 2010

Test question 4 To view Excel 2010 files in Excel 2003, you must do which of the following? Answer: Make sure your version of Excel is fully patched by installing and downloading free converters. Download and install free converters. Make the switch to Excel 2010

Test question 5 Which tab do you use to do math? (Pick one answer.) The Formulas tab. The Home tab. You can use any tab. Make the switch to Excel 2010

Test question 5 Which tab do you use to do math? Answer: In Excel 2010, you can do math while you’re working in any tab. You can use any tab. Make the switch to Excel 2010

Test question 1 You want to insert a new slide and pick a layout for it. What do you do first? (Pick one answer.) Click the slide icon on the Home tab. Click the arrow under the slide icon on the Home tab, next to New Slide. Click the slide icon on the Insert tab. Make the switch to PowerPoint 2010

Test question 1 You want to insert a new slide and pick a layout for it. What do you do first? Answer: Clicking the arrow opens the Layout gallery, and the layout you choose gets applied to the new slide. Click the arrow under the slide icon on the Home tab, next to New Slide. Make the switch to PowerPoint 2010

Test question 2 You want to protect your presentation with a password. What are the initial steps? (Pick one answer.) Click the File tab, and click Save & Send. Click the File tab, and click Info. Click the File tab, and click Options. Make the switch to PowerPoint 2010

Test question 2 You want to protect your presentation with a password. What are the initial steps? Answer: Then in the Permissions section, click Protect Presentation, and choose from among those options. Click the File tab, and click Info. Make the switch to PowerPoint 2010

Test question 3 How do you open the Print options? (Pick one answer.) Click the File tab, and click Print. Press ALT+F+P. Click the Print Preview icon, which you added to the Quick Access Toolbar. All of the above. Make the switch to PowerPoint 2010

Test question 3 How do you open the Print options? Answer: Maybe that was laborious, but note all the ways you can open the Print options. All of the above. Make the switch to PowerPoint 2010

Test question 4 You’ve finished the presentation and you want to run the spelling checker. Where is it on the ribbon? (Pick one answer.) The Hometab. The Slide Show tab. The Reviewtab. Make the switch to PowerPoint 2010

Test question 4 You’ve finished the presentation and you want to run the spelling checker. Where is it on the ribbon? Answer: The Review tab. Make the switch to PowerPoint 2010

Test question 5 You see a tab on the ribbon that you hadn’t noticed before called Drawing Tools. What’s it there for? (Pick one answer.) To help you work with shapes. To help you work with pictures. To help you work with SmartArt graphics such as org charts. Make the switch to PowerPoint 2010

Test question 5 You see a tab on the ribbon that you hadn’t noticed before called Drawing Tools. What’s it there for? Answer: The Drawing Tools contain the Format tab and are always available when you have clicked within a shape, such as a text box or list placeholder. Use the Drawing Tools Format tab to insert or change shapes, edit the current shape, apply a shape style, add WordArt, and position all shapes on the slide. To help you work with shapes. Make the switch to PowerPoint 2010

Mailing Labels Full Page Create a new document Mailings, Labels, Options, Avery US Letter, 5160, OK Address Type your information in, add picture, Full page of the same label, New Document. In Word Select all –Crtl + A, Change font, size, center Word 2010 tips and tricks

Mailing Labels Merge Open Word Start Mail Merge, Labels, Choose Product #, Ok Select Recipents From existing list, type new list Address Block, Insert Merge Field Add fields –be sure to add space between fields Update Labels, Preview Results, Finish & Merge Word 2010 tips and tricks

Office Tips and Tricks