Showing posts with label MS Office. Show all posts
Showing posts with label MS Office. Show all posts

Friday, 9 November 2012

10 Things To Know About MS Office 2013



The New Microsoft Office ( MS Office 2013) is available wherever you are, on whatever device you’re using at the time, and with full touch-screen support, the entire suite has been reinvented to work with Windows 8-driven tablets, regular keyboard-and-mouse desktop setups, and even smartphones. It has a completely reinvented interface.

Here is a list of 10 things that you should know about MS Office 2013:

All in the Cloud:
Microsoft’s cloud storage SkyDrive has its presence from a long time but it’s only now that SkyDrive has to play a major role to play in company’s plans. The New Microsoft Office 2013 enhances its functionality by storing all your Office Docs in SkyDrive by default. This will not only save your disk space but will also let you access the documents from any location using a remotely located device. Named Office 365, you will need to subscribe for this service. The price has still not been announced yet but is expected to come out by this fall.

Touch and Stylus:
Microsoft has taken a big leap forward by embracing the touch and stylus modes beyond the usual mouse and keyboards. Though, multi-touch laptops won’t be a primary choice for businesses, but touch is being widely accepted in the Smartphone and Tablet market. The pen, much like the one used in Galaxy Note, is also making a comeback. The features that Office 2013 is providing will resemble the ones you are much used to like swiping your fingers across to turn the page, pinching in and out to zoom and read the documents etc. The most attractive feature though is conversion of your handwritten emails into text!

The ‘Metro’:
Microsoft, in its launch of the Office 2013 conform its ‘Metro’ look that is persistent through software developers mobile apps.One more remarkable change that is worth noticing is the flatness of the ribbon in MS Office 2013 when compared to MS Office 2010.

Editing PDF:
Now you can edit your PDF documents in MS Word, a feature Microsoft has incorporated in its new launch keeping in mind the growing popularity of Adobe’s PDF format. The earlier versions did not allow you to edit PDF formats in Word and this was a major turn off as most of the documents available on the internet now come as a PDF document. Also, you can now integrate videos from YouTube and Facebook in your Word documents that can be viewed by other users while reading the file.

Excel 2013:
Microsoft has launched Excel nearly three decades ago to facilitate all the major number-crunchers and the new release Office 2013 lets Excel do what it does best without adding any drastic updates. But still, Excel 2013 offers some new templates for budgets, calendar, reports, and forms. The Flash Fill feature is also very useful as it recognizes your data and fills in the details accordingly.

Powerful PowerPoint:
As in the earlier versions where the initial page guided you to the steps to build a presentation, the newer version, has an updated Start screen that consists of new color templates and design themes. The Presenter now makes it easier for you to zoom in a part of any image, chart or graph on which you need to emphasize. The Navigation Guide lets you switch slides from a grid that is hidden from the audience. The Collaboration tools are the most important upgrade in the new PowerPoint that allows various business colleagues to work on creating one presentation that is saved in Microsoft’s SkyDrive or SharePoint.

Note-Taking:
Microsoft’s new note taking app, OneNote, is well-suited to notebooks, tablets and the added advantage Office 2013 has is its Metro-Style user interface. It automatically saves your note on SkyDrive making your idea readily available even on a remote location. It also lets you grab screens and pull them to your notebooks, a feature that might prove to be compelling to many business users who opt for Stylus based Windows RT and Windows 8 based tablets.

Skype Integration:
Microsoft Office 2013 makes it easier for you to import your Skype contacts in Microsoft enterprise-oriented Lync communication platform for calling and instant messaging. Office subscribers will be getting 60 minutes of international calls each month.

Office 2013 ‘Social’ Suite:
The new Office suite gives further direction to Microsoft’s attempt to target the large number of Enterprise users. Yammer’s acquisition last month was tentative yet the integration of the safe and secure social platform mainly used to network Enterprise users has made Microsoft’s intentions to outshine in the enterprise networking platform. The new suite is loaded with Skype and Yammer making it an obvious choice for all socially committed enterprise users. Office 2013’s People tool will now provide you detailed information about your contacts, their Facebook and LinkedIn updates and everything else you need to know about them.

