We at theapptimes.com have written numerous app tips this year to help both novices and power users working with the popular Office 2010 application. In this post, let’s re-look some of the top Office 2010 tips we shared this year with our readers. You can take a print out and pin it up your dashboard for a quick reference too.
Top Office 2010 Tips in: Microsoft PowerPoint 2010
How to Remove a SmartArt Animation
How to Copy Animations from One SmartArt Graphic to Another
Select the object, on the Animations tab, in the Advanced Animation group, click Animation Painter. Navigate to the slide you want to apply the copied animation and click the object you want to apply the animation effect.
How to Change Clip Art Colors in PowerPoint 2010
Select the Clip Art image. In the Picture Tools Format contextual tab, in the Adjust group, click Color and from the gallery, select a color option.
How to Play PowerPoint Slide Show Continuously
On the Slide Show tab, in the Set Up group, click Set Up Slide Show. In the Set Up Show dialog box, in the Show options section, check the Loop continuously until ‘Esc’ check box and click OK.
Resize Multiple Objects in a PowerPoint Slide Simultaneously
To resize multiple objects in a slide simultaneously, select the objects by Shift-clicking and then drag the corners of the objects to resize them uniformly. Keep the Shift key depressed to ensure that the individual aspect ratios of the objects are maintained.
How to Move Objects in a PowerPoint Slide
To move an object in a PowerPoint slide, select the object and press Ctrl+ Any arrow key.
How to Change the Orientation of a Slide in PowerPoint
Select the Design tab, in the Page Setup group, click Slide Orientation and select Portrait or Landscape.
How to Add Customized Video Clips to the Clip Organizer
The Clip Art gallery in Office contains a whole lot of illustrations, photographs, videos and audio files that you can add to your presentation. But sometimes you may need to add an image, video, or image that you have customized to your specific requirements. In such instances, you can add your personalized clips to the Clip Organizer.
1. Click Start and select All Programs.
2. Select Microsoft Office –> Microsoft Office 2010 Tools –>Microsoft Clip Organizer.
3. Click File, select Add Clips to Organizer and then click On My Own.
4. The Favorites – Add Clips to Organizer dialog box is displayed. Navigate to the folder that contains the video clips you want to add, select the clips and click Add.
5. Close the Clip Organizer.
Your video clips are now added to the Clip Organizer. You can access the files whenever you need them from the Clip Art task pane. You can also add other clips such as audio files, images and illustrations using this method.
How to Password Protect a PowerPoint 2010 Presentation
Most of us working on a presentation, may have, at some point of time or the other, shared or collaborated with other users. One of the most common problems with working on shared documents is that the data contained therein may be available to manipulation by anyone. If your presentation contains sensitive data, it is wise to restrict the number of people who can open the presentation, or better yet, have it password protected. PowerPoint 2010 provides you with the necessary tools to keep your presentation data secure.
To password protect a presentation:
1. Select the File tab and choose Save As.
2. The Save As dialog box is displayed. Click the Tools drop-down arrow and choose General Options.
3. The General Options dialog box is displayed. In the Password to open text box, enter a password to open the presentation.
4. In the Password to modify text box, enter a password to modify the contents of the presentation and click OK.
You have now added password protection for both opening as well as modifying the contents of your presentation. You can test if the settings are working by closing the presentation and opening it again. Enter the required password to open and modify the presentation.
A key point to remember when it comes to adding password protection on Microsoft documents is that, should you forget your password, you cannot have Microsoft retrieve it for you. So make sure to note down your passwords in a safe location so that you don’t lose your data in the name of protecting it!
Share a PowerPoint Presentation as a Video Using Windows Live SkyDrive
PowerPoint 2010 is a powerful tool that allows you to share and collaborate with other users. However, not everyone you work with, use the same version of PowerPoint. For instance, when you need to showcase presentations to people who do not have PowerPoint installed on their computers, you could convert the presentation to a video file and then share it using cloud platforms such as Windows Live SkyDrive. This also ensures that the presentation’s contents are not edited or modified by the user.
1. Save the presentation as a video.
2. Once you have converted the presentation to a video, sign in to your Windows Live SkyDrive account with your Windows Live credentials.
3. On the navigation menu, click Add files.
4. Select the folder into which you want to upload the video.
5. On the Add documents to page, drag and drop files to upload the video file to SkyDrive.
6. When the upload is complete, click Continue.
7. To share a link to the video with one or more people, click Send a link. (This link will share the folder in which you save the file. Ensure that the folder permissions are set to public or share with friends.)
8. Enter the email addresses of the users you want to share the video and click Send.
Protect PowerPoint Content Using the PPP Format
Consider a situation where you have to share a presentation with your colleagues but you don’t want them to change the slides’ contents. You can protect PowerPoint content from being editing or modified by others using the PowerPoint Picture Presentation format.
When you save the presentation in this format, the slides are converted into pictures. So while your slides can be reused, it cannot be edited or modified. Furthermore, since it is saved as a PowerPoint presentation, your colleagues can add additional slides or remove slides they don’t need. In this way, you get to protect your content as well as help out your colleagues.
To protect PowerPoint content using the PPP Format:
1. Select the File tab and choose Save & Send.
2. In the File Types section, click Change File Type.
3. In the Presentation File Types section, select PowerPoint Picture Presentation and click Save As.
4. In the Save As dialog box, enter a file name and click Save.
You can now share your presentation with other users, safe in the knowledge that the slides will not be modified.
PowerPoint 2010: How to Hide ScreenTips
ScreenTips, which are small descriptive terms about a tool or a command can be an annoyance in some situations. For instance, if you need to take a screenshot of a command, the ScreenTip may be a distractor. In such cases, hiding the ScreenTip is ideal. This option has the effect of hiding the ScreenTips in all MS Office applications as well.
1. Select the File tab and choose Options.
2. In the PowerPoint Options dialog box, in the General section, from the ScreenTip style drop-down list, select Don’t show ScreenTips.
Microsoft Outlook 2010 Tips
Display Several Days Side by Side in Outlook Calendar
In the Calendar view, in the left pane, in the Calendar, select the first date, then Ctrl+click the other days you want to view.
How to Change the Time Interval in Outlook Calendar
In Calendar view, on the View tab, in the Arrangement group, click Time Scale. From the drop-down list, select the desired time interval you want to display in the calendar.
How to Delete an RSS Feed
Simply select the folder you no longer wish to read and press Delete. In the Microsoft Outlook message box, click Yes to confirm the deletion.
How to Move to A Calendar View from Another View
If you frequently use the Outlook 2010 calendar, a quick way to get there from the Mail view is to press Ctrl+2. You can actually press Ctrl+A from any view to display the Outlook calendar.
How to Go to a Specific Date In Outlook 2010 Calendar
Press Ctrl+G to find a specific date in the Calendar. Pressing Ctrl+G will open the Go To Date dialog box, from which you can choose a date and a calendar view.
Keyboard Shortcut to View Specific Days in the Outlook Calendar
If you want to check five days beginning May 15th on your Outlook calendar, select May 15th and then press Alt+5. The Outlook calendar will display May 15th through 20th.
How to Switch Between the Weeks and Month View in Outlook 2010 Calendar
If you want to navigate between the Weeks view and the Month view in Outlook 2010, all you need to do is press Alt+- (the character to the right of the zero key.) and Alt+=. Alt+- will take you to the Weeks view and Alt+= will take you to the Month View.
Keyboard Shortcut for Advanced Find Feature in Outlook 2010
To use the Advanced Find feature in Outlook 2010, press Ctrl+Shift+F.
How to Search for Text Within an Open Item in Outlook
Press F4 to search for text within an open item in Outlook 2010.
How to Quickly Send a Message in Outlook 2010
If you have composed an email message, you can press Alt+S or Ctrl+Enter to send the message to the recipient.
How to Resend an Email from Office Outlook 2010
Open the message you want to resend. In the Move group, click Actions and select Resend This Message.
Microsoft Word 2010 Tips
How to Add an Automatic Border to Your Word Document
On the Home tab, in the Paragraph group, you can click the Border button to select the border you want to insert in your document.
How to Move Text Up or Down a Paragraph
Lets assume that on page 1, you want to move the fourth paragraph above the third paragraph. You can do this by clicking within the fourth paragraph, holding down Alt+Shift and pressing the Up arrow key. You can continue to press the arrow keys to move up or down one level. You can also use this shortcut to move rows of text within tables, or move bulleted/numbered lists.
How to Select Text Vertically
Simply press Alt and drag down to select the text.
How to Position the Cursor Above a Table in a Word Document
Place the cursor in the first row and first cell of the table and press Enter.
How to Check Formatting Inconsistencies in Word 2010
If you want Word to auto-check your documents for inconsistencies in formatting, select the File tab and choose Options. In the Word Options dialog box, select Advanced. In the Advanced tab, in the Editing options section, check Keep track of formatting and Mark formatting inconsistencies check boxes and click OK.
How to Automatically Update the Date in a Word Document
If you have a letter template that needs to reflect the current date every time you use the template, select the Insert tab, and in the Text group click Date & Time. In the Date and Time dialog box, check the Update automatically check box.
How to Change the Casing of Words
Press SHIFT+F3 to change the case of selected text from lower case to sentence case. Press SHIFT+F3 again to change the case to All Caps.
How to Insert a Bullet in Between a Sentence In Word 2010
To insert a bullet in between a sentence, hold down Alt and press 0183.
Microsoft Excel 2010 Tips
How to Change the Standard Font Of Excel Text
The standard font set for Excel text is the Body Font. If you wish to change the default font in Excel, simply navigate to the File tab, choose Options, and in the When creating new workbooks section, from the Use this font drop-down list, select the desired font and click OK.
How to Change the Default Number of Worksheets
You probably know that when you open a workbook, three worksheets are displayed by default. To add or reduce the number of worksheets displayed, select the File tab and choose Options. In the When creating new workbooks section, choose the number of worksheets you want to set as the default number by moving the up or down arrow and click OK.
How to Join Two or More Cell Values in Excel
To join 2 cells in Excel simply use the formula, =A1&A2. If you need a space between the two values, then use the formula =A1&” “&A2.
How to Convert All Text in Excel to Lowercase
Using this simple Excel formula =LOWER(Cell Reference) will convert the text in your cell to lowercase.
How to Convert All Text in Excel to Proper Case
=PROPER(A1) will convert the text in your cell to proper case.
How to Quickly Add a Border to Selected Cell
If you want to add an outline border around selected cells in your Excel sheet, press Ctrl+Shift+7.
How to Insert a New Worksheet in Excel 2010
Press Shift+F11 to insert a new worksheet in a workbook. You could also click the Insert Worksheet button on the worksheet tab.
How to Set Options to Manually Calculate Formulas
There may be instances when you want to change a cell value in one or more formulas, but you do not want Excel to automatically recalculate the changes as a result thereof. In such instances, you can set the option to manually calculate figures, by selecting the File tab and choosing Options. In the Excel Options dialog box, select the Formulas tab. In the Calculation options section, select manual update. You can check the Recalculate workbook before saving option if required and click OK.
Change the Behavior of the Enter Key in Excel 2010
Select the File tab and choose Options. In the Excel Options dialog box select Advanced. In the Editing Options section, from the Direction drop-down list, select an option and click OK.