Big Screen Bonanza:
The availability of big screen might not be an essential feature of Office 2013, but with its release Microsoft is all set to transform the way we work. For instance, in a classroom, the lecturer can use OneNote app to jot down lecture notes on a big screen such as Perceptive Pixel’s 82-inch monster using Stylus and the students can later download the notes in their tablets using SkyDrive. This will transform the conventional way of teaching making the profession more technology oriented.

Friday, 2 November 2012

10 Tricks to Follow for Microsoft Outlook


1.Save a few keystrokes when entering dates 
 
When entering the start and due dates for a new task, you don't have to type the entire date. If a date is in the current month, just enter the day and Outlook will enter the rest of the date for you. For instance, if the current month is March and you enter 14, Outlook assumes you mean March 14 of the current year and fills in that date.
When a date isn't in the current month, you can still save a few keystrokes by entering the month and day. Outlook will fill in the year as follows:
If the month and day haven't occurred in the current year, Outlook uses the current year.
If the month and day have passed, Outlook uses the next year.

2.Control how you print notes
If you use the Notes feature to jot down questions, ideas, or quick reminders, you might also want to print them occasionally. By default, Outlook prints each note on a separate page, which might or might not be what you want. You can force Outlook to fill each page, to save paper or to keep related notes together. Select the notes you want to print and then choose Print from the File menu. In the resulting Print dialog box, deselect the Start Each Item On A New Page check box in the Print Options and click OK.
If the option is disabled, you're using HTML format. You must switch to plain or text format to enable this option. To do so, choose Options from the Tools menu. Click on the Mail Format tab and choose Plain Text from the Compose In This Message Format option's drop-down list. Then, click Apply and OK. Repeat the print instructions, and you'll find the Start Each Item On A New Page option is enabled. After printing the notes, just retrace your steps to reset your format setting .

3.Print e-mail when it arrives

For a variety of reasons, some of us end up printing e-mail messages. If you print most of your messages, or all of your messages from a specific source, opening each message to print it manually interrupts your work. Setting a rule to print the desired incoming mail might be more efficient. To do so:
1. From the Tools menu, choose Rules And Alerts.
2. Click New Rule on the E-mail Rules tab.
3. Click Start From A Blank Rule at the top of the resulting Rules Wizard dialog box.
4. In the Step 1 box, highlight the Check Messages When They Arrive option (it should be the default) and then click Next.
5. In the Step 1 box, select the Where My Name Is In The To Box check box (or whatever option applies, if you don't want to print all you messages) and click Next.
6. In the Step 1 box, click the Print It option and click Next.
At this point, you can identify exceptions to the rule, but we won't do that here. Just click Next, and then Finish, Apply, and OK to return to Outlook.
After setting up the new print rule, Outlook will print every incoming message that meets your requirements. Now, the chances are that you won't want to print every message. So make good use of the conditions offered in steps 5 and 7 to limit the messages Outlook prints.

4.Store sent mail efficiently
When you reply to an e-mail, Outlook stores a copy of that message in the Sent folder. If you're like me, your Sent folder has thousands of messages. If you need to find a specific message later, you must sort through all those messages, and that takes time. Instead, store your replies with the original message. For instance, suppose you automatically route all your messages from your boss into a folder named, appropriately enough, MyBoss. If you want Outlook to store your replies in MyBoss with the original messages, do the following:
1. From the Tools menu, choose Options.
2. On the Preferences tab (which should be selected by default), click E-mail Options in the E-mail section.
3. Click Advanced E-mail Options at the bottom of the Message Handling section.
4. In the Save Messages section, select the In Folders Other Than The Inbox, Save Replies With The Original Message check box and then click OK three times to return to Outlook.
Outlook will apply this setting to all of your personal folders. Just remember that Outlook saves replies with the original message and not in the Sent folder only when the original message is in a folder other than the Inbox. Outlook continues to save all replies sent from messages in the Inbox in the Sent folder.

5.Create a Flags toolbar
Quick Flags help you categorize your messages, usually by some level of importance or by task. For instance, you might use a red flag to mark messages that need a quick response and a blue flag to mark messages on which you've acted and are waiting for a response.
The problem with Quick Flags is that there's no way to customize their descriptions. Outlook identifies them only by color. You can't change the name of Red Flag to Critical. Remembering what each color represents can become burdensome.
1. An easy way to remember what each flag represents is to create a custom toolbar that displays each flag with text that means something to you. Fortunately, the process is easy:
2. From the Tools menu, choose Customize.
3. On the Toolbars tab, click New and name the new toolbar appropriately (for instance, you might name it "Flags") and click OK.
4. In the Customize dialog box, click the Commands tab.
5. Select Actions from the Categories list box.
6. Next, drag the appropriate flag color buttons from the Commands list to the custom toolbar. (If you can't find the toolbar, look behind the dialog box.)
7. After adding all the flags you want, change the text for each flag button. Right-click a flag button and replace the Name setting, e.g., &Red Flag, with something more helpful, such as "Critical." Select the Image And Text option so that Outlook will display the button's name on the toolbar.
8. Complete steps 6 and 7 for each flag button in your new toolbar.

6.Modify the scope of your Calendar work week

By default, the Work Week calendar view displays the five days of the traditional business week, Monday through Friday. To include Saturday and Sunday in that view, choose Options from the Tools menu. In the resulting Options dialog box, click Calendar Options in the Calendar section. In the Calendar Options dialog box, check Sat and Sun in the Calendar Work Week section. Then, click OK twice to return to the Calendar.
You don't have to view a seven- or traditional five-day work week. Check the days of the week that apply to you for a custom work week view. For example, if you work Wednesday through Sunday, you can make those selections to build a view that reflects your schedule.

7.Use color to identify messages from specific senders
Expecting important mail? Identify it as soon as it comes in by displaying it in a distinctive color. Start by select an existing message from the sender in question, if you have one. If you don't, that's okay; you can enter the sender's name manually. Now follow these steps:
1. In Mail, choose Organize from the Tools menu.
2. In the Ways To Organize Mail pane, click the Colors link on the left side.
3. In the first condition statement (we won't use the second), choose From in the first drop-down list.
4. If you chose a message before starting, the sender's name will appear in the text box to the right. If it's the wrong name, enter the right name or the person's e-mail address.
5. Choose a color from the second drop-down list.
6. Click Apply Color and close the pane.
Afterward, Outlook will display all messages, existing and new, from the person you specified in step 4 in the color you selected in step 5.

8.Distinguish incoming mail from existing mail

By default, Outlook displays incoming mail as bold text until you read it. If you need a bit more help, consider displaying unread mail in a bright color. To do so, you'll work in a view, not a rule:
1. In Mail, choose Inbox.
2. Choose Arrange By from the View menu.
3. Select Current View and then Define View from the subsequent submenus.
4. In the Custom View Organizer dialog box, check the option and click Modify.
5. Click Automatic Formatting.
6. In the Automatic Formatting dialog box, click Font.
7. In the Font dialog box, choose a color from the Color dropdown list, and click OK three times. Then, click Apply View.
Outlook will display all unread mail in the Inbox in the color you choose in step 7. Doing so won't display unread messages automatically routed to other folders. Since this is a view, it works only on the current folder. However, you can set up a similar view for any folder you like. In addition, the unread mail formatting takes precedent over colors used to identify mail from a specific sender.

9.Force replies to reach multiple recipients
A problem arises when you need recipients to reply to everyone receiving a message. The responding recipient must remember to click Reply All instead of Reply. If the recipient forgets to click Reply All, you're the only one who will see the reply, forcing you to forward it to everyone else, which is inefficient. Before you send the message, you can configure it to reply to everyone:
When composing the message, click the Options button on the Formatting toolbar.
1. Choose Options from the resulting drop-down list.
2. In the Message Options dialog box, check the Have Replies Sent To option in the Delivery Options section, which will automatically enter your e-mail address.
3. Next, click the Select Names button to the right and select all the appropriate recipients.
4. Click Close to return to your message.
5. When any recipient responds to the message, regardless of which reply choice they click, the reply will go to everyone you specified in the Have Replies Sent To option.

10.Create a temporary work week in the Calendar
The Work Week calendar view displays a week view, and you define what constitutes a work week (see Tip #6). If you need to see more or less than the usual work week, you can temporarily change that view. In the Date Navigation pane, click the first date you want to view. Then, hold down the [Shift] key and press the last date in the period. Outlook automatically adjusts the Calendar Work Week to include all of the dates in the selected time period. Alternately, you can view a group of noncontiguous dates by holding down [Ctrl] instead of [Shift] as you click dates. Outlook will display the days in order, regardless of how you select them